title: NetSuite get transactions that do not contain items with specified attributes
body: <p>I am attempting to create a list of open pending approval sales orders that do not contain items with specific values defined in a custom field. I am able to do this when the sales order contains only items that meet this criteria. However, when their are two items and one meets while the other does not my search is no longer valid.</p>
  
  <p>I have two sales orders. Sales order <strong>123</strong> has a shipping method of Ground, while Sales order <strong>321</strong> has an item with Shipping method of Ground and shipping method of Freight. I expect to get only Sales order <strong>123</strong>  returned.</p>
  
  <p>I made this formula in criteria section:</p>
  
  <pre class="lang-js prettyprint-override"><code>CASE WHEN {item.custitem_shippingmethod} = 'Freight' Or {item.custitem_shippingmethod} = 'Free Freight' THEN 1 ELSE 0 END
  </code></pre>
  
  
  
  <p>but got both orders returned.  I tried using the same formula in the summary criteria but that also did not work. Any suggestions?</p>
  
  <p><a href="https://i.stack.imgur.com/Qqp5p.jpg" rel="nofollow noreferrer">Picture of Criteria in NetSuite</a></p>
  
  <p>Thank you!</p>