Tell Acumatica not to run a query when you open a Generic Inquiry so you can add a filter

Tim Rodman — Tue, 03 Dec 2024 17:44:38 +0000

When you open a Generic Inquiry in Acumatica, it usually doesn't take very long because it's only retrieving the first 10 or so records (depending on your screen size). But, sometimes, it still takes a long time to run the query when the screen first opens.

If you're always adding a filter, it's annoying to have to wait for that first query to run so you can add the filter and then run the query again.

So, if you want a Generic Inquiry to open up as empty so you can add filters and then run the query, you can use this technique:

1. Add a checkbox parameter to the PARAMETERS tab on the Generic Inquiry (SM208000) screen:

3584

2. Use that parameter on the CONDITIONS tab of the Generic Inquiry (SM208000) screen to essentially tell it not to run unless the Run Query box is checked:

3585

If you do that, then the Generic Inquiry be empty when you open it from the menu since Run Query will be unchecked. You can add your filters and then check Run Query to get it to run like this:

3588

Tell Acumatica not to run a query when you open a Generic Inquiry so you can add a filter - Acumatica Generic Inquiries & Pivot Tables

Tell Acumatica not to run a query when you open a Generic Inquiry so you can add a filter