Odoo: Multi-currencies: Odoo sums amounts of different currencies

[DiepNP]

Impacted versions:
12.0 Enterprise

Steps to reproduce:

• Multi-companies with multi-currencies
• Sales/ Orders > list view (or other views as well)

Current behavior:

• Column Total is the total amounts in the currency of the SO which may be a mix of several currencies. This mix of currencies results in misleading computation of sums when doing group by in a tree view or even by checking the sum at the bottom of the list view.

Expected behavior:

• Allow defining (in the Settings or Configuration Parameters) a "Consolidation Currency" (because we need to support the case of multi-currency + multi-company so we can't use the base_currency of the company).
• On sale order (and any object impacted by currency) with a tree/pivot/graph view, add a column "Total in Consolidation Currency" visible only for the group multi-currency.
• The Total should be indicative and computed whenever the total is being updated, and also when the quotation is confirmed. This will allow having a total stored in database which won't impact performance when loading the list of Sale Orders.
• Allow to group by Currency

Note:
We are having this problem on Enterprise version, module Subscriptions, model "sale.subscription.report". There should be a holistic solution that fixes it in all modules (subscription, sales, purchases, expenses, accounting, etc.), all models and view types.

Video/Screenshot link (optional):

[sswapnesh]

AFAIK, This is by design to display sum of column.

[mart-e]

Indeed, this is an total computed automatically (indeed it does not mean much in multi-currency). I had already reported this feedback in the past but it was rejected.
You should check the sales report to analyse your sales cross-currencies instead.

[jcdrubay]

I am not sure if you took into account this part of the request:

On sale order (and any object impacted by currency) with a tree/pivot/graph view, add a column "Total in Consolidation Currency" visible only for the group multi-currency.

This is achievable rather easily without changing anything in the core.

At least 2 of our customers using Enterprise edition have been asking for this change to compensate for this confusing behavior of odoo ...

We had to implement similar changes for non-enterprise customers.

All of them complaining that Odoo does not really support multi-currencies !

Is that really your final decision to do nothing about it? Could this be at least added to your backlog for the future?