The executive who could not see the real margin
María, sales manager at a medical supplies distributor, was frustrated reviewing her monthly sales report. Although sales figures looked good, she could not determine which products were actually profitable. Odoo's standard report showed total sales by product, but it lacked crucial information: the unit cost and the percentage margin of each transaction. "If I could only see the real margin by customer and by product," she thought, "I could focus my efforts on what truly creates value." This limitation in her reporting kept her from making strategic decisions based on complete data.
Direct access to order lines: the data goldmine
The solution lies in accessing the sale.orderline model directly, where each order line holds detailed information that is not always available in standard reports. Each line includes data such as delivered quantity, invoiced quantity, unit cost, margin percentage, taxable amount and taxes. This highly valuable information stays hidden if you only use predefined reports.
Case study: At Ganemo, we implemented this solution for a retail client who needed to analyze profitability by product category. By accessing the order lines directly, they found that although electronics generated high sales volume, their margin was minimal compared with accessories, which sold less but had 40% margins. This insight let them reorient their sales strategy with immediate results.
Creating access through Odoo Studio
The first step is to create a shortcut menu to the order line model using Odoo Studio. From the top-right corner, go to Studio > Edit Menu > New Menu, and select the existing sale.orderline model. This creates a direct entry point to all order line records.
Real example: A furniture manufacturer working with Ganemo needed to track production times per order line. We created this shortcut and then customized the model to include production start and end date fields. They can now generate efficiency reports per product line that were previously impossible to obtain.
Activating report views: Graph and Pivot Table
Once access to the model is created, you activate the report views from Studio. The most useful views are graph and pivot table. These views let you group and analyze the data flexibly, showing measures such as cost, subtotal, margin and any other field available on the lines.
Ganemo implementation: For an education client, we set the pivot view as the default, showing sales by course and by month, including both sale value and cost. This let them identify which courses were most profitable and when they performed best, optimizing their academic and commercial planning.
Advanced setup with developer mode
For technical users, developer mode enables more advanced configuration. From Actions > Configure Window Action, you can define filters, domains and specific groupings that will apply by default to your custom report.
Success case: A Ganemo partner in logistics needed profitability reports by distribution route. Using developer mode, we configured automatic groupings by geographic zone and customer type, showing average margins per route. The solution saves them hours of manual analysis every week.
Why does this solution transform your business?
The ability to build custom reports from order lines is not just a technical matter; it is a competitive advantage. It lets you make decisions based on complete data, identify hidden opportunities and optimize your sales strategy. At Ganemo, we have seen companies that implement these solutions achieve 15-20% profitability increases simply by having full visibility into their operations.
If you are a business owner or executive, you do not need to worry about these technical details. Our Ganemo team handles all of these configurations during implementation, ensuring you have the reports you need from day one. For partners and developers, we offer complete technical documentation and specialized support so you can replicate these solutions in any project.