Community: Accounting and Finance mailing list archives
Re: problems with transactions in foreign currencies Odoo 9, 10by
I don't understand the way you are working. Odoo is able to work with foreing currencies witouth making manual transactions.
Let's try explaining how...
You can set currencies for the company and also for tarifs applying to customer or supplier
You can set the currency value by date in currencies table
You can use intermediate accounts to register variations for currencies adjusments.
All your documents transactions until the invoice will use foreing currency
When you validate the invoice if currency is different from the company's one you account move will register the amount in both currencies + the change value used
When you pay the invoice using foreing currency and depending the used payment method you will obtain the amount difference from invoice date to payment date so you will have all credit and debit differences registered an controled in intermetiate accounts
Everything is made automatically if you correctly set all parameters so... it's because of that I don't understand how are you working.
Wishing this helps:
Dear Odoo Community, I write this because, in my opinion, it's incredible to translate foreign transactions in a foreign currency to the company's currency with a calculator using accounting software. Yes I'm writing about Odoo 9, and likely about 10. Ten versions in the currency translating hell... Creating manual journal entries in a foreign currency an accountant has to write the currency amount and using appropriate FX rate write the amount in the currency of the company. Why using a calculator? Because there is only a simple field for a foreign currency amount and Odoo does not know about whether the amount goes to Dr or Cr. Let's take 1000 transactions.... Looks like the hell for accountants, doesn't it? How it could be? Company's currency is called 'functional currency'. Foreign currency - any currency other than that the functional one. So any transaction happens either in a functional currency or in a foreign currency. Therefore a transaction shall be entered as the Dr or Cr in a journal in TRANSACTION'S CURRENCY. Necessarily as Dr or Cr and not as it goes now when the currency amount is entered just into one field. Having an amount in the transaction's currency, Dr or Cr, it's really easy to get Dr or Cr amount in the functional currency. And easy super feature, for example, for the corporate edition to introduce a presentation currency - a currency in which financial statements are presented. The presentation currency can be the same as the functional currency - the most common case - but if someone wants a different presentation currency, voilà, use the feature, Fields for the account.move.line mode In a brief: amount_currency - remove and add instead debit_amount_currency credit_amount_currency change debit - calc as debit_amount_currency * FX_rate credit - calc as credit_amount_currency * FX_rate add presentation_currency_id debit_presentation_currency credit_presentation_currency -- Sincerely yours Artem Afanasev Public Accountant
Post to: mailto:expert-finance@mail.