AR Tax being added twice to invoice total (E10)

Hello,

I am having an issue where my invoice total is adding the tax in twice.

When I look at a line for the invoice I see the sub total, Misc Charges, and the tax amount. Then the line total which is all of those values added together. However, when I navigate to the header/summary tab I see the total for the lines as the sub total, which includes the tax for each line. I also see the tax appear again in the Tax field for the invoice header. That tax amount is then added again to make the Invoice Amount more than it should be by the tax amount for each line.

Example below:

Line 1: Subtotal:100, Tax 7, So the line total would be 107
Line 2: Subtotal: 50, Tax 3.5, SO the line total would be 53.5

on the head level it will say the subtotal is 160.5
on the header level it will say the tax is 10.5
on the header level it will say the invoice total is 171.00

In the example the tax is being added twice, once at the line level and once at the header level. This is not accurate and I’m not sure what would be doing this? Any information or direction to look into for this would be great.

Thanks!

This sounds like a tax setup issue.

On the tax type setup there is a document (header) or line field on the tax
rate effective rate tab.

Then on the tax liability screen on that taxes tab a similar field called
tax method.

Then on the customer master billing tab the tax level field is also per
line or per invoice.

My guess is you are cross wired somewhere on one of these fields.

Brad

Hey Group,

I just wanted to add an update to this Thread. This is a known bug with Epicor on 10.1.XXX.XX version using the Tax Connect module. So if you are seeing this issue a 10.1.400.18 hot fix is available.

1 Like