Forums › Cached › Customization › Searches / List Views

This topic contains 1 reply, has 0 voices, and was last updated by girieshg 8 years, 10 months ago.

  • Author
    Posts
  • December 30, 2015 at 2:11 am #5392 Score: 0

    zahmed
    • Contributions: 0
    • Level 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.

  • January 6, 2016 at 11:46 am #5393 Score: 0

    girieshg
    • Contributions: 0
    • Level 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

You must be logged in to reply to this topic.