[jmessersmith Contributions: 0Level 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.

[al3xicon Contributions: 0Level 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

[torin@aminian.com Contributions: 0Level 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.

[jmessersmith Contributions: 0Level 1☆]

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

[al3xicon Contributions: 0Level 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.

[Author]

Posts