Bill of Materials (BOM)
Bill of Materials (BOM) Module - User Guide
π¬ Business Impact
The Bill of Materials (BOM) is the engineering and operational “recipe” for your product. An accurate BOM ensures 100% material availability via MRP, defines standardized routing processes on the shop floor, and generates precise Product Cost Sheets to protect your profit margins.
β‘ Quick Start: 3-Minute Fast Track
For engineers who need to set up a product recipe quickly:
- Header: Click Create New, select the Product, and optionally link a Customer Code (if client-specific formulation is enabled).
- Components: Use Excel Import for large component lists or add lines manually (select Input Type, Item, Stage, Process, and Qty).
- Costing: Review the Cost Sheet tab to set standard/manual rates, contingency, overheads, and profit margins.
- Finalize: Save. The BOM is now active and immediately available for Production Plans and Material Requirement Planning (MRP).
πΊοΈ Process Flow: Recipe to Reality
graph LR
Item[Item Master] --> BOM[Bill of Materials]
BOM --> Costing[Product Cost Sheet]
BOM --> MRP[Material Planning]
BOM --> Prod[Production Plan]
style BOM fill:#f9f,stroke:#333,stroke-width:2pxβ Prerequisites Checklist
Before creating a BOM, ensure these are ready:
- Item Master: Both the manufactured finished product and all raw/packing components must be registered.
- Process Master: Routing operations (e.g., Lathe Machining, Powder Coating, Final Assembly) must be defined.
- BOM Input Types: Categories like Raw Material (
RM), Packing Material (PM), and Sub-Assembly (SA) must be configured. - Change Note: If modifying or deleting existing lines in an active BOM, have your 9-digit authorization code ready.
1. Introduction π
The Bill of Materials (BOM) module is the cornerstone of manufacturing execution and cost accounting. It establishes the multi-level hierarchy of materials, packaging, labor, and sub-assemblies required to manufacture any finished goods or intermediate assemblies.
Typically, this module is utilized by Production Engineers, Plant Managers, Cost Accountants, and R&D Teams.
2. Getting Started with BOM π
Accessing the Module
Navigate to Manufacturing > Transactions > Bill of Material.
Index Page Tools & Features
The BOM Index page includes essential management and navigation options:
- Create New BOM: Initializes a new BOM definition for a selected product.
- Set Up BOM Structure: Configure standard default percentages across your manufacturing plant for Contingency %, Overheads %, and Profit Margin %.
- BOM Input Type: Direct navigation to configure and manage component classifications (Raw Material, Packing Material, Sub-Assembly, Consumables, Overheads).
- Item Details View: Search by component across all BOMs to immediately identify every finished product that uses a specific raw material or part.
- Duplicate / Clone BOM: Clone an entire BOM from an existing similar product to rapidly create product variants.
- Bulk Excel Import: Download the standardized Excel template (
ImportBOM.xlsx), populate components offline, and import them directly with automatic field validation and row-level error reporting.
3. Features & Architecture β¨
π¦ Multi-Level Hierarchical Architecture
- Sub-Assembly Integration: Seamlessly link Sub-Assemblies (
SA) into parent products. The system natively traverses multiple nesting levels to compute complete gross material requirements in MRP. - Change Control & Audit Trail: Modifications or line deletions in an active BOM strictly enforce a 9-digit Change Note No. and audit reason (up to 150 characters), providing a comprehensive revision history.
π° Automated Costing Engine
- Cost Sheet Integration: Value components automatically using Last Purchase Rate (LPR) or Weighted Average Rate (WAR), or toggle Manual Rate to specify fixed target costs.
- Cost Sheet Flags (“System” vs “Manual”): Each component line supports an independent cost sheet flag:
- System: The Cost Sheet Quantity and Rate mirror the operational BOM values.
- Manual: Allows engineers to specify a separate Cost Sheet Qty and Cost Sheet Rate without altering the physical production batch quantity.
- Costing Summary: Summarizes cumulative costs of Raw Materials, Packing Materials, and Overheads with automated markups for Contingency (%), Factory Overheads (%), and Profit Margins (%).
β‘ Client-Specific Formulations
- Customer Code Linkage: If enabled via system settings (
LinkedCustomerCodeInBOM = Y), BOM formulations can be tied to a specific Customer Code, allowing unique recipes for specific clients.
4. Complete Flow π
Initialize the BOM (Header)
- Select the Product you want to manufacture.
- Choose whether this formulation relates to a specific Linked Customer Code.
- The system generates a unique BOM No.
Build Formulations (Lines)
- Add components manually or via Bulk Excel Import.
- Select the Input Type (e.g., Raw Material, Packing Material, Sub-Assembly).
- Select the routing Process Code and input Stage (e.g.,
00for Raw Material,07for Semi-Finished). - Specify the definitive Quantity required to manufacture one base unit of the parent product.
Define Cost Sheet & Finalize
- Review the Cost Sheet Qty and Rate and set Manual/System cost flags.
- Verify default markups (Contingency %, Overheads %, Margin %).
- Save the BOM. It is now active and immediately usable in production plans and MRP.
5. Validations and Business Logic β οΈ
Header-Level Rules
- One Primary BOM per Product: An active product cannot have duplicate primary BOM formulations for the same customer linkage.
- Customer Linkage: If customer linking is active, a unique customer code is mandatory for client-specific formulations.
- Cloning Requirements: You can only clone a BOM that is currently Active (
IsActive = Yes) and contains at least one line item (Line Count > 0). - Sub-Assembly Protection: A BOM cannot be deleted if its finished product is referenced as a Sub-Assembly (
SA) in any other active BOM.
Line-Level Rules
- Sub-Assembly Active BOM Requirement: If an input component is designated as a Sub-Assembly (
SA), the system verifies that the component itself has an active, predefined BOM. - Self-Reference Block: An item cannot be added as an input component to its own BOM (circular references are strictly prevented).
- Duplicate Line Prohibition: The exact same component item cannot be added multiple times under the same BOM formulation.
- Positive Quantity: Quantities must strictly be greater than zero. If Manual Rate is enabled, Rate cannot be zero.
Line Modification & Deletion Rules
- Single-Line Deletion Lock: If a BOM contains only one line (
Line Count = 1), deleting that line is prohibited. To remove the component, you must delete the entire BOM. - Mandatory Change Note on Deletion & Edit: Deleting an existing line or modifying line quantities strictly requires a valid 9-digit Change Note No. and an explanation Reason (up to 150 characters).
- Read-Only Key Fields on Edit: When editing an existing line, the Process, Input Type, and Item Name are strictly read-only to preserve structural integrity. Only quantities, rates, and cost sheet parameters can be adjusted.
6. Master Data Dependencies π
- Item Master: Defines manufactured products, raw materials, intermediate components, and packing materials.
- Process Master: Defines routing stages assigned to each BOM line.
- BOM Input Type Master: Controls classification rules for input components.
- Shift & Machine Masters: Integrated downstream during daily scheduling and production execution.
7. Related Reports π
- π BOM Report (
BOM_Report.xlsx): Generates structured, multi-level tree expansions showing input items, stages, and optional complete Cost Sheet views. - π§Ύ BOQ Report (
BOQ_Report.xlsx): Extracts required purchasing estimations utilizing LPR or WAR pricing across customizable date ranges. - π BOM Change Log (
BOM_Change_Log.xlsx): Audits every historical line adjustment, detailing Old Qty vs New Qty with associated 9-digit Change Note references. - β Missing & In-Active BOMs Report: Highlights active finished items that lack BOM recipes or lists inactive formulations.
8. Best Practices / Tips π‘
- Configure Standard Percentages First: Use Set Up BOM Structure before creating your BOMs to ensure consistent default Contingency, Overheads, and Margins across all recipes.
- Maintain Change Note Discipline: Always record a genuine 9-digit Change Note whenever modifying an active BOM to ensure traceability for ISO and external quality audits.
- Use Bulk Excel Import: For complex assemblies with dozens of components, use the standardized Excel template to streamline data entry.
- Leverage Cross-BOM Search: Use the Item Details search to instantly find all products affected when a supplier announces an obsolescence or price change for a specific component.