It is not only valuable to have data; you want an easy way to find it and view it. In Acumatica Generic Inquiries you can set up color conditioning so you can visually see your data in different colors based on your specifications. Plus, you can drag and drop columns, add or remove fields and add filters and shortcuts to personalize your view of any data in Acumatica.

Watch the video: Quick Look at Acumatica Generic Inquiries (GI), Color Conditioning, Filters, and Pivot Tables

Video Transcription:

“The next thing I’m going to go into is actually just the opportunity screen again, and again, just to show the different level of color conditioning in different ways. We can use pivot tables and filters on a screen. So, for this particular one, we’re putting a color condition at a line level, which is actually the status of my opportunity. You can see “Won” is green, yellow is “New” bringing attention to it. “Open” is things that are being worked on and there’s also red for “Lost”.

I have another cell-specific highlight, which is blue for prospect. That allows, again, just to bring attention just to that one cell. There’s different ways that I can actually personalize this generic inquiry for myself, which is dragging and dropping the header. I could use what they call a column configurator and I could remove this. I can remove or add different fields that are available on this generic inquiry. And again, I can still drag and drop them as well. And this is personalized just for this particular user. If I have access rights, I can add different filters. For example, my opportunity, with taking advantage of the owner, looking at the @me, which is connected to the user that signed into the application.

But also that I have access, I can share this throughout the system to all the users that they can see this on that generic inquiry if they have access. Or also I can make it a default so when I go into Opportunities, I don’t want to see all records. I want to see my opportunities. I can actually copy it and make additional ones, or just create a brand new filter from scratch.

Another way to filter data is a shortcut, which is Shift F. If I go to Shift F and I click, I’m sorry, if I click on US Bartending School and I hit Shift F, you can see it automatically knew to filter the contained USA Bartending. If I hit Shift F again, it’s going to automatically remove that. If I look at other header level filters, I can filter on status by Select All, Clear All, Select One. Now it’s going to filter on my opens. If I would like just to get rid of this and not really touch it, I can drag and drop that away. It’s going to remove that filter.

Another cool feature is with filtering, I can tie it into a pivot table, very similar to Excel. If I want to take a look at all my open filtered Opportunities and kind of stage them by customer and by the stage they’re in, you can see it’s breaking it down. I’m going to click on this one here. It’s showing me that it’s an unassigned contact. That’s why everything’s resigning in the one amount. I can do a Drill In from a field. So I clicked on that value, and it brought me to what’s equaling that value.

The one last thing I’d like to show on the navigation is coming back to all records. If I’m looking at this US Bartending School and tying back to the information we talked about on a dashboard, I can use this as a side panel. The system knows that by clicking on US Bartending, I can actually pull right to their screen, that profile screen, or I can go to the dashboard that we originally looked at, which is the customer account idea of USA Bartending. It’s giving me that same view and taking advantage of that responsive design, but also allows me to expand that to overlay on this if I want to see more detail.”

This is a snippet from a detailed Acumatica overview. Watch the full video – Acumatica Lunch and Learn Part 2 – Acumatica Financials.

If you want to see more features that stand out in Acumatica review the series of articles our senior ERP consultants have published that compare Acumatica vs Microsoft Dynamics GP.

Get Acumatica user tips at

Are you ready to evaluate Acumatica or looking for Acumatica training and support? Contact CAL Business Solutions at or 860-485-0910 x4.

By CAL Business Solutions, Acumatica and Microsoft Dynamics GP Partner,

Compare Acumatica versus Dynamics GP