Bill of material generation method, computing device and computer readable storage medium

Abstract

The invention discloses a bill-of-material generation method, an operation control device, computing equipment and a computer readable storage medium, and the method comprises the steps: obtaining an initial bill-of-material table, and carrying out the format check of the initial bill-of-material table; the initial bill of materials at least comprises a material number, a position number and a quantity; performing typesetting operation according to a preset format to obtain a basic bill of materials table; and uploading the basic bill of material table to an enterprise management system, and downloading the target bill of material table from the enterprise management system. After the initial bill of material table is obtained, the basic format is checked firstly, and then the typesetting operation is carried out according to the preset format, so that the basic bill of material table uploaded to the enterprise management system is more uniform and meets the requirements, and the target bill of material table downloaded from the enterprise management system is more consistent with the local BOM. The working period can be effectively shortened, manual operation is reduced, and errors are reduced to the maximum extent while efficiency is improved.

Description

Technical Field

[0001] This invention relates to the field of bill of materials (BOM) technology, and in particular to a method for generating a BOM, an operation control device, a computing device, and a computer-readable storage medium. Background Technology

[0002] A Bill of Materials (BOM) is a technical document describing the composition of a company's products. In the processing capital goods industry, it shows the structural relationships between the final assembly, sub-assemblies, components, parts, and even raw materials, as well as the required quantities. Currently, the original BOM resources exported from design software are generally in a fixed format and sorting, which will not match the final required layout. Generating the final BOM requires many steps, is complex, and requires human judgment, which can easily lead to omissions, misjudgments, and errors in final production. Moreover, it requires multiple modifications, adjustments, and checks, with a standard operating time of several working days, resulting in low generation efficiency. Summary of the Invention

[0003] The purpose of this invention is to at least solve one of the technical problems existing in the prior art, and to provide a method for generating a bill of materials, an operation control device, a computing device and a computer-readable storage medium, which can improve efficiency and reduce the probability of errors.

[0004] In a first aspect, embodiments of the present invention provide a method for generating a bill of materials, comprising the following steps: Obtain an initial bill of materials (BOM) and perform a format check on the initial BOM; the initial BOM shall include at least the material number, location number, and quantity. The basic bill of materials is obtained by formatting the data according to the preset format. Upload the basic bill of materials to the enterprise management system, and download the target bill of materials from the enterprise management system.

[0005] The bill of materials generation method provided by the embodiments of the present invention has at least the following beneficial effects: after obtaining the initial bill of materials table, by first checking the basic format and then performing a layout operation according to the preset format, the format of the basic bill of materials table uploaded to the enterprise management system is more uniform and meets the requirements. Finally, the target bill of materials table downloaded from the enterprise management system is more consistent with the local BOM, which can effectively shorten the work cycle, reduce manual operation, and improve efficiency while minimizing errors.

[0006] The method for generating a bill of materials according to some embodiments of the present invention further includes: Compare the target bill of materials with the basic bill of materials; Based on the results of the format check, the layout operation, and the comparison, a report on the generation of the target bill of materials is obtained.

[0007] According to some embodiments of the present invention, the method for generating a bill of materials further includes, before performing a format check on the initial bill of materials table: Load the file portion of the initial bill of materials table, and locate the header of the initial bill of materials table by finding the material number, the location number, and the reference information; The material number, the location number, and the quantity are mapped to the mapping table.

[0008] According to some embodiments of the present invention, the method for generating a bill of materials includes, in which, the format check includes: It is confirmed that there are no gaps in the material number, the location number, and the quantity; It has been confirmed that there are no duplicates in the material number and the location number; The quantity of the material number is determined to be the same as the quantity of the location number.

[0009] According to some embodiments of the present invention, the method for generating a bill of materials further includes an initial bill of materials table with material placement status; the format check further includes: The material patching status is confirmed to be consistent.

[0010] According to some embodiments of the present invention, the method for generating a bill of materials includes the following typesetting operation: Filter out and delete materials that are not in the "not in order" state from the initial bill of materials, and keep materials that are in the "in order" state; The materials in the "upper part" state are sorted in ascending order according to component type.

