Sure you’ve had a case where you need to see reports in different currency.. In Mexico it is common that customers need to see their accounting reports generated in USD, actually this workaround solved an specific issue where we had almost all of the invoices in USD but as a main currency in MXN we got a conversion in the accounting and we were looking forward to see that info in the original currency of the invoice, this helped a lot. 

To have the best outcome in this workaround it would be better to get this configuration set up since the beginning before they start entering data into Odoo. These are the very simple steps to accomplish getting those reports.

The first step would be to create a new company with the main currency that you need to see, in this example mentioned we need to see reports in USD for a Mexican company.

In this new company created you will go directly to the currencies and set the same configuration that you have in the original first company regarding the exchange rates, setting it up as daily in this example with the same source “Banco de Mexico”.

With this done, you’re ready to see reports!! As simple as that, you only need to enter this new USD company created and select the information from the main company.. 

Obviously this would be after you make transactions in the main currency, otherwise you can import the historic exchange rates into the new company USD to see these reports of transactions that were created before you knew about this workaround. 

While you have a balance sheet in MXN for the main company:

You can use the workaround to see it in USD:

Same with partner ledger or general ledger…

Hope it helps you guys to get an easy way solution to this issue..

Best,