How To Fix Tax Calculations

[Former Member]

Hi,

We have two taxes, provincial (5%) and federal (5%). We have a tax code for both that of course combines the provincial and federal taxes. If we create a document with a line item that has both taxes applied, the calculation is incorrect in some cases because instead of calculating each tax one by one, rounding each, then adding them together, it simply uses a combined tax percentage of 10%. This is incorrect because when we report our taxes each must be rounded and paid individually.

Example:

Line Item 1 - Price $62.10 - Tax - $6.21

The tax calculation should really be $6.22 because each tax calculates to $3.105 which rounds to $3.11 for a total of $6.22.

Are there any plans to resolve this issue?

Thanks,

David

[Former Member]

Are you using 4 decimal or 2?

[JesperB1]

Hi David,

This is also something that you can approach your local field organization with. They will have an answer or continue the discussion with the regional solution management.

Jesper

[Former Member]

This is current B1 system design. For future availability, you probably need to post a development request on the following forum:

/community [original link is broken]

Thanks,

Gordon