Example of a Mexican company looking forward to get reports in USD….
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Comptabilitat
- Inventari
- PoS
- Projectes
- MRP
This question has been flagged
1
Respondre
5074
Vistes
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,
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Registrar-se| Related Posts | Respostes | Vistes | Activitat | |
|---|---|---|---|---|
|
0
de maig 23
|
2587 | ||
|
0
de juny 24
|
1875 | ||
|
1
d’oct. 25
|
993 | ||
|
0
de març 21
|
3554 | ||
|
0
de febr. 21
|
4036 |
Hi.. I recently tried your solution by doing the following:
Company A with PEN as main and USD secondary
Company A USD with USD as main and PEN as secondary
I registered sales in Company A in USD because many of the products are imported and sold in USD. The reports when I enter in Company A USD all of the reports are inaccurate. It will show something like this:
Company A
Balance: S/112,232
Company A USD
Balance $112,232
It takes the raw number from the original currency and just changes the currency sign which is completely wrong.
Do you have any ideas for this case? We are registered sales/bills in USD in a company that has transactions in both PEN and USD. I need to get reports in both currencies if possible or be able to switch to see them in each one.
This sounds like Odoo is using the default exchange rate of 1:1 - for your options to manually or automatically update exchange rates, see https://www.odoo.com/documentation/18.0/applications/finance/accounting/get_started/multi_currency.html#manual-update
Hi José!!. Thanks for the advise. I have tryied this out and can not get it to work properly. I have created the second company, but the only difference when viewing a report from de second company (Both companies selected, but the second one in Bold), is that the reports are translated to the new currency, but taking into account only the last exchange rate. Its like dividing the hole report of the main company by the last registered rate, instead of every move with is corresponding rate. This is true not only for historic transactions (I've already imported historic exchage rates), but also for the new ones. Every time the exchage rate changes, al reports change accordingly. Am I doing something wrong?