This topic contains 4 replies, has 0 voices, and was last updated by al3xicon 8 years ago.
-
Posts
-
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. -
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
-
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.
-
jmessersmith- Contributions: 0
- Level 1
- ☆
Is there an equivalent for that for a custom column on the item?
-
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.