Skip to Content
This question has been flagged
2 Replies
4961 Views
Avatar
Ernesto Fabian Rodriguez Coimbra

Hello,

using the orignal setup from odoo (free) and activating the tax to be included in the price 3% and 13% the Total is always wrong 3% is 2.91 and 13% is 11.17  from a price of 100

could someone knows how to fix this?


Avatar
Discard
Avatar
Ermin Trevisan
Best Answer

You should fix your mathematical brain! :-)

If you have a price of 100 including 3% tax, then 100 = x * (100% + 3%), so x = 100 / 103% => x = 97.087379 and tax = 100 - x => tax = 2.91

If you want to apply more than 1 tax rate, you have to specify if an applied tax should affect the base of subsequent taxes, means if the subsequent tax should be applied to the original net amount plus the previous tax or again to the original net amount:

Avatar
Discard
Ermin Trevisan

But don't worry, you are not the first one in this forum with the same problem ;-)

Ernesto Fabian Rodriguez Coimbra
Author

Thanks, that was very enlighten, but still have some doubt, we use 2 taxes so, when not including taxes in the prices: I got (price 100 and taxes 3% and 13%) 116.39

can you guess where the 0.39 is coming from?

Ermin Trevisan

Again, this is very easy: you did calculate 100 * 103% = 103 * 113% = 116.39.

Ermin Trevisan

This means you either did check "Included in Price" for the first tax (3%) and/or did check "Affect Base of Subsequent Taxes" for the first tax. See my amended answer and thank you very much for flagging it as an answer and upvoting it.

Avatar
Axel Mendoza
Best Answer

If you are seeing that in a report or analysis view you need to check your currency rate that need to be set it to 1 because Odoo does an currency convert between rates to display those values. Check the currency at your company form configuration, modify the rate to 1 and you will be ok

Avatar
Discard
Ernesto Fabian Rodriguez Coimbra
Author

Thanks, all is set in BOB and 1, should be something else