Skip to Content
This question has been flagged
salesinvoicing
10 Replies
24139 Views
Avatar
Nicolas Lopez

Hi All

I would like to know hoy to perform the following in OpenERP 7:

1) Create a quotation + sales order in one currency (let's say USD)

2) Invoice the previous sale order in a different currency (EUR)

I already have multicurrency, exchange rates and 2 pricelists (USD and EUR) configured.

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!

Avatar
Discard
Avatar
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


Avatar
Discard
Avatar
Mehmet Demirel
Best Answer

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

Avatar
Discard
Avatar
Nicholas Hamilton
Best Answer

I would be moving to a different country.

Avatar
Discard
Avatar
Nilim
Best Answer

 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!!

Avatar
Discard
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

Avatar
Fabrice Henrion (fhe)
Best Answer

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

Avatar
Discard
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.

Related Posts Replies Views Activity
Problem when partial invoice.
sales invoicing
Avatar
Avatar
1
Mar 15
4629
Problems with inventory valuation in odoo 17 Solved
sales inventory invoicing
Avatar
Avatar
1
May 25
2194
New Sales App
sales invoicing quotation
Avatar
1
Nov 23
2924
How to implement internal invoicing?
sales invoicing repair
Avatar
0
Sep 24
2391
Odoo 12 Invoicing policy selector per order
sales invoicing odoo12
Avatar
0
Aug 19
2997