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 None [1] http://snag.gy/Q8UyX.jpg [2] 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

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

客戶關係
e-Commerce
會計
庫存
PoS
專案管理
MRP

All apps

所有帖文人獎章

標籤（查看所有）

odoo accounting v14 pos v15

關於此討論區

支援

Problem with payment of supplier in different currency

multicurrency journal supplier 8.0

12 回覆

11279 瀏覽次數

Open Alpha LLC

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

Open Alpha LLC

作者最佳答案

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

Ermin Trevisan

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

Open Alpha LLC

作者

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

Shivam D Sahu

Hello

https://www.odoo.com/documentation/user/9.0/accounting/others/multicurrencies/exchange.html

The above link will help you how to automate your currency rate and how to use different Bank Journal to maintain your record. And following link help you how to use multi-currency in your system.

https://www.odoo.com/documentation/user/9.0/accounting/others/multicurrencies/how_it_works.html

Thanks.

Ermin Trevisan

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.

Open Alpha LLC

作者

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

作者

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.

Ermin Trevisan

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

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.

Nilim

Hi,

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

Open Alpha LLC

作者

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?

Nilim

Yes it applies to V8 even

喜歡這則討論？不要只閱讀，加入發表意見吧！

今天就建立帳戶，享受獨家功能，與我們精彩的社群互動！

註冊

相關帖文	回覆	瀏覽次數
how to filter by customer or supplier in journal entries filter journal customer supplier	0 3月 15	5251
Journal Entry not appearing under Supplier or Customer accounting journal customer supplier transactions	1 3月 15	6216
Second website not showing multiple currency option (odoo v15) multicurrency	1 3月 23	2748
How can you create journal sequences based on accounting posting dates? 已解決 journal	2 6月 22	3859
Impossible to find multi currency 已解決 multicurrency	2 1月 22	3948

此問題已被標幟

喜歡這則討論？不要只閱讀，加入發表意見吧！