The Powerful Uses of Generic Inquiry

As both an Acumatica partner and user we have found Generic Inquires to be a very powerful tool in Acumatica. From simple data exports, to reporting, to data analysis, Generic Inquires is the go-to place. It can be complex and is not for the general user but for anybody familiar with the data structures and SQL queries this can be very useful.

When we setup a new customer on Acumatica we always come across needs for custom reporting or data exporting. We always start with setting up Generic Inquires and almost all the time they meet the needs of the customer. Generic Inquires can be added to any screen in Acumatica for easy access by the customer. I would like to discuss a few instances Generic Inquires have proven to be helpful to us and our customers.

Simple Export

Let’s say our customer would like to do a mass update on inventory items but needs to look at a few values to determine what needs to be updated. Building a Generic Inquiry can get us that data quickly. From there, the customer can modify the data as needed in excel and be sent back for import.

Or let’s say our customer needs some data not available in any of the current inquiry screens, for example full customer address information. We can build a Generic Inquiry to get them that data quickly.


While most users like a pretty formatted report they eventually want just the raw data in excel so they can manipulate it. We have found Generic Inquires to be a great tool for this purpose. You can setup parameters to filter things like date and allow the user to add additional filters. Exporting to excel is very easy for them to continue to work with the data.

If a report is required, you can use the Generic Inquiry and Export as Report to get you started.

Data Analysis

For a few of our customers they have needed the ability to see real time data like what is on back order, what needs to be ordered from vendors, or sales trends. Generic Inquires can do this with a simple refresh of your screen. You can carry out formulas or color code cells based on values for quick identification.

Once Generic Inquiry (GI) can also be used for multiple purposes by saving the filters for quick access. This means one GI can be used by different users depending on their needs.


Generic Inquires can do many powerful things not already mentioned so here are a few additional highlights.

  • Link multiple tables
  • Parameters
  • Conditions (user defined or pre-defined)
  • Grouping
  • Sorting
  • Formulas
  • Custom column names
  • Aggregate functions (Average, Min, Max, Count, Sum)
  • Custom styles
  • Navigation
  • Pivot tables

Things to Keep in Mind

I try to stay away from editing a standard GI provided by Acumatica. But, in some cases it is inevitable I find any major changes that should be setup in its own GI.

Generic Inquires if not done correctly can slow down your system and cause issues. Always follow best practices with data linking.

Like any other reporting tool, always validate the results to make sure you haven’t made any mistakes.

For more information on Acumatica, contact us at or call us at 856-335-1010

Was this article helpful? Please share this information with your connections and make sure to tag ACC Software Solutions in your post!

Solutions by Industry

What's New

Open-Source ERP vs. Proprietary ERP

While open-source ERP systems may seem appealing due to their initial cost savings and perceived flexibility, proprietary ERP solutions offer a wide range of benefits that can ultimately provide greater value and efficiency. Read More

Submitted by Stephanie Dean on Tue, 04/16/24 - 5:00

Acumatica’s Configure-to-Order Manufacturing

Acumatica, a pioneer in cloud ERP solutions, takes the helm in empowering businesses with its Configure-to-Order (CTO) Manufacturing capabilities. Read More

Submitted by Stephanie Dean on Thu, 04/11/24 - 5:00

Spring Forward: Boost Efficiency with ERP

Spring forward with confidence by choosing the ERP solution that aligns with your business's growth trajectory. The right ERP is not just a tool; it's a catalyst for positive change, streamlining operations, and propelling your business toward a future of success and efficiency. Read More

Submitted by Stephanie Dean on Thu, 04/04/24 - 5:00

Whatever Your ERP Needs, We Have the Solution!

Or call us for a free consultation 866-379-3799