[0011] According to some embodiments of the present invention, the method for generating a bill of materials includes a report of the target bill of materials, which includes items for changing materials, items for judging attribute differences, items for changing location numbers, items for deleting materials, and items for adding materials. When the material number in the target bill of materials table is inconsistent with the material number in the basic bill of materials table, the generated report includes the material change entry; When the material number in the target bill of materials table is consistent with that in the basic bill of materials table, the generated report has an attribute difference judgment entry; When the target bill of materials table is inconsistent with the location number set of the basic bill of materials table, the generated report has the location number change entry; When the basic bill of materials table has a location number that does not exist in the target bill of materials table, the generated report includes the material deletion entry; When the target bill of materials table has a location number that does not exist in the base bill of materials table, the generated report contains the newly added entry for the material.

[0012] In a second aspect, embodiments of the present invention provide an operation control device, including at least one control processor and a memory for communicatively connecting to the at least one control processor; the memory stores instructions executable by the at least one control processor, the instructions being executed by the at least one control processor to enable the at least one control processor to perform the bill of materials generation method as described in the first aspect embodiment above.

[0013] The operation control device provided by the embodiments of the present invention has at least the following beneficial effects: after obtaining the initial bill of materials, by first checking the basic format and then performing a layout operation according to the preset format, the format of the basic bill of materials uploaded to the enterprise management system is more uniform and meets the requirements. Finally, the target bill of materials downloaded from the enterprise management system is more consistent with the local BOM, which can effectively shorten the work cycle, reduce manual operation, and improve efficiency while minimizing errors.

[0014] Thirdly, embodiments of the present invention provide a computing device including the operation control device described in the second aspect embodiment.

[0015] The computing device provided by the embodiments of the present invention has at least the following beneficial effects: after obtaining the initial bill of materials, by first checking the basic format and then performing a layout operation according to the preset format, the format of the basic bill of materials uploaded to the enterprise management system is more uniform and meets the requirements. Finally, the target bill of materials downloaded from the enterprise management system is more consistent with the local BOM, which can effectively shorten the work cycle, reduce manual operation, and improve efficiency while minimizing errors.

[0016] Fourthly, embodiments of the present invention provide a computer-readable storage medium storing computer-executable instructions for causing a computer to perform the bill of materials generation method as described in the first aspect embodiment.

[0017] The computer-readable storage medium provided in the embodiments of the present invention has at least the following beneficial effects: after obtaining the initial bill of materials, by first checking the basic format and then performing a layout operation according to the preset format, the format of the basic bill of materials uploaded to the enterprise management system is more uniform and meets the requirements. Finally, the target bill of materials downloaded from the enterprise management system is more consistent with the local BOM, which can effectively shorten the work cycle, reduce manual operation, and improve efficiency while minimizing errors.

[0018] Other features and advantages of the invention will be set forth in the description which follows, and will be apparent in part from the description, or may be learned by practicing the invention. The objects and other advantages of the invention may be realized and obtained by means of the structures particularly pointed out in the description, claims, and drawings. Attached Figure Description

[0019] The accompanying drawings are provided to further understand the technical solutions of the present invention and constitute a part of the specification. They are used together with the embodiments of the present invention to explain the technical solutions of the present invention, and do not constitute a limitation on the technical solutions of the present invention.

[0020] The present invention will be further described below with reference to the accompanying drawings and embodiments; Figure 1 This is a flowchart of a method for generating a bill of materials according to an embodiment of the present invention; Figure 2 This is a flowchart of another method for generating a bill of materials provided in an embodiment of the present invention; Figure 3 This is a schematic diagram of the operation control device provided in an embodiment of the present invention. Detailed Implementation

[0021] This section will describe in detail specific embodiments of the present invention. Preferred embodiments of the present invention are shown in the accompanying drawings. The purpose of the drawings is to supplement the textual description with graphics, so that people can intuitively and vividly understand each technical feature and overall technical solution of the present invention, but they should not be construed as limiting the scope of protection of the present invention.

[0022] In the description of the embodiments of the present invention, "several" means one or more, "multiple" means two or more, "greater than," "less than," "exceeding," etc. are understood to exclude the number itself, while "above," "below," "within," etc. are understood to include the number itself. "At least one" refers to one or more, and "at least one of the following" and similar expressions refer to any combination of these items, including any combination of single or multiple items. If "first," "second," etc., are used in the description, they are only for the purpose of distinguishing technical features and should not be construed as indicating or implying relative importance or implicitly indicating the number of indicated technical features or the order of the indicated technical features.

