Withholding Tax calculation on the basis of Cumulated Invoice Amount

@7

Hi All,

We have a requirement where WHT is calculated on the basis of Total Amount Invoiced since 1 Jan. There should be no WHT calculated after a threshold limit is achieved, For Example-

For Amount range 0-25000 invoiced since 1 Jan of the year; withholding should be calculated @7.325%

and after 25000 of amount has been invoiced; there should be not WHT calculated.

Can you help me configure this. I have set WHT for Amount range and system is not calculating as per above expectations. I still calculates WHT even though more than 25K invoice amount is booked.

Best Regards,

Anil