How can I make a saved search show me the total amount distracted on each order and item line? We do discounts on item lines and not using the Discount Item field.

AI generated answer (using internal Slack threads):

To make a saved search show the total amount discounted on each order and item line, you can use the 'Amount Discount' field in your saved search. This field will show the discount applied to each line item. Here are the steps to create such a saved search: 1. Navigate to Reports > Saved Searches > All Saved Searches > New. 2. Select the record type for which you want to create the saved search. In this case, it would be 'Transaction'. 3. In the Criteria tab, add 'Main Line' is False to only show line items. 4. In the Results tab, add the fields you want to display. For your case, you would need 'Name', 'Item', 'Amount', and 'Amount Discount'. 5. If you want to see the total amount discounted for each order, you can use a summary type of 'Group' for the 'Document Number' field and 'Sum' for the 'Amount Discount' field. 6. Save and run the search. This will give you a saved search that shows the total amount discounted on each order and item line. Please note that this approach assumes that you are applying discounts directly to the line items and not using the Discount Item field. If you are using the Discount Item field, the discount amount would not be reflected in the 'Amount Discount' field. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******