Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Duplicate results in NetSuite saved search

I created a simple saved search in NetSuite on the Transaction object, but for some reason I'm seeing duplicate results being returned. Screenshot below shows the duplicate results for the same Transaction record.

Duplicate results in NetSuite saved search

Can anyone help me understand why I'm getting these duplicate results for the same Internal ID, especially that last result that actually shows a different Name value? And how can I configure the saved search to just return one result for each Internal ID?

Below are screenshots showing the saved search's configuration on the Criteria and Results subtabs.

Transaction search Criteria subtab

Transaction saved search Results subtab

like image 359
Marty C. Avatar asked Sep 06 '25 03:09

Marty C.


1 Answers

This is because of how NetSuite treats sublists in Search Results.

Watch this video explanation and/or read this post for more details.

TL;DR: add a Criteria for Main Line in the search

like image 124
erictgrubaugh Avatar answered Sep 07 '25 23:09

erictgrubaugh