Acumatica generic inquiries are powerful ways to view data. Each user can personalize how they view the inquiries. In this video, we show ways to personalize generic inquiries including color formatting and filters.

Watch the video:  Quick Look at Personalizing Acumatica Generic Inquiries

Video Transcription:

“The example we’re going to look at today is going to be our opportunity and look at our primary list or a generic inquiry that controls them. Acumatica generic inquiries don’t typically look like this right out of the box. We took some time and took some of the features so that we can actually demonstrate what you can do to personalize this experience. The first thing that we did here was we added a coloring condition that is looking at the status of the opportunity. Well, anything that is new is highlighting the whole row as yellow. Anything that’s won is showing me everything in green, and anything that’s lost is highlighting that in red. I also have a cell-specific condition where I said, “if it’s someone that is a prospect instead of a customer, highlight that blue, draw a little more attention to that”.

Another way that you can use that is to flag may be a possible user error that you’ve seen where if I go to the stage of won, which now I’m clicking on that word won, I’m going to hold shift on my keyboard and hit the button F. The system knows to filter automatically on the cell that I clicked, and you can see here I used that as well. If open is my status and my stage is won let’s have visibility to my user to see that. We are currently looking at all records, so I may want to take advantage of the @me functionality where it’s personalizing the records based on my login which is “Maxwell Baker”. I come over here, you can see my opportunity is a little different than we saw in “all records”.

I can even do some more additional filters where maybe I want to say, “Well, I don’t want to see Won because I feel like they’re not something I’m working on right now.” A feature that we use a lot internally in our system is the functionality of the allowing to see account, a sum, an average, a max, or a min right at the total of your generic inquiry. A good example of this is the thing I have nine documents that are related to eight customers, and I have a sum of $617,000. If I come back to all records, this will dynamically adjust based on all the records that I’m looking at. All my records are equal to 37 across 30. We thought that was a really nice feature to show everyone.

One more thing that we can do is different ways of filtering. You can see up here, I have statuses where I can say I don’t want to see won or lost. I can check, I can clear all, I can select all. I’m just going to cancel out of there. I already have a stage Won that was filtered, as you remember. I can just drag and drop this. Now it’s going to remove that. But because I’m doing it in this session, it’s going to come back, that filter, because it’s designed by the generic inquiry to always be there.

Another thing that we’d like to take a look at is the filtering that I can do as an admin, where I can create them and share them throughout the company. I can make them default so that when I come into this screen, it automatically goes to the default instead of all records of my opportunities. Then we can add different conditions to them and save them. Again, that is user-driven so if I don’t have access to do that, I can only do them for my personal experience, but it still allows that user to create stuff that they made, that you don’t want another user to see.”

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

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,