NetSuite – Saved Search: Discount Amount not matching actual transaction value Context: On a Vendor Bill, the following line structure was set up: • Item 1 • Discount 10% • Item 2 • Item 3 • Subtotal • Discount 10% Objective: Display the discount amount on the same line as the item code in a Transaction Saved Search (column: Amount Discount). What was observed: The saved search does show a value in the Amount Discount column on item lines — so it is technically possible to display it. However, the values shown do not match the actual discount applied on the transaction. Screenshots show: • On the Vendor Bill: Item 1 (00K47010) has a discount of -10.00 applied • In the Saved Search results: • Line 1 (00K47010) → Amount Discount = -10.00 • Line 2 (Bianco Latte - Eau De Parfum 100ml) → Amount Discount = -19.00 The value -19.00 on Line 2 does not correspond to any discount visible on the actual transaction. Questions: a. Is this a known NetSuite behavior with discount lines in saved searches? b. Is there a workaround or alternative approach to correctly retrieve and display the discount amount on the same line as the item code? c. Is something being misconfigured or misinterpreted in the saved search setup?​​​​​​​​​​​​​​​​

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that the issue you're experiencing with the Amount Discount field in your saved search is a known behavior in NetSuite. a. Yes, this is a known NetSuite behavior with discount lines in saved searches. NetSuite seems to distribute the discount across the line items when the saved search is set to mainline false. b. An alternative approach to correctly retrieve and display the discount amount on the same line as the item code is to ensure that you're using the correct fields and criteria in your saved search. There are two types of discounts in NetSuite as far as searches are concerned: line level discounts and header level discounts. Line level discounts are discount items that are added in the item sublist and these discounts apply to the item above it. On search rows, the item the discount is applied to has the

Amount Discount

set to the discount amount. Header level discounts (order promotions and the header level discount item) are search rows which have the

Transaction Discount

column set to true. These have their discount amount in the

Amount

column. c. It's possible that something is being misconfigured or misinterpreted in the saved search setup. If you're using a promotion which gives a percentage of the order amount as a discount, this is a header level discount and its value is in the

Amount

column, not the

Amount Discount

. Make sure you don't filter out the specific search row for transaction discounts in your criteria. Remember to remove the filters on a search so that you only include an internal id filter and don't use summary columns. This should help you see the correct discount amounts. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******