Sales Order in Multiple currencies not considering in sales analysis reports

[mmotahar]

Impacted versions:
11e

I copy over the original issue.

In sale order multiple currencies accepting, but in reports and other analysis sum of sales value not consider the different currency effect.
Ex. I have sales orders like (5000-USD , 5000-EUR and 10000-AED)
the total will show the total sales order value is 20,0000/-
It should show separately currency wise and one more column to show in local currency.
Otherwise the information is wrong.

It's already reported here #4434
and wasn't fixed since 27 Dec 2014 and a template reply on 13 Dec 2017 from @Yenthe666 said :

"Hi @orchidinfosys,

Thank you for your bug report and our apoligies that we haven't had the time to look at this bug report. We do our best to handle all of them, but we sometimes miss some.
At this point Odoo 8 is no longer supported as Odoo only supports three versions (9.0, 10.0, 11.0 at the moment).
If you can still reproduce this issue on Odoo 9, Odoo 10 or Odoo 11 we encourage you to create a new bug report.

Regards,
Yenthe"

Technically It's not difficult to fix. Please review and provide feedback.

[alyngsoe]

@seyed-mohammad-motahar , i had this issue in odoo 11 enterprise also. You can simply solve it by setting exchangerates for currencies you are using. Remember to set the date of the exchange rate back to the earliest date of your first salesorder. After settting the currecy rates, the sales analysis report will show you the amounts in your base currency.

[CheYangLin]

I have the same question and that's why I add my comment for anybody who can help us to grasp a clear understanding on what we are asking.

And I still can not setting exchangerates for currencies you are using with set the date of the exchange rate back to the earliest date of your first salesorder to solve this problem.

It still show difference currencies.

========================================================
Let’s say, you sold 100 units of product P1 at price 100 USD to customer A and 100 units at price 80 EUR to customer B.

In terms of sale amount 10,000 USD to customer A and 8,000 EUR to customer B.

Let’s assume your base currency (company default currency) is USD and current exchange rate 1.25 USD/EUR.

Then the total is 20,000 USD ( = 10,000 + 1.25 * 8,000 ).

But I couldn't find any report showing this.

What I really want is simply a report like below:

Product Quantity Ccy Price (in Ccy) Amount (in Ccy) Amount (converted)

P1 100 USD 100 10,000 10,000

P1 100 EUR 80 8,000 10,000

    Total                                                                                  20,000

Can anyone help me to get this type of report?

Thanks in advance.

[farazbdm]

is there an update on this issue, as Sales Analysis becomes totally unreliable for companies which deal in Multiple Currencies, with this issue.

[mmotahar]

As I mentioned It wasn't fixed since 27 Dec 2014 I haven't seen any commits related to this. we fixed it with a quick customisation.

[ladrua]

@mmotahar could you elaborate how you customized to fix it?

[farazbdm]

@mmotahar could you elaborate how you customized to fix it?

@ladrua answer by @alyngsoe is the perfect solution to it. Its already there just need to configure historic exchange rates.

Still if you are not able to get around it, you can write to me, i will configure it for you, free of charge. As i remember my suffering in the same situation, in which you are now.
farazda1@gmail.com

[ladrua]

Thanks @farazda1 thats very generous of you. But I have changed the exchange rates and made sure they are back in time. But still the reports are showing the numbers as is they are the defautl currency. Do I need to retrigger the calculations somehow?

[farazbdm]

Thanks @farazda1 thats very generous of you. But I have changed the exchange rates and made sure they are back in time. But still the reports are showing the numbers as is they are the defautl currency. Do I need to retrigger the calculations somehow?

For me just setting up exchange rate before transaction date worked, no retriggering was needed.