I'm trying to search on the "NS Item Rate" of a discount line item. And so far nothing gives me that value. I can't even find a reference to that value in any of

item

or

line item

details.

this sounds like rate, but thats probably too obvious for what you are describing

On the Sales Order, on the line item it has "NS Rate" as the column header. The item itself is a "null" item it exists so that we can apply line item discounts. So it relates to a Discount item which reduces the 'real' line item's

Rate

by an amount set by the coupon.

NS Rate is not the standard label for a field in netsuite

I went trudging around the custom form and I couldn't find the information I'm looking for. I've added a screen shot of the key info I'm trying to work with. 1. the is the code and apropriate NetSuite Promotion 2. the line item that gets added to calculate the discount (referenced by the promotion) 3. the

NS Item Rate

The value that affects the Sales Order value (I'm putting this here for explicitness sake) 4. the value I wish to grab for the saved search

looks like the rate field to me

You are looking for Amount Discount?

for your search, matching the row with the item column set to

Webstore Discount from Promo Code

will have an

Item Rate

set to -20 (or maybe -20% depending on the account)

@Michael King Yeah I'm trying to pull the discount value.

I meant, the field, Amount Discount {discountamount} is that value

amount

hmmm

keep in mind that these values may not match exactly if the currency on the sales order is different

You will duplicate potential results unless you omit the discount item from the results if I recall

@battk Thankfully we don't really deal with international currency, so that shouldn't be an issue at this time, still Puts a note about this in "back pocket"

I am doing this from memory so its a little difficult at the minute, but I think you just run a saved search with the required fields, include amount discount, but omit the item type discount item to avoid duplicating the line. Again, I cannot be sure from where I sit

screams in field name hell For reasons that I am struggling to understand there is no field for "Discount Item" in any of the drop down options. attached image of Criteria list, maybe you all can see something I'm not.

honestly your item : Manufacturer filter will probably exclude the discount item

🤬 That is kinda the point of the search. I want to gather all the items from a particular Manufacturer, and then calculate the promotional/discount value for our and their records. And a little reimbursement.

use the

Amount Discount

column

I sorta wish NS would let you "comment out" search items so you could try out ideas w/o having to keep adding new searches.

if that doesnt give you what you want, then you need to use expressions in your saved search so you can use expressions like AND, OR, NOT

I appreciate all the help. I'm not seeing

Amount Discount

coming up in the field list. ☹️ I'm gonna contact NS support, hopefully they can help me see the thing that I'm missing.

Its a very old column, should be in the search results

Oh! I've often wonderd what the "Results" tab was for. I've not seen that in the results before, but then again I didn't need to look for it till now.

um, @Michael King can have the kiss

I could kiss you both, TBH! You both have been very helpful! That said, the acceptace of the kiss is up to you. 😉

holy shit is

Amount Discount

new?!?!? i have been wanting to run saved searches to determine an item’s original amount, the discounted amount and the difference for years (please say it’s new)

its old, its at least as old as the 2014.1 record browser: https://system.na0.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2014_1/script/record/transaction.htmls