Bill of material matching method and device, electronic equipment and storage medium

By automatically matching and intelligently recommending materials in the product life cycle management system, the problem of bill of material matching relying on manual operations is solved, improving efficiency and quality and reducing costs.

CN118940051APending Publication Date: 2024-11-12INSPUR SUZHOU INTELLIGENT TECH CO LTD
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202410985488.1
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-07-22
Publication Date
2024-11-12

AI Technical Summary

Technical Problem

During the server board design process, bill of materials matching mainly relies on manual operations, which consumes a lot of time and energy, affecting project quality and progress.

Method used

By obtaining the bill of materials and automatically matching the materials in the product life cycle management system, identifying materials with the same supplier component number, and intelligently recommending them based on the key parameters of differential materials, generating alternative bill of materials to reduce manual intervention.

Benefits of technology

It improves the efficiency of material list matching, reduces the work intensity of engineers, ensures project quality and progress, reduces communication costs, and achieves cost reduction and efficiency improvement.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN118940051A_ABST
    Figure CN118940051A_ABST
Patent Text Reader

Abstract

The embodiment of the invention provides a bill of material matching method and device, electronic equipment and a storage medium. The method comprises the following steps: acquiring a first bill of material and determining a first material list according to the first bill of material; then obtaining a second material list stored in the product life cycle management system, and determining a first material and a second material according to the first material list and the second material list; therefore, the target material is determined in the product life cycle management system according to the second material, and the second material list is determined according to the first material and the target material, so that the same material stored in the enterprise product life cycle management system is automatically determined based on the supplier component number after the material list is received. And the target material can be determined as an optional alternative material in the product life cycle management system according to the difference material in the original bill of materials, so that the matched bill of materials is generated, the matching efficiency of the bill of materials is improved, and the working intensity of engineers is reduced.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the field of material management, and in particular to a bill of materials matching method and device, electronic equipment, and storage medium. Background Art

[0002] In the process of server board design, BOM (Bill of Materials) refers to the list of all materials used in the board design process. The BOM list usually includes detailed information such as the name, number, quantity, specification, material and procurement information of each material. It is an important document in many fields such as product design, procurement and production, which helps to optimize product design, production and supply chain processes, improve efficiency and reduce costs. As an important document in modern manufacturing and supply chain management, the historical development of BOM is closely linked to the evolution of industrialization. At the same time, it is also affected by industrial technology and information technology, and is constantly improved and perfected.

[0003] For example, in a Copy Design project, the existence of a BOM plays a vital role: First, as an important supplement to the design schematic, BOM often records the structural composition and material configuration information of the product; Second, BOM clarifies the specifications of the materials required for the product, the type and quantity of accessories and other details, providing designers with a basis for modifying and adapting the original design to suit the material resources and production needs of a specific organization, including the possibility of selecting alternative materials; Third, as an important reference document, BOM can assist in the formulation of procurement plans to ensure that necessary materials are provided in a timely manner at all stages of product adaptation, modification and production testing; Fourth, based on the material quality and performance requirements listed in the BOM, quality control and performance testing can be performed on the product to ensure that the finished product meets the expected quality standards.

[0004] However, in the process of related projects, the BOM list matching method in related technologies mainly relies on the vlookup function of Excel for operation, which requires heavy reliance on manual query and matching. Due to the large number of materials involved in the boards, the BOM lists received by the companies are also different, resulting in a lot of time and energy of engineers for matching operations, which seriously affects the quality and progress of the project. Summary of the invention

[0005] In view of the above problems, a bill of materials matching method and device, electronic device, and storage medium are proposed to overcome the above problems or at least partially solve the above problems, including:

[0006] A bill of materials matching method, the method comprising:

[0007] Obtaining a first bill of materials, and determining a first material list according to the first bill of materials;

[0008] Obtain a second material list stored in the product lifecycle management system, and determine a first material and a second material according to the first material list and the second material list, wherein the first material is a material having the same supplier part number in the first material list and the second material list, and the second material is a remaining material after removing the first material from the first material list;

[0009] Based on the second material, a target material is determined in the product lifecycle management system, and based on the first material and the target material, a second bill of materials is determined.

[0010] Optionally, determining a target material in the product lifecycle management system according to the second material includes:

[0011] Performing key parameter extraction processing on the second material to obtain the first key parameter corresponding to the second material;

[0012] Matching and comparing the first key parameter with a second key parameter of a material stored in the product lifecycle management system to determine a third material list in the product lifecycle management system; wherein the second key parameter is a key parameter of the material stored in the second material list;

[0013] Determining similarity information between the first key parameter and the second key parameter;

[0014] sorting the third material list according to the similarity information to generate a fourth material list;

[0015] Compare the first key parameter with the third key parameter in the fourth material list to determine the key parameter difference;

[0016] Generate a material parameter difference report based on the key parameter difference points;

[0017] The target material is determined in the product lifecycle management system according to the fourth material list and the material parameter difference report.

[0018] Optionally, determining the target material in the product lifecycle management system according to the fourth material list and the material parameter difference report includes:

[0019] Determining procurement attributes of the materials in the fourth material list in the product lifecycle management system;

[0020] sorting the fourth material list according to the procurement attributes to generate a fifth material list;

[0021] The target material is determined in the product lifecycle management system according to the fifth material list and the material parameter difference report.

