Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Filter the Sales Order on the basis of Line Items Committed Quanity
Hi,
I've created the saved search in which I'm getting both the sales order main line and line items columns in result.
I want to filter the sales order based on the line items committed quantity.
Filter Needs to Apply,
If the SUM of all the line items committed quantity for any sales order is greater than zero then include it in the result.
In the below example the saved search filter needs to filter out the Sales Order 2.
Example:
Sales Order - 1:
LineItem1 -> Committed Quantity - 1
LineItem2 -> Committed Quantity - 0
Sales Order - 2:
LineItem1 -> Committed Quantity - 0