Discussions
SuiteWorld is the largest annual gathering of the NetSuite community! It will be held in Las Vegas on October 6-9, 2025. Our customers and partners look forward to SuiteWorld every year as a place to hear the latest from NetSuite, get hands-on learning, and connect with each other. Register now!
NSC | How to Create a Saved Search Showing Sales Orders with only Two Specific Items
Scenario
User would like to create a Saved Search that shows Sales Orders containing only two specific items. The saved search results should return Sales Orders with the following items:
- Item A
- Item B
- Item A and Item B
If the Sales Order contains different items than those mentioned above, or, if those items are in the Sales Order with other items, then it should not be shown in the results.
Solution
1. Under the Criteria subtab > Standard sublist, add the following fields as filters:
- Type = is Sales Order
- Tax Line = is false
- COGS Line = is false
- Shipping Line = is false
Jeremy Guimaras-Oracle | Ask A Guru?️
Learn how to Refer A Member| Earn the Answer Accepter Badge | Be the Content Creator of the Quarter| Vote for the content you want to see!
Expand your NetSuite knowledge by joining this month's Ask A Guru Live about Advanced Accounting. RSVP on this event now!