[0023] It should be noted that the terms "set," "install," and "connect" in the embodiments of this invention should be interpreted broadly. Those skilled in the art can reasonably determine the specific meaning of the above terms in the embodiments of this invention based on the specific content of the technical solution. For example, the term "connect" can be a mechanical connection, an electrical connection, or a connection that allows for mutual communication; it can be a direct connection or an indirect connection through an intermediate medium. The terms "upload" and "download" include, but are not limited to, data exchange through API interface calls, Web services, File Transfer Protocol (FTP), Secure File Transfer Protocol (SFTP), database connections, etc.

[0024] It should be noted that the technical features involved in the various embodiments of the present invention described below can be combined with each other as long as they do not conflict with each other.

[0025] A Bill of Materials (BOM) is a technical document describing the composition of a company's products. In the manufacturing industry (especially in Electronic Manufacturing Services (EMS), Original Design Manufacturers (ODM), and Original Equipment Manufacturers (OEM), the BOM not only shows the structural relationships and required quantities between the final assembly, sub-assemblies, components, parts, and raw materials, but also contains key information such as material codes, locations, surface mount status, suppliers, alternative materials, and costs. It is the core data hub connecting product design, process planning, manufacturing, procurement and logistics, and cost accounting; its accuracy directly affects the smooth operation of production, effective cost control, and stable product quality.

[0026] Currently, the raw BOM resources required for production are typically exported from electronic design automation software (such as Altium Designer, Cadence OrCAD, Mentor PADS, etc.) or product lifecycle management (PLM) systems. These raw BOM files (such as CSV, Excel, and TXT formats) usually have fixed formats and sorting rules by default, which differ significantly from the BOM layout, field specifications, and data logic required by final systems such as Manufacturing Execution Systems (MES) and Enterprise Resource Planning (ERP).

[0027] Generating a final BOM that meets production requirements traditionally requires the following tedious manual steps: Data extraction and cleaning: Manually filter and copy the required columns (such as material number, location number, quantity, and patch status) from the exported file; Format checking and error correction: Manually check key fields line by line for issues such as missing, duplicate, mismatched quantities, inconsistent status, etc. This process is very prone to omissions or misjudgments due to fatigue or negligence. Data mapping and transformation: Manually adjust field order, rename table headers, and transform data formats (e.g., convert "Yes / No" to "Y / N") according to the requirements of the target system. Logic processing and layout: Manually filter out and delete materials that do not need to be mounted (in the unmounted state); sort the materials according to component type (such as resistor, capacitor, IC) or assembly order; System Upload and Verification: Upload the pre-compiled BOM to the ERP / MES system. The system typically performs internal verification and may return a "target BOM" that has been processed (e.g., encoding conversion, default value filling, internal association). Manual verification and confirmation: The target BOM returned by the system is manually compared item by item with the locally compiled basic BOM to check for discrepancies such as material changes, additions, deletions, and attribute modifications. This step requires extremely high accuracy but is tedious and time-consuming.

[0028] The entire process is complex and involves numerous steps, heavily relying on the individual experience and sense of responsibility of engineers. Standard operating times often take several working days, resulting in low efficiency and becoming a critical bottleneck and error risk point in the production data flow. A single BOM error can lead to serious consequences such as production line downtime, material mismatch, and batch scrap.

[0029] Based on this, embodiments of the present invention provide a method for generating a bill of materials (BOM), an operation control device, a computing device, and a computer-readable storage medium, which can improve efficiency and reduce the probability of errors. The core of the present invention lies in constructing an automated, streamlined, and intelligent BOM processing engine, aiming to transform the aforementioned multi-step, high-risk manual operations into a standard process automatically executed by a computer program. Through automated format checking, intelligent mapping, rule-based layout, and inter-system data comparison, the present invention can significantly improve BOM processing efficiency, shortening the generation cycle from several days to several hours or even minutes; simultaneously, through rigorous procedural checks and comparisons, it minimizes human intervention, thereby significantly reducing the probability of errors caused by negligence, fatigue, or misjudgment, ensuring the accuracy and reliability of production data.

[0030] The embodiments of the present invention will be further described below with reference to the accompanying drawings.

