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.
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.
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
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With