How to make extra fields available on measures in the pivot view of report.pos.order model

Question

Hi Everyone!
I was able to add extra fields on product.template model, but now I want to make the fields available on measures in the pivot view of report.pos.order model (image below). Please how can I achieve that?
Thanks in advance!
daily-sales-report [1]

[1] https://www.servercrib.com/wp-content/uploads/2025/02/daily-sales-report.jpg

Cybrosys Techno Solutions Pvt.Ltd · Answer

Hi,
You can add Create a field in that model and in the Pivot View add it as type="measure".
How to Create Pivot View in Odoo 17
https://www.cybrosys.com/blog/how-to-create-pivot-view-in-odoo-17 [1]
https://www.cybrosys.com/blog/inheriting-existing-pivot-reports-in-odoo [2]

Hope it helps

[1] https://www.cybrosys.com/blog/how-to-create-pivot-view-in-odoo-17
[2] https://www.cybrosys.com/blog/inheriting-existing-pivot-reports-in-odoo

Andry Ang · Answer

Hi Chijioke,
This requires you to customize the query that's inside the model.
Do you have any technical capacity to do this? If yes, I can help to guide you.

Hope this helps

İlgili Gönderiler	Cevaplar	Görünümler
Default_code instead of Name in pdf report doesn't work Çözüldü models reporting	1 Ağu 21	2462
Add more fields to POS 'Order Analysis' report? treeview pos models reporting	2 Mar 15	21165
How to integrate POS and Sales.Orders report..? Çözüldü delivery reporting report sales.order Point Of Sale	3 Eki 23	7765
How do I figure out how much of a tax was paid with credit card? pos reporting taxes payments Point Of Sale	0 Nis 17	2860
How can I use two models in an API (foreign key - relations)? models	0 Ara 24	1447

Bu soru işaretlendi

Enjoying the discussion? Don't just read, join in!