Skip to Content
This question has been flagged
currenciesSalesOrder
1 Respondre
638 Vistes
Avatar
Frank Wagner

Hello, we are implementing Odoo since a couple of months. So still new to some of the tricks. 
Our company is trading in three different currencies, and we have these currencies set up in Accounting/Currencies with their exchange rates.


In the sales module, in pivot view, I can add the "Currency Rate" as a metric, but the displayed numbers are only correct on the level of the individual sales order number. 

Any summary does not show the average of the individual currency rates, but the sum of it. This is not what I need.

If I have 10 Transactions at a 0.8 currency rate, these transaction have a currency rate of 0.8 and not of 8, as it is displayed.

Avatar
Descartar
Frank Wagner
Autor

Thanks a lot!

While your solution works, I found an easier option.
I found that after exporting the pivot to a spreadsheet, I get the option to edit the pivot parameters and set "Aggregate by" for the currency rate from "sum" to "average". 
So, for reporting purposes, this works well.
Thank you!

Avatar
Cybrosys Techno Solutions Pvt.Ltd
Best Answer

Hi,

You can add a computed stored field on sale.order that represents the currency rate as a float, but tell Odoo to aggregate it as an average in the pivot view.

from odoo import models, fields, api


class SaleOrder(models.Model):

    _inherit = 'sale.order'


    avg_currency_rate = fields.Float(

        string="Currency Rate (Avg)",

        compute="_compute_avg_currency_rate",

        store=True,

        group_operator="avg",  # 👈 Key point — use average aggregation

    )


    @api.depends('currency_rate')

    def _compute_avg_currency_rate(self):

        for order in self:

            order.avg_currency_rate = order.currency_rate


Hope it helps.



Avatar
Descartar
Related Posts Respostes Vistes Activitat
Odoo 10 single currency setup but quotes show incorrect currency
currencies
Avatar
Avatar
2
de març 17
3483
Change multi currency order views?
currencies
Avatar
0
de març 15
4581
Is there a way to create recurring sales orders without using the subscriptions app in Odoo 19
configuration SalesOrder
Avatar
Avatar
Avatar
Avatar
3
d’oct. 25
768
Sales Order Product Image
cost SalesOrder
Avatar
Avatar
1
de febr. 25
4495
Best way to issue Quote variations
SalesOrder Quotation
Avatar
1
de nov. 24
1862