[zahmed Contributions: 0Level 1☆]

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

LineItem2 -> Committed Quantity – 0

Is this possible in Netsuite ?

Thanks,

Faisal Nasir
This is a cached copy. Click here to see the original post.

[girieshg Contributions: 0Level 1☆]

Have you tried a summary search criteria of type Sum, on field Quantity Committed? You could also try a regular search criteria on the field Quantity Committed.

[Author]

Posts