Hi,
We in our company has implemented rebate agreements. We have monthly offtake rebate as one of the rebate agreement type. The scales are as
0-50 nil
51-100 Rs. 375/MT
101-200 Rs.425/MT
201-500 Rs. 500/MT
> 500 Rs. 600/MT
Total billed qty for a month is 250 MT.
Currently it is calculating as 250MT*Rs.500 = Rs. 125000 as the rebate amount.
But the system should calculate as below
first 50MT - 50MT*0 = 0
second 50MT 50*375 = 18750
for 100 MT 100*425 =42500
last 50 MT 50*500 = 25000
total rebate amount = Rs.86250
I tried with scale type D - graduated to-interval but it is not accepting this scale type.
Please help me to solve this problem.