Odoo set invoice currency in multi-currency environment
Channel: TC Academy
Date: 2020-04-23

In Odoo it is possible to utilizar several different currencies. The company in this example video has US Dollars as a main currency and products are sold to European and Mexican customers. Mexican customers expect offers done in pesos and European customers expect offers made in euros.

We have installed and configured multiple currencies and enabled a function to automatically update their exchange rates. It should be noted that Odoo accounting accounts and journals should be set to one currency only per account and journal. We have thus generated copies of the main accounts for each currency. As this operation has to be carried out manually and it triplicates the number of accounts, only accounting accounts that really need multiple currencies are done for now.

To manage the customer quotations there are two concepts that have to be taken in account.
1. Odoo system has price lists. Typically a price list is used for applying discounts (buy three products, get 20% discount) but they can also be used for currencies. This is exactly what we have done. The system has three public price list who each apply the currency rule and then a 0% discount.
2. Each customer has a default price list. In this system the clients have currently a default price list of US Dollars. This can be changed later on per client or per quotation.

To create a quotation in Mexican pesos, please follow these steps:
1. Create a new quotation
2. Select the customer
3. Select the price list
4. Add products

Note that the product prices in the quotation change automatically to reflect the applied price list. Also note that it is not possible to combine multiple currencies to one quotation.

Changing the price list (of currency) after products have been added to the quotation does not cause update of prices. The products added must be first removed to have the selected price list applying correct price and currency. Also, note that one must first select the customer, then the price list. (Customer has the price list as an attribute).

The system is using Odoo 13 CE and has following add-ons:
Openworx Material Backend Theme V13 
Cybrosys Odoo 13 Full Accounting Kit 
Terra Colligo Import product in Batch
Alpha Brains Auto-update Currency rate