Skip to main content
Answer

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?

  • March 8, 2024
  • 1 reply
  • 98 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.

 

 

1 reply

dcomerford
Captain II
Forum|alt.badge.img+15
  • Captain II
  • Answer
  • March 8, 2024

@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.