[0031] Figure 1 This is a flowchart of a method for generating a bill of materials according to an embodiment of the present invention. (Refer to...) Figure 1 The first aspect of the present invention provides a method for generating a bill of materials (BOM). This method can be implemented by a standalone BOM processing software, a pre-processing module of an ERP / MES system, or a cloud service. The method for generating the BOM includes, but is not limited to, steps S110 to S130: Step S110: Obtain the initial bill of materials (BOM) and perform a format check on it. The initial BOM includes at least material number, location number, and quantity. Specifically, this step mainly involves obtaining and checking the format of the initial BOM, which is typically a raw file exported from design software. It includes at least three core fields: material number (e.g., component reference designator, R1, C2, U3), location number (e.g., PCB coordinates or assembly station number), and quantity. The acquisition method can be file upload, reading from a specified directory, or pulling from the PLM system via an interface. Subsequently, the system performs an automated format check on the obtained initial BOM. The purpose of this step is to detect and report basic errors in the raw data early on, preventing erroneous data from flowing into subsequent stages. The check rules are predefined.

[0032] Step S120: Perform layout operations according to a preset format to obtain a basic bill of materials table. Specifically, this step mainly implements standardized layout operations; after passing the format check, the system performs layout operations on the data according to a set of preset format rules to generate a basic bill of materials table; this basic bill of materials table is a cleaned, organized, and standardized version, and its format meets or is close to the import requirements of the target enterprise management system. The layout operation is a collection of data conversion and organization steps.

[0033] Step S130: Upload the basic bill of materials (BOM) to the enterprise management system and download the target BOM from the enterprise management system. Specifically, this step mainly realizes system interaction and obtains the target BOM. The generated basic BOM is automatically uploaded to the enterprise management system (such as ERP or MES). The upload process is completed through predefined interfaces between systems (such as WebAPI or database stored procedures) without manual intervention. After receiving the basic BOM, the enterprise management system will perform its internal logic processing such as material code verification, inventory association, and process route matching, and finally generate a target BOM that is officially effective within its system. Subsequently, this step automatically downloads the target BOM from the enterprise management system for local archiving, verification, or to drive subsequent downstream processes such as SMT programming and material kitting checks.

[0034] According to the bill of materials generation method provided in the embodiments of the present invention, after obtaining the initial bill of materials table, the basic format is checked first, and then the layout operation is performed according to the preset format, so that the format of the basic bill of materials table uploaded to the enterprise management system is more uniform and meets the requirements. Finally, the target bill of materials table downloaded from the enterprise management system is more consistent with the local BOM, which can effectively shorten the work cycle, reduce manual operation, and improve efficiency while minimizing errors.

[0035] It should be noted that this embodiment of the invention constructs an automated pipeline from the original BOM to the production-ready BOM. Through programmed format checks, "basic errors" at the data level are intercepted in advance; standardized formatting operations ensure the standardization and consistency of data input into the enterprise management system, reducing the risk of system errors or processing anomalies due to format issues; finally, automated system upload and download streamlines the data flow. The entire process integrates previously discrete operations relying on manual judgment into a coherent, reusable automated workflow, effectively shortening the BOM processing cycle and reducing the number of manual data manipulation steps, thereby improving efficiency while minimizing the possibility of human error.

[0036] Figure 2 This is a flowchart of another method for generating a bill of materials provided in an embodiment of the present invention. (Refer to...) Figure 2 In some embodiments of the present invention, the method for generating a bill of materials further includes steps S140 and S150: Step S140: Compare the target bill of materials (BOM) with the basic BOM. Specifically, this step mainly involves comparing differences. The system automatically compares the target BOM downloaded from the enterprise management system with the basic BOM before it was uploaded locally. This is a crucial verification step designed to identify changes that may be caused by internal processing within the enterprise management system (such as automatic material replacement, code conversion, default value application, etc.), ensuring that engineers have a clear understanding of the final production basis.

[0037] Step S150: Based on the results of the format check, the layout operation, and the comparison, a report on the target bill of materials is generated. Specifically, this step mainly generates the report. The system automatically generates a structured target bill of materials generation report by combining the results of the format check (e.g., the number of gaps and duplicates found), the layout operation log (e.g., the number of unused materials deleted), and the difference comparison results. This report is an auditable record of the entire process, which can be checked, archived, or used as a basis for problem tracing.

[0038] In this embodiment, a target bill of materials report is generated based on the results of format checks, layout operations, and comparisons. This allows users to check, record, or mark the results, and conveniently view the outcome. It is understood that this embodiment primarily implements the complete process and report generation. Figure 1 Based on the basic process, steps S140 and S150 are further included to form a complete process that includes closed-loop verification.

[0039] In some embodiments of the present invention, the method for generating a bill of materials further includes, before performing a format check on the initial bill of materials table: Load the file portion of the initial bill of materials table, and locate the header of the initial bill of materials table by finding the material number, the location number, and the reference information; The material number, the location number, and the quantity are mapped to the mapping table.

