Skip to Content
0
Jan 08, 2011 at 05:57 AM

rebate agreement scales

226 Views

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.