how to show sales orders with no work orders created for the line item

AI generated answer (using internal Slack threads):

To show sales orders with no work orders created for the line item, you can create a saved search in NetSuite. Here are the steps: 1. Navigate to

Reports > New Search > Transaction

. 2. Set the

Type

to

Sales Order

. 3. In the

Criteria

tab, add a new criterion:

Main Line

is

False

. This will ensure that the search results include line items. 4. Add another criterion:

Type

is

Sales Order

. This will ensure that only sales orders are included in the results. 5. In the

Results

tab, add the fields you want to display. For example, you might want to include

Sales Order: Internal ID

,

Sales Order: Number

,

Item

,

Quantity

, etc. 6. In the

Summary

tab, add a new summary type:

Count

of

Sales Order: Internal ID

. This will count the number of line items for each sales order. 7. Add a

Formula (Numeric)

field in the

Criteria

tab with the following formula:

NVL({createdfrom}, 0) = 0

. This will filter out sales orders that have associated work orders. This saved search will return sales orders where no work orders have been created for the line items. You can adjust the criteria and results to suit your needs. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******