#C298P0BCK #C2A1ZEMF0 Is it possible to create a saved search of all Sales Order lines that have NOT been returned? Itried using Applying Transaction joins, but can't seem to figure out the logic because it's being messed up by the other applying transactions like Item Fulfillments and Invoices.

A saved search based on the Sales Orders can filter on an Applying Transaction join to only consider the applying transactions (which can be many to many) that have the correct type, like Applying Transaction : Type noneof whatever you call Returns in your NetSuite account Then I think it would include only lines in the results that are from Sales Orders where that line doesn't have a Return among any of its Applying Transactions.

Thanks @Aaron McCausland I've tried all manner of applying transaction filters, but it doesn't work 100%. If I say Applying Transaction is NOT Return Authorization, the line still shows up because there is an Item Fulfillment and Invoice for each line. However, if I exclude Item Fulfillments then it omits lines that are shipped but have NOT been returned. Can't win...LOL