Skip to Content

Is Your Sales Report Missing Key Information? Learn How to Build Advanced Reporting in Odoo

Discover how to access hidden data in sales order lines and turn it into custom reports that drive your decision-making
September 22, 2025 by
Is Your Sales Report Missing Key Information? Learn How to Build Advanced Reporting in Odoo
Wilfredo Fernando Pastor Avila
| No comments yet

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.

Related video

Is Your Sales Report Missing Key Information? Learn How to Build Advanced Reporting in Odoo
Wilfredo Fernando Pastor Avila September 22, 2025
Share this post
Tags
Archive
Sign in to leave a comment
How to Control Your Sales Margins in Real Time and Make Smart Decisions?
Discover how to view costs and margins directly on your sales orders to optimize prices and increase profitability.