Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
NSC | Avoid duplicate results in BOM Revision Saved Search
Scenario
User is trying to create a saved search of BOM revision and component data, but gets duplicate results.
Solution
User can try the following steps:
- In the Results tab, use Name field only instead of Bill of Materials : Revision : Name
- In the Criteria tab, add the ff to get only the active revisions:
- Effective Start Date is on or before today
- Effective End Date is not on or before today
Note: If it still shows some duplicate rows, you may need to add more filters in the Criteria. Check this related article about more troubleshooting steps:
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!
Tagged:
0