# Odoo Manufacturing Reports: Production Analysis, Cost and Forecast

> Source: https://netray.co/erp-help/odoo-manufacturing-report-production-analysis-and-forecast
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: ERP Help

## Short answer

Odoo has a Reporting menu in the Manufacturing app with analysis views of manufacturing orders and work center productivity, plus forecasted stock views in Inventory. Cost analysis, OEE and a master production schedule depend on version and edition. For anything else, group and filter the manufacturing order list, use pivot and graph views, or build a custom report with a SQL view, Python model or Studio.

## Kind

how-to

## System

small-erp

## Erp

Odoo (Community and Enterprise)

## Module

Manufacturing / Reporting

## Query

odoo manufacturing report

## Alternate Queries

- odoo production report
- odoo manufacturing forecast
- odoo manufacturing order analysis
- odoo mrp reporting custom report

## Applies To

Odoo 15 through 18, Community and Enterprise. Menu names and which reports exist vary by version and edition; check your own Reporting menu.

## Steps

### How to get the production report you need

**Items:**

- Open the Manufacturing app and go to Reporting. List the reports available in your edition, which typically include manufacturing order analysis and work center productivity.
- Switch between list, pivot and graph views, and use Filters and Group By (product, work center, responsible, month) to build the view you need.
- For component shortages and future needs, use the Inventory reporting forecast view or the product Forecasted report, which show on-hand, incoming and outgoing quantities over time.
- If your edition has a master production schedule, set a period and demand quantities per product to plan manufacturing and purchases together.
- Save useful combinations as Favorites so the filters persist.
- Export a pivot or list to a spreadsheet when stakeholders need it in Excel.
- For custom needs, build a SQL view model, a Studio report or a QWeb PDF, and test it against a standard report for matching totals.

## Sections

### Built-in views worth knowing

**Body:**

The manufacturing order analysis shows planned versus produced quantity, status, dates and responsible users, which is the starting point for on-time production questions. The work center productivity view shows time spent per work center and operation, split into productive and loss time, and is the basis for utilization and OEE style analysis.

Cost analysis and component consumption reports depend on valuation settings and, in some versions, on Accounting. If cost figures look wrong, the issue is usually product costing and valuation settings, not the report.

### Forecasting demand and components

**Body:**

There are three levels. The Forecasted quantity per product shows expected stock by date from open sales, purchases and manufacturing orders. Reordering rules create replenishment automatically based on minimum and maximum levels. A master production schedule, where available, lets planners enter demand by period and generates manufacturing and purchase suggestions.

Forecast accuracy depends on clean data: correct lead times, accurate bills of materials, and confirmed rather than draft orders. A forecast built on draft quotes or missing routings is only as reliable as those inputs.

### Custom reports with SQL

**Body:**

When filters cannot answer the question, query the database through a reporting replica rather than production. Manufacturing orders are stored in the mrp_production table and work orders in mrp_workorder. Always filter by company in multi-company setups.

For recurring needs, wrap the query as a SQL view model in a custom module so Odoo exposes it with pivot and graph views and access rules, instead of passing around ad hoc queries.

**Code:**

SELECT p.name AS mo, pt.name->>'en_US' AS product, p.product_qty,
       p.qty_produced, p.state, p.date_start, p.date_finished
FROM mrp_production p
JOIN product_product pp ON pp.id = p.product_id
JOIN product_template pt ON pt.id = pp.product_tmpl_id
WHERE p.company_id = 1
ORDER BY p.date_start DESC;

### Studio, spreadsheets and dashboards

**Body:**

In Enterprise, Studio can add fields and custom views without code, and spreadsheet dashboards can pull pivots from Odoo data into a living sheet. Community users can reach similar results with custom modules or external BI tools connected to a replica.

Whichever route you choose, document which report is the source of truth for each KPI. Two dashboards disagreeing about output is more damaging than having no dashboard.

## Pitfalls

- Trusting cost reports before fixing product costing and valuation settings.
- Forecasting from draft orders or missing lead times.
- Running heavy SQL on the production database during working hours.
- Building custom reports without matching them to a standard report.
- Assuming a Community install has the same reports as Enterprise.

## Ai Angle

Planners ask production questions in plain language, such as which manufacturing orders are late and which components caused it. An assistant grounded in your Odoo data can answer those with the underlying query visible, without anyone building a new report. Netray deploys it on-prem with an open-weight model, read-only by default.

## Faq

### Where is the manufacturing report in Odoo?

**Answer:** In the Manufacturing app, open the Reporting menu. Common entries include manufacturing order analysis and work center productivity. Stock forecasting is under the Inventory reporting menu. Which entries appear depends on your Odoo version and whether you use Community or Enterprise.

### How do I forecast production in Odoo?

**Answer:** Use forecasted quantities on products, reordering rules for automatic replenishment, and a master production schedule if your edition includes one. Keep lead times and bills of materials accurate, because forecasts are only as good as those inputs.

### Can I export Odoo production data to Excel?

**Answer:** Yes. List and pivot views have export options. For large or recurring exports, build a saved pivot, a spreadsheet dashboard in Enterprise, or an automated extract against a reporting replica.

### Why do production costs look wrong?

**Answer:** Check the product cost method, bill of materials costs, work center hourly costs and valuation settings first. Reports reflect those inputs, so correcting the setup usually fixes the numbers.

## Search terms

odoo manufacturing report, odoo production report, odoo manufacturing forecast, odoo mrp reporting, odoo work center productivity, odoo master production schedule, odoo manufacturing analysis, odoo mrp_production sql

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json