Hi,
Steps:
1. Open Sales-> Reporting->Sales
2 . Switch to Pivot View.
3. Put Product on rows.
4. Put the Pricelist on columns.
5. Add the Fixed Price measure.
Result: exactly the format you described, with products in rows and multiple pricelists as columns.
Hope it helps.
Hello Anup Ghosh,
Creating a report that groups products by multiple pricelists in Odoo 18 requires a custom approach. Here's a general guide to achieve this:
1. Create a new report template in your custom module.
2. Use Odoo's QWeb reporting engine to design your report layout. Ensure you include fields for "Product", "PricelistA", and "PricelistB".
3. Develop a method in your report's model to fetch product prices from different pricelists. This might involve querying the 'product.pricelist.item' model to get prices for each product under each pricelist.
4. In your method, structure the data to match your report layout, grouping products and their corresponding prices under each pricelist.
5. Finally, link your report template to an action, making it accessible from the Odoo interface.
For personalized assistance:
https://www.pragtech.co.in/contact-us-mql.html
