Is there an easy way without creating a complex search, that when adding lines items to a sales order, to get the original rate without discounts?
b
battk
02/16/2022, 7:51 PM
be more specific, original implies there is an old rate
battk
02/16/2022, 7:51 PM
which sounds strange when adding new lines
s
screnshaw
02/16/2022, 7:54 PM
True. So we have a Default Discount on a price level and then different price points depending on the quantity. When a price level is selected, it shows the rate with the discount. I need a way to get the original rate so that I can add it to a custom column.
Right now I'd have to do a look up on price level's that also filters on the quantity range. I was hoping there is a simple getSublistValue I can do that will get it for me
c
creece
02/16/2022, 7:54 PM
There's no way to do this natively you're gonna have to script it because of price levels and other things. I've had to do something similar for a % difference in price vs default price level.
s
screnshaw
02/16/2022, 8:00 PM
Yeah, that's what I was thinking @creece My laziness was hoping that there was something not in the docs that was available to me.
Thanks!
b
battk
02/16/2022, 8:43 PM
you can probably just set the base price level and quantity to 1 and store that rate
battk
02/16/2022, 8:44 PM
more complicated would be doing that process using a copy of the transaction using N/record and dynamic mode