Odoo Help


How to update a currency when the invoices are already validated ?

on 12/12/13, 3:49 AM 1,544 views


While displaying my aged balance with the OpenERP v7 reports, I noticed that my currency rates were not up to date, so the total due by my customers didn't match the reality. It was due to a wrong currency exchange rate input. And we didn't notice it while validating the invoices.

Now I would like to know if there is a way to recalculate the currency exchange rates and change the journal entries in a kind of automated way (I would like to avoid recalculating the value of around 300 invoices manually).

I thought of cancelling invoices and re adding these but I think it would result in a mess, so I ask here if there is a more elegant solution.



I'd say you can't : it's the whole point of validating an invoice!

Cogitae, Pierre Soum
on 12/12/13, 6:56 AM

One way you can do that is export. If you have already validated your invoice and wish to change the currency, what you can do is export the invoice in question with all the fields then change the currency id to the one you want. Import the edited export file back into the application and the new currency type will be displayed. You might need to trace the invoice to other documents it relates too and do the same but that works for me

on 12/12/13, 8:13 AM

@Pierre: I was more hoping of getting a trick to not process every invoices manually. @kaynis: thanks that gave me part of a solution, I exported the file with the original price and currency and with a couple of spreadsheets formulas managed to reduce the list to the elements needed to be corrected, I did the editing manually but it probably made me win a couple of hours.

on 12/12/13, 10:15 AM

That would be difficult mate. Glad I could help

on 12/12/13, 10:18 AM

Pierre Soum

--Pierre Soum--

| 5 5 8
Aucamville, France
--Pierre Soum--
Pierre Soum
On 12/12/13, 7:02 AM

I'd say you can't : it's the whole point of validating an invoice!

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

1 follower(s)


Asked: 12/12/13, 3:49 AM
Seen: 1544 times
Last updated: 3/16/15, 8:10 AM