ANS-0163 · SAVED SEARCHES & FORMULAS
How to Accurately Reference Discount Information in NetSuite Searches?
Identify and utilize NetSuite's {discountamount} and {transactiondiscount} fields to accurately reference discount values in transaction searches.
Short answer
NetSuite uses {discountamount} for line-specific discounts and {transactiondiscount} as a flag for transaction-level discount lines. The actual discount value for transaction-level discounts is found in the 'Amount' field of the dedicated discount line. These discount lines are identifiable by negative values in both their 'Amount' and {discountamount} fields, which are typically identical.
Scenario
Users often need to accurately identify and retrieve discount amounts within NetSuite transaction searches. Understanding which fields contain the relevant discount data and how discount lines are structured is crucial for precise reporting and analysis.
Solution
NetSuite provides two key fields for referencing discount information within transaction searches: {discountamount} and {transactiondiscount}. The {discountamount} field represents the discount applied to a specific line item. The {transactiondiscount} field acts as a flag to identify a transaction-level discount line. The actual discount value for such a line is found in its 'Amount' field. It is important to note that main lines typically do not carry a discount amount directly. Instead, a dedicated line item represents the discount values. This dedicated discount line will display both its 'Amount' and {discountamount} as negative numbers, and these values will typically be identical.
Expert NetSuite Support
Need help with this NetSuite issue?
Saved Searches & Formulas consulting and configuration support