Export Flattened BOM to Excel with subcontracting cost
This module extends the report of the Export Flattened BOM to Excel module with a new tab showing the subcontracting cost.
auto_awesome What this module does
AI-generated from the code · Odoo 16.0Adds a 'Subcontracting Costs' tab to the Flattened BOM Excel export, showing the subcontractor, quantity and subcontracting cost for each subcontracted bill of materials.
When you export a flattened bill of materials to Excel, this module adds an extra worksheet called 'Subcontracting Costs' to the same file. The tab lists, for every subcontracted bill of materials found in the structure, the main BOM, the subcontracted BOM, its internal reference, the product name, the subcontractor (partner) name, the quantity, the unit of measure, the subcontracting unit cost, the total subcontracting cost and the currency.
The subcontracting unit cost is calculated automatically on the bill of materials: if the BOM is of type 'subcontract' and a subcontractor is set, Odoo looks up the supplier price for that subcontractor and product, and uses it as the cost. If the BOM is not subcontracted or has no subcontractor, the cost is zero.
The new tab is formatted for printing in landscape, fits to one page wide, freezes the header row and uses a highlighted header style. The BOM structure is explored level by level, and only subcontracted BOMs are written to the sheet. This module extends the existing flattened BOM Excel report and the bill of materials model (mrp.bom), and relies on the subcontracting features of Odoo.
Models and fields (2)
- mrp.bom · extends an existing modelsubcontracting_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.