We have multiple vendors enabled and I am trying t...
# general
m
We have multiple vendors enabled and I am trying to create a transaction search that will show items that dont have a specific vendor. The issue is that i have not been able to successfully exclude any items that have that vendor. I have tried Item: vendor is none of ... Item: vendor name does not contain... and Vendor: name/ID Is there a different approach I should be taking?
m
This will proabably end up being a summary search. Don't put anything about vendors in your criteria. But add your vendor fields to the results. Then add a formula column of CASE WHEN {vendor.name} IS NULL THEN 1 ELSE 0 END Then do summary type of group on item name and SUM on your formula. Anything with a value over 0 will NOT have a vendor