AUG

Acumatica User Group

  • Start
  • Forums
  • Blog
  • Courses
  • Login

Query Quarry for Acumatica ERP

January 23, 2019 by Tim Rodman

Query Quarry for Acumatica ERP is a Membership Site, helping you build Dashboards, Pivot Tables, Business Events, and Excel / Power BI reports in Acumatica.

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 Membership Site 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

AUG is an Acumatica User Group.

AUG Forums provide an online place for Acumatica users to ask questions about Acumatica, share information about Acumatica, and improve their Acumatica skill set.

AUG Forums
AUG Blog
AUG Courses

Recent AUG Forums Topics

  • Enhancement list

    By Muhamad Nasir Omar, 5 hours ago

  • Report from Inquiry Screen

    By Wyatt.ERP, 10 hours ago

  • Automated Warehouse Operations Special Commands Barcodes

    By Graeme Knox, 11 hours ago

  • Expense Receipt Default "Paid With" Value

    By Tim Rodman, 1 day ago

  • Acumatica Incoming Email Processing

    By Tim Rodman, 1 day ago

Recent AUG Blog Posts

  • Who Uses Acumatica? (Audio Post) December 9, 2019
  • What is AUGForums.com? (Audio Post) November 11, 2019
  • Acumatica 2019 R2 Roadshow – Columbus, Ohio November 8, 2019
  • Acumatica 2019 R2 Launch Series (Audio Post) November 7, 2019
  • Columbus Ohio After Party @ Acumatica 2019 R2 Launch Event November 6, 2019

Other Acumatica Resources

Acumatica.com
LinkedIn Acumatica User Group
Acumatica Learning Resources
Acu-Connect.com
AcumaticaUserGroup.com
Recent Tweets

Copyright © 2019 · Tim Rodman
The views and opinions expressed on this website are solely my own and are not necessarily those of Acumatica or Aktion Associates. This is a personal website that is completely disconnected from my day job.