Method and device for generating multiple boms of the same style from paper grid color matching in erp

Abstract

The present invention proposes a method and device for generating multiple BOMs of the same style by color matching of paper grids in ERP. The method includes: establishing a certain style number, style number version, color matching items and detailed data of paper grids and storing them in a database table; establishing The main material, ingredient color name and color number corresponding to a certain model number product are saved to the color data table; the order model number, model number version, color, material name, quantity, ingredients and color matching requirements for each color name and material matching are established, Save it in the sales order database table; search for the style number and style number version of the order, and match the material of each color when placing the order according to the style number, style number version, material name, raw material, and consumption information to be used Request information and automatically generate BOMs of the same model with different colors. The method and device of the present invention have the following beneficial effects: the amount of BOM input in the ERP system is small, multiple input of BOMs of the same model number and different colors is avoided, error rates are reduced, and the efficiency is high.

Description

Technical field [0001] The invention relates to the field of handbags and luggage, and in particular to a method and device for generating multiple BOMs of the same style from paper grid color matching in ERP. Background technique [0002] BOM is (bill of material) a list of all materials used in a product, including what materials are used, how much is the amount, and what is used. It is a key part of all ERP systems. It is also the most important and most input workload. An error-prone link. Because of the characteristics of the handbag industry, a product often has multiple colors. Therefore, according to the BOM rule of ERP, a corresponding product BOM must be established for each color product. In this way, the BOM construction is very heavy and error-prone , The BOM input volume in the ERP system is large, the BOM of the same model number and different colors needs to be input multiple times, the error rate is high, and the efficiency is low. Summary of the invention [00...

AI Technical Summary

Problems solved by technology

Because of the characteristics of the handbags industry, a product often has many colors, so according to the BOM rule of ERP, a corresponding product BOM must be created for each color product, so the workload of building a BOM is very heavy and error-prone , the amount of BOM input in the ERP system is large, and BOMs of the same model number and different colors need to be input multiple times, which has a high error rate and low efficiency

Images