Community mailing list archives

RE: SO total adds all totals as if they are 1 currency

Rooms For (Hong Kong) Limited, Yoshi Tashiro
- 06/21/2015 00:49:48

Just a sample for 7.0 to modify invoice list view to add columns to show base currency amounts (converted from the transaction currency amounts using the exchange rate of the invoice date), which show the total at the bottom.


You can apply the same logic to SO, PO, etc.


It is a different approach than grouping by currency, but to me showing base currency amounts and their totals would provide better overview of the situation (I think many enterprise systems take this approach by default).


Yoshi Tashiro


From: []
Sent: Saturday, June 20, 2015 7:57 PM
To: Community
Subject: Re: SO total adds all totals as if they are 1 currency


I had that problem on V7. If you cannot midify currency_id to be stored (saas) then you can still broup by list price. What you could also do is modify the tree view and remove the automatic total.


here's a stepby-step:






Yves Goldberg

odooOfficial Partner

Phone+972 (0)3 720.8818

Skype: ygol_support

Raanana [ISRAEL]





----- Original message -----

From: Caudal Eric <>

To: Community <>

Subject: Re: SO total adds all totals as if they are 1 currency

Date: Sat, 20 Jun 2015 07:50:19 -0000


+1 with Eva


On Sat, Jun 20, 2015, 07:45 Eva Pinter @ Openit <> wrote:



This is a bug throughout all Odoo. The system automatically sums certain type of fields and, as the currency or the unit of measure is not linked technically to that field, the system does not realise, they are different. I heard rumurs saying that this will be corrected by version 9.


In the meantime, you can create a standard grouping by currency or any unit of measure in your views, so that you always see the sum by currency.


Good luck


Eva P.


On 19 Jun 2015, at 22:47, Arjan Duijs <> wrote:

I have created 2 SO, one in the local currency, and one in dollars through a pricelist i have set.

however the SO screen shows a total of the both, and summed them as if they were of the same currency.










Post to:






Post to: