Ir al contenido
Menú
Se marcó esta pregunta
2 Respuestas
91 Vistas

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
Descartar
Autor Mejor respuesta

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
Descartar
Mejor respuesta

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
Descartar