BOM Routing via Mapping Table for ERP-ME Integration
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
The existing systems for engineering and manufacturing bill of materials (BOM) and routings are incompatible, making it difficult to create a robust interface between Enterprise Resource Planning (ERP) and Manufacturing Execution (ME) systems, leading to errors when transferring and enhancing routings.
Innovation Solution
A system that uses a mapping table and routing templates to map components from the BOM to appropriate routing operations, automatically selecting and modifying templates to generate routings that are compatible with both ERP and ME systems, eliminating the need for manual enhancements and transfers.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If routing is transferred from ERP system to ME system, then routing can be utilized in both systems, but the routing needs to be enhanced in ME system and this process must be repeated every time a new version is created, making it prone to errors
Solution Approach 1:
A mapping table is introduced as an intermediary component that stores the correspondence between ERP routing attributes and ME routing attributes. This mapping table serves as a mediator that automatically translates and transforms routing data during transfer, eliminating the need for manual enhancement and reducing errors. The mapping table acts as a bridge between the two different routing systems, enabling accurate and reliable data transfer.
Solution Approach 2:
The system changes the parameters of routing representation by using a standardized mapping table that defines how ERP routing attributes correspond to ME routing attributes. This parameter transformation allows the same routing data to be interpreted correctly in both systems without manual intervention, ensuring consistency and reducing transfer errors.
2Adaptability or versatility
If routing is manually enhanced in ME system, then routing can be customized for manufacturing needs, but the process must be repeated every time a new version is created, increasing time consumption
Solution Approach 1:
The mapping table is created in advance with pre-defined correspondences between ERP and ME routing attributes. This preliminary configuration allows for automatic routing transformation without manual enhancement during each transfer. The mapping table is prepared beforehand to handle future transfer scenarios, eliminating repetitive manual work and reducing time consumption.
Solution Approach 2:
The system performs self-service by automatically transforming routing data using the pre-configured mapping table. Instead of requiring manual enhancement for each new routing version, the system autonomously translates and adapts the routing data, saving time and reducing human intervention in the repetitive transfer process.
3Manufacturing precision
If routing is enhanced in ME system, then routing can be optimized for manufacturing execution, but the enhancement process is error-prone and requires repeated manual intervention
Solution Approach 1:
The mapping table serves as an intermediary that simplifies the interface between ERP and ME systems. By pre-defining the correspondence between routing attributes, it reduces the complexity of the interface and eliminates the need for complex manual enhancement processes. The mapping table handles the transformation logic automatically, reducing errors while maintaining manufacturing precision.
Data Source
AI summary
A method and system includes a bill of materials stored on a computer readable storage device, listing multiple components to be assembled. A mapping table is stored on a computer readable storage device having rows listing attributes of components of the bill of materials and a routing operation attribute identifying work centers or another unique attribute. A plurality of routing templates stored on a computer readable storage device, the routing templates identifying work centers and routing operations between work centers. A route generator utilizes the mapping table to map components from the bill of materials to a routing template and its operations.