Discussions

Check out Oracle NetSuite upcoming events and conferences here
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Update your Profile with your Support type to get your Support Type badge.
Expand your NetSuite knowledge by joining our Ask A Guru Live sessions. RSVP on this event now.
Community Poll: What sort of content would you like to see more of?

NSC | Avoid duplicate results in BOM Revision Saved Search

edited Apr 9, 2024 8:07PM in Search / Reporting

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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!

Leaderboard

Community Whiz

Quarter 2 ((Apr-Jun 2024) )

This Week's Leaders

This Month's Leaders

All Time Leaders