1 / 8

Multi level bom import from cad software into mrp system

BOM is a list of parts that are needed to produce a product or an assembly. If the BOM lists only the details of which the product is directly composed, then this is a one-level BOM. If a part is produced inside the company, then it will have its own BOM. If the BOM of the final product includes the BOMs of its components, it is a multi-level BOM. http://manufacturing-software-blog.mrpeasy.com/blog/2017/09/12/multi-level-bom/

MRPEasy
Download Presentation

Multi level bom import from cad software into mrp system

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Multi-level BOM Import From CAD Software into the MRP System

  2. MULTI-LEVEL BOM IMPORT FROM CAD SOFTWARE INTO THE MRP SYSTEM Recently, several our customers launched complex products, designed in CAD software. The projects consisted of many components and many levels of nesting. It was necessary to move the multi-level BOM from the CAD software into the MRP system. Several important points were discovered during these transfers of this multi-level BOM. Therefore, we will describe the process of importing BOM into MRPEasy, highlighting what you need to pay attention to.

  3. SPECIFICS OF MULTI-LEVEL BOM When you print out a multi-level BOM, it may seem very complex. However, it is important to understand that it can be decomposed into a set of simple one-level BOMs. BOM is a list of parts that are needed to produce a product or an assembly. If the BOM lists only the details of which the product is directly composed, then this is a one-level BOM. If a part is produced inside the company, then it will have its own BOM. If the BOM of the final product includes the BOMs of its components, it is a multi-level BOM.

  4. SPECIFICS OF MULTI-LEVEL BOM Thus, a multi-level BOM is simply one way to represent BOM. Every multi-level BOM can be represented by several single-level BOMs. So, when you want to import a multi-level BOM, you are truly importing just many one-level BOM: one for the final product and one for every component, or subassembly, built in-house.

  5. IMPORTING THE BOM INTO MRPEASY Advanced CAD programs allow exporting the BOM into an Excel file. Then, it can be imported into MRPEasy. Different CAD programs output different data formats; therefore, some principles must be considered. If the exported file is in XLS(x) format, it should be saved to CSV format, which is more universal. This can be done in Excel. MRPEasy allows you to import many BOMs at once. The import could be one product with a multilevel BOM, or BOM of several different products. To know which product includes the part, the product number must be on each line of the CSV file. The user manual contains a detailed description of how to import a BOM from a CSV – file. ( Https://www.mrpeasy.com/documentation/production-planning/bills-of-materials/import).

  6. WHAT TO LOOK FOR WHEN IMPORTING A MULTI-LEVEL BOM If the imported BOM is missing a part, check the line with this part in the CSV file. The product number should be included on the line. 2. It is important that the parent product’s (or assembly’s) number is listed in the ‘product numbers’ column. If the part is a component of an assembly, then the assembly number is the ‘product number’ for that part. 3. If the multi-level BOM has 2 or more levels of nesting and one “subcomponent” is a part of several components, it is necessary that the subcomponent’s BOM is represented only one time in the CSV file. This is important since the program imports all rows in the CSV file. Therefore, if the same is found in the CSV file several times, the items will be added to the BOM several times. We hope that this post, based on our experience, helps you quickly and smoothly import your sophisticated products from your CAD software to our MRP system.

  7. WHAT TO LOOK FOR WHEN IMPORTING A MULTI-LEVEL BOM 3. If the multi-level BOM has 2 or more levels of nesting and one “subcomponent” is a part of several components, it is necessary that the subcomponent’s BOM is represented only one time in the CSV file. This is important since the program imports all rows in the CSV file. Therefore, if the same is found in the CSV file several times, the items will be added to the BOM several times. We hope that this post, based on our experience, helps you quickly and smoothly import your sophisticated products from your CAD software to our MRP system.

  8. MRPEasy Cloud ERP/MRP Solution • Production planning and reporting • Supply chain management • Stock management • CRM • Managerial statistics, business intelligence • Integration with online accounting solutions • Easy to deploy and use! Visit us @ www.mrpeasy.com

More Related