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

  • Author
    Posts
  • #5091 Score: 0

    jmessersmith
    • Contributions: 0
    • Level 1

    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 Score: 0

    al3xicon
    • Contributions: 0
    • Level 1

    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 Score: 0

    torin@aminian.com
    • Contributions: 0
    • Level 1

    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 Score: 0

    jmessersmith
    • Contributions: 0
    • Level 1

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

  • #5095 Score: 0

    al3xicon
    • Contributions: 0
    • Level 1

    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.