This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Is it possible to compose a search on two entries in the same sublist? I want to compose a search of all sales orders where the customer bought both a widget and an accessory for it.

You can use summary filters and columns for this

For the normal filters you add a filter where the item is anyof your selected items

And in the summary filter, add one where the count of items is greater than one

For your columns you want to group by internalid

Hmmm, what if they bought two widgets (on two separate lines) but no accessory?

Aha: two summary criteria:
SUM CASE WHEN {item}=A THEN 1 ELSE 0 END &gt;= 1
SUM CASE WHEN {item}=B THEN 1 ELSE 0 END &gt;= 1

Thanks for the nudge in the right direction!