[0022] Optionally, before determining the procurement attributes of the materials in the fourth material list in the product lifecycle management system, the method further includes:

[0023] Determine status information of the material in the fourth material list, and add first annotation information to the material in the fourth material list according to the status information.

[0024] Optionally, determining the target material in the product lifecycle management system according to the fifth material list and the material parameter difference report includes:

[0025] Determine the optimal solution material in the fifth material list, and add second annotation information to the optimal solution material;

[0026] The target material is determined in the product lifecycle management system according to the first marking information, the second marking information, the fifth material list and the material parameter difference report.

[0027] Optionally, before determining a target material in the product lifecycle management system based on the second material, the method further includes:

[0028] According to the supplier part number of the first material, a preset part number corresponding to the supplier part number is added to the first material.

[0029] Optionally, determining the first material and the second material according to the first material list and the second material list includes:

[0030] Matching the first material list and the second material list according to a preset matching function to determine materials in the first material list and the second material list that have the same supplier part number;

[0031] The materials in the first material list and the second material list that have the same supplier part number are determined as the first materials, and the remaining materials in the first material list after removing the first material are determined as the second materials.

[0032] A bill of materials matching device, comprising:

[0033] A first material list determination module, used to obtain a first material list and determine a first material list according to the first material list;

[0034] A first material and a second material determination module, used to obtain a second material list stored in the product lifecycle management system, and determine a first material and a second material according to the first material list and the second material list, wherein the first material is a material having the same supplier part number in the first material list and the second material list, and the second material is a remaining material in the first material list after removing the first material;

[0035] The second bill of materials determination module is used to determine a target material in the product lifecycle management system based on the second material, and to determine a second bill of materials based on the first material and the target material.

[0036] An electronic device, characterized in that it includes a processor, a memory, and a computer program stored in the memory and capable of running on the processor, and when the computer program is executed by the processor, the bill of materials matching method as described above is implemented.

[0037] A computer-readable storage medium, characterized in that a computer program is stored on the computer-readable storage medium, and when the computer program is executed by a processor, the bill of materials matching method as described above is implemented.

[0038] The embodiments of the present invention have the following advantages:

[0039] In an embodiment of the present invention, a first bill of materials is obtained and a first material list is determined based on the first bill of materials; then a second material list stored in the product lifecycle management system is obtained, and the first material and the second material are determined based on the first material list and the second material list, wherein the first material is a material having the same supplier part number in the first material list and the second material list, and the second material is a remaining material in the first material list after removing the first material; thereby determining a target material in the product lifecycle management system based on the second material, and then determining a second bill of materials based on the first material and the target material, not only realizes automatic determination of the same material stored in the enterprise product lifecycle management system based on the supplier part number after receiving the bill of materials, but also can determine the target material in the product lifecycle management system as an optional alternative material based on the difference material in the original bill of materials and then generate a matched bill of materials, thereby avoiding complete reliance on manual bill of materials query and matching, improving the matching efficiency of the bill of materials, reducing the workload of engineers, and ensuring the quality and progress of the project. BRIEF DESCRIPTION OF THE DRAWINGS

[0040] In order to more clearly illustrate the technical solution of the present invention, the accompanying drawings required for use in the description of the present invention will be briefly introduced below. Obviously, the accompanying drawings in the following description are only some embodiments of the present invention. For ordinary technicians in this field, other accompanying drawings can be obtained based on these accompanying drawings without paying creative labor.

[0041] Figure 1 is a flowchart of the steps of a bill of materials matching method provided by some embodiments of the present invention;

[0042] Figure 2 It is a schematic diagram of a partial execution flow of the present invention provided by some embodiments of the present invention;

[0043] Figure 3 is a schematic diagram of another part of the execution flow of the present invention provided by some embodiments of the present invention;

[0044] Figure 4 is a schematic diagram of another part of the execution flow of the present invention provided by some embodiments of the present invention;

[0045] Figure 5 is an example diagram of a UI interface of the automation tool of the present invention provided in some embodiments of the present invention;

[0046] Figure 6 is a schematic diagram of the structure of a bill of materials matching device provided by some embodiments of the present invention;

[0047] Figure 7 is a block diagram of an electronic device provided in some embodiments of the present invention;

[0048] Figure 8 is a schematic diagram of a computer-readable medium provided in some embodiments of the present invention. DETAILED DESCRIPTION

[0049] In order to make the above-mentioned purposes, features and advantages of the present invention more obvious and easy to understand, the present invention is further described in detail below in conjunction with the accompanying drawings and specific embodiments. Obviously, the described embodiments are part of the embodiments of the present invention, rather than all the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0050] In fact, when carrying out Copy Design projects, the hardware engineers involved in the design need to obtain relevant information such as the design schematics and BOM (Bill of Materials) provided by the customer. Then, the hardware engineers often need to match the vendor part number (Vendor PN) in the BOM with the company part number (Company PN) in the product lifecycle management (PLM) system to ensure that the customer-specified parts have been correctly incorporated into the company's system and are available for normal use. For materials that exist in the customer's BOM but are missing in the company's PLM system, the hardware engineers need to manually select appropriate alternative parts based on the part number and specification parameters provided by the supplier, update the BOM accordingly, and submit the newly generated BOM to the procurement department to confirm the procurement attributes of the parts. Only after the procurement department confirms that the information of the required materials is correct can the final version of the BOM be obtained, which can be used to guide subsequent procurement and production activities. In addition, whenever the design schematic changes, the hardware engineer must update the BOM according to the latest design and synchronize this information with relevant departments in a timely manner to ensure the smooth progress of the project.

