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

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

By
Alti
on 12/12/13, 3:49 AM 913 views

Hello,

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.

Regards,

Thomas.

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

kaynis
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.

Alti
on 12/12/13, 10:15 AM

That would be difficult mate. Glad I could help

kaynis
on 12/12/13, 10:18 AM
0

Pierre Soum

--Pierre Soum--
1414
| 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!

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: 12/12/13, 3:49 AM
Seen: 913 times
Last updated: 3/16/15, 8:10 AM