Skip to main content
Answer

Create GI Parmeter to filter less than or equal to a specic number

  • July 31, 2025
  • 2 replies
  • 29 views
S
Varsity I
Forum|alt.badge.img

I’m creating a GI tool based on the AMRPDetail table,

Users need to be able to input a sales order number into a parameter and then have the GI filter to show any sales orders “less than or equal to” that sales order number.

I created a formula to parse out the SO number from the related document field. Can I use that formula field as the parameter? 

Thank you!

Best answer by BenjaminCrisman

​@SBaldwin You just need to add a condition which will check the value in the parameter against the function in the results grid.

Here’s my parameter:

Here’s my condition:

Here’s my results:

 

    2 replies

    BenjaminCrisman
    Acumatica Employee
    Forum|alt.badge.img+4
    • BenjaminCrisman
    • Acumatica Support Team
    • Answer
    • July 31, 2025

    ​@SBaldwin You just need to add a condition which will check the value in the parameter against the function in the results grid.

    Here’s my parameter:

    Here’s my condition:

    Here’s my results:

     

    Chris Hackett
    S
    Varsity I
    Forum|alt.badge.img
    • SBaldwin
    • Author
    • Varsity I
    • July 31, 2025

    Great that worked!

    Chris Hackett
    Terms & ConditionsCookie settingsAccessibility statement
    About Acumatica ERP system
    Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
    © 2008 — 2024  Acumatica, Inc. All rights reserved