In SBO we have price levels defined by UDFs.
(Unit Price in database is $2.00)
PriceLevel1 = $1.80
PriceLevel2 = $1.60
PriceLevel3 = $1.40
PriceQty1 = 10
PriceQty2 = 20
PriceQty3 = 30
When a customer orders 10-19 of an item they get PriveLevel1 discount, 20-29 is PriceLevel2, and 30+ is PriceLevel3. These prices are changed in the sales order during entry via an add-on written by our partner.
We would like to find a way to display this discount in PLD Invoices. I.E. if they bought 12 items their discount would be 10%, 22 items is 20%, 32 items is 30% discount.
I've been unable to do this using the formula editor. I am not sure if it is possible to do it otherwise?