Skip to Content
This question has been flagged
posreports
3 Replies
2377 Views
Avatar
CCCHD IT

Greetings,

I am running an on-prem instance of Odoo 17 for the Point of Sale module. The client is very happy with the Point of Sale system and is ready to put it into production. They had one question, though. Is it possible to add a column to the Sales Details report showing the payment method for each transaction? They will run and print this report every day, but they need to know the payment method.

So far, I have made it to enabling developer mode, going to technical --> reports, and finding the sales details report. From there I am confused as to what XML code is needed to add this column.

I have been looking through the documentation and this forum before making this post. Is there some documentation or tutorials that I might have missed?


Thank you for your help and guidance!

Avatar
Discard
Avatar
CCCHD IT
Author Best Answer

I apologize for the delay in my reply.

It doesn't look like I'm allowed to post any images.

Under the "Point of Sale" app, click the "Reporting" menu, and then click "Sales Details". That will generate a report of the shop you choose to show the transactions for the day.

The current columns in the PDF report are "Product Category", "Product", and "Quantity Total (Tax excluded)". I need to add the payment method for each transaction to the right of Quantity Total.

The payment method is shown at the bottom of this PDF report, but it is a percentage of all the transactions. They need to see the payment method for each transaction.

Avatar
Discard
CCCHD IT
Author

Just bumping this post to see if anyone has an answers or guidance.

CCCHD IT
Author

This is so incredibly frustrating! I started my own Odoo online trial so that I can test Odoo Studio. That is just as confusing for editing this PDF report as is looking at the raw QWeb code. What I see in video tutorials do not match what I see when I try to edit this report. Please, I only need something simple added to this Sales Details PDF report and my deadline is almost here. Is this post being ignored now since I'm a new user?

CCCHD IT
Author

I ended up using the Odoo developer services to build a new POS Sales Details report. Now I have a new problem: where in the world are the original files installed? I was just told to "replace the old report files with the new", however I can't find them.

Avatar
jaydeep chaudhari
Best Answer

can you tell me in which module you want to add the column, you can go to that particular mule find the report and into reports you can specify your custom Column and all set

Avatar
Discard
Avatar
Naitik Vithalani
Best Answer

Please share the report screenshot or something where exactly you want new column.

Avatar
Discard
Related Posts Replies Views Activity
How to see cash in/out on PoS reports on v17? Solved
pos reports v17
Avatar
Avatar
2
Jul 25
2136
Sales report from PoS customization
development pos reports
Avatar
0
May 23
2732
Kitchen printing printer other than odoo provided list
pos
Avatar
Avatar
1
Nov 25
242
POS Table Synchronization Issue Between Devices in Odoo v17 CE
pos
Avatar
Avatar
Avatar
2
Nov 25
2638
Refund and Discount access to admin user only for Pos selling
pos
Avatar
Avatar
1
Nov 25
465