Saved search formula with summary type and main line = any to display qty billed and po subtotal. need formula for po subtotal that is not duplicated.

AI generated answer (using internal Slack threads):

To create a saved search formula with summary type and main line = any to display qty billed and PO subtotal, you can follow these steps: 1. Create a new Transaction Saved Search. 2. In the Criteria tab, set Main Line to False. This will allow you to access line item data. 3. In the Results tab, add the following fields: - Quantity Billed (Summary Type: Sum) - Amount (Summary Type: Sum) 4. To avoid duplication of PO subtotal, you can use a Formula (Numeric) field with a case statement to only sum the Amount when the line is a PO line. The formula could look something like this:

CASE WHEN {type} = 'PurchOrd' THEN {amount} ELSE 0 END

. Set the Summary Type for this field to Sum. Please note that this is a general guide and you may need to adjust the criteria or formula to fit your specific needs. Also, the field names and values used in the formula are based on standard NetSuite fields and values. If you have custom fields or values, you will need to adjust the formula accordingly. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******