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

Related Posts	Replies	Zobrazenia
Default_code instead of Name in pdf report doesn't work Solved models reporting	1 aug 21	2393
Add more fields to POS 'Order Analysis' report? treeview pos models reporting	2 mar 15	21082
How to integrate POS and Sales.Orders report..? Solved delivery reporting report sales.order Point Of Sale	3 okt 23	7704
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	2858
How can I use two models in an API (foreign key - relations)? models	0 dec 24	1430

This question has been flagged

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