Discussions
Exclude Item from Search if a member of a BOM meets criteria
I am building an item search that returns specific assembly items if their member items meet a certain criteria.
For example, My search is showing me all Assembly items that have a member with a preferred vendor of 'Vendor1'.
My criteria looks a bit like this:
Type: is Assembly items
Member Items:Preferred Vendor: is "Vendor 1"
Now, I would like to exclude any Assembly items that  contain a member with a certain phrase in the description.
I have added the "Member Items: Description does not contain "..." criteria, but this does not seem to be working.  I believe it is because there are multiple items in each assembly and Netsuite cannot pick out a single item with the description, and apply it to the entire assembly to disregard.