Maybe a dumb question, but coming from databases, it's how my brain thinks. Is it possible to do a saved search where you get the results that are IN one saved search and NOT IN another search.
Sort of a classic database where X in (saved search 1) and X not in (saved search 2). Or something similar?
s
Suitestallion
04/21/2020, 9:48 PM
you should be able to do that with "Any of" or " None of " in criteria Tab
j
Jason Zech
04/21/2020, 9:51 PM
Currently I'm pulling in SO item rows filtered by Item type. That gets me all the orders that have that item type. But it also brings in orders that have that item type and other item types too. I just want the orders that are only this one type (so bring in all rows with my item type but exclude rows where the so includes items of other types).
b
battk
04/22/2020, 11:14 AM
netsuite doesnt make this task simple and requires using more advanced search filters
battk
04/22/2020, 11:15 AM
you have to use summary filter criteria since you are interested in the groupings of search rows