CN-121997906-A - Bill of materials generation method, computing device and computer readable storage medium

CN121997906ACN 121997906 ACN121997906 ACN 121997906ACN-121997906-A

Abstract

The invention discloses a bill of materials generating method, an operation control device, a computing device and a computer readable storage medium, comprising the steps of obtaining an initial bill of materials table and checking the format of the initial bill of materials table; the initial bill of materials list at least comprises a bill of materials number, a position number and a quantity, typesetting operation is carried out according to a preset format to obtain a basic bill of materials list, the basic bill of materials list is uploaded to an enterprise management system, and a target bill of materials list is downloaded from the enterprise management system. After the initial bill of materials table is obtained, the basic bill of materials table format uploaded to the enterprise management system is more unified by checking the basic format first and typesetting operation according to the preset format, the requirements are met, and finally the target bill of materials table obtained by downloading from the enterprise management system is more consistent with the local BOM, so that the working period can be effectively shortened, the manual operation is reduced, and the error is furthest reduced while the improvement of the efficiency is realized.

Inventors

LAO CHUNLU
ZHANG WU

Assignees

深圳市迈迪杰电子科技有限公司

Dates

Publication Date: 20260508
Application Date: 20260129

Claims (10)

1. A method of generating a bill of materials, comprising: Acquiring an initial bill of materials table, and performing format check on the initial bill of materials table, wherein the initial bill of materials table at least comprises a material number, a position number and the number; typesetting operation is carried out according to a preset format, and a basic bill of materials table is obtained; uploading the basic bill of materials table to an enterprise management system, and downloading a target bill of materials table from the enterprise management system.
2. The bill of materials generation method according to claim 1, further comprising: comparing the target bill of materials table with the base bill of materials table; and obtaining a generation report of the target bill of materials table according to the result of the format check, the typesetting operation and the comparison result.
3. The bill of materials generation method according to claim 1, wherein before the format check of the initial bill of materials table, the method further comprises: Loading a file part of the initial bill of materials table, and locating a header of the initial bill of materials table by searching the material number, the position number and the reference information; And positioning the material number, the position number and the number to a mapping table.
4. The bill of materials generation method according to claim 1, wherein the format check includes: Determining that the material number, the position number and the number are free of gaps; determining that repeated items do not exist in the material numbers and the position numbers; And determining that the number of the material numbers is the same as the number of the position numbers.
5. The method of claim 4, wherein the initial bill of materials table further comprises a bill of materials state, and wherein the format check further comprises: and determining that the material patch states are consistent.
6. The bill of materials generation method according to claim 1, wherein the typesetting operation includes: Screening out materials in a non-loading state from the initial bill of materials table, deleting the materials, and retaining the materials in the loading state; and sorting the materials in the loading state in ascending order according to the type of the components.
7. The bill of materials generation method according to claim 2, wherein the report of the generation of the target bill of materials table includes a reload entry, an attribute difference judgment entry, a position number change entry, a material deletion entry, and a material addition entry; when the material numbers of the target bill of materials table and the basic bill of materials table are inconsistent, the generated report has the material changing item; When the material numbers of the target bill of materials table and the basic bill of materials table are consistent, the generated report is provided with an attribute difference judging item; When the position number set of the target bill of materials table is inconsistent with that of the basic bill of materials table, the generated report has the position number change item; when the base bill of materials table has a location number that is not present in the target bill of materials table, the generated report has the bill of materials deleted entry; And when the target bill of materials table has a position number which does not exist in the basic bill of materials table, the generated report has the new entry of materials.
8. An operation control device, characterized by comprising at least one control processor and a memory for communication connection with the at least one control processor, the memory storing instructions executable by the at least one control processor, the instructions being executable by the at least one control processor to enable the at least one control processor to perform the bill of materials generation method according to any one of claims 1 to 7.
9. A computing device comprising the operation control apparatus of claim 8.
10. A computer-readable storage medium storing computer-executable instructions for causing a computer to perform the bill of materials generation method according to any one of claims 1 to 7.

Description

Bill of materials generation method, computing device and computer readable storage medium Technical Field The present invention relates to the technical field of bill of materials, and in particular, to a method for generating a bill of materials, an operation control device, a computing device, and a computer readable storage medium. Background A bill of materials (Bill of Materials, BOM for short) is a technical document describing the composition of an enterprise product. In the process capital industry, it is shown the structural relationship between the total assembly, sub-assembly, component, part, up to the raw materials of the product, and the quantity required. At present, BOM original resources are derived from design software, generally in a fixed format and ordered, and the layout required by the final BOM is different, so that the steps required for generating the final BOM are more, the operation is complicated, the manual judgment is required, omission and misjudgment are easy to cause final production errors, the middle part is required to be modified, adjusted and rechecked for multiple times, the standard operation time is multiple working days, and the generation efficiency is low. Disclosure of Invention The invention aims to at least solve one of the technical problems in the prior art, and provides a bill of materials generation method, an operation control device, a computing device and a computer readable storage medium, which can improve the efficiency and reduce the error probability. In a first aspect, an embodiment of the present invention provides a method for generating a bill of materials, including the following steps: Acquiring an initial bill of materials table, and performing format check on the initial bill of materials table, wherein the initial bill of materials table at least comprises a material number, a position number and the number; typesetting operation is carried out according to a preset format, and a basic bill of materials table is obtained; uploading the basic bill of materials table to an enterprise management system, and downloading a target bill of materials table from the enterprise management system. The bill of materials generation method provided by the embodiment of the invention has the advantages that after the initial bill of materials table is obtained, the basic bill of materials table format uploaded to the enterprise management system is more unified by checking the basic format and typesetting operation according to the preset format, so that the format of the basic bill of materials table uploaded to the enterprise management system meets the requirement, and finally, the target bill of materials table obtained by downloading from the enterprise management system is more consistent with the target bill of materials table obtained by downloading from the enterprise management system, thus the working period can be effectively shortened, the manual operation is reduced, and the error is furthest reduced while the improvement of the efficiency is realized. According to some embodiments of the present invention, the method for generating a bill of materials further includes: comparing the target bill of materials table with the base bill of materials table; and obtaining a generation report of the target bill of materials table according to the result of the format check, the typesetting operation and the comparison result. According to some embodiments of the present invention, before the format check is performed on the initial bill of materials table, the method further includes: Loading a file part of the initial bill of materials table, and locating a header of the initial bill of materials table by searching the material number, the position number and the reference information; And positioning the material number, the position number and the number to a mapping table. According to some embodiments of the invention, the format check includes: Determining that the material number, the position number and the number are free of gaps; determining that repeated items do not exist in the material numbers and the position numbers; And determining that the number of the material numbers is the same as the number of the position numbers. According to the bill of materials generation method provided by some embodiments of the present invention, the initial bill of materials table further includes a bill of materials state, and the format check further includes: and determining that the material patch states are consistent. According to the bill of materials generation method provided by some embodiments of the present invention, the typesetting operation includes: Screening out materials in a non-loading state from the initial bill of materials table, deleting the materials, and retaining the materials in the loading state; and sorting the materials in the loading state in ascending order according to the type of the components. According to the b