[0051] In related technologies, BOM lists are usually transferred and exchanged in Excel format between EE (Electronic Engineer), DC (Direct Current Engineer) and other field staff. In Copy Design projects, when docking with the product lifecycle management (PLM) system, the following two situations may be encountered when performing material matching:

[0052] There are no differentiated materials: After obtaining the BOM provided by the customer, the engineer needs to export the complete bill of materials from the PLM system and use the supplier part number (PN) as a keyword for matching. In this case, the engineer compares the materials in the customer's BOM with the material numbers in the company's PLM system one by one to ensure consistency. Taking the mainstream two-way system project as an example, the number of boards involved is about 20, of which the main motherboard BOM contains about 300 different materials.

[0053] Differentiated materials exist: If the customer's BOM list contains differentiated materials that are not included in the PLM material library, engineers need to replace these differentiated materials based on the actual situation of the enterprise. This requires engineers to find alternative materials with similar functions and specifications in the PLM system based on the material models in the BOM list, and consider multiple factors to determine the best alternative. Subsequently, engineers need to communicate with the procurement department to confirm whether the selected alternative material is feasible.

[0054] Based on the above content, the following process is generally used in related technologies to match the bill of materials: manually extract material data from the product lifecycle management (PLM) system, and use the vlookup function in Excel to compare these material data with the BOM provided by the customer; then the material information required in the PLM system will be copied back to the BOM, and the BOM will be reorganized as necessary to form the final version; for those differentiated materials that are in the customer's BOM but missing in the PLM system, engineers must first identify the key parameters of these materials, then search them in the PLM system, and select the most suitable alternative materials from many possible alternative materials based on design requirements.

[0055] However, the above process mainly relies on manual operation by engineers. When selecting alternative materials, the selection of materials also depends on the experience and expertise of engineers. In addition, when selecting from a wide range of materials, it is very easy to miss suitable materials or fail to match the best alternative materials, which in turn affects the quality and progress of the project.

[0056] In the embodiment of the present invention, based on the core technical concept of automatically determining the same materials stored in the enterprise product lifecycle management system based on the supplier part number after receiving the bill of materials, and determining the target material as an optional alternative material in the product lifecycle management system according to the difference material in the original bill of materials, and then generating a matched bill of materials, the bill of materials matching method in the related art is improved. The present invention will be described in detail below with reference to the accompanying drawings:

[0057] Reference Figure 1 , shows a flowchart of a bill of materials matching method provided by some embodiments of the present invention, which may specifically include the following steps:

[0058] Step 101, obtaining a first bill of materials, and determining a first material list according to the first bill of materials;

[0059] Python is a general-purpose programming language inspired by the ABC language. It has attracted many beginners and professional developers for its simplicity, efficiency and feature-rich features. It is widely used in Web development, scientific computing, artificial intelligence, data analysis, automated scripts, network programming and many other fields.

[0060] Therefore, in the specific implementation, the first bill of materials provided by the customer can be obtained first, and the first material list can be determined based on the first bill of materials; specifically, the tkinter module can be used in the python script to directly import the BOM list provided by the customer into the automation tool in the corresponding UI interface; and the pandas library can be used to perform automatic preprocessing on the imported BOM list to generate the corresponding material list for the subsequent matching process.

[0061] Step 102, obtaining a second material list stored in the product lifecycle management system, and determining a first material and a second material according to the first material list and the second material list, wherein the first material is a material having the same supplier part number in the first material list and the second material list, and the second material is a remaining material after removing the first material from the first material list;

[0062] In practical applications, such as Figure 2 As shown, Python's ORM library tool and the interface of the PLM system can be used to obtain information in the PLM system database, thereby automatically exporting the material list in the PLM system (i.e., the second material list). Furthermore, the existing materials in the BOM list (i.e., the first material list) in the PLM system (i.e., the second material list) can be matched. For example, a module with a comparison function can be written accordingly, and the matched function can be used to match the first material list with the second material list, identify the materials in the first material list and the second material list that have the same supplier part number (i.e., the first material), and use the remaining materials in the first material list after removing the first material as the differential materials (i.e., the second material).

[0063] Furthermore, materials that are in the first material list but not in the second material list of the PLM system can be skipped, and a new column of information can be added to the first material list based on the identification results in the above steps. For example, the PN information corresponding to the material set in the PLM in the enterprise can be inserted into the determined first material and sent back for subsequent use in building a matched bill of materials.

[0064] In some embodiments of the present invention, determining the first material and the second material according to the first material list and the second material list includes:

[0065] Matching the first material list and the second material list according to a preset matching function to determine materials in the first material list and the second material list that have the same supplier part number;

[0066] The materials in the first material list and the second material list that have the same supplier part number are determined as the first materials, and the remaining materials in the first material list after removing the first material are determined as the second materials.

[0067] In practical applications, Python's ORM library tool and the interface of the PLM system can be used to obtain information from the PLM system database, thereby automatically exporting the material list in the PLM system (i.e., the second material list). Furthermore, the existing materials in the BOM list (i.e., the first material list) in the PLM system (i.e., the second material list) can be matched. For example, a module with a comparison function can be written accordingly, and the matched function can be used to match the first material list with the second material list, identify the materials with the same supplier part number in the first material list and the second material list (i.e., the first material), and use the remaining materials in the first material list after removing the first material as differential materials (i.e., the second material), thereby realizing automatic identification of materials with the same supplier part number and differential materials, thereby improving the efficiency of bill of materials matching.

[0068] In some embodiments of the present invention, before determining the target material in the product lifecycle management system based on the second material, the method further includes:

[0069] According to the supplier part number of the first material, a preset part number corresponding to the supplier part number is added to the first material.

[0070] In a specific implementation, materials that are in the first material list but not in the second material list of the PLM system can be skipped, and a new column of information can be added to the first material list based on the identification results in the above steps. For example, the PN information corresponding to the material set in the PLM in the enterprise can be inserted into the determined first material and sent back for subsequent use in building a matched bill of materials.

[0071] Step 103: determining a target material in the product lifecycle management system according to the second material, and determining a second bill of materials according to the first material and the target material.

[0072] In the specific implementation, Figure 3As shown, after identifying the differentiated materials that are not in the PLM system, the corresponding function module can be written to export the list of differentiated materials, and the key parameters of the differentiated materials (i.e., the second materials) in the list can be further extracted to obtain the first key parameters corresponding to the second material; specifically, the read_excel() function of the pandas library can be used to extract the key parameters of the differentiated materials and store them in variables such as excel_datar1 and excel_datar2;

[0073] Furthermore, an intelligent recommendation step can be performed, that is, a material search and matching module can be written, and the key parameters of the differentiated materials (i.e., the first key parameters) can be matched and compared with the key parameters of the materials in the PLM system (i.e., the second key parameters) through the Python difflib library, so as to determine the third material list as an alternative material list for the differentiated materials in the product lifecycle management system, and then the similarity can be calculated based on the key parameters of the differentiated materials and the second key parameters corresponding to the materials in the third material list, and then the materials in the third material list can be sorted according to the similarity information, so as to generate a fourth material list as an alternative material list.

[0074] Furthermore, the key parameter of the differentiated material (i.e., the first key parameter) can be used as the original data to traverse the candidate materials in the candidate material list, compare the parameters of the candidate materials (i.e., the third key parameter) with the parameters of the original materials, determine the parameter difference points, and then generate and output a material parameter difference report based on the parameter difference points;

[0075] Furthermore, engineers can select target materials as replacement materials in the product lifecycle management system based on comprehensive considerations based on the above-mentioned candidate material list and material parameter difference report, or directly select target materials as replacement materials in the product lifecycle management system based on the contents of the candidate material list and material parameter difference report. The specific selection can be made based on actual application requirements;

[0076] Furthermore, after the target material is selected as a replacement material for the differentiated material in the product lifecycle management system, a second bill of materials can be generated as a matched bill of materials (i.e., the final bill of materials) based on the selected target material and the first material determined in the above steps.

[0077] In some embodiments of the present invention, determining a target material in the product lifecycle management system according to the second material includes:

[0078] Performing key parameter extraction processing on the second material to obtain the first key parameter corresponding to the second material;

[0079] Matching and comparing the first key parameter with a second key parameter of a material stored in the product lifecycle management system to determine a third material list in the product lifecycle management system; wherein the second key parameter is a key parameter of the material stored in the second material list;

[0080] Determining similarity information between the first key parameter and the second key parameter;

[0081] sorting the third material list according to the similarity information to generate a fourth material list;

[0082] Compare the first key parameter with the third key parameter in the fourth material list to determine the key parameter difference;

[0083] Generate a material parameter difference report based on the key parameter difference points;

[0084] The target material is determined in the product lifecycle management system according to the fourth material list and the material parameter difference report.

[0085] In practical applications, after identifying differentiated materials that are not in the PLM system, the corresponding function module can be written to export the list of differentiated materials, and the key parameters of the differentiated materials (i.e., the second materials) in the list can be further extracted to obtain the first key parameters corresponding to the second materials; specifically, the read_excel() function of the pandas library can be used to extract the key parameters of the differentiated materials and store them in variables such as excel_datar1 and excel_datar2;

[0086] Furthermore, an intelligent recommendation step can be performed, that is, a material search and matching module can be written, and the key parameters of the differentiated materials (i.e., the first key parameters) can be matched and compared with the key parameters of the materials in the PLM system (i.e., the second key parameters) through the Python difflib library, so as to determine the third material list as an alternative material list for the differentiated materials in the product lifecycle management system, and then the similarity can be calculated based on the key parameters of the differentiated materials and the second key parameters corresponding to the materials in the third material list, and then the materials in the third material list can be sorted according to the similarity information, so as to generate a fourth material list as an alternative material list.

[0087] Furthermore, the key parameter of the differentiated material (i.e., the first key parameter) can be used as the original data to traverse the candidate materials in the candidate material list, compare the parameters of the candidate materials (i.e., the third key parameter) with the parameters of the original materials, determine the parameter difference points, and then generate and output a material parameter difference report based on the parameter difference points;

[0088] Furthermore, engineers can select target materials as replacement materials in the product lifecycle management system based on comprehensive considerations based on the above-mentioned alternative material list and material parameter difference report, or they can directly select target materials as replacement materials in the product lifecycle management system based on the contents of the alternative material list and material parameter difference report. The specific selection can be made based on actual application requirements.

[0089] In some embodiments of the present invention, determining the target material in the product lifecycle management system according to the fourth material list and the material parameter difference report includes:

[0090] Determining procurement attributes of the materials in the fourth material list in the product lifecycle management system;

[0091] sorting the fourth material list according to the procurement attributes to generate a fifth material list;

[0092] The target material is determined in the product lifecycle management system according to the fifth material list and the material parameter difference report.

[0093] In actual applications, a corresponding material status check mechanism can be added to screen differentiated materials and materials with abnormal status, and re-sort them according to the degree of equipment parameter matching, material procurement attributes, and the purchase list provided by the procurement department. Deep learning and database optimization can also be performed based on feedback from different projects to achieve the purpose of real-time and uninterrupted updating of the tool.

[0094] Specifically, Figure 4 As shown, the procurement attributes of the materials in the fourth material list in the product life cycle management system can be determined, so that the fourth material list can be sorted again according to the procurement attributes to generate a fifth material list as an alternative material list, wherein the procurement attributes may include procurement attributes such as procureable status, unit price, and manufacturer, and the fourth material list can be sorted again according to factors such as procureable status (whether the material can be purchased at present), manufacturer (credit rating of cooperative manufacturer), unit price, etc., or it can be sorted according to procurement attributes and corresponding weights provided by the procurement department, which can be set specifically according to the actual application scenario;

[0095] Furthermore, the target material can be determined in the product lifecycle management system based on the fifth material list and the material parameter difference report, so as to incorporate procurement attributes into the factors for determining the alternative material list, thereby improving the rationality and practicality of the target material determination.

[0096] In some embodiments of the present invention, before determining the procurement attributes of the materials in the fourth material list in the product lifecycle management system, the method further includes:

[0097] Determine status information of the material in the fourth material list, and add first annotation information to the material in the fourth material list according to the status information.

[0098] In actual applications, Python scripts can be used to match materials in the BOM with materials in the PLM system and obtain the status information of the corresponding materials in the PLM system material database. Specifically, the material status can be set to include normal, risky, and unavailable. This allows highlighting of materials in risky and unavailable states, and recommendation of spare materials for materials in risky and unavailable states. This makes it easier to incorporate the material status information into the factors for determining the target material, further improving the rationality and practicality of determining the target material.

[0099] In some embodiments of the present invention, determining the target material in the product lifecycle management system according to the fifth material list and the material parameter difference report includes:

[0100] Determine the optimal solution material in the fifth material list, and add second annotation information to the optimal solution material;

[0101] The target material is determined in the product lifecycle management system according to the first marking information, the second marking information, the fifth material list and the material parameter difference report.

[0102] In a specific implementation, the optimal solution material can also be determined and marked according to the fifth material list determined in the aforementioned step. For example, the material with the highest ranking can be directly marked as the optimal solution material, so as to facilitate engineers or computers to use it as reference data when determining the target material in subsequent processes. Engineers or computers can also comprehensively consider the first marking information, the second marking information, the fifth material list and the material parameter difference report in the aforementioned steps to determine the target material in the product life cycle management system. For example, corresponding priorities can be set for the computer for the above-mentioned first marking information, the second marking information, the fifth material list and the material parameter difference report as judgment conditions for the target material, etc.

[0103] Furthermore, after the target material is selected as a replacement material for the differentiated material in the product lifecycle management system and confirmed with the purchasing department, a second bill of materials can be generated based on the selected target material and the first material determined in the above steps as a matched bill of materials (i.e., the final bill of materials).

[0104] The following is an exemplary description of the embodiment of the present invention in combination with 5:

[0105] Depend on Figure 5 It can be seen from the content that an automation tool with a UI interface can be set up to implement the above technical solution. Specifically, Python can be used as the programming language and the PLM system as the interface to develop an automation tool based on server-client and with a UI interface, so as to realize the functions of automatic matching of bills of materials and intelligent recommendation of alternative materials for differentiated materials, thereby improving the efficiency of BOM matching and communication with relevant departments and saving human resources.

[0106] Furthermore, the overall code idea of ​​the above automation tool with UI interface can be:

[0107] 1. Refer to the BOM list of the existing project, sort out a template corresponding to the BOM list and input it into the automation tool;

[0108] 2. Write the codes of each functional module according to the functions in the above scheme, for example, you can write a BOM format conversion and sorting module, a keyword matching and new attribute insertion module, a BOM generation and output module, a differentiated material automatic retrieval module, a keyword retrieval spare material module, a material difference point retrieval module, and a spare material sorting module;

[0109] 3. Build the UI interface and implement interaction with the above functional modules;

[0110] 4. Use Pyinstaller to package the Python code to form an automated tool.

[0111] Furthermore, the operation method of the above-mentioned automation tool may be:

[0112] 1. Use the "Browse" button to find the BOM list provided by the customer and import it into the automation tool. Click "Start Matching" to match materials. When the words "Processing Completed" appear in the text box below, you can click the "Download" button to export the matched BOM and choose the export path.

[0113] 2. Click "Differentiated Material List" in the left menu bar to see the categories and information of the differentiated materials matched in the previous step;

[0114] 3. Click "Smart Material Sorting" at the top or below the left menu bar. You can use the pop-up search bar to filter materials of specified models and get a list of candidate materials sorted by the set algorithm.

[0115] 4. Generate the final result.

[0116] In an embodiment of the present invention, a first bill of materials is obtained and a first material list is determined according to the first bill of materials; then a second material list stored in the product lifecycle management system is obtained, and the first material and the second material are determined according to the first material list and the second material list, wherein the first material is a material having the same supplier part number in the first material list and the second material list, and the second material is a remaining material after removing the first material from the first material list; thereby determining a target material in the product lifecycle management system according to the second material, and then determining the second bill of materials according to the first material and the target material, not only realizes automatic determination of the same material stored in the enterprise product lifecycle management system based on the supplier part number after receiving the bill of materials, but also can determine the target material as an optional alternative material in the product lifecycle management system according to the difference material in the original bill of materials and then generate a matched bill of materials, thereby avoiding complete reliance on manual query and matching of the bill of materials, improving the matching efficiency of the bill of materials, reducing the workload of engineers, ensuring the quality and progress of the project, improving production efficiency, reducing the communication cost of different positions, and achieving the technical effect of reducing costs and increasing efficiency.

[0117] It should be noted that, for the sake of simplicity, the method embodiments are described as a series of action combinations, but those skilled in the art should be aware that the embodiments of the present invention are not limited by the order of the actions described, because according to the embodiments of the present invention, certain steps can be performed in other orders or simultaneously. Secondly, those skilled in the art should also be aware that the embodiments described in the specification are all preferred embodiments, and the actions involved are not necessarily required by the embodiments of the present invention.

[0118] Reference Figure 6 , shows a schematic diagram of the structure of a bill of materials matching device provided by some embodiments of the present invention, which may specifically include the following modules:

[0119] A first material list determination module 601 is used to obtain a first material list and determine a first material list according to the first material list;

[0120] The first material and second material determination module 602 is used to obtain a second material list stored in the product lifecycle management system, and determine a first material and a second material according to the first material list and the second material list, wherein the first material is a material having the same supplier part number in the first material list and the second material list, and the second material is a remaining material in the first material list after removing the first material;

[0121] The second bill of materials determination module 603 is used to determine a target material in the product lifecycle management system according to the second material, and to determine a second bill of materials according to the first material and the target material.

[0122] In some embodiments of the present invention, the second bill of materials determination module 603 includes:

[0123] A first key parameter acquisition submodule, used for performing key parameter extraction processing on the second material to obtain the first key parameter corresponding to the second material;

[0124] A key parameter matching and comparison processing submodule is used to match and compare the first key parameter with the second key parameter of the material stored in the product lifecycle management system to determine a third material list in the product lifecycle management system; wherein the second key parameter is the key parameter of the material stored in the second material list;

[0125] A similarity information determination submodule, used to determine similarity information between the first key parameter and the second key parameter;

[0126] A fourth material list generating submodule, configured to sort the third material list according to the similarity information to generate a fourth material list;

[0127] A key parameter difference determination submodule, used for comparing the first key parameter with the third key parameter in the fourth material list to determine the key parameter difference;

[0128] A material parameter difference report generation submodule is used to generate a material parameter difference report according to the key parameter difference points;

[0129] The target material determination submodule is used to determine the target material in the product lifecycle management system according to the fourth material list and the material parameter difference report.

[0130] In some embodiments of the present invention, the target material determination submodule includes:

[0131] a procurement attribute determination unit, configured to determine procurement attributes of the materials in the fourth material list in the product lifecycle management system;

[0132] a fifth material list generating unit, configured to sort the fourth material list according to the procurement attributes to generate a fifth material list;

[0133] A target material determination unit is used to determine the target material in the product life cycle management system according to the fifth material list and the material parameter difference report.

[0134] In some embodiments of the present invention, the target material determination submodule further includes:

[0135] The first annotation information adding unit is used to determine the status information of the material in the fourth material list, and add first annotation information to the material in the fourth material list according to the status information.

[0136] In some embodiments of the present invention, the target material determination unit includes:

[0137] A second annotation information adding subunit is used to determine the optimal solution material in the fifth material list and add second annotation information to the optimal solution material;

[0138] The target material determination subunit is used to determine the target material in the product life cycle management system according to the first marking information, the second marking information, the fifth material list and the material parameter difference report.

[0139] In some embodiments of the present invention, the device further comprises:

[0140] A preset part number adding module is used to add a preset part number corresponding to the supplier part number for the first material according to the supplier part number of the first material.

[0141] In some embodiments of the present invention, the first material and second material determination module 602 includes:

[0142] A matching processing submodule, used for matching the first material list and the second material list according to a preset matching function to determine materials in the first material list and the second material list that have the same supplier part number;

[0143] The first material and second material determination submodule is used to determine the materials in the first material list and the second material list that have the same supplier part number as the first material, and determine the remaining materials in the first material list after removing the first material as the second material.

[0144] As for the device embodiment, since it is basically similar to the method embodiment, the description is relatively simple, and the relevant parts can be referred to the partial description of the method embodiment.

[0145] Some embodiments of the present invention further provide a computer program product, including a computer program, which implements the above bill of materials matching method when executed by a processor.

[0146] In addition, an embodiment of the present invention further provides an electronic device, such as Figure 7 As shown, it includes a processor 701, a communication interface 702, a memory 703 and a communication bus 704, wherein the processor 701, the communication interface 702, and the memory 703 communicate with each other through the communication bus 704.

[0147] Memory 703, used for storing computer programs;

[0148] The processor 701 is used to execute the program stored in the memory 703 to implement the following steps:

[0149] Obtaining a first bill of materials, and determining a first material list according to the first bill of materials;

[0150] Obtain a second material list stored in the product lifecycle management system, and determine a first material and a second material according to the first material list and the second material list, wherein the first material is a material having the same supplier part number in the first material list and the second material list, and the second material is a remaining material after removing the first material from the first material list;

[0151] Based on the second material, a target material is determined in the product lifecycle management system, and based on the first material and the target material, a second bill of materials is determined.

[0152] In an optional embodiment of the present invention, determining a target material in the product lifecycle management system according to the second material includes:

[0153] Performing key parameter extraction processing on the second material to obtain the first key parameter corresponding to the second material;

[0154] Matching and comparing the first key parameter with a second key parameter of a material stored in the product lifecycle management system to determine a third material list in the product lifecycle management system; wherein the second key parameter is a key parameter of the material stored in the second material list;

[0155] Determining similarity information between the first key parameter and the second key parameter;

[0156] sorting the third material list according to the similarity information to generate a fourth material list;

[0157] Compare the first key parameter with the third key parameter in the fourth material list to determine the key parameter difference;

[0158] Generate a material parameter difference report based on the key parameter difference points;

[0159] The target material is determined in the product lifecycle management system according to the fourth material list and the material parameter difference report.

[0160] In an optional embodiment of the present invention, determining the target material in the product lifecycle management system according to the fourth material list and the material parameter difference report includes:

[0161] Determining procurement attributes of the materials in the fourth material list in the product lifecycle management system;

[0162] sorting the fourth material list according to the procurement attributes to generate a fifth material list;

[0163] The target material is determined in the product lifecycle management system according to the fifth material list and the material parameter difference report.

[0164] In an optional embodiment of the present invention, before determining the procurement attributes of the materials in the fourth material list in the product lifecycle management system, the method further includes:

[0165] Determine status information of the material in the fourth material list, and add first annotation information to the material in the fourth material list according to the status information.

[0166] In an optional embodiment of the present invention, determining the target material in the product lifecycle management system according to the fifth material list and the material parameter difference report includes:

[0167] Determine the optimal solution material in the fifth material list, and add second annotation information to the optimal solution material;

[0168] The target material is determined in the product lifecycle management system according to the first marking information, the second marking information, the fifth material list and the material parameter difference report.

[0169] In an optional embodiment of the present invention, before determining the target material in the product lifecycle management system based on the second material, the method further includes:

[0170] According to the supplier part number of the first material, a preset part number corresponding to the supplier part number is added to the first material.

[0171] In an optional embodiment of the present invention, determining the first material and the second material according to the first material list and the second material list includes:

[0172] Matching the first material list and the second material list according to a preset matching function to determine materials in the first material list and the second material list that have the same supplier part number;

[0173] The materials in the first material list and the second material list that have the same supplier part number are determined as the first materials, and the remaining materials in the first material list after removing the first material are determined as the second materials.

[0174] The communication bus mentioned in the above terminal can be a Peripheral Component Interconnect (PCI) bus or an Extended Industry Standard Architecture (EISA) bus, etc. The communication bus can be divided into an address bus, a data bus, a control bus, etc. For ease of representation, only one thick line is used in the figure, but it does not mean that there is only one bus or one type of bus.

[0175] The communication interface is used for communication between the above terminal and other devices.

[0176] The memory may include a random access memory (RAM) or a non-volatile memory, such as at least one disk memory. Optionally, the memory may also be at least one storage device located away from the aforementioned processor.

[0177] The above-mentioned processor can be a general-purpose processor, including a central processing unit (CPU), a network processor (NP), etc.; it can also be a digital signal processor (DSP), an application specific integrated circuit (ASIC), a field programmable gate array (FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components.

[0178] like Figure 8 As shown, in another embodiment provided by the present invention, a computer-readable storage medium 801 is also provided, in which instructions are stored. When the computer-readable storage medium is run on a computer, the computer executes a bill of materials matching method described in the above embodiment.

[0179] The various embodiments in this specification are described in a progressive manner, and each embodiment focuses on the differences from other embodiments. The same or similar parts between the various embodiments can be referenced to each other.

[0180] Those skilled in the art will appreciate that the embodiments of the present invention may be provided as methods, devices, or computer program products. Therefore, the embodiments of the present invention may take the form of a complete hardware embodiment, a complete software embodiment, or an embodiment combining software and hardware. Moreover, the embodiments of the present invention may take the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) containing computer-usable program codes.

[0181] The embodiments of the present invention are described with reference to the flowcharts and / or block diagrams of the methods, terminal devices (systems), and computer program products according to the embodiments of the present invention. It should be understood that each process and / or block in the flowchart and / or block diagram, as well as the combination of the processes and / or blocks in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing terminal device to generate a machine, so that the instructions executed by the processor of the computer or other programmable data processing terminal device generate instructions for implementing the processes in the flowchart and / or block diagram. Figure 1 A process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.

[0182] These computer program instructions may also be stored in a computer-readable memory capable of directing a computer or other programmable data processing terminal device to operate in a specific manner, so that the instructions stored in the computer-readable memory produce a manufactured product including an instruction device, which implements the process Figure 1 A process or multiple processes and / or boxes Figure 1 A function specified in one or more boxes.

[0183] These computer program instructions can also be loaded onto a computer or other programmable data processing terminal device so that a series of operating steps are executed on the computer or other programmable terminal device to produce a computer-implemented process, thereby providing instructions for executing on the computer or other programmable terminal device to implement the process. Figure 1 A process or multiple processes and / or boxes Figure 1 The steps for the functions specified in one or more boxes.

[0184] Although the preferred embodiments of the present invention have been described, those skilled in the art may make additional changes and modifications to these embodiments once they have learned the basic creative concept. Therefore, the appended claims are intended to be interpreted as including the preferred embodiments and all changes and modifications that fall within the scope of the embodiments of the present invention.

[0185] Finally, it should be noted that, in this article, relational terms such as first and second, etc. are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Moreover, the terms "include", "comprise" or any other variants thereof are intended to cover non-exclusive inclusion, so that a process, method, article or terminal device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or terminal device. In the absence of further restrictions, the elements defined by the sentence "including one..." do not exclude the existence of other identical elements in the process, method, article or terminal device including the above elements.

[0186] The above provides a detailed introduction to a bill of materials matching method and device, electronic device, and storage medium. Specific examples are used in this article to illustrate the principles and implementation methods of the present invention. The description of the above embodiments is only used to help understand the method of the present invention and its core idea; at the same time, for those skilled in the art, according to the idea of ​​the present invention, there will be changes in the specific implementation method and application scope. In summary, the content of this specification should not be understood as a limitation on the present invention.

Claims

1. A bill of materials matching method, characterized in that: The method comprises: Obtaining a first bill of materials, and determining a first material list according to the first bill of materials; Obtain a second material list stored in the product lifecycle management system, and determine a first material and a second material according to the first material list and the second material list, wherein the first material is a material having the same supplier part number in the first material list and the second material list, and the second material is a remaining material after removing the first material from the first material list; Based on the second material, a target material is determined in the product lifecycle management system, and based on the first material and the target material, a second bill of materials is determined.

2. The material list matching method according to claim 1, characterized in that: Determining a target material in the product lifecycle management system according to the second material includes: Performing key parameter extraction processing on the second material to obtain the first key parameter corresponding to the second material; Matching and comparing the first key parameter with a second key parameter of a material stored in the product lifecycle management system to determine a third material list in the product lifecycle management system; wherein the second key parameter is a key parameter of the material stored in the second material list; Determining similarity information between the first key parameter and the second key parameter; sorting the third material list according to the similarity information to generate a fourth material list; Compare the first key parameter with the third key parameter in the fourth material list to determine the key parameter difference; Generate a material parameter difference report based on the key parameter difference points; The target material is determined in the product lifecycle management system according to the fourth material list and the material parameter difference report.

3. The material list matching method according to claim 2, characterized in that: Determining the target material in the product lifecycle management system according to the fourth material list and the material parameter difference report includes: Determining procurement attributes of the materials in the fourth material list in the product lifecycle management system; sorting the fourth material list according to the procurement attributes to generate a fifth material list; The target material is determined in the product lifecycle management system according to the fifth material list and the material parameter difference report.

4. The material list matching method according to claim 3, characterized in that: Before determining the procurement attributes of the materials in the fourth material list in the product lifecycle management system, the method further includes: Determine status information of the material in the fourth material list, and add first annotation information to the material in the fourth material list according to the status information.

5. The material list matching method according to claim 4, characterized in that: The determining the target material in the product lifecycle management system according to the fifth material list and the material parameter difference report includes: Determine the optimal solution material in the fifth material list, and add second annotation information to the optimal solution material; The target material is determined in the product lifecycle management system according to the first marking information, the second marking information, the fifth material list and the material parameter difference report.

6. The material list matching method according to any one of claims 1 to 5, characterized in that: The step of determining the target material in the product lifecycle management system according to the second material further includes: According to the supplier part number of the first material, a preset part number corresponding to the supplier part number is added to the first material.

7. The material list matching method according to any one of claims 1 to 5, characterized in that: The determining the first material and the second material according to the first material list and the second material list includes: Matching the first material list and the second material list according to a preset matching function to determine materials in the first material list and the second material list that have the same supplier part number; The materials in the first material list and the second material list that have the same supplier part number are determined as the first materials, and the remaining materials in the first material list after removing the first material are determined as the second materials.

8. A bill of materials matching device, characterized in that: The device comprises: A first material list determination module, used to obtain a first material list and determine a first material list according to the first material list; A first material and a second material determination module, used to obtain a second material list stored in the product lifecycle management system, and determine a first material and a second material according to the first material list and the second material list, wherein the first material is a material having the same supplier part number in the first material list and the second material list, and the second material is a remaining material in the first material list after removing the first material; The second bill of materials determination module is used to determine a target material in the product lifecycle management system based on the second material, and to determine a second bill of materials based on the first material and the target material.

9. An electronic device, characterized in that: The method comprises a processor, a memory, and a computer program stored in the memory and capable of running on the processor, wherein the computer program implements the bill of materials matching method according to any one of claims 1 to 7 when executed by the processor.

10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the bill of materials matching method according to any one of claims 1 to 7 is implemented.