This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

i am trying to create a saved search for sales order to show discount amount against each sales order but i am not able to find discount column ! does anyone know how to get discount column in a saved search

May want to add criteria where Item:Type is Discount

Amount Discount column selected in saved search but it is not showing the discount which is -6.51 for this sales order

There are 2 types of discounts as far as searches are concerned

line level discounts are discount items that are added in the item sublist

these discounts apply to the ltem above it (other discounts and markups dont count)

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

I am actually using a promotion which gives 25% of order amount as discount

just want to get this amount that is discounted from the sales order due to promotion applied

tried this column in saved search but it shows empty result

a promotion is a header level discount, its value is in the `Amount` column, not the `Amount Discount`

keep in mind that there is a specific search row for transaction discounts

its easiest to see this stuff by removing the filters on a search so that you only include an intenral id filter

found by removing filters .. Thanks for help sir . I was stuck in this problem since yesterday ..:+1: