how can i create a saved search or suiteanalytic workbook in netsuite that compares the sales order total to the sum of all invoices against this sales order and return only sales orders where these numbers do not match. I am looking for orders where the invoice total is more or less than the sales order total.

AI generated answer (using internal Slack threads):

To create a saved search or SuiteAnalytic workbook in NetSuite that compares the sales order total to the sum of all invoices against this sales order and return only sales orders where these numbers do not match, you can follow these steps: 1. Create a new Transaction Saved Search. 2. In the Criteria tab, add the following filters: - Type = Sales Order - Main Line = True - Applying Transaction: Type = Invoice - Applying Transaction: Status IS NOT Paid In Full 3. In the Results tab, add the following fields: - Name (Group) - Amount (Sum) - Applying Transaction : Amount (Sum) 4. In the Summary tab, add a formula (numeric) field with the following formula:

abs(nvl({amount},0) - nvl({applyingtransaction.amount},0))

5. Set the Summary Type of this formula field to 'Sum'. 6. Add a criteria filter for this formula field to be greater than 0. This will return the sales orders where the total amount does not match the sum of the invoice amounts. Please note that this approach assumes that the sales order and invoice amounts are in the same currency. If they are not, you may need to add additional logic to handle currency conversion. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******