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 there a way to remove Shipping Line Items from Sales Transactions-oriented reports, similar to how Transaction Saved Searches need to have `Shipping Line` set to false in its criteria?

There seems to be a `Sales Transaction &gt; Shipping Item` field in Reports, but when I use this field as a filter, the Report  filters out entire invoices whenever a “Shipping Item” exists anywhere on those invoices :rage:

Main line false + item is not shipping line as 2 criteria line items?

It might be shipping line or shipping item rather than selecting none of item = the item # for shipping items tied to your GL/COA 

Reports don’t have fields called `Main Line` nor `Shipping Line/Item` though

On the filtering section you can’t do not equal to shipping lines or the item you have associated when shipping lines are present right?

There is no `Shipping Line` field, correct.

However: there is a `Shipping Item` field, and when I set the filter to not include Shipping Items of `UPS Ground`, then the Report filters out ALL the line items on any invoice record associated with this Shipping Item

I would try it in saved search format although I’m sure your user wants the report version 

<@U9CQ584RE> I don't know if you ever figured out this issue, but I was able to resolve it by using the Transaction Line &gt; Item Type &gt; None of Shipping Cost Item