I have created a report built on Sales Orders, where the Document Number is grouped, and I am displaying line items along with a custom date field from the line item. When I run the report, there is one Sales Order that includes a Work Order. The report is showing the Work Order item as well, even though the Sales Order contains only one actual item. How can I remove the Work Order item from the report? Its type is still showing as Sales Order.

AI generated answer (using internal Slack threads):

Based on the conversations, it seems like you are trying to exclude a specific type of line item (Work Order item) from your Sales Order report. In NetSuite, you can achieve this by modifying the criteria of your report or saved search. Here's how you can do it: 1. Go to your report or saved search. 2. Navigate to the 'Criteria' tab. 3. Under 'Filters', add a new filter. 4. Select the 'Item' field. 5. Set the operator to 'none of'. 6. In the value field, select the Work Order item that you want to exclude. 7. Save your changes. This will exclude the Work Order item from your report, even if it's associated with a Sales Order. Remember, this method works if the Work Order item is a specific item that you can select. If it's a type of item, you might need to use a different field for the filter, like 'Item Type' or a custom field that indicates the item is a Work Order item. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******