[0040] In this embodiment, the imported initial bill of materials (BOM) table is mapped, i.e., a mapping control is implemented, which effectively improves compatibility. For example, the mapping control can support both manual selection and automatic identification and matching. It is understood that this embodiment primarily achieves intelligent mapping and high compatibility processing. In the header positioning step, the system loads the initial BOM file and intelligently locates and identifies the row containing the header of the original file by searching for reference information (which can be a predefined list of keywords) for key fields such as "material number" and "location number." This solves the problem of inconsistent header positions caused by different design software or user export habits. In the field mapping step, based on the header identification, the system establishes a mapping relationship between the columns in the original file and the logical fields (material number, location number, quantity, patch status, etc.) required for internal processing. This mapping process can be completed through automatic identification and matching (based on column name semantic analysis). When the confidence level of automatic identification is insufficient, manual selection by the user can be supported for calibration. The mapping relationship can be saved as a template for reuse when processing files from the same source. This design greatly improves the system's compatibility with original BOM files from different sources and in different formats.

[0041] In the bill of materials generation method provided in some embodiments of the present invention, the format check includes: It is confirmed that there are no gaps in the material number, the location number, and the quantity; It has been confirmed that there are no duplicates in the material number and the location number; The quantity of the material number is determined to be the same as the quantity of the location number.

[0042] In some embodiments of the present invention, the method for generating a bill of materials includes an initial bill of materials table further including material patch status; the format check further includes: The material patching status is confirmed to be consistent.

[0043] In this embodiment, the format check can be summarized as "three missing, two duplicates, one identical, and one aligned." Specifically, "three missing" means ensuring that each row of data in the three core fields—"Material Number," "Location Number," and "Quantity"—has no missing values ​​(NotNull). Any missing value will be recorded as an error. "Two duplicates" means ensuring that there are no duplicates in the "Material Number" and "Location Number" columns. Duplicate Material Numbers may indicate a design error; duplicate Location Numbers mean a physical space conflict and must be detected. "One identical" means ensuring that the total number of entries for "Material Number" is the same as the total number of entries for "Location Number," which is a basic requirement for data integrity. "One aligned" means that when the initial bill of materials table contains the "Material Placement Status" field, the format check must also ensure that all Location Numbers associated with the same Material Number have the same "Material Placement Status." For example, there cannot be contradictory situations where Material R1 is "Put on" at Location A1 and "Not Put on" at Location A2 (unless there are special process specifications). This ensures that the production instructions are clear and unambiguous.

[0044] It should also be noted that in some embodiments, duplicate material numbers can be exempted. Specifically, if the same material number exists in both "installed" and "not installed" states in the exported data, duplication is allowed. Specifically, the exemption for duplicate "material numbers" is allowed in specific scenarios. For example, the same material number (such as a resistor with a specific value) may appear multiple times in the BOM, corresponding to multiple different location numbers, which is generally allowed. In more complex cases, the same material number may be "installed" in some locations and "not installed" (NC) in others. The system needs to combine this with the "mount status" field for comprehensive judgment. Such duplication with clear business logic support can be exempted by the rules.

[0045] According to some embodiments of the present invention, the method for generating a bill of materials includes the following typesetting operation: Filter out and delete materials that are not in the "not in order" state from the initial bill of materials, and keep materials that are in the "in order" state; The materials in the "upper part" state are sorted in ascending order according to component type.

[0046] In this embodiment, the components are sorted in ascending order according to their internal position numbers, and PCBA information is added to complete the modification records, thereby completing the layout operation. In summary, the layout operation includes filtering and sorting.

[0047] It's important to further explain that the layout process is a crucial step in converting raw data into a standard format. In the filtering step, based on the "Material Placement Status" field, all material records in the "Not Connected (NC, DNP)" state are automatically filtered from the initial Bill of Materials (BOM) and removed from the list, retaining only the materials that need to be actually placed (installed). This simplifies the production BOM. In the sorting step, the materials in the installed state after filtering are grouped by component type (e.g., all resistors first, then all capacitors, then ICs, etc.). Within each group, they are sorted in ascending order by "Location Number" (e.g., R1, R2, R3… C1, C2…). This sorting method aligns with the reading and operational habits on the production floor, facilitating SMT equipment programming and material inventory management. Furthermore, the layout process can automatically add PCBA information (e.g., board number, version), operator information, and timestamps, improving modification records.

[0048] In the bill of materials generation method provided in some embodiments of the present invention, the generation report of the target bill of materials table includes material change entries, attribute difference judgment entries, location number change entries, material deletion entries, and material addition entries; When the material number in the target bill of materials table is inconsistent with the material number in the basic bill of materials table, the generated report includes the material change entry; When the material number in the target bill of materials table is consistent with that in the basic bill of materials table, the generated report has an attribute difference judgment entry; When the target bill of materials table is inconsistent with the location number set of the basic bill of materials table, the generated report has the location number change entry; When the basic bill of materials table has a location number that does not exist in the target bill of materials table, the generated report includes the material deletion entry; When the target bill of materials table has a location number that does not exist in the base bill of materials table, the generated report contains the newly added entry for the material.

[0049] In this embodiment, items such as material change entries, attribute difference judgment entries, location number change entries, material deletion entries, and material addition entries can be displayed in the UI on the function page corresponding to the format check results or the function page corresponding to the comparison results. The display controls allow for convenient viewing of the results. It is understood that the report generated after the difference comparison clearly displays all changes through structured entries, such as in the software's UI using tables, highlighting, or tree structures. For material change entries, this entry is reported when the material number corresponding to the same location number in the target BOM and the base BOM is inconsistent. This usually indicates that the enterprise management system has automatically replaced the material according to the substitute material rule or engineering change (ECN). For attribute difference judgment entries, this entry is reported when the material number is the same, but other attributes (such as description, specifications, supplier code) are different, prompting users to pay attention to attribute changes that may affect procurement or processes. For location number change entries, this entry is reported when the set of location numbers associated with a material in the target BOM and the base BOM is inconsistent (e.g., from [A1, A2] to [A1, A3]), reflecting a design change. For material deletion entries, location numbers that exist in the base BOM but cannot be found in the target BOM are reported as deleted, possibly because the enterprise management system has removed the material point according to inventory or process rules. For material addition entries, location numbers that exist in the target BOM but do not exist in the base BOM are reported as added, possibly from automatic system supplementation or association. The presentation of these items allows engineers to quickly and accurately grasp the key changes that occur in the BOM after system processing without having to manually compare each line, and to make decisions on whether to accept it or whether further intervention is needed.

[0050] Additionally, refer to Figure 3 A second aspect of the present invention provides an operation control device 300, including at least one control processor 310 and a memory 320 communicatively connected to the at least one control processor 310; the memory 320 stores instructions executable by the at least one control processor 310, the instructions being executed by the at least one control processor 310 to enable the at least one control processor 310 to perform the bill of materials generation method as described in the first aspect of the present invention, for example, performing... Figure 1 Method steps S110 to S130, or execution Figure 2 The method steps S110 to S150.

[0051] According to the operation control device 300 provided in the embodiment of the present invention, after obtaining the initial bill of materials, it first checks the basic format and then performs a layout operation according to the preset format, so that the format of the basic bill of materials uploaded to the enterprise management system is more uniform and meets the requirements. Finally, the target bill of materials downloaded from the enterprise management system is more consistent with the local BOM, which can effectively shorten the work cycle, reduce manual operation, and improve efficiency while minimizing errors.

[0052] In addition, a third aspect of the present invention provides a computing device including the operation control device 300 described in the second aspect embodiment.

[0053] According to the computing device provided in the embodiments of the present invention, after obtaining the initial bill of materials (BOM), the basic format is checked first, and then the formatting operation is performed according to the preset format. This makes the format of the basic BOM uploaded to the enterprise management system more uniform and meets the requirements. Finally, the target BOM downloaded from the enterprise management system is more consistent with the local BOM. This can effectively shorten the work cycle, reduce manual operation, and improve efficiency while minimizing errors.

[0054] Furthermore, a fourth aspect of the present invention provides a computer-readable storage medium storing computer-executable instructions for causing a computer to perform a bill of materials generation method as described in the first aspect embodiment, for example, executing... Figure 1 Method steps S110 to S130, or execution Figure 2 The method steps S110 to S150.

[0055] According to the computer-readable storage medium provided in the embodiments of the present invention, after obtaining the initial bill of materials (BOM), the basic format is checked first, and then the formatting operation is performed according to the preset format. This makes the format of the basic BOM uploaded to the enterprise management system more uniform and meets the requirements. Finally, the target BOM downloaded from the enterprise management system is more consistent with the local BOM. This can effectively shorten the work cycle, reduce manual operation, and improve efficiency while minimizing errors.

