lower rate tds deduction- tds calculation

@3%

Hi All,

I have created lower rate tds setup . also i have created tds threshold setup as follows

cummulative tds threshold

Sec 194(c)

1- 200000 = 0.5%

200001      = 3%

i attached this to a supplier x

Now i have created first invoice for amount of 100000 for supplier X .

Tds caluated as follows =500 (100000*0.5%)

now i have created second invoice against this supplier for amount 150000

Tds calculated as follows =7000 ( 250000*3% - 500(tds amount calculated earlier)

My requirement is that if the amount exceed 200000 then tds is to be calculated on increase amount @3% .

in this case tds amount should be as follows

upto 200000@ 0.5% = 1000

next 50000@3 %= 1500

how to do the following setup.