Export Flattened BOM to Excel with labour cost
This module extends the report of the Export Flattened BOM to Excel module with a new tab showing the labour costs.
auto_awesome What this module does
AI-generated from the code · Odoo 16.0Adds a Labour Costs tab to the Flattened BOM Excel export, showing the cost of each manufacturing operation per work center. It also adds a computed labour cost field on bills of materials.
When you export a flattened bill of materials to Excel, this module adds an extra worksheet called "Labour Costs" next to the existing sheets.
The new tab lists, for every operation of the bill of materials and its sub-bills, the operation name, the work center, the quantity, the unit of measure, the duration in hours, the cost per hour, the labour unit cost, the total labour cost and the currency. Rows are grouped by bill of materials level, so you can see the main bill and its sub-bills in order.
The labour cost of an operation is calculated from the work center's hourly cost multiplied by the operation duration converted into hours. The total labour cost multiplies that unit cost by the quantity.
A new computed field labour_cost is also added on mrp.bom, summing the labour cost of all operations of the bill of materials. It is read-only and calculated automatically.
The module only extends the existing Excel report and the bill of materials model; it does not add new menus or screens of its own. The export is started from the same place as the standard flattened BOM Excel report.
Depends on
Models and fields (2)
- mrp.bom · extends an existing modellabour_cost
- report.mrp_flattened_bom_xlsx.flattened_bom_xlsx · extends an existing model
Text generated by AI (DeepSeek) from reading the Odoo 16.0 code on GitHub; it may contain mistakes, so check the code before deciding. View the code on GitHub
Availability by version
Reviewed: 2026-11-03Confirmation status: 2 confirmed, 7 with no information of 9 versions.
Sources · Odoo 14.0
Confirmed on 2026-11-03 in branch 14.0 of OCA/manufacture-reporting.
terminal Installation and usage
OCA documentation · Odoo 16.0Usage
Source · Odoo 16.0To use this module, you need to:
- Go to 'Manufacturing / Products / Bill of Materials'
- Select a BOM or more BOMS (Could be interesting to modify quantities of these BOMs)
- Go to 'Print / Export Flattened BOM to Excel'.
No verified information in OCA: Installation, Configuration.
Installation instructions, the distribution package, dependencies and configuration steps are not shown because they have not yet been verified in the module documentation for any version.
Data imported from GitHub: this sheet reflects the latest catalog review, not a live lookup. Always check the module documentation and staging before installing in production.