how can I add a criteria for a sales order search to get all sales order with 0 line items?

AI generated answer (using internal Slack threads):

To create a search for sales orders with 0 line items, you can use the following steps: 1. Create a transaction search. 2. Set the Type to 'Sales Order'. 3. Set Main Line to 'False'. This will exclude the main line of the sales order and only consider the line items. 4. Add a Formula (Numeric) field in the criteria with the formula

{quantity}

. This formula will return the quantity of each line item. 5. Set the condition of the Formula (Numeric) field to 'equal to' and the value to '0'. This will filter out sales orders that have line items with a quantity greater than 0. Here is a sample of how the criteria section might look: - Type is Sales Order - Main Line is False - Formula (Numeric)

{quantity} equal to 0

In the results tab, you can add the fields you want to display for each sales order that meets the criteria. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******

you can't create a sales order without any line items