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.
Keep an eye out for upcoming NetSuite events, including meetups, workshops, and webinars. These sessions are a great way to connect with peers, learn from experts, and stay current on the latest NetSuite updates and best practices. Registration links are provided in each event.
Summary Criteria Search - Equivalent of Duplicate Detection but for Item Custom Field
We have a scenario where our customer assigns a value to a custom field that they use Externally when displaying Item Availability and Pricing so their competitors cannot map to an actual SKU. I am trying to create a search that will return a result if more than 1 item has the same external part number custom field.
I have not done Summary Criteria in a while but thought it would be simple.
Summary Criteria:
Summary Type=Count
Field=EPN (Custom)
is Greater than 1
Results:
Field=EPN
Summary Type=Group (have also tried Count)
I would think it would return my 2 test items that have the same EPN but I always get No Results Found
John Cirocco
Sr. NetSuite Administrator
0