Invoice in a different currency than the Sales Order

The problem is when I perform the invoice from the sales order, OpenERP assumes the same currency must be used. And if I edit the invoice and change the currency, it does not update the amounts based on the currency exchange (if the invoice was USD100, I change the currency of the invoice and remains EUR100).

Thanks!

Nicolas Lopez

Author Best Answer

So this is the module requested (and paid) by the company where I work, that solved the issue: account_sale_different_currency

Mehmet Demirel

I have same problem. This problem is big problem. This problem must be resolved immediately!

Nicholas Hamilton

I would be moving to a different country.

Nilim

Hi Nicolas Lopez,

W.r.t your query, I have gone through it and tried to replicate it. Few recommendations which I would like to suggest you which might cater to your needs are as follows:-

1) In odoo if you have a Sales Quotation in a particular currency then the whole process of generating invoices(i.e. the Accounting part) would be in the same currency.

2) The reason behind this to keep track and avoid discrepancy of information/Data which is the major function of implementing an ERP

3) Hence, if Sales Quotation is in different currency and customer wants to pay in different one then the only option we have currently is through Customer Payments. Here we can make Customer payments in any currency as per our requirement and to track payments we can either mention Invoice Number or payment ref, so that we can refer back to the payment later.

Hope this helps

Cheers!!

Nicolas Lopez

Author

Hi Nilim, thanks for your answer. Just a few comments: 1) Yes, that's exactly the issue for this business case, the whole process in the same currency. 2) I do not agree with this statement. If you keep record of the exchange rated used to "translate" from one currency to another, there would be no discrepancy at all. 3) This is not the business case I described, it should be: Quotation in one currency, INVOICE in another currency. Finally the solution was to develop a custom module: now when we create a quotation, we set the currency that will be used for invoicing. Then when the invoice is created, Odoo uses the currency exchange set for that day and sets the amounts of the items accordling. Cheers Nicolas.

Nilim

Hi Nicolas, Hope my answer helped you.As you were of the view that the requirement would need a custom module to be developed hence I would like to convey you that,We are one of the leading provider of Odoo customized modules, hence in case you require any customization feel free to get in touch with us anytime. We will be glad to help you. To get in touch with us you can simply follow the link http://webkul.com/ticket/ Regards Nilim

Fabrice Henrion (fhe)

Could you precise the business scenario where you need to do this because it doesn't sound like something you should do at all. If it was allowed, you would end up with an invoice that refers to an order that is different (because of a different currency). OpenERP doesn't allow that.

If your customer asks you to get an invoice in a different currency than the quotation (or order) you sent him, you should create another quotation (or order) with the correct currency and create the invoice out of that correct quotation (or order).
On the other hand, if your scenario is that your customer got the invoice in USD but is going to pay you in EUR, then what you need is to keep your invoice in USD and create a customer payment in EUR that will reconcile it (which OpenERP supports).

Nicolas Lopez

Author

Dear Fabrice, thanks for your answer. The business scenario is very tipical in my country: due to inflation, some companies quote in USD, and when it's confirmed they invoice in local currency using the exchange rate of the invoicing day. Your suggested approach (creating a new quotation/order in local currency when it's confirmed) has a drawback: in my case many times we invoice 50% at the begining of the project, and 50% when it's finished, therefore the currency exchange rate is different for those two invoices.

Fabrice Henrion (fhe)

Why can't you invoice in USD and request the payment in local currency? This way it will take the exchange rate into account, even if 50% is paid at the beginning and 50% at the end.

Nicolas Lopez

Author

Just because of the local regulation, invoices must be in local currency. I know it could sound a bit strange for you, but it is what it is. So this kind of operation is very frequent here: quotation in USD, invoice in local currency using the day's exchange rate.

Ing. Daniel Blanco

This problem is not only for AR, it happens in different countries. For example in Chile is usual to quote in UF, and to invoice in CLP. The difference between these is not so big, but in long contracts, or in properties for example is very useful.

This question has been flagged