How to pull discount taken from line level field from the payment transaction record on a saved search?

AI generated answer (using internal Slack threads):

To pull the discount taken from the line level field from the payment transaction record on a saved search, you can follow these steps: 1. Base your saved search on the 'Customer Payment' record type. This will allow you to see the discount amount applied at the payment record level. 2. Use 'Applied to Transaction' in the results to see all invoice information. 3. If you need to include 'Cash Sale' and 'Invoices' in your criteria, use 'Applied to Transaction' with 'Type = Cash Sale' and 'Invoices' as your criteria. Also, include 'Type = Payment' in your criteria. 4. If you do not want to see all payments, add another criteria such as 'Discount is not null'. This will ensure that you only see payments that have a discount and are applied to invoices/cash sales. 5. If the discount is indicated at the line level on the payment, you can visualize the field. If not, you can use the NetSuite field explorer to flag this field by retrieving the ID. For body level discounts, these are represented as a discount line in a search. You can search for your transaction with 'Mainline is false' and 'Item Fields... Type is Discount' to see these discounts. For line and header level discounts, you can use the 'Amount Discount' field in a saved search with 'Mainline is false'. NetSuite distributes the discount across the line items. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******

Generate a saved search step by step