Scale Based Discount - Question
There is a requirement in my client's business that the discount is based on the unit price of a particular material. And this discount is for specific customers.
i.e. If the price of a material is less that 500 then 10% discount, for 501 - 1000 -> 20% discount and For 1001 and above -> 25 %.
Now if I create a condition type with the above mentioned scales then the total value of the line item (but not Unit Price) is considered to determine the discount percentage.
This doesnot give the correct discount if there are multiple items in the line.
Is there any way to make the scales work based on Unit Price of the material ? Pls. help.