AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Acumatica Generic I...
Tell Acumatica not ...
 
Notifications
Clear all

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

 
Acumatica Generic Inquiries & Pivot Tables
Last Post by Tim Rodman 6 months ago
1 Posts
1 Users
2 Reactions
450 Views
RSS
Tim Rodman
Posts: 3192
 Tim Rodman
Admin
Topic starter
December 3, 2024 1:44 pm
(@timrodman)
Famed Member
Joined: 10 years ago

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:

image

 

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:

image

 

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:

Run Query Checkbox
Jennifer Peterson and alconroy reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,519 Topics
  • 10.9 K Posts
  • 20 Online
  • 2,309 Members
Our newest member: Jason Rhodes
Latest Post: Hello Everyone ,
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

  • Julie Baker
Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2025 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×