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!
Don’t miss your chance to meet our SuiteGurus—NetSuite Support professionals and subject matter experts with extensive experience in select product areas, including OneWorld, Advanced & Basic Accounting, Supply Chain Management, Receivables & Payables, CRM, Account Administration, and the SuiteCloud Platform. Full Conference attendees can prebook exclusive 30-minute one-on-one sessions for your product questions.
Spots are limited! Register through your Agenda Builder and find SuiteGuru under Agenda Enhancements.
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!