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

Gerelateerde posts	Antwoorden	Weergaven
Default_code instead of Name in pdf report doesn't work Opgelost models reporting	1 aug. 21	2474
Add more fields to POS 'Order Analysis' report? treeview pos models reporting	2 mrt. 15	21178
How to integrate POS and Sales.Orders report..? Opgelost delivery reporting report sales.order Point Of Sale	3 okt. 23	7772
How do I figure out how much of a tax was paid with credit card? pos reporting taxes payments Point Of Sale	0 apr. 17	2860
How can I use two models in an API (foreign key - relations)? models	0 dec. 24	1448

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!