Apply different WTH rates based on cumulated Gross amount per period

Summary:

Hello,

We have the following requirement for WHT:

If Cumulated Invoices Gross amount per month is less than 50,000 we need to apply a rate that is different from rate when Cumulated Invoices Gross amount per month is greater than 50,000.

We used Gross amount Rate schedule and defined it as follows:

on WHT Tax:

Rate Schedule Controls: Schedule Basis = Period

Apply Single rate on total taxable basis = not checked

On Tax rate:

Rate Type: Gross Amount Rate Schedule

Min Value 0 and Max value 50,000 —> Rate 0%

Min Value 50,000 —> 15%

The system behavior is as follows:

if total invoices amount for the month is 45,000