AUGForums.com

An Acumatica User Group

  • Forums
  • Podcast
  • Blog
  • Rolodex
  • Login
  • Start Here
  • Courses
  • Register

Query Quarry for Acumatica ERP

January 23, 2019 by Tim Rodman

Query Quarry for Acumatica ERP helps you get started with Acumatica Generic Inquiries, Pivot Tables, Dashboards, Business Events, & Excel / Power BI OData.

AUG Query Quarry

Update December 07, 2019: Query Quarry is now part of AUG Courses (click here)

You have spent a lot of time, energy, and money implementing Acumatica ERP in your organization with the focus on getting data into Acumatica.

Now you find yourself needing to get data out of Acumatica. But you might find that the report you need is not available out-of-the-box.

The Acumatica reporting strategy is to use Generic Inquiries as the reporting foundation and allow you to build things like Dashboards, Pivot Tables, and Business Events on top of those Generic Inquiries. You can also enable a Generic Inquiry for OData to build reports with Microsoft Excel and Power BI that can be refreshed automatically.

AUG Query Quarry

The goal of Query Quarry is to help you get data out of Acumatica by making it easier to create Acumatica Dashboards, Pivot Tables, and Business Events or utilize tools like Excel and Power BI.

What is Query Quarry?

  1. Query Quarry is the most affordable reporting investment you can make for Acumatica, with the goal of reaching EVERY SINGLE Acumatica customer.
  2. Query Quarry is a powerful set of Generic Inquiries. Generic Inquiries are the foundation of the Acumatica reporting strategy, but too often you find that you have to create the Generic Inquiry yourself because the one you need doesn’t exist. This is frustrating, especially knowing that someone else has probably already created the Generic Inquiry that you are looking for.
  3. Query Quarry is a Community where Query Quarry members can access exclusive content and share the things that they have built on the Query Quarry foundational Generic Inquiries. Don’t build Dashboards, Pivot Tables, Business Events, and Excel / Power BI reports by yourself, alone in your cubicle with no one to talk to. Interact with other Query Quarry members to ask questions and share what you built so you can get feedback.
  4. Query Quarry is constantly evolving, with regular new additions to the foundational Generic Inquiries.

Not many people want to work in a dirty Quarry. They want to take what was extracted from the Quarry and build something cool with it. Like maybe granite counter tops? 🙂

Let me do the “dirty” work so you can do the “cool” work by leveraging Query Quarry for all of your Dashboard, Pivot Table, and Business Event needs. You can also get started faster with Business Intelligence using Microsoft Excel and Power BI by building upon the Query Quarry foundation.

I’m currently hard at work building the first version of Query Quarry. You can track my progress on the spreadsheet below. On the right is the list of Generic Inquiries that I’m targeting for Query Quarry Version 1 (including whether they are Done or not). On the left is the number of fields that are included in each Generic Inquiry.

Update December 07, 2019: Query Quarry is now part of AUG Courses (click here)

Filed Under: Acumatica Reporting Tagged With: Acumatica, Acumatica Business Events, Acumatica Dashboards, Acumatica Pivot Tables, Microsoft Excel, Microsoft Power BI, Query Quarry

By using this website, you agree to our Terms of Use (click here)

Online Members

Recent Blog Posts

  • EP 37: Jody Lorincz, IT Manager at MHR Brands, sharing his Acumatica Customer Story (Podcast) January 13, 2021
  • EP 36: What Motivates ERP Veteran Nicole Ronchetti To Participate in Acu-Connect (Podcast) January 8, 2021
  • Acumatica and Scanco WMS – A Cautionary Tale for ISVs January 6, 2021
  • EP 35: Ideas for AUGForums.com Live with Ryan Brown (Podcast) December 12, 2020
  • EP 34: Talking Acumatica eCommerce and the Next Normal for Distribution, Wholesale, and Manufacturing with Ted Stenstrom (Podcast) December 11, 2020
Acumatica Learning Resources

Recent Forum Posts

  • RE: Construction Module/Purchase Orders - Commitments

    Do you see them in the Commitment tab of the project? I...

    By johnymt, 1 day ago

  • RE: Compressing Images

    That would be cool. Not that I know of personally. Are ...

    By Tim Rodman, 2 days ago

  • RE: Support for custom fonts

    @ckwiat That's what I've experienced with MICR which is...

    By Tim Rodman, 2 days ago

  • RE: Support for custom fonts

    I actually came across this that I will try:

    By Cory, 2 days ago

  • RE: Support for custom fonts

    @timrodman do you know if anything was definitely figur...

    By Cory, 2 days ago

  • RE: Adding bill description on check stub

    @cfritsch Chip great modifications. Just a quick questi...

    By Jswartz, 2 days ago

  • RE: Setting Up System Accounts with Individual Email Accounts for all Users

    Cory, Did your company end up making a decision o...

    By nsmith, 3 days ago

  • Problem when i have more then one Alternate ID

    Hi, I have Stock Items that includes more than one A...

    By Fosse, 3 days ago

  • Best way to Learn Microsoft PowerApps

    Hi All, I recently started PowerApps Training at Mind...

    By Steveskok, 3 days ago

Recent Tweets

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2021 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.