Discussions
Join the NetSuite community to innovate, connect, and discover what’s next.
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Register now
Sales Order saved search limiting results by item attribute
Hi,
I am trying to figure out a way to create a saved search that will show only orders that have one or many 'license' line items but that do not also have a 'maintenance' line item (therefore, I want a search to find "license only" sales orders).
We have a custom field on all our items that would indicate if the item itself is license vs maintenance, but I can't figure out a way to use this attribute to limit my saved search. If I include this field as a criteria for my search and set the value to show "None Of = Maintenance", my results don't include maintenance lines but the other lines of the order that include maintenance would show up. I want the whole order excluded from my results if any one line includes an item that has the attribute = maintenance.