[0056] It will be understood by those skilled in the art that all or some of the steps and systems in the methods disclosed above can be implemented as software, firmware, hardware, and suitable combinations thereof. Some or all of the physical components can be implemented as software executed by a processor, such as a central processing unit, digital signal processor, or microprocessor, or as hardware, or as an integrated circuit, such as an application-specific integrated circuit. Such software can be distributed on a computer-readable medium, which may include computer storage media or non-transitory media and communication media or transient media. As is known to those skilled in the art, the term computer storage media includes volatile and non-volatile, removable and non-removable media implemented in any method or technology for storing information such as computer-readable instructions, data structures, program modules, or other data. Computer storage media includes, but is not limited to, RAM, ROM, EEPROM, flash memory or other memory technologies, CD-ROM, digital versatile disc DVD or other optical disc storage, magnetic cartridges, magnetic tape, disk storage or other magnetic storage devices, or any other medium that can be used to store desired information and is accessible to a computer. Furthermore, as is known to those skilled in the art, communication media typically contain computer-readable instructions, data structures, program modules, or other data in modulated data signals such as carrier waves or other transmission mechanisms, and may include any information delivery medium.

[0057] The embodiments of the present invention have been described in detail above with reference to the accompanying drawings. However, the present invention is not limited to the above embodiments. Within the scope of knowledge possessed by those skilled in the art, various changes can be made without departing from the spirit of the present invention.

Claims

1. A method for generating a bill of materials, characterized in that, include: Obtain the initial bill of materials and perform a format check on the initial bill of materials; The initial bill of materials shall include at least the material number, location number, and quantity; The basic bill of materials is obtained by formatting the data according to the preset format. Upload the basic bill of materials to the enterprise management system, and download the target bill of materials from the enterprise management system.

2. The method for generating a bill of materials according to claim 1, characterized in that, Also includes: Compare the target bill of materials with the basic bill of materials; Based on the results of the format check, the layout operation, and the comparison, a report on the generation of the target bill of materials is obtained.

3. The method for generating a bill of materials according to claim 1, characterized in that, Before performing a format check on the initial bill of materials, the method further includes: Load the file portion of the initial bill of materials table, and locate the header of the initial bill of materials table by finding the material number, the location number, and the reference information; The material number, the location number, and the quantity are mapped to the mapping table.

4. The method for generating a bill of materials according to claim 1, characterized in that, The format check includes: It is confirmed that there are no gaps in the material number, the location number, and the quantity; It has been confirmed that there are no duplicates in the material number and the location number; The quantity of the material number is determined to be the same as the quantity of the location number.

5. The method for generating a bill of materials according to claim 4, characterized in that, The initial bill of materials also includes the material patch status; the format check also includes: The material patching status is confirmed to be consistent.

6. The method for generating a bill of materials according to claim 1, characterized in that, The typesetting operations include: Filter out and delete materials that are not in the "not in order" state from the initial bill of materials, and keep materials that are in the "in order" state; The materials in the "upper part" state are sorted in ascending order according to component type.

7. The method for generating a bill of materials according to claim 2, characterized in that, The generated report of the target bill of materials includes material change entries, attribute difference judgment entries, location number change entries, material deletion entries, and material addition entries; When the material number in the target bill of materials table is inconsistent with the material number in the basic bill of materials table, the generated report includes the material change entry; When the material number in the target bill of materials table is consistent with that in the basic bill of materials table, the generated report has an attribute difference judgment entry; When the target bill of materials table is inconsistent with the location number set of the basic bill of materials table, the generated report has the location number change entry; When the basic bill of materials table has a location number that does not exist in the target bill of materials table, the generated report includes the material deletion entry; When the target bill of materials table has a location number that does not exist in the base bill of materials table, the generated report contains the newly added entry for the material.

8. An operation control device, characterized in that, It includes at least one control processor and a memory for communicatively connecting to the at least one control processor; the memory stores instructions executable by the at least one control processor to enable the at least one control processor to perform the bill of materials generation method as described in any one of claims 1 to 7.

9. A computing device, characterized in that, Includes the operation control device as described in claim 8.

10. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores computer-executable instructions for causing a computer to perform the bill of materials generation method as described in any one of claims 1 to 7.

Images