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

Problem with payment of supplier in different currency

By
Open Alpha LLC
on 3/17/16, 7:06 PM 667 views

Hi All,

We are receiving supplier invoices in various currencies.

We have also installed the exchange rate auto update module (and it works).

After registering the invoice in USD (our base currency is EUR), we want to pay it.

And we get the following

http://snag.gy/Q8UyX.jpg

As you can see the payment is in EUR and not in the currency of the invoice.

How can we pay the exact amount in the invoice's currency without using a USD journal?

So basically have odoo, pre-fill (or something like) the exact EUR amount based on the exchange rate on the day of payment.

Or alternately, register a payment after we have paid out the invoice from the EUR account (via CreditCard) and cross check the cost in EUR through bank statements.

Thank you All for Your Time.

Best regards,

Nick

0
Open Alpha LLC
On 3/19/16, 4:56 PM

Thank you both first of all

In Odoo 9 it can be done in one step. The interface provides for that.

Not the case in Odoo 8.

It seams that the journals in Odoo 8.0 auto acquire the company's base currency, even no currency is set for the Journal (or the bank account).

So trying to go through supplier payments, defaults to an equal amount in whatever the base currency is, no matter what the currency of the invoice is. If the invoice is 100USD, and you try to pay that out, Odoo will try to pay out 100BaseCurrency.

Apparently it can be done through a different path.

If one goes via Suppliers --> Supplier payments, then a payment against any or all journal entries for a specific supplier can be registered.

For specific supplier invoice, select the appropriate line (remove the other lines), select full reconcile and the result will be Odoo to convert from the invoice's currency to the base currency (taking into consideration the exchange rates manually or automatically updated).

Hope we are correct and hope it helps

Regards

Nick 

Yes, but if no currency is set, you can post entries in different currencies.

Ermin Trevisan
on 3/20/16, 1:49 AM

Hi Ermin, Apparently it can be done with v8 through a different path. Trying to just go through supplier payments, defaults to an equal amount in EUR no matter what the currency of the invoice is. But if one goes via Suppliers --> Supplier payments, then one can register a payment against any or all journal entries for a specific supplier. That way, the recorded amount for a specific bank account, will match the correct value in that account's currency. Anything we miss here? Appreciated Theo

Open Alpha LLC
on 3/23/16, 10:04 AM
0

Ermin Trevisan

--Ermin Trevisan--
3548
| 6 3 7
Walchwil, Switzerland
--Ermin Trevisan--


Ermin Trevisan
On 3/18/16, 4:37 AM

You will end up in the hell of mess if you refuse to use appropriate accounts and journals and try to fiddle around with exchange rate conversions. If you receive a bill in USD you have to pay it in USD (and not in converted EUR) and it has to be registered as such as long as there are no other agreements with your supplier. Please ask your accountant for a proper setup.

A simple hint to make your life easier: do not define a currency for your bank account or for the corresponding journal.

Thank you for your reply. Our concern is related to the fact that all currencies are paid out via our EUR account. We guess (combining what we read in the link provided bellow by Nilim) that not setting a currency for the bank account is part of the solution?

Open Alpha LLC
on 3/19/16, 2:57 PM

BTW No accountant involved yet. Believe it or not, no one felt brave enough to deal with a small company having a dominant currency other then USD. So the next question is, any link to provide "Accounting with Odoo for Dummies" style info? Thank you for your time.

Open Alpha LLC
on 3/19/16, 2:59 PM

You can delete the specific currency of a bank account or use a journal with no currency set. For Odoo accounting see https://www.odoo.com/documentation/user/9.0/accounting.html

Ermin Trevisan
on 3/20/16, 1:51 AM

The size of the company does not matter, you need somebody with serious accounting knowledge anyway, and you do obviously do not know enough about accounting in order to ensure proper multi-currency accounting even if Odoo helps a lot with automagic exchange difference posting when set up properly.

Ermin Trevisan
on 3/20/16, 1:55 AM
0
Nilim
On 3/18/16, 5:26 AM

Hi,

Refer to this link https://www.odoo.com/documentation/user/9.0/accounting/others/multicurrencies/how_it_works.html

Thank you very much. Useful. Though we will try it our selves, do you happen to know if this applies to v8 which is the version we are using?

Open Alpha LLC
on 3/19/16, 2:56 PM

Yes it applies to V8 even

Nilim
on 3/22/16, 12:48 AM

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

1 follower(s)

Stats

Asked: 3/17/16, 7:06 PM
Seen: 667 times
Last updated: 3/25/16, 7:28 AM