Plan to Import Automatic BOM Build and Check
Author: Steven Zheng
At the beginning of 2019, we thought about planning ERP BOM build and check automatic. Through the efforts of relevant departments, the program has entered the testing phase and will expect to put into use in 2020.
This program consists of three parts: Customer BOM data automatic filing, build BOM preceding operation, build and check BOM to automatic update ERP data.
First, the program automatically checks each business new order program (cxmp001) to ensure whether that model have any new orders. If so, then start the new and old BOM comparison process to Initial confirm the differences, and start the technical data automatic transfer procedure, transfer and save customer BOM to customer technical data officially area (which have setup in PSI server). And automatic marks on "update BOM" column.
Secondly, program starts to build BOM initial operation. The main function includes: Checking if the comparison between old and new BOM has completed, whether ERP BOM has completed, whether the order model can find the corresponding main part number in the ERP BOM, whether the product data in ERP BOM is valid, whether the order model product process can consistent with ERP BOM, Whether to combine multiple PCBA, whether to update the BOM, etc.. It is mainly to do the initial check operation for the new order model. If it is the model that has been produced before, when conditions are met, the program will automatically complete the work order opening operation, and do not need manual operation. If there is updated BOM, the program will automatically continue the following operation.
Third, for the marked "update BOM" column, the program will automatically proceed ERP BOM establishment and checking operation.
  1. For the old model renew BOM, the program will automatically find the corresponding main part number for ERP BOM, and update customer BOM content to ERP BOM.
  2. If it is a new model, the program will gradually achieve automatically establishment of main model part number, automatically establish ERP BOM structure, and automatic import of materials.
  3. If there is any new materials, the program will automatically notify operation personnel to build the material part number. The program will periodically check whether the new material part number is completed or not, until the ERP BOM is completely build or update.
After above steps has completed, the program will notify the ERP to open the work order automatically.
The fully automatic BOM build and check program will be put into use on some customer first, and then expanded to others. Strive to achieve the application to all customers of PSI.
ERP BOM build and check automation, achieve routine operation steps will be completed by the computer, during the program automatic execute process. If there has any exceptions, it will automatically send the message and abnormal code to the corresponding personnel to deal with. It can shorten operation time, improve efficiency, and reduce the error rate during manual operation, so as to provide customers with more efficient and quality assurance services.