Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
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!