Odoo Help

Welcome!

This community 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.

0

Incorrect exchange rate calculation on Purchase Journal (BRL)

By
Luciana Souza
on 7/23/15, 2:57 PM 553 views

I am new to Odoo and am trying to create a supplier invoice with a foreign currency (CHF). My company base currency is BRL.

When I check the exchange rate for CHF I see only one value: 12/31/2009    1.308600

I create the supplier invoice with one item costing 100CHF. A tax is applied to this invoice in a total of 15% (15CHF). So far all is ok.

When I check the entry in the Purchase Journal (BRL) I see the following values:


Invoice

Name
Account
Debit
Credit
Amount Currency
Currency
Tax Account
Tax/Base Amount
Status
EXJ/2015/0002
/
120000 Creditors
0.00
196.36
-115.00
CHF

0.00
Balanced
EXJ/2015/0002
OTAX S
110300 Tax Paid
25.61
0.00
15.00
CHF
Tax Paid Rate S (15%)
25.61
Balanced
EXJ/2015/0002
Test Product
220000 Expenses
170.75
0.00
100.00
CHF
Taxable Purchases Rated S (15%)
170.75
Balanced


I don't understand why the exchange rate calculation finds this values.

I expected to see:

Instead of 170.75 (BRL), it should be 130.86

Instead of 25.61 (BRL), it should be 19.63

Instead of 196.36 (BRL), it should be 150.49


Any light into this matter would be greatly appreciated, I have already invested quite some time trying to get this to work with no success.

Many thanks


-------------------------------------------

Unfortunately I don't have enough Karma point to comment on the first answer I got from zbik, so I edited my own post.

It is possible that this issue is related to the one you posted if the scenario I described is indeed a bug. From the description on the related bug I cannot really say, as it focuses mainly on the source code, and so far I am simply using the GUI.

The scenario I described is a very basic one for multi-currency. If I did not miss anything and indeed the exchange rate calculation is wrong, this would be a very severe bug.

Can anyone confirm that the scenario I described is correct and the calculation is incorrect?

I forgot to mention, I tried with two versions of odoo: -Free trial online (Version 8.saas~6) -Locally installed (Versão 8.0-20150401)

Luciana Souza
on 7/23/15, 3:02 PM

We found the solution for the problem. It turns out that the echange rate for BRL was not set to 1. I don't know why the system does not set it to one once we chose BRL as the base currency. Setting it to 1 solves the issue.

Luciana Souza
on 7/24/15, 12:49 PM
0
Pierre Lamarche
On 7/24/15, 4:46 PM

You probably forgot to set your base currency exchange rate to 1.00.

P.

0

zbik

--zbik--
5941
| 6 4 7
Lodz, Poland
--zbik--


zbik
On 7/24/15, 6:19 AM

See this issue, it is possible that this is the same problem.

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

2 follower(s)

Stats

Asked: 7/23/15, 2:57 PM
Seen: 553 times
Last updated: 7/24/15, 4:46 PM