We are using App 9 with Avalara AvaTax connector for tax calculation. Florida has a discretionary surtax rule, where they have a cap of $5000 for county tax. This applies to the most Florida counties. The problem we are facing is the customer order tax amount is inaccurate, but the associated customer invoice has the correct tax amount. This is caused by the way IFS is sending the data to AvaTax.
That is:
Customer order sends each line item to be calculated.
As for FL discretionary tax, any amount over $5000 is exempt from the county tax.
For instance, when a line item amount is over $5000, the correct tax amount is calculated. Majority of line items are under $5000, so the sum of the tax on the customer order is inaccurate.
Whereas the customer invoice tax amount is calculated with total net amount, instead of each line item. Therefore, it is creating a discrepancy between the customer order amount and the customer invoice amount.
Has anyone experienced the same issue, and did you find any solution or workaround?