This topic contains 4 replies, has 0 voices, and was last updated by al3xicon 8 years ago.

  • Author
    Posts
  • #5091

    jmessersmith

    We have a list of sales orders. We want to exclude those sales orders with a specific item.

    Mainline = false on this search.

    I cant seem to figure out how that would work. Is it doable?
    This is a cached copy. Click here to see the original post.

  • #5092

    al3xicon

    Try the “Item on Any Line” search filter field. Then you wouldn’t need main line = false.

    If you need main line = false for other reasons, it will probably still work, but you could also then use a summary criteria. Sum of formula(numeric)…CASE WHEN {item} = %YOURITEMID% THEN 1 ELSE 0 END…is equal to 0

  • #5093

    torin@aminian.com

    I agree with Alex. I would try to use the criteria- Item On Any Line and set it to none of the items you want to see.

  • #5094

    jmessersmith

    Is there an equivalent for that for a custom column on the item?

  • #5095

    al3xicon

    You could use the summary formula approach I posted if you need to base it off of a custom column field jmessersmith . Just beware that it will only work properly if your results tab also groups together all results into one row per sales order.

You must be logged in to reply to this topic.