Skip to main content
Solved

How to amend the SO-SalesOrder Generic inquiry so a filter can be added to show only sales orders which contain an order line for an inventory item of a specific class?

  • 8 March 2024
  • 1 reply
  • 65 views

I’m new to using formulas in Generic inquiries, and I’m struggling find a way to add a field in the result grid of Generic Inquiry SO-SalesOrder that flags an order as ‘Provision’ if any of the stock items in SOLine belong to an item class of IC0004.

I would then add a filter to the GI that shows only orders with ‘Provision’ in this column.

 

Would anyone be able to advise how to do this?

 

Any advice very much appreciated.

 

Many Thanks

Best answer by dcomerford

@Bencartledge32 Look at this post and my response to it. It was a similir idea they wanted to find orders that started with a particular letter.

 

https://community.acumatica.com/reports-and-generic-inquires-115/create-a-generic-inquiry-that-shows-only-orders-with-specific-items-18519

 

View original
Did this topic help you find an answer to your question?

dcomerford
Captain I
Forum|alt.badge.img+15

@Bencartledge32 Look at this post and my response to it. It was a similir idea they wanted to find orders that started with a particular letter.

 

https://community.acumatica.com/reports-and-generic-inquires-115/create-a-generic-inquiry-that-shows-only-orders-with-specific-items-18519

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings