CN-122022701-A - BOM table automatic verification method, system and medium

CN122022701ACN 122022701 ACN122022701 ACN 122022701ACN-122022701-A

Abstract

The invention provides an automatic BOM table verification method, system and medium, wherein the method comprises the steps of enabling fields of a standard material table to comprise material codes, specification descriptions, PCB packaging and material states, analyzing the BOM table to be verified through format verification, executing verification items in parallel, wherein the state verification comprises the steps of identifying and marking materials which are disabled or disabled in the BOM table to be verified according to the standard material table, describing and verifying the materials with substantial errors in parameter values recorded in the specification descriptions in the BOM table to be verified according to the standard material table, packaging and verifying the materials with errors in packaging types recorded in the PCB packaging in the BOM table to be verified according to the standard material table, and the repeatability verification comprises the steps of identifying and marking repeated materials with the position numbers or the material codes, and outputting the BOM table after verification. The invention can obviously improve the verification efficiency and the verification accuracy.

Inventors

LU KERUI
Chi changhong

Assignees

广东中强精英电子科技有限公司

Dates

Publication Date: 20260512
Application Date: 20260209

Claims (10)

The BOM automatic checking method is characterized by comprising the following steps: Loading a standard material summary table, wherein the field of the standard material summary table comprises a material code, a specification description, a PCB package and a material state, and one of on-use, off-use and off-use is recorded under the field of the material state; Analyzing the BOM table to be checked passing the format check, and executing the following check items in parallel: identifying and marking materials belonging to the disabling or forbidden materials in the BOM table to be checked according to the standard material summary table; Identifying and marking materials with substantial errors of parameter values recorded under a field of specification description in the BOM table to be verified according to the standard material summary table; identifying and marking materials with wrong packaging models recorded under a field of PCB packaging in the BOM table to be verified according to the standard material summary table; repeatedly checking, namely repeatedly checking the bit number and the material code in the BOM table to be checked, and identifying and marking the material with repeated bit number or material code; outputting the checked BOM table.
2. The automated BOM table checking method according to claim 1, wherein the description checking specifically comprises: According to the material codes, comparing the records of all materials in the BOM table to be checked in the field of specification description with the records of corresponding materials in the standard material table in the field of specification description one by one, and screening out the materials with inconsistent parameter values under the condition of filtering out format differences; and marking the materials in the BOM table to be checked.
3. The automated BOM table checking method of claim 2, wherein the format differences include comma missing or redundant, redundant space present, and case-based differences.
4. The automated BOM table checking method according to claim 1, wherein said package checking comprises: According to the material codes, comparing records of each material in the BOM table to be checked under the two fields of the position number and the PCB packaging with records of corresponding materials in the standard material summary table under the field of the PCB packaging one by one, and screening out materials inconsistent in PCB packaging; and marking the materials in the BOM table to be checked.
5. The automated BOM table verification method of claim 1, wherein the package verification is performed only for materials of a capacitive or resistive type in the BOM table to be verified.
6. The automated BOM table checking method according to claim 1, wherein outputting the checked BOM table comprises: After all the check items are executed, respectively generating a checked BOM table for highlighting the marked materials and an abnormal BOM table only containing the marked materials; and according to a user instruction, the corresponding checked BOM table or the abnormal BOM table is called for display.
7. The automated BOM table checking method according to claim 1, wherein said parsing the BOM table to be checked that passes the format check comprises: And the BOM table to be checked, which passes the format check, comprises a bit number, a material code, a specification description and a field of the PCB package.
8. The automated BOM table checking method according to claim 7, wherein said parsing the BOM table to be checked through format check further comprises: Loading a BOM table to be verified, which is derived from the schematic diagram; performing format verification on the BOM table to be verified; If the format is abnormal, prompting an error and requesting to be reintroduced; If the format is normal, prompting that the BOM table to be checked is successfully imported through format check.
9. A computer readable storage medium having stored thereon a computer program, which, when executed by a processor, is capable of performing the steps comprised in the automated BOM table checking method according to any of the preceding claims 1 to 8.
10. A BOM table automated verification system comprising the computer readable storage medium of claim 9 and a processor.

Description

BOM table automatic verification method, system and medium Technical Field The invention relates to the technical field of bill of materials management, in particular to a BOM (bill of materials) automatic verification method, system and medium. Background In the whole process of research and development of electronic equipment and production, the accuracy of material data directly determines the quality of products, the production efficiency and the cost control. After the schematic diagram design of the product is finished, a derived bill of materials (BOM) often has the problems of mismatching of material packaging, inconsistent description, even containing shutdown or forbidden materials and the like, and if the problems are not found in time, a series of chain reactions such as PCB design reworking, material purchasing errors, production line stagnation and the like can be caused, so that project progress and product quality are seriously affected. In the prior art, the verification work of the BOM table and the standard material table in the research and development process of the electronic equipment is mainly finished manually. The technical scheme is that after an engineer derives a BOM table from a schematic diagram, information such as material codes, specification descriptions, PCB packaging and the like is manually checked row by row, materials which are not consistent in use, forbidden and information are screened out, abnormal materials are manually marked in the checking process, and the difference types are confirmed through manual secondary checking, so that correction and updating of the BOM table are finally completed. Some enterprises can assist in checking by virtue of the basic screening function of Excel, but the core checking logic still depends on manual judgment. The scheme has the advantages that 1, the verification efficiency is extremely low, a great amount of time is consumed for manual row-by-row verification, particularly when the quantity of BOM materials exceeds thousands, the verification work usually needs hours or even days, the development progress is seriously influenced, the efficient development requirement cannot be adapted, 2, the error rate is high, the manual verification is easily influenced by subjective factors such as fatigue and negligence, subtle differences such as commas and blank spaces in specification description are easily missed, critical information such as packaging model and material state is easily misjudged, abnormal materials are not identified, and further the problems such as follow-up PCB design reworking and material purchasing errors are caused. Therefore, according to the research and development and quality requirements, there is a need to provide a solution for automatically and accurately verifying a bill of materials (BOM) table, which aims at the problems of packaging materials and mismatching of descriptions and summary of materials in a bill of materials (BOM table) derived from a schematic diagram, and the defects of the verification solution in the prior art. Disclosure of Invention The invention aims to solve the technical problem of providing an automatic checking method, an automatic checking system and an automatic checking medium for a BOM table so as to remarkably improve the checking efficiency and the checking accuracy. In order to solve the technical problems, the invention adopts the following technical scheme: the automated BOM table checking method comprises the following steps: Loading a standard material summary table, wherein the field of the standard material summary table comprises a material code, a specification description, a PCB package and a material state, and one of on-use, off-use and off-use is recorded under the field of the material state; Analyzing the BOM table to be checked passing the format check, and executing the following check items in parallel: identifying and marking materials belonging to the disabling or forbidden materials in the BOM table to be checked according to the standard material summary table; Identifying and marking materials with substantial errors of parameter values recorded under a field of specification description in the BOM table to be verified according to the standard material summary table; identifying and marking materials with wrong packaging models recorded under a field of PCB packaging in the BOM table to be verified according to the standard material summary table; repeatedly checking, namely repeatedly checking the bit number and the material code in the BOM table to be checked, and identifying and marking the material with repeated bit number or material code; outputting the checked BOM table. Optionally, the description verification specifically includes: According to the material codes, comparing the records of all materials in the BOM table to be checked in the field of specification description with the records of corresponding materials in the standard ma