We have a scenario to deduct security deposit for vendors after their bill amount reaching certain amount say 10,00,000. We have already configured security deposit in Withholding tax code route. We have developed a Z report to arrive bills passed till date and activating Withholding tax code created for SD purpose.
Now we thought of using WT accumulation route in conjunction with formulas for WT to define up to certain amount, zero SD and after that the desired rate. The problem in using accumulation is, we can accumulate only for the year or calendar year or monthly or quarterly. There is no provision for accumulating more than a year.
Kindly suggest how to achieve the requirement.