TDS deducted on advance get reversed when we clear advance with invoive. but how the system should work in case there is a change in the rates of tds deducted between the two. For example, Advance made in march for Rs 10000, tds deducted @ 10 % 1000.
Now Invoice come in April for 30000/-, rated for TDS got changed (by budget) from either to 15% or 5%. We have made the approipriate tax codes and assigned them to the vendor master. But at the time of invoice processing TDS is deducted on whole 30000 @ either 15% or 5%.
Invoice 15 % 5%
TDS 4500 1500
F-54, Clearing of advance agt. Invoice, TDS will be reversed 1000 1000
Net TDS 3500 500
This is how system respond.
However, what should happen functionally is
Advance posting 1000 1000
Invoice [ 30000-10000] 20000 3000 1000
Total should be 4000 2000
I have checked JV, etc. but nothing is giving appropriate answer, Pl suggest on that.