A method and system for automatically analyzing BOM accuracy
By setting capture time points within the operating cycle and automatically analyzing the BOM accuracy of order numbers and configuration numbers, the problem of low BOM accuracy statistics efficiency is solved, and real-time feedback and accuracy improvement are achieved.
Patent Information
- Application Number
- CN202210842372.3
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Priority Date
- 2021-10-19
- Filing Date
- 2022-07-18
- Publication Date
- 2025-09-30
- Estimated Expiration
- 2042-07-18
AI Technical Summary
The existing technology has low efficiency in BOM accuracy statistics and cannot provide real-time data feedback, resulting in the R&D department being unable to handle material problems in a timely manner and unable to continuously improve accuracy.
Set the time point for capturing the order number and configuration number in each operation cycle, automatically analyze the BOM accuracy of the order number and configuration number through the calculation formula, provide real-time feedback on technical problem materials to the R&D terminal, and generate an accuracy trend analysis report.
Effectively reduce labor costs, improve work efficiency, provide real-time feedback on technical problem materials, and continuously promote the improvement of BOM accuracy.
Smart Images

Figure CN115081928B_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the field of BOM technology, and in particular to a method and system for automatically analyzing BOM accuracy. Background Art
[0002] A Bill of Materials (BOM) is a computer-aided production management document that allows computers to read the product components and all materials involved. To facilitate computer recognition, the product structure, represented graphically, is converted into a data format to describe the product structure. A BOM is a technical document that defines the product structure. It is also known as a product structure table or product structure tree.
[0003] Currently, most BOM accuracy statistics are manually calculated through on-site trial assembly verification, which is inefficient and can only represent the BOM accuracy in the past. It cannot feedback real-time data and BOM accuracy change trends, resulting in the R&D department being unable to deal with problematic materials in a timely manner and unable to continuously promote the improvement of BOM accuracy. Summary of the Invention
[0004] In order to overcome the above-mentioned deficiencies in the prior art, the present invention provides a method for automatically analyzing the BOM accuracy to solve the problem that the BOM accuracy cannot be automatically analyzed in the prior art;
[0005] Methods include:
[0006] In each operation cycle, set the time point for capturing order numbers;
[0007] Based on the order number capture time point, the order number in the emergency pull table is captured, and the order BOM accuracy corresponding to the order number is calculated.
[0008] The specific calculation method is: take the number of components of any work order of the order as the total data volume of the order BOM A1, summarize the emergency pull data of the order number, and filter the number of entries B1 where the reason for the emergency pull is technical problems, calculate the order number BOM accuracy through the formula (1-B1 / A1)×100%, and store it.
[0009] It should be further explained that the material details of the order with technical problems are summarized by order number, and the materials with technical problems are fed back to the R&D terminal.
[0010] In the method,
[0011] By querying the order history BOM accuracy, an order BOM accuracy trend analysis report is generated.
[0012] It should be further explained that the method further includes:
[0013] In each operation cycle, set the configuration number capture time point;
[0014] Capture the configuration number in the emergency pull table based on the configuration number capture time point, and calculate the configuration number BOM accuracy corresponding to the configuration number;
[0015] The specific calculation method is as follows: obtain the order information associated with the configuration number according to the configuration number, obtain the work order BOM lists corresponding to different orders, summarize the BOM list information and remove duplicates as the total BOM quantity A2 of the configuration number, obtain the emergency pull items associated with today's order number of the configuration number, remove duplicates and sum them according to the material number, filter out the number of items B2 whose emergency pull orders are due to technical problems, calculate the configuration number BOM accuracy using the formula (1-B2 / A2)×100%, and store it.
[0016] It should be further explained that the material details of the order with technical problems are summarized by configuration number, and the materials with technical problems are fed back to the R&D terminal.
[0017] By querying the configuration number BOM accuracy, a configuration number BOM accuracy trend analysis report is generated.
[0018] The present invention also provides a system for automatically analyzing BOM accuracy, comprising: a storage medium, an order number capture and setting module, and an order number calculation module;
[0019] The order number capture setting module is used to set the order number capture time point in each operation cycle;
[0020] The order number calculation module grabs the order number in the emergency pull table based on the order number grabbing time point, and calculates the order BOM accuracy corresponding to the order number.
[0021] The number of components in any work order of the order is taken as the total data volume of the order BOM A1, the order number emergency pull data is summarized, and the number of entries B1 where the emergency pull request reason is technical problem is filtered out, and the order number BOM accuracy is calculated by the formula (1-B1 / A1)×100%, and the calculated order number BOM accuracy is stored in the storage medium.
[0022] It should be further explained that it also includes: a configuration number capture and setting module and a configuration number calculation module;
[0023] The configuration number capture setting module is used to set the configuration number capture time point in each operation cycle;
[0024] The configuration number calculation module grabs the configuration number in the emergency pull table based on the configuration number grabbing time point, and calculates the configuration number BOM accuracy corresponding to the configuration number.
[0025] Obtain order information associated with the configuration number based on the configuration number, obtain the work order BOM lists corresponding to different orders, summarize the BOM list information and remove duplicates as the total BOM quantity A2 of the configuration number, obtain the emergency pull items associated with today's order number of the configuration number, remove duplicates and sum them according to the material number, filter out the number of items B2 whose emergency pull orders are due to technical problems, calculate the configuration number BOM accuracy using the formula (1-B2 / A2)×100%, and store the calculated configuration number BOM accuracy in the storage medium.
[0026] It can be seen from the above technical solutions that the present invention has the following advantages:
[0027] This invention automatically calculates BOM accuracy, effectively reducing labor costs and improving work efficiency. It also provides real-time feedback on technically problematic materials to the R&D department, improving BOM problem handling efficiency. By analyzing daily BOM accuracy trends, it continuously promotes BOM accuracy improvements. BRIEF DESCRIPTION OF THE DRAWINGS
[0028] In order to more clearly illustrate the technical solution of the present invention, the following is a brief introduction to the drawings required for the description. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative work.
[0029] Figure 1 Flowchart of the method for automatically analyzing BOM accuracy;
[0030] Figure 2 A flow chart of an embodiment of a method for automatically analyzing BOM accuracy;
[0031] Figure 3 Schematic diagram of the system for automatically analyzing BOM accuracy;
[0032] Figure 4 Schematic diagram of a system embodiment for automatically analyzing BOM accuracy. DETAILED DESCRIPTION
[0033] The following will clearly and completely describe the technical solutions in the embodiments of the present invention in conjunction with the accompanying drawings. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without making creative efforts are within the scope of protection of the present invention.
[0034] The units and algorithm steps of each example described in the disclosed embodiments of the method and system for automatically analyzing the accuracy of the BOM provided by the present invention can be implemented by electronic hardware, computer software, or a combination of the two. In order to clearly illustrate the interchangeability of hardware and software, the composition and steps of each example have been generally described in terms of function in the above description. Whether these functions are performed in hardware or software depends on the specific application and design constraints of the technical solution. Professional and technical personnel can use different methods to implement the described functions for each specific application, but such implementation should not be considered to be beyond the scope of the present invention.
[0035] The block diagrams shown in the accompanying drawings of the method and system for automatically analyzing BOM accuracy provided by the present invention are merely functional entities and do not necessarily correspond to physically separate entities. Specifically, these functional entities may be implemented in software, in one or more hardware modules or integrated circuits, or in different networks and / or processor devices and / or microcontroller devices.
[0036] In the method and system for realizing automatic analysis of BOM accuracy provided by the present invention, it should be understood that the disclosed system, device and method can be realized in other ways. For example, the device embodiment described above is only schematic. For example, the division of the units is only a logical function division. There may be other division methods in actual implementation. For example, multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. In addition, the mutual coupling or direct coupling or communication connection shown or discussed can be an indirect coupling or communication connection through some interfaces, devices or units, or can be an electrical, mechanical or other form of connection.
[0037] like Figure 1 As shown, in the method of the present invention, in each operation cycle, the order number capture time point is set;
[0038] For example, you can set a time point for order number capture based on a daily cycle. This time point can be a specific time point of the day, such as 12:00 or 23:59. You can also set multiple time points for order number capture, and there is no limit to the number of time points you can set.
[0039] The operation cycle involved in the present invention can also be an operation cycle in hours, days, or weeks. If the operation cycle is in hours, the order number capture time point can be a few minutes within an hour.
[0040] Based on the order number capture time point, the order number in the emergency pull table is captured, and the order BOM accuracy corresponding to the order number is calculated.
[0041] The specific calculation method is: take the number of components of any work order of the order as the total data volume of the order BOM A1, summarize the emergency pull data of the order number, and filter the number of entries B1 where the reason for the emergency pull is technical problems, calculate the order number BOM accuracy through the formula (1-B1 / A1)×100%, and store it.
[0042] Based on the order number BOM accuracy rate and the number of technical issue items (B1) obtained above, the details of the materials with technical issues are summarized by order number and the technical issue materials are fed back to the R&D terminal. The R&D terminal can be set up in the R&D department or the problem handling department to ensure that R&D personnel are promptly informed of the technical issue materials and can promptly handle them.
[0043] After the order BOM accuracy is calculated, the order history BOM accuracy can be extracted from the storage medium, and an order BOM accuracy trend analysis report can be generated based on the query of the extracted order history BOM accuracy.
[0044] like Figure 2 As shown, in each operation cycle, the configuration number capture time point is set;
[0045] For example, you can set a configuration number capture time point with a daily operation cycle. The configuration number capture time point can be a specific time point of the day, such as 12:00 or 23:59, etc. You can also set multiple configuration number capture time points, and there is no limit to the number of specific time points you can set.
[0046] Capture the configuration number in the emergency pull table based on the configuration number capture time point, and calculate the configuration number BOM accuracy corresponding to the configuration number;
[0047] The specific calculation method is as follows: obtain the order information associated with the configuration number according to the configuration number, obtain the work order BOM lists corresponding to different orders, summarize the BOM list information and remove duplicates as the total BOM quantity A2 of the configuration number, obtain the emergency pull items associated with today's order number of the configuration number, remove duplicates and sum them according to the material number, filter out the number of items B2 whose emergency pull orders are due to technical problems, calculate the configuration number BOM accuracy using the formula (1-B2 / A2)×100%, and store it.
[0048] Summarize the material details of the order with technical problems by configuration number, and feedback the materials with technical problems to the R&D terminal.
[0049] R&D terminals can be set up in the R&D department or the problem handling department, so that R&D personnel can promptly understand technical problem materials and handle them in a timely manner.
[0050] The present invention queries the configuration number BOM accuracy and forms a configuration number BOM accuracy trend analysis report.
[0051] By automatically calculating BOM accuracy, we can effectively reduce labor costs, improve work efficiency, and provide real-time feedback to the R&D department on technical issues, thereby improving BOM problem handling efficiency. By analyzing daily BOM accuracy trends, we can continuously promote BOM accuracy improvements.
[0052] In particular, according to an embodiment of the present disclosure, the process described with reference to the flowchart can be implemented as a computer software program. For example, an embodiment of the present disclosure includes a computer program product, which includes a computer program carried on a computer-readable storage medium, and the computer program includes program code for executing the method shown in the flowchart. In such an embodiment, the computer program can be downloaded and installed from a network through a communication part, and / or installed from a removable medium. When the computer program is executed by a central processing unit (CPU), the various functions defined in the method and / or device of the present application are executed.
[0053] Based on the above method, the present invention also provides a system for automatically analyzing the accuracy of BOM. Figure 3 As shown, it includes: a storage medium, an order number capture setting module and an order number calculation module;
[0054] The order number capture setting module is used to set the order number capture time point in each operation cycle;
[0055] The order number calculation module grabs the order number in the emergency pull table based on the order number grabbing time point, and calculates the order BOM accuracy corresponding to the order number.
[0056] The number of components in any work order of the order is taken as the total data volume of the order BOM A1, the order number emergency pull data is summarized, and the number of entries B1 where the emergency pull request reason is technical problem is filtered out, and the order number BOM accuracy is calculated by the formula (1-B1 / A1)×100%, and the calculated order number BOM accuracy is stored in the storage medium.
[0057] like Figure 4 As shown, the system also includes: a configuration number capture setting module and a configuration number calculation module;
[0058] The configuration number capture setting module is used to set the configuration number capture time point in each operation cycle;
[0059] The configuration number calculation module grabs the configuration number in the emergency pull table based on the configuration number grabbing time point, and calculates the configuration number BOM accuracy corresponding to the configuration number.
[0060] Obtain order information associated with the configuration number based on the configuration number, obtain the work order BOM lists corresponding to different orders, summarize the BOM list information and remove duplicates as the total BOM quantity A2 of the configuration number, obtain the emergency pull items associated with today's order number of the configuration number, remove duplicates and sum them according to the material number, filter out the number of items B2 whose emergency pull orders are due to technical problems, calculate the configuration number BOM accuracy using the formula (1-B2 / A2)×100%, and store the calculated configuration number BOM accuracy in the storage medium.
[0061] It should be noted that the storage medium shown in the present disclosure can be a computer-readable signal medium or a computer-readable storage medium, or any combination of the two. A computer-readable storage medium can be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, device, or device, or any combination of the above. More specific examples of computer-readable storage media can include, but are not limited to: an electrical connection with one or more wires, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM (Erasable Programmable Read Only Memory) or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above. In the present disclosure, a computer-readable storage medium can be any tangible medium that contains or stores a program that can be used by or in conjunction with an instruction execution system, device, or device. In the present disclosure, a computer-readable signal medium can include a data signal propagated in baseband or as part of a carrier wave, which carries computer-readable program code. Such propagated data signals may take various forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination thereof. A computer-readable signal medium may also be any computer-readable storage medium other than a computer-readable storage medium that can transmit, propagate, or transfer a program for use by or in conjunction with an instruction execution system, apparatus, or device. The program code contained on the computer-readable storage medium may be transmitted using any suitable medium, including but not limited to wireless, wired, optical cable, RF (Radio Frequency), etc., or any suitable combination thereof.
[0062] The configuration number calculation module and the order number calculation module can be implemented by using at least one of an application specific integrated circuit (ASIC), a digital signal processor (DSP), a digital signal processing device (DSPD), a programmable logic device (PLD), a field programmable gate array (FPGA), a processor, a controller, a microcontroller, a microprocessor, and an electronic unit designed to perform the functions described herein. In some cases, such an implementation can be implemented in a controller. For software implementation, an implementation such as a process or function can be implemented with a separate software module that allows the execution of at least one function or operation. The software code can be implemented by a software application (or program) written in any appropriate programming language, and the software code can be stored in a memory and executed by a controller.
[0063] The method and system for automatically analyzing the accuracy of the BOM provided by the present invention are the units and algorithm steps of each example described in combination with the embodiments disclosed herein, and can be implemented by electronic hardware, computer software, or a combination of the two. In order to clearly illustrate the interchangeability of hardware and software, the composition and steps of each example have been generally described in terms of function in the above description. Whether these functions are performed in hardware or software depends on the specific application and design constraints of the technical solution. Professional and technical personnel can use different methods to implement the described functions for each specific application, but such implementation should not be considered to be beyond the scope of the present invention.
[0064] The above description of the disclosed embodiments is intended to enable one skilled in the art to implement or use the present invention. Various modifications to these embodiments will be readily apparent to one skilled in the art, and the general principles defined herein may be implemented in other embodiments without departing from the spirit or scope of the present invention. Therefore, the present invention is not limited to the embodiments shown herein but is intended to conform to the widest scope consistent with the principles and novel features disclosed herein.
Claims
1. A method for automatically analyzing BOM accuracy, characterized in that the method include: In each operation cycle, set the time point for capturing order numbers; Based on the order number capture time point, the order number in the emergency pull table is captured, and the order BOM accuracy corresponding to the order number is calculated. The specific calculation method is: take the component quantity of any work order as the total order BOM data volume A1, summarize the emergency pull data for this order number, and filter out the number of items B1 where the emergency pull request reason is technical issues. Calculate the order number BOM accuracy using the formula (1-B1 / A1) × 100% and store it. Summarize the details of materials with technical problems according to the order number, and feedback the materials with technical problems to the R&D terminal; In the method, By querying the order history BOM accuracy, an order BOM accuracy trend analysis report is generated.
2. A method for automatically analyzing BOM accuracy, characterized in that the method include: In each operation cycle, set the configuration number capture time point; Capture the configuration number in the emergency pull table based on the configuration number capture time point, and calculate the configuration number BOM accuracy corresponding to the configuration number; The specific calculation method is as follows: obtain the order information associated with the configuration number based on the configuration number, obtain the work order BOM lists corresponding to different orders, summarize the BOM list information and remove duplicates as the total BOM quantity A2 of the configuration number, obtain the emergency pull items associated with today's order number of the configuration number, remove duplicates and sum them according to the material number, filter out the number of items B2 where the emergency pull order reason is technical problems, calculate the configuration number BOM accuracy using the formula (1-B2 / A2) × 100%, and store it.
3. The method for realizing automatic analysis of BOM accuracy according to claim 2, characterized in that: Summarize the material details of the order with technical problems by configuration number, and feedback the materials with technical problems to the R&D terminal.
4. The method for realizing automatic analysis of BOM accuracy according to claim 3, characterized in that: In the method, By querying the configuration number BOM accuracy, a configuration number BOM accuracy trend analysis report is generated.
5. The method for realizing automatic analysis of BOM accuracy according to claim 1, characterized in that: The method also includes: The operating cycle is in hours, days, or weeks.
6. A system for automatically analyzing BOM accuracy, characterized in that: include: Storage medium, order number capture setting module and order number calculation module; The order number capture setting module is used to set the order number capture time point in each operation cycle; The order number calculation module grabs the order number in the emergency pull table based on the order number grabbing time point, and calculates the order BOM accuracy corresponding to the order number. Take the number of components in any work order of the order as the total order BOM data volume A1, summarize the order number emergency pull data, and filter out the number of entries B1 where the emergency pull request reason is technical issues. Calculate the order number BOM accuracy using the formula (1-B1 / A1)×100%, and store the calculated order number BOM accuracy in the storage medium.
7. A system for automatically analyzing BOM accuracy, characterized in that: include: Configuration number capture setting module and configuration number calculation module; The configuration number capture setting module is used to set the configuration number capture time point in each operation cycle; The configuration number calculation module grabs the configuration number in the emergency pull table based on the configuration number grabbing time point, and calculates the configuration number BOM accuracy corresponding to the configuration number. Obtain order information associated with the configuration number based on the configuration number, obtain the work order BOM lists corresponding to different orders, summarize the BOM list information and remove duplicates as the total BOM quantity A2 for the configuration number, obtain the emergency pull items associated with today's order number for the configuration number, remove duplicates and sum them based on the material number, filter out the number of items B2 where the emergency pull order reason is technical issues, calculate the configuration number BOM accuracy using the formula (1-B2 / A2) × 100%, and store the calculated configuration number BOM accuracy in the storage medium.