OdooWiki OCA HUB

Export Flattened BOM to Excel with direct materials cost

mrp_flattened_bom_xlsx_direct_materials_cost folder_open OCA/manufacture-reporting open_in_new
Manufacturing License: AGPL-3

This module extends the report of the Export Flattened BOM to Excel module showing the direct material costs.

auto_awesome What this module does

AI-generated from the code · Odoo 16.0

Adds a Direct Material Cost to bills of materials and shows material unit costs and total material costs in the Flattened BOM Excel export.

This module extends the Flattened BOM Excel export so that the exported spreadsheet also shows how much the materials in a bill of materials cost.

On each bill of materials (mrp.bom) a new computed field called Direct Material Cost is available. It is calculated automatically from the flattened list of components: for every component, its total quantity is multiplied by a unit cost, and all lines are added up.

The unit cost of a product comes from its cost price. If a product has no cost price but does have a supplier price, the first supplier price is used instead.

When the Flattened BOM Excel report is generated, the first worksheet is renamed Direct Materials. Three extra columns are added: Material Unit Cost, Material Cost and Currency. The total Direct Material Cost of the bill of materials is written on the header row, and below it each component is listed with its unit cost, its total material cost and the currency symbol.

No new menus or buttons are added; the information appears inside the existing Excel export of the flattened bill of materials.

Depends on

mrp_flattened_bom_xlsx

Required by other modules

mrp_flattened_bom_xlsx_labour_costmrp_flattened_bom_xlsx_subcontracting_cost
Models and fields (3)
  • mrp.bom · extends an existing modeldirect_materials_cost (Direct Material Cost)
  • product.product · extends an existing model
  • 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-03
Confirmed (verified in repository and branch) Estimated (unverified) No information

Confirmation status: 3 confirmed, 6 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.0

Usage

Source · Odoo 16.0

To 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.

info

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.