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

Hello all.
I want to create a saved search which gives me all Sales Orders that do not have a Purchase Order (in related records tab).
When I add the criteria: _Applying Transaction Type Is None OF Purchase Orders,_ it excludes Sales Orders that have only a PO as the related record.
If the Sales Orders has any other related records (item fulfillment, invoice, etc.) and a purchase order, the transaction is brough into the search.
How do I get it to exclude all Sales Orders with a Purchase Order as a related record?

Group your search results by something unique like internal id

then, add a summary criteria formula where the `Sum` of your `Formula Numeric` is 0. The formula should be something like: `CASE {applyingtransaction.type} WHEN 'Purchase Order' THEN 1 ELSE 0 END`

I had that in standard. I will give try in summary. Thank you.