Discussions
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
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.