Odoo Help


Chart of taxes, wrong calculation

Björn Kruggel
on 8/8/13, 3:31 PM 3,548 views


I have a problem with the chart of taxes when it is configured for the application of two different taxes on a product (as in the province of Québec, Canada, where there is a provincial sales tax and a federal sales tax). Please see this image: imgur.com/ihQUmL1 When you have a look at "Base de taxes", it seems to be adding "Base de la TPS" to "Base de la TVP" - while, in fact, the Basis for the tax calculation is the same. Is this a bug or a local problem? Has someone encountered this behavior before?

The second, more important part of the problem, is that the tax calculation itself is wrong, because it doesn't properly calculate refunds. When I click on "TPS reçue", which in the overview is at 190.65, I see that: imgur.com/J832To4, so in the credit column 162.63 and in the debit column 28.02. The debits is there because a refund or cancellation of an invoice has taken place. Obviously, the received taxes are Debit (minus) credit, so 134.61, NOT Debit (plus) Credit.

Has anybody else encountered that? Should I open a bug report or is this a problem with my local configuration?



Anas Taji

--Anas Taji--
| 6 7 8
Amman, Jordan
--Anas Taji--

Skype: anas.taji-sw

Email: anas.taji@smartway-jo.com

Anas Taji
On 8/8/13, 11:07 PM

Have you configured the following correctly?

In Accounting -> Configurations -> Taxes -> Tax Codes

Base Purchases + Tax Purchases to have Coefficent for parent = -1

Base Sales + Tax Sales to have Coefficent for parent = 1

In Accounting -> Configurations -> Taxes -> Taxes

  • Sale Tax (Invoices): Base Code Sign + Tax Code Sign = 1
  • Sale Tax (Refunds): Base Code Sign + Tax Code Sign = -1
  • Purchases Tax (Invoices): Base Code Sign + Tax Code Sign = -1
  • Purchases Tax (Refunds): Base Code Sign + Tax Code Sign = 1

Hope this configurations will help you..%

Hello again Anas,

It seems like you were completely right, this is the solution. a) ONLY Base Purchases + Tax Purchases need to have coefficient -1 - the actual sums need to stay positive (so that it gets substracted only once, as -- is +)

b) I forgot to set the refund and invoice code signs on the children as well - silly me!

B changes (refunds) will only kick in with new invoices.

Thank you very much for your help!

Björn Kruggel
on 8/28/13, 3:58 PM

Glad to hear it, you may want to vote up and/or mark this answer as the best answer, so others can benefit too..%

Smart Way Business Solutions, Anas Taji
on 8/30/13, 8:01 PM

How did you make the red color text on your post???? I want to do it!

Pascal Tremblay
on 11/25/14, 8:04 PM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

2 follower(s)


Asked: 8/8/13, 3:31 PM
Seen: 3548 times
Last updated: 3/16/15, 8:10 AM