AUGForums.com

An Acumatica User Group

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

You can build Cool Things on top of Generic Inquiries

January 30, 2017 by Tim Rodman

Like the hub of a wheel, Generic Inquiries are a foundational tool that allow you to build cool things on top of them.

During one of my presentations at Acumatica Summit 2017, entitled Business Intelligence for Business Leaders, I mentioned that you can build cool things on top of Generic Inquiries.

Click here for the slides and other information from that presentation.

But, what did I mean by “You can build Cool Things on top of Generic Inquiries”?

Generic Inquiry is like the hub of a wheel. There are spokes around that wheel, but Generic Inquiry is the center, holding everything together. Many of the cool reporting features in Acumatica are actually built on top of Generic Inquiry. First you build the Generic Inquiry, then you build the things on top of it.

This is actually going to be a really short post because it’s easier to show with a picture than to explain. So here you go:

You can build Cool Things on top of Generic Inquiries

A few notes about the picture above:

  1. Dashboards are listed twice, once as Dashboards and once as Dashboards (Acumatica 6), because although Dashboards have changed significantly in Acumatica 6, they are still available in Acumatica 5.3.
  2. OData is just a communication protocol, like HTTPS. It’s simply a delivery mechanism, like a pizza delivery car. Nothing fancy about it, it just allows you to securely deliver your Acumatica data to Microsoft Excel, Power BI, and other applications that support OData. For more on OData:
    • Acumatica Connects to Microsoft Excel and Power BI with OData
    • Acumatica Liberates ERP with OData
    • Data Nirvana: Power Pivot, OData, and Acumatica ERP
  3. Notice the box called Data Access Classes that sits in between Acumatica Database and Generic Inquiry. Actually, Generic Inquiry does not communicate with the database directly. This is a good thing for a few reasons:
    1. The database is agnostic and can be Microsoft SQL Server, MySQL, etc.
    2. The Generic Inquiry will pickup security, including row-level security, so it will know whether or not you have access to a particular warehouse or customer for example. Two users can run the same inquiry, but see only the data that they have access to (their respective sets of customers for example).
    3. This makes the Inspect Element feature a possibility (click here for more on Inspect Element).
    4. Data Access Classes do some work for you. They are like SQL Views in that they automatically join multiple underlying tables together for you.
    5. They can be slow. Actually, this is not a good thing, but I wasn’t sure where else to put it. Because Generic Inquiry doesn’t access the Acumatica Database directly, they typically run a little slower than regular SQL statements. And it makes sense because they have to do more work in order to pass through the Data Access Classes layer.

Filed Under: Acumatica Reporting Tagged With: Acumatica, Acumatica Blog, Acumatica Learning, Acumatica Summit 2017, Acumatica Training

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

  • Acumatica Payroll PTO Banks adjustment

    Has anyone figured out how you would make a manual entr...

    By MSylvia, 2 hours ago

  • Best Practices/Suggested Processes for Before and After Acumatica Version Upgrade

    We have a process in Sage 100 where we will run various...

    By CLove26, 3 hours ago

  • Denominated Currency Accounts, Foreign Currency and Project Accounting

    I'm noting this here for some future reference. I've s...

    By megan.friesen, 3 hours ago

  • RE: Importing Acumatica User Roles / User Security Permissions from Excel

    I tried a simple test in 2020R1 and 2020R2 and it doesn...

    By AhmedBahar, 5 hours ago

  • Combining Bill Retainage Invoices to one AR Invoice in Construction

    Hi was wondering if anyone has come up with a good work...

    By Mike Baio, 10 hours ago

  • RE: Generic Inquiry RESULTS GRID Column Order

    On the Results Grid tab you can drag and drop the items...

    By Michael Roszkowski, 12 hours ago

  • RE: Acumatica 2020 R2 OwnerID Field

    Thank you, Tim. Just faced this problem in a customized...

    By Anna Borisova, 1 day ago

  • Import Azure AD Groups to User Roles Screen

    Hi AUG, I'm cross posting this from the community as I ...

    By Michael.Barker, 1 day ago

  • Link EPApproval to APInvoice

    I am trying to write a GI that will link an Invoice to ...

    By Michael Roszkowski, 1 day 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.