THE THREE POWERFUL USES OF GENERIC INQUIRY

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.

Reporting

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.

Abilities

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 satkins@4acc.com 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

The 5 Most Common ERP Objections

Making the decision to upgrade from a basic accounting software to a robust ERP system can come with challenges. Not everyone will be on board or open to the idea of change. Throughout our years in practice, we have found the following common objections to adopting a new software.  Read More

Submitted by Ally Donahue on Fri, 01/22/21 - 11:33

ERP Hierarchy of Needs

Maslow's Hierarchy of Needs a psychological concept that people are willing to fulfill basic needs before pursuing higher level needs. This theory was created in 1943 by Abraham Maslow. The five levels, physiological, safety, connection, esteem, and self-actualization are all components of what humans need. Just like we need these basic necessities, so does a company when implementing a new ERP system. All five levels in an ERP sense are vital to future system success. Below you will find a creative infographic highlighting the similarities of each human need to each ERP need. Read More

Submitted by Ally Donahue on Fri, 01/15/21 - 12:36

Why an ERP System Isn’t “One Size Fits All”

Have you seen the phrase, “One Size Fits All”, marked on different types of clothing? Most items labeled as such usually are very plain and have a standard size to accommodate most. Of course there are outliers and truly not everyone can fit in a one sized option. This is also true of  ERP systems; they cannot be “One Size Fits All” due to complexities. Read More

Submitted by Ally Donahue on Fri, 01/08/21 - 10:27

Whatever Your ERP Needs, We Have the Solution!

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