Odoo 18: Sales Order Pivot - How can I get Currency Rate shown as a Average instead of a Total?

Question

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.

Cybrosys Techno Solutions Pvt.Ltd · Accepted 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(se

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
Odoo 10 single currency setup but quotes show incorrect currency currencies	2 maalisk. 17	3491
Change multi currency order views? currencies	0 maalisk. 15	4586
Is there a way to create recurring sales orders without using the subscriptions app in Odoo 19 configuration SalesOrder	3 lokak. 25	769
Sales Order Product Image cost SalesOrder	1 helmik. 25	4499
Best way to issue Quote variations SalesOrder Quotation	1 marrask. 24	1862

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!