Kindly try to understand my requirement, I am working on this but not getting
As our requirement is <b>to calculate rebate on cumulative sales for the entire year</b>, I
tried it using scale. However, system adds the rebate value of every billing
document and showing it as an accrual value & finally it takes sum of all billing
document value to calculate rebate.
For example Scale is given as 10,000 1%
First order delivery invoice created for the amount 42,000 EUR, then system
calculate accrual value as 420 EUR(1% of 42,000) and maximum payment
amount as 1260 EUR (3% of 42,000 )
Similarly when we creates next order for 24,000 EUR then accrual value is 660
EUR [420 +240(1% of 24,0000)] and maximum payment amount as 1980 EUR
(3% of 66,000)
Whereas my requirement is as follows
System should add the all invoice value and the for first more than 10,000 it
should calculate rebate as 1%
For more than 20,000 --- 2%
For more than 30,000 --- 3%
and then add it.
Ple suggest on this.