BOM table automatic verification method and system and medium
By using automated verification methods, the problems of low efficiency and poor accuracy of manual BOM verification have been solved, achieving efficient and accurate material verification and ensuring R&D progress and product quality.
Patent Information
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- GUANGDONG CHUNTEX ELITE ELECTRONIC TECH CO LTD
- Filing Date
- 2026-02-09
- Publication Date
- 2026-05-12
AI Technical Summary
In existing technologies, BOM verification relies on manual checking, which is inefficient and inaccurate, leading to problems such as mismatched material packaging and inconsistent descriptions, affecting R&D progress and product quality.
An automated verification method is adopted, which loads a standard material master list, parses the BOM to be verified, and performs status verification, description verification, encapsulation verification and repeatability verification in parallel to identify and mark abnormal materials and generate a verified BOM.
Significantly improves verification efficiency and accuracy, enabling verification of massive amounts of materials to be completed within 3-5 minutes, with an accuracy rate exceeding 95%, reducing the risk of human error and ensuring material compliance and production reliability.
Smart Images
Figure CN122022701A_ABST
Abstract
Description
Technical Field
[0001] This invention relates to the field of bill of materials management technology, and in particular to a method, system and medium for automated verification of BOM (Bill of Materials) tables. Background Technology
[0002] In the entire process of electronic device R&D and production, the accuracy of material data directly determines product quality, production efficiency, and cost control. After the product schematic design is completed, the exported bill of materials (BOM) often has problems such as mismatched material packages, inconsistent descriptions, and even the inclusion of discontinued or disabled materials. If these problems are not detected in time, they will lead to a series of chain reactions such as PCB design rework, material procurement errors, and production line shutdowns, which will seriously affect project progress and product quality.
[0003] In existing technologies, the verification of the Bill of Materials (BOM) and the standard Bill of Materials (BOM) during the R&D process of electronic devices mainly relies on manual labor. The specific approach is as follows: After exporting the BOM from the schematic, engineers manually compare it line by line with the standard BOM, checking material codes, specifications, PCB packages, and other information to identify discontinued, disabled, or inconsistent materials. Abnormal materials are manually marked during the verification process, and then a second manual check confirms the type of discrepancy, ultimately completing the correction and update of the BOM. Some companies use Excel's basic filtering functions to assist in the verification, but the core verification logic still relies on manual judgment. This solution has two significant drawbacks: 1. Extremely low verification efficiency. Manual line-by-line verification consumes a lot of time, especially when the number of materials in the BOM exceeds a thousand. Verification work often takes several hours or even days, seriously affecting the R&D progress and failing to meet the needs of efficient R&D. 2. High error rate. Manual verification is easily affected by subjective factors such as fatigue and negligence. It is easy to miss subtle differences such as commas and spaces in the specification description, and to misjudge key information such as package model and material status. This leads to abnormal materials not being identified, which in turn causes problems such as PCB design rework and material procurement errors.
[0004] Therefore, based on R&D and quality requirements, and considering the mismatch between the material packaging and description in the Bill of Materials (BOM) derived from the schematic diagram and the overall material list, as well as the shortcomings of the existing verification schemes, it is necessary to provide an automatic and accurate BOM verification solution. Summary of the Invention
[0005] The technical problem to be solved by this invention is to provide an automated BOM (Bill of Materials) verification method, system, and medium to significantly improve verification efficiency and accuracy.
[0006] To solve the above-mentioned technical problems, the technical solution adopted by the present invention is as follows: Automated BOM validation methods include: Load the standard material master table, whose fields include material code, specification description, PCB package, and material status; wherein, the material status field records one of the following: in use, deactivated, or disabled; Parse the BOM table that has passed format validation and perform the following validation items in parallel: Status verification: Based on the standard material summary table, identify and mark the materials in the BOM to be verified that are discontinued or disabled; Description verification: Based on the standard material summary table, identify and mark the materials whose parameter values recorded in the specification description field of the BOM table to be verified have substantial errors; Package verification: Based on the standard bill of materials, identify and mark the materials whose package model is incorrect in the PCB package field of the BOM to be verified; Repeatability check: Perform a repeatability check on the tag numbers and material codes in the BOM table to be checked, and identify and mark the materials with duplicate tag numbers or material codes; Output the validated BOM table.
[0007] Optionally, the description verification specifically includes: Based on the material code, the records of each material in the BOM table to be verified under the specification description field are compared with the corresponding records of the materials in the standard material summary table under the specification description field. After filtering out format differences, materials with inconsistent parameter values are selected. The materials are marked in the BOM table to be verified.
[0008] Optionally, the format differences include missing or extra commas, extra spaces, and differences in capitalization.
[0009] Optionally, the encapsulation verification specifically includes: Based on the material code, the records of each material in the BOM table to be verified under the fields of tag number and PCB package are compared with the records of the corresponding materials in the standard material summary table under the field of PCB package, and materials with inconsistent PCB packages are filtered out. The materials are marked in the BOM table to be verified.
[0010] Optionally, the packaging verification is performed only on materials of the capacitor or resistor type in the BOM to be verified.
[0011] Optionally, the output verified BOM table includes: After all the verification items are executed, a verified BOM summary table with the marked materials highlighted and an abnormal BOM table containing only the marked materials are generated. Based on user instructions, retrieve and display the corresponding verified BOM summary table or the abnormal BOM table.
[0012] Optionally, parsing the BOM table to be validated that has passed format validation includes: The BOM table to be verified, which has passed the format validation, includes fields for tag number, material code, specification description, and PCB package.
[0013] Optionally, the parsing of the BOM table to be validated, which has passed format validation, further includes: Load the BOM table to be verified exported from the schematic; Perform format validation on the BOM table to be validated; If the format is incorrect, an error message will be displayed and you will be prompted to re-import. If the format is correct, a message will appear indicating that the format validation has passed and the BOM table to be validated has been successfully imported.
[0014] Another technical solution provided by this invention is: A computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, is capable of implementing the steps included in the above-described automated BOM verification method.
[0015] Another technical solution provided by this invention is: An automated BOM (Bill of Materials) verification system includes the aforementioned computer-readable storage medium and processor.
[0016] The BOM (Bill of Materials) automated verification method, system, and medium provided by this invention are based on a preset standard material summary table. Combining a standardized matching algorithm and anomaly identification logic, they adopt a fully automated verification method to efficiently and accurately complete the verification and anomaly screening of the BOM table derived from the schematic diagram. Attached Figure Description
[0017] Figure 1 A flowchart illustrating an automated BOM (Bill of Materials) verification method provided in an embodiment of the present invention; Figure 2 This is an example interface diagram of one optional style of the standard material summary table described in this invention; Figure 3 This is an example of an interface for one optional style of the BOM table to be verified as described in this invention. Figure 4 This is an example diagram of an optional style of the verified BOM table described in this invention. Detailed Implementation
[0018] To explain in detail the technical principles, specific implementable solutions, possible application scenarios, and achievable objectives and effects of the present invention, exemplary embodiments of the present invention will be described in more detail below with reference to the accompanying drawings. It is understood that the embodiments described herein and the embodiments shown in the accompanying drawings are only used to more clearly illustrate the technical solutions of the present invention, and are therefore only examples intended to explain the present invention, and should not be construed as limiting the present invention. It should be understood that the present invention can be implemented in various forms and should not be limited to the embodiments set forth herein.
[0019] Explanation of technical terms involved in this invention: Bill of Materials (BOM): A technical document describing the composition of a product. It records the raw materials, components, and their quantities required for the finished product in a data format. It is a core document connecting design, procurement, production, and management. It can be simply understood as the product's "master recipe" or "component identification card."
[0020] Item Number: A unique location code assigned to each item in the BOM (Bill of Materials) to accurately locate the physical position of the item on the product or circuit board (PCB package). It is a key index for production and quality inspection.
[0021] Material code: A unique identifier for each material, usually using standardized coding rules; material codes enable automated management and information traceability.
[0022] Material name: Directly reflects the material properties.
[0023] Specification Description: Also known as specification model, it records the detailed and specific technical parameters of the material, distinguishing different sizes, performance or configurations of the same material to avoid confusion.
[0024] Material status: Indicates whether the material is compliant and poses any risk. In this invention, it mainly includes three types: in use, discontinued, and disabled.
[0025] Please see Figures 1 to 4 This invention provides an automated BOM (Bill of Materials) verification method.
[0026] Please combine Figure 1 To understand this, the present invention provides an automated BOM (Bill of Materials) verification method, which includes the following steps: S1: Preset Standard Material Summary Table ( Figure 1 (Not shown).
[0027] The standard material master list includes core fields: material code, specification description, PCB package, and material status. Optionally, it may also include other fields such as manufacturer information and alternative material codes.
[0028] Preferably, the standard material summary sheet is in Excel format (.xlsx file extension). The standard material summary sheet is presented and stored in an Excel chart view format, which not only facilitates direct editing and viewing operations for engineers, providing a user-friendly interface, but also, as an industry standard format, allows seamless integration with mainstream systems such as ERP, PLM, and CAD, enabling automated data flow through APIs or middleware, and supporting easy import and export.
[0029] For example, one optional format of the standard bill of materials is as follows: Figure 2 As shown.
[0030] S2: Load the standard material summary table.
[0031] Preferably, if loading fails, a loading error is displayed and the operation is terminated. This ensures that the standard material summary table, which serves as the verification benchmark, is loaded correctly, guaranteeing the accuracy of subsequent verification work.
[0032] S3: Import the BOM table to be verified.
[0033] The BOM (Bill of Materials) to be verified is directly derived from the schematic diagram. The BOM includes core fields such as material code, reference designator, specification description, and PCB package. Optionally, it may also include other fields such as manufacturer information and alternative component codes.
[0034] For example, one optional style of the BOM table to be verified is as follows: Figure 3 As shown.
[0035] In some specific implementations, this step specifically includes: S31: Load the BOM table to be verified exported from the schematic; S32: Perform format validation on the BOM table to be validated; If the format is incorrect, an error message will be displayed and you will be prompted to re-import. If the format is correct, a message will appear indicating that the format verification has passed and the BOM table to be verified has been successfully imported. Then, S4 will be executed.
[0036] By performing format validation on the BOM table to be inspected, the standardization and integrity of the data structure of the BOM table to be inspected can be ensured, laying a solid foundation for subsequent automated comparison and anomaly identification, thereby greatly improving the efficiency and accuracy of the validation.
[0037] S4: Parse the BOM table to be verified that has passed the format validation, and execute the following validation items (1)-(4) in parallel. The parsing specifically refers to parsing the data of each field and the records under it in the BOM table to be verified.
[0038] (1) Status verification: Based on the standard material summary table, identify and mark the materials in the BOM to be verified that are discontinued or disabled.
[0039] Specifically, based on the "Material Code" field in the BOM to be verified, each material code recorded under it is checked one by one in the "Material Status" field of the standard material summary table. If the record is in a "Disabled" or "Disabled" state, it is determined that the material code has failed the status verification, and the material corresponding to the material code is marked in the BOM to be verified. Otherwise, it is determined that the material corresponding to the material code has passed the status verification. The next material code is checked until the status verification of all material codes recorded in the "Material Code" field of the BOM to be verified is completed.
[0040] The above status verification ensures that all materials in the BOM are currently available and compliant, avoiding production accidents or supply chain risks caused by the use of abnormal materials.
[0041] In some specific implementations, the aforementioned status verification supports dynamic logical association. Specifically, R&D personnel and other staff can obtain the latest material status information from channels such as the R&D database and update the corresponding material's record in the "Material Status" field of the standard material master table in real time. This closed-loop dynamic update mechanism ensures that the verification logic of the "Status Verification" item always reflects the current availability of the material, thereby improving the timeliness and reliability of the BOM verification results.
[0042] (2) Description verification: Based on the standard material summary table, identify and mark the materials whose parameter values recorded in the specification description field of the BOM table to be verified have substantial errors.
[0043] Specifically, based on the "Material Code" field in the BOM to be verified, the record of each material code under the "Specification Description" field is compared with the record of the corresponding material code under the "Specification Description" field in the standard material summary table to determine whether there is a substantial error in the record of each material in the BOM to be verified under the "Specification Description" field. If there is no substantial error, the material is determined to have passed the description verification; if there is a substantial error, the material is determined to have failed the description verification, and the material is marked as such in the BOM to be verified.
[0044] The aforementioned substantive error refers to a discrepancy in parameter values between the two objects after filtering out formatting differences. Formatting differences include, but are not limited to: missing commas / periods, extra commas / periods, extra spaces, and differences in capitalization.
[0045] The aforementioned description verification employs a standardized algorithm specifically designed to address common "formatting errors" in "specification descriptions." It accurately distinguishes between "substantive differences" and "formatting differences," automatically filtering out "formatting differences" that do not affect selection and eliminating invalid interference; it focuses on identifying substantial parameter differences that are sufficient to impact procurement / implementation. Furthermore, compared to traditional manual verification methods, this verification item, implemented automatically, effectively avoids the risk of misjudgment due to human oversight, while significantly improving verification efficiency and result reliability, ensuring the accuracy of material specification parameter data.
[0046] (3) Packaging verification: Based on the standard material summary table, identify and mark the materials whose packaging model is incorrect in the PCB packaging field of the BOM table to be verified.
[0047] Specifically, for each material code under the "Material Code" field in the BOM table to be verified, based on the records under the "Specification" and "PCB Package" fields, it is determined whether the PCB package defined by the material is consistent with the PCB package defined by the corresponding material in the "PCB Package" field of the standard material master table. If the PCB packages defined by the two are consistent, the package verification of the material in the BOM table to be verified is deemed to have passed; if they are inconsistent, the package verification of the material is deemed to have failed, and the material is marked in the BOM table to be verified.
[0048] Optionally, the aforementioned packaging verification is specifically designed for verifying basic materials such as capacitors and resistors. This significantly improves verification efficiency and accuracy, allowing resources to be precisely focused on high-risk components and effectively mitigating engineering risks caused by incorrect material procurement.
[0049] The aforementioned packaging verification mechanism, through deep integration of key elements in the R&D chain and leveraging the strong correlation between "reference designation," "material code," and "PCB package" unique to the BOM (Bill of Materials), constructs the packaging verification mechanism of this embodiment. This mechanism effectively mitigates the engineering risk of "accurate R&D drawings but incorrect material procurement," significantly improving product development reliability.
[0050] (4) Repeatability check: Perform a repeatability check on the tag number and material code in the BOM table to be checked, and identify and mark the materials with duplicate tag numbers or material codes.
[0051] The aforementioned duplicate verification can accurately identify and mark duplicate data in the BOM table, avoiding assembly errors, production chaos, or cost waste caused by coding conflicts, and significantly improving the uniqueness of BOM data and manufacturing reliability.
[0052] S5: Output the verified BOM table.
[0053] In some specific implementations, the verified BOM will mark materials that fail any of the verification items in (1)-(4) above: Optional tagging objects: material code, specific failed validation items (e.g., "PCB package"), the entire row of data, or adding new validation result fields corresponding to each validation item (e.g., "Validation (Description)", "Validation (Package)", etc.) for explanation (e.g.) Figure 4 (as shown) Optional marking methods: highlighting, adding special icons, inserting annotations, and other visualization techniques.
[0054] For example, the validated BOM table is as follows: Figure 4 As shown.
[0055] In some specific implementations, after all verification items are executed, a verified BOM summary table highlighting the marked materials and an abnormal BOM table containing only the marked materials will be generated. The display interface includes a "Hide Qualified Materials" option for the user to select. Based on user instructions (including instructions on whether to select the aforementioned option), the corresponding verified BOM summary table or the abnormal BOM table will be retrieved and displayed. By providing users with an abnormal BOM table containing only the marked materials, it facilitates centralized processing of abnormal materials.
[0056] In other specific implementations, it is also possible to generate a corrected BOM after correcting any anomalies in the verified BOM, which can be viewed or exported by users for reference in the procurement or design process.
[0057] Another embodiment of the present invention, based on the above embodiments, also provides a computer-readable storage medium.
[0058] This embodiment provides a computer-readable storage medium storing a computer program. When executed by a processor, the computer program can implement the steps included in the automated BOM verification method described in the above embodiment. The specific steps will not be repeated here; please refer to the description in the above embodiment for details.
[0059] Another embodiment of the present invention, based on the above embodiments, provides an automated BOM (Bill of Materials) verification system, including the computer-readable storage medium and processor described in the previous embodiment. The computer program is specifically executed by the processor of the automated BOM verification system, and is capable of implementing the steps included in the automated BOM verification method described in the above embodiments. The specific steps will not be repeated here; please refer to the description in the above embodiments for details.
[0060] Those skilled in the art will understand that all or part of the processes in the above technical solutions can be implemented by a computer program instructing related hardware. The program can be stored in a computer-readable storage medium, and when executed, it can include the processes of the methods described above. After being executed by a processor, the program can also achieve the beneficial effects of the corresponding methods.
[0061] The storage medium can be a disk, optical disc, read-only memory (ROM), or random access memory (RAM), etc.
[0062] This invention provides an automated BOM (Bill of Materials) verification method, system, and medium, which have at least the following beneficial effects: (1) The verification efficiency is improved by more than 90%. The BOM table with a large number of materials can be automatically verified in 3-5 minutes, which greatly improves the verification efficiency and shortens the R&D cycle.
[0063] (2) The accuracy rate of verification is improved to over 95%. Through standardized algorithms and anomaly identification logic, human subjective errors are effectively avoided, and substantial differences in the description of discontinued and disabled materials and parameters are accurately identified, effectively solving the defects of poor accuracy in traditional solutions.
[0064] (3) The operation threshold is low, and you can get started with only two core operations: "load BOM table - start verification".
[0065] Although preferred embodiments of the invention have been described, those skilled in the art, upon understanding the basic inventive concept, can make other changes and modifications to the embodiments. Therefore, the appended claims are intended to cover the preferred embodiments and all equivalent modifications falling within the scope of protection defined by the claims and their equivalents. Clearly, those skilled in the art can make various alterations and variations to the invention without departing from its spirit and scope. If such modifications and variations fall within the scope of protection defined by the claims and their equivalents, the invention also intends to include them.
[0066] It should be noted that any reference signs placed between parentheses in the claims should not be construed as limiting the claims. The word "comprising" does not exclude the presence of components or steps not listed in the claims. The word "a" or "an" preceding a component does not exclude the presence of a plurality of such components. The invention can be implemented by means of hardware comprising several different components and by means of a suitably programmed computer. In a unit claim enumerating several means, several of these means may be embodied by the same item of hardware.
[0067] In this invention, the terms "first" and "second" are used for descriptive purposes only and should not be construed as indicating or implying relative importance or implicitly specifying the number of indicated technical features. Therefore, a feature defined as "first" or "second" may explicitly or implicitly include one or more of that feature. In the description of this invention, "multiple" means two or more, unless otherwise explicitly specified. The term "and / or" is merely a description of the relationship between related objects, indicating that three relationships can exist. For example, A and / or B can represent: A existing alone, A and B existing simultaneously, or B existing alone.
[0068] In this invention, unless otherwise explicitly specified and limited, the terms "installation," "connection," "linking," and "fixing," etc., should be interpreted broadly. For example, they can refer to a fixed connection, a detachable connection, or an integral part; they can refer to a mechanical connection or an electrical connection; they can refer to a direct connection or an indirect connection through an intermediate medium; they can refer to the internal communication of two components or the interaction between two components. Those skilled in the art can understand the specific meaning of the above terms in this invention according to the specific circumstances.
[0069] In this specification, the use of terms such as "one embodiment," "some embodiments," "example," "specific example," or "some examples," etc., refers to a specific feature, structure, material, or characteristic described in connection with that embodiment or example, which is included in at least one embodiment or example of the present invention. The illustrative expressions of the above terms in this specification should not be construed as necessarily referring to the same embodiment or example. Furthermore, the specific features, structures, materials, or characteristics described may be combined in any suitable manner in one or more embodiments or examples. Moreover, without contradiction, those skilled in the art can combine and integrate the different embodiments or examples described in this specification, as well as the features of different embodiments or examples.
[0070] The above description is merely an embodiment of the present invention and does not limit the patent scope of the present invention. Any equivalent modifications made based on the content of the present invention specification and drawings, or direct or indirect applications in related technical fields, are similarly included within the patent protection scope of the present invention.
Claims
1. An automated BOM (Bill of Materials) verification method, characterized in that, include: Load the standard material master table, whose fields include material code, specification description, PCB package, and material status; wherein, the material status field records one of the following: in use, deactivated, or disabled; Parse the BOM table that has passed format validation and perform the following validation items in parallel: Status verification: Based on the standard material summary table, identify and mark the materials in the BOM to be verified that are discontinued or disabled; Description verification: Based on the standard material summary table, identify and mark the materials whose parameter values recorded in the specification description field of the BOM table to be verified have substantial errors; Package verification: Based on the standard bill of materials, identify and mark the materials whose package model is incorrect in the PCB package field of the BOM to be verified; Repeatability check: Perform a repeatability check on the tag numbers and material codes in the BOM table to be checked, and identify and mark the materials with duplicate tag numbers or material codes; Output the validated BOM table.
2. The automated BOM verification method as described in claim 1, characterized in that, The description verification specifically includes: Based on the material code, the records of each material in the BOM table to be verified under the specification description field are compared with the corresponding records of the materials in the standard material summary table under the specification description field. After filtering out format differences, materials with inconsistent parameter values are selected. The materials are marked in the BOM table to be verified.
3. The automated BOM verification method as described in claim 2, characterized in that, The format differences include missing or extra commas, extra spaces, and differences in capitalization.
4. The automated BOM verification method as described in claim 1, characterized in that, The encapsulation verification specifically includes: Based on the material code, the records of each material in the BOM table to be verified under the fields of tag number and PCB package are compared with the records of the corresponding materials in the standard material summary table under the field of PCB package, and materials with inconsistent PCB packages are filtered out. The materials are marked in the BOM table to be verified.
5. The automated BOM verification method as described in claim 1, characterized in that, The encapsulation verification is only performed on materials of the capacitor or resistor type in the BOM to be verified.
6. The automated BOM verification method as described in claim 1, characterized in that, The output verified BOM table includes: After all the verification items are executed, a verified BOM summary table with the marked materials highlighted and an abnormal BOM table containing only the marked materials are generated. Based on user instructions, retrieve and display the corresponding verified BOM summary table or the abnormal BOM table.
7. The automated BOM verification method as described in claim 1, characterized in that, The parsing of the BOM table to be validated, which has passed format validation, includes: The BOM table to be verified, which has passed the format validation, includes fields for tag number, material code, specification description, and PCB package.
8. The automated BOM verification method as described in claim 7, characterized in that, The parsing of the BOM table to be validated, which has passed format validation, also includes: Load the BOM table to be verified exported from the schematic; Perform format validation on the BOM table to be validated; If the format is incorrect, an error message will be displayed and you will be prompted to re-import. If the format is correct, a message will appear indicating that the format validation has passed and the BOM table to be validated has been successfully imported.
9. A computer-readable storage medium having a computer program stored thereon, characterized in that, When the computer program is executed by the processor, it can implement the steps included in the BOM table automated verification method according to claims 1 to 8.
10. An automated BOM (Bill of Materials) verification system, characterized in that, Includes the computer-readable storage medium and processor as described in claim 9.