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:

  1. Header: Click Create New, select the Product, and optionally link a Customer Code (if client-specific formulation is enabled).
  2. Components: Use Excel Import for large component lists or add lines manually (select Input Type, Item, Stage, Process, and Qty).
  3. Costing: Review the Cost Sheet tab to set standard/manual rates, contingency, overheads, and profit margins.
  4. 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., 00 for Raw Material, 07 for 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 πŸ“š

  1. Item Master: Defines manufactured products, raw materials, intermediate components, and packing materials.
  2. Process Master: Defines routing stages assigned to each BOM line.
  3. BOM Input Type Master: Controls classification rules for input components.
  4. 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.