Skip to Content
Menu
This question has been flagged
2 Replies
88 Views

Hello Odoo Community,

I am currently working with Odoo 16 Community and I’m looking for a module (or potential customization) that can help me generate detailed sales reports by pricelist. Ideally, I need a solution that allows me to:

  • Track total sales quantity and revenue per pricelist.
  • Break down sales by product under each pricelist.


While I’ve found some modules that help with pricelist management, I haven't found one that specifically aggregates sales data per pricelist. Most of the existing modules are focused on pricelist structure or versioning, but they don’t seem to offer the sales-by-pricelist reporting I need.

I would greatly appreciate it if anyone could point me to a  module that fits this need, or if there’s a way to customize the current modules to achieve this. If there’s any development work required, I’d also be open to suggestions on how to approach it.

Looking forward to hearing from you all!

Avatar
Discard
Author Best Answer

Thank you so much for your help! I’m looking to purchase a module if it's something you can help me with. I’ve bought a few modules from you already, and while I’ve tried your recommendations, it’s still not working. I’ve checked, and the module should be available to handle it.


Avatar
Discard
Best Answer

Hi,


Odoo 16 Community doesn’t include a built-in report for sales by pricelist. Existing modules focus on pricing logic, not reporting. The best approach is to add a stored pricelist field to sale.order.line and create a pivot view grouping sales by pricelist and product to show quantities and revenue. For large datasets, a separate aggregated report model can improve performance. Alternatively, tools like MIS Builder can generate similar reports with some setup. In short, a small custom module or MIS Builder configuration is the most practical way to achieve detailed sales reporting by pricelist.


Related module:

- https://odoo-community.org/shop/sale-pricelist-global-rule-716203

-https://www.odoo-community.org/shop/sale-report-crossed-out-original-price-10641


Hope it helps

Avatar
Discard