Complete-set material management and control method and system and computer equipment

By establishing a bidirectional association index and dynamic management between complete sets and sub-items, the problem of lack of dynamic maintenance of association relationships in complete set material management is solved, the linkage between procurement and production and the precise control of inventory are achieved, and the efficiency of material management and the stability of production are improved.

CN120707253AActive Publication Date: 2025-09-26SHANDONG INSPUR GENESOFT INFORMATION TECH CO LTD

Patent Information

Application Number
CN202511194673.X
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2025-08-26
Publication Date
2025-09-26
Estimated Expiration
2045-08-26

AI Technical Summary

Technical Problem

In the existing management of complete sets of materials, there is a lack of dynamic maintenance of the relationship between complete sets and sub-items, the purchase orders are not closely connected with production needs, and there is a lack of real-time verification of the matching of inventory information and issuance needs, resulting in excessive applications or inventory backlogs, which makes it difficult to meet the refined needs of modern production.

Method used

By establishing a bidirectional association index between complete sets and sub-items, generating arrival traceability codes, verifying inventory dynamic data in real time, binding purchase orders with production nodes, calculating material allocation weights and storage location optimization, and real-time monitoring of loss warnings, full-process traceability and dynamic adjustment can be achieved.

Benefits of technology

Ensure the reasonable matching relationship between complete sets and sub-items, realize the linkage between procurement plan and production progress, avoid over-application or inventory backlog, improve inventory utilization efficiency and issuance accuracy, optimize cost control, and ensure production stability and material safety.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN120707253A_ABST
    Figure CN120707253A_ABST
Patent Text Reader

Abstract

The invention belongs to the technical field of data processing. The invention provides a complete-set material management and control method and system and computer equipment, and the method comprises the steps: building a bidirectional correlation index of a suite and subitems, and carrying out the correlation display of the to-be-purchased suite and the subitems according to the bidirectional correlation index when a suite purchasing application is received; according to received purchase order arrival information, generating arrival traceability codes of arrival subitems; according to a received suite receiving application, determining subitems of the suite according to the bidirectional association index, and according to traceability codes of the determined subitems and an approved receiving application form, determining a to-be-delivered suite and updating a suite inventory; and when a sub-item receiving application is received, according to the arrival traceability code of the sub-item and the approved receiving application form, determining the sub-item to be delivered and updating the sub-item inventory at the same time, and according to the bidirectional association index and the updated sub-item inventory, updating the kit inventory, thereby improving the inventory utilization efficiency and the receiving accuracy.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the field of data processing technology, and in particular to a complete set of material management and control method, system and computer equipment. Background Art

[0002] The statements in this section merely provide background art related to the present invention and do not necessarily constitute prior art.

[0003] In the equipment manufacturing industry, especially in the shipbuilding sector, the management of complete sets of materials is a core component of the supply chain. These materials include mechanical equipment, electrical components, pipe fittings, and other types. Not only are they numerous and complex in specifications, but they also involve multiple links such as bulk procurement, decentralized use, and long-term storage, making management extremely complex. With the continuous development of industry technology and the increasingly accelerated pace of production, higher requirements are placed on the tracking accuracy, timely supply, and reasonable inventory of complete sets of materials. Traditional management methods rely heavily on manual record-keeping and operations. When dealing with large-scale, multi-batch flow of complete sets of materials, they gradually expose problems such as low efficiency and information lag, making it difficult to meet the refined material management needs of modern production.

[0004] However, the current management and control scheme for complete set materials has the following problems: there is a lack of a dynamic maintenance mechanism for the relationship between complete sets and sub-items, which makes it difficult to synchronously ensure the compatibility of complete sets when sub-item information changes; the connection between purchase orders and production needs is not close enough, and the procurement rhythm cannot be accurately adjusted according to production nodes; the matching of inventory information and issuance needs lacks real-time verification, which makes it easy to over-apply or have inventory backlogs. Summary of the Invention

[0005] In order to address the deficiencies of the prior art, the present invention provides a complete set of material management and control methods, systems, and computer equipment, which effectively avoid overapplication or inventory backlogs, improve inventory utilization efficiency and accuracy, thereby ensuring the stability of production progress and optimizing cost control.

[0006] In order to achieve the above object, the present invention adopts the following technical solutions: In a first aspect, the present invention provides a method for managing and controlling a complete set of materials.

[0007] A complete set of material management and control method includes the following processes: Create a bidirectional association index between kits and sub-items. When a kit purchase requisition is received, the kit to be purchased and its included sub-items are displayed based on the bidirectional association index. Generate the arrival traceability code of the sub-item according to the received purchase order arrival information; Based on the received kit requisition, the sub-items of the kit are determined based on the bidirectional association index. Based on the traceability code of the determined sub-item and the approved requisition form, the kit to be shipped is determined and the kit inventory is updated; When a sub-item requisition is received, the sub-item to be shipped is determined based on the sub-item's arrival traceability code and the approved requisition form, and the sub-item inventory is updated simultaneously. The kit inventory is also updated based on the bidirectional association index and the updated sub-item inventory. When the sub-item information is edited, the association check is triggered. If the quantity ratio between the sub-items exceeds the preset ratio threshold, a prompt message is issued to remind the user to adjust the quantity of related sub-items.

[0008] In an implementation of the first aspect of the present invention, when establishing a bidirectional association index between a kit and sub-items, the weight of the sub-items in the kit is recorded to verify the matching degree between the number of sub-items and the overall requirement of the kit.

[0009] In an implementation method of the first aspect of the present invention, when a purchase order is bound to a production node, the production node time window period in the production planning module is retrieved, and the delivery date is set to a preset number of days before the start date of the window period, and the time for material warehousing inspection and allocation is reserved by the preset number of days; when verifying the sub-item information of the requisition application, the dynamic value of the available inventory of the sub-item is displayed, and the dynamic value of the available inventory is the current inventory minus the application quantity that has been reviewed but not shipped out.

[0010] In one implementation of the first aspect of the present invention, when handling the shipment procedure, if there is a discrepancy between the actual shipment quantity and the requested quantity, a discrepancy association document is generated, marking the unshipped portion as pending replenishment and linking it to the corresponding purchase order; When obtaining sub-item information, the industry specification database is called to compare the deviation between the input value and the standard value, and a standardized mapping code is generated for the sub-item of non-standard specifications, which is used to realize the associated retrieval of non-standard sub-items and standard sub-items during procurement and issuance inquiries.

[0011] In one implementation of the first aspect of the present invention, the first The actual required quantity of each kit item at each production stage , the average demand quantity during the entire production cycle , standard deviation of demand quantity , in the Demand urgency score during the production phase , No. Total duration of the production phase , in the Inventory quantity at the beginning of the production phase and maximum inventory capacity ; According to The actual required quantity of each kit item at each production stage , the average demand quantity during the entire production cycle , standard deviation of demand quantity , calculate the The kit item is in Production demand fluctuation coefficient in the production stage ; According to the production demand fluctuation coefficient , Demand urgency score , No. Total duration of the production phase , in the Inventory quantity at the beginning of the production phase and maximum inventory capacity , get the The kit item is in Allocation weight of production stage , according to the distribution weight The order of allocation of each sub-item in each production stage is sorted according to the size of the sub-item, and the sub-item with higher weight is allocated materials first.

[0012] In one implementation of the first aspect of the present invention, the capacity of each storage location, the current space utilization rate, the volume of each kit sub-item, the access frequency, and the access cost coefficient of each sub-item at different storage locations are collected; Calculate the storage location weight based on the current space utilization, the volume of each component in the kit, and the access cost coefficient of each component in different storage locations; Based on the storage location weights, the volume of each kit sub-item, the capacity of each storage location, and the inventory layout optimization objective function, a linear programming algorithm is used to solve and determine the optimal storage location for each sub-item.

[0013] In one implementation of the first aspect of the present invention, according to The kit item is Storage time loss factor at the moment, The storage environment humidity at all times The loss factor of the kit sub-item, The kit item is The loss factor of the number of times of transportation at the moment and the The kit item is The ambient temperature loss factor at the moment is used to obtain the material loss warning index ; Set a loss warning threshold for each kit sub-item based on historical loss data and the importance of the sub-item ,when , the system issues a loss warning.

[0014] As a further limitation of the first aspect of the present invention, the material loss warning index ,include: ; in, Indicates the The kit item is Material loss warning index at all times; 、 、 、 is the weight coefficient, and ; For the The kit item is Storage time loss factor at the moment; for The storage environment humidity at all times The loss factor of the kit item; For the The kit item is Loss factor of number of transports at a time; For the The kit item is Ambient temperature loss factor at the moment.

[0015] In a second aspect, the present invention provides a complete material management and control system.

[0016] A complete set of material management and control system, including: The association relationship determination unit is configured to: establish a bidirectional association index between the kit and the sub-items, and when a kit purchase requisition is received, associate and display the kit to be purchased and the sub-items contained therein according to the bidirectional association index; The sub-item traceability code generating unit is configured to: generate an arrival traceability code for the sub-item that has arrived according to the received purchase order arrival information; The kit requisition unit is configured to: based on a received kit requisition application, determine the sub-items of the kit using a bidirectional association index; and based on the traceability code of the determined sub-item and the approved requisition form, determine the kit to be shipped and update the kit inventory; The sub-item requisition unit is configured to: upon receiving a sub-item requisition application, determine the sub-item to be shipped based on the sub-item's arrival traceability code and the approved requisition form, update the sub-item inventory, and update the kit inventory based on the bidirectional association index and the updated sub-item inventory; The sub-item editing prompt unit is configured to: trigger association verification when sub-item information is edited, and if the quantity ratio between sub-items exceeds a preset ratio threshold, issue a prompt message to remind the user to adjust the quantity of related sub-items.

[0017] In a third aspect, the present invention provides a computer device comprising: a processor and a computer-readable storage medium; a processor adapted to execute a computer program; A computer-readable storage medium, wherein a computer program is stored in the computer-readable storage medium, and when the computer program is executed by the processor, the method for controlling and managing complete sets of materials as described in the first aspect of the present invention is implemented.

[0018] Compared with the prior art, the present invention has the following beneficial effects: 1. The present invention solves the problems in the prior art of lack of dynamic maintenance of the association relationship between complete sets and sub-items and difficulty in ensuring the compatibility of complete sets when sub-item information changes by establishing a bidirectional association index between complete sets and sub-items and supporting dynamic maintenance. It realizes association verification and proportion balance when sub-item information is adjusted, ensuring that the sub-items of the complete set always maintain a reasonable matching relationship. By binding purchase orders with production nodes, it solves the problem of loose connection between purchase orders and production needs and inability to accurately control the procurement rhythm, so that the procurement plan and production schedule are linked to ensure the matching of material supply and production nodes. By generating arrival traceability codes and running through the entire process of collection and delivery, it solves the problem of incomplete material traceability chain throughout the entire process, realizes full traceability of sub-items from arrival to delivery, and facilitates rapid positioning of sub-item sources and flow tracks. By performing real-time verification of sub-item information of collection applications and associating it with inventory dynamic data, it solves the problem of lack of real-time verification of matching between inventory information and collection needs, effectively avoids excessive applications or inventory backlogs, improves inventory utilization efficiency and collection accuracy, and thus ensures the stability of production progress and optimizes cost control.

[0019] 2. When establishing a bidirectional association index between the complete set and the sub-items, the present invention also records the proportion weight of the sub-items in the complete set. The proportion weight is used to quickly verify the matching degree of the sub-item quantity and the overall demand of the complete set in the subsequent procurement, arrival and collection links, ensuring the proportional coordination of the sub-item supply and the assembly demand of the complete set; when editing the sub-item information to trigger the association verification, if the quantity ratio between the sub-items exceeds the preset ratio threshold, a prompt message is issued. The prompt message is used to remind the user to adjust the quantity of related sub-items in time to maintain the compatibility between the sub-items of the complete set, so as to avoid the inability to fully assemble the complete set due to the imbalance of the quantity of a certain sub-item.

[0020] 3. When the present invention binds a purchase order to a production node, it retrieves the production node time window in the production plan module, and sets the delivery date by default to a preset number of days before the start date of the window period. The preset number of days is used to reserve time for material warehousing inspection and allocation to ensure that materials can be supplied in time when the production node is started; when the purchase order is reviewed and processed, a production matching report is attached. The report includes the overlapping time between the purchase order delivery period and the production node, and the compatibility verification results of the kit sub-items and the production process. The report provides a decision-making basis for the reviewer to determine whether the purchase order meets the actual production needs and reduce unreasonable purchases.

[0021] 4. When verifying the sub-item information of the application for requisition, the present invention displays the dynamic value of the available inventory of the sub-item. The dynamic value of the available inventory is the current inventory minus the application quantity that has been reviewed but not issued. The dynamic value is used to assist the issuing department to reasonably determine the application quantity to avoid excessive application or inventory backlog due to information lag; when handling the outbound procedure, if the actual outbound quantity is different from the application quantity, a difference association form is generated, and the unissued part is marked as to be replenished, and is associated with the corresponding purchase order. Through the difference association form, the procurement link is promoted to give priority to filling the missing sub-items to ensure the continuity of production demand; when obtaining sub-item information, the industry specification database is called to compare the deviation between the input value and the standard value, and a standardized mapping code is generated for the sub-item of non-standard specifications. The mapping code is used to realize the associated retrieval of non-standard sub-items and standard sub-items during procurement and requisition inquiries, thereby improving the accuracy and efficiency of information query.

[0022] 5. When the present invention reviews and processes purchase orders, it automatically determines the approval level based on the order amount and the importance of the kit, and pushes the corresponding related data to the approver interface. Through hierarchical approval and accurate data push, the efficiency of purchase order review is improved, and the approval quality of important procurement links is ensured. When generating an arrival note based on the arrival information of sub-items, if the arrival quantity of the sub-items exceeds the preset proportion of the unfinished requisition quantity, an excess arrival prompt will be marked on the arrival note and pushed to the inventory management module. This prompt is used to guide the inventory management department to adjust the storage strategy and give priority to allocating the excess part to the long-term storage area, thereby improving the utilization rate of storage space.

[0023] 6. The present invention addresses the significant fluctuations in demand for complete sets of sub-items during different production stages in the equipment manufacturing industry. By calculating the production demand fluctuation coefficient and the material allocation weight, it achieves dynamic adjustment of material allocation, accurately identifies the demand priority for each sub-item at different production stages, and gives priority to material allocation for sub-items with higher weights, thus solving the problem of uneven material distribution caused by the inability of traditional allocation methods to flexibly respond to production changes. In scenarios such as shipbuilding, where production cycles are long and stages are clearly defined, it ensures that various sub-item materials such as steel plates and mechanical parts are reasonably allocated on demand during different stages such as hull construction and equipment installation, reducing resource waste caused by excess materials in one stage and shortages in another, ensuring the continuity of the production process, and improving material utilization efficiency.

[0024] 7. To address the issues of long storage times, low storage space utilization, and improper storage management that can easily lead to material damage or loss, this system calculates storage location weights and constructs an inventory layout optimization objective function to achieve rational inventory space planning. By comprehensively considering the storage location's space utilization, the access frequency of each item, and the access cost coefficient, it can match optimal storage locations for kit items of varying sizes, weights, and access requirements (such as large mechanical parts, small electrical components, and long pipes). This solves the problem of space waste caused by improper material storage in traditional storage layouts and improves storage space utilization. Furthermore, by arranging frequently used items in easily accessible locations, it reduces access time and operational difficulty, lowering the risk of material damage and loss due to frequent handling or improper storage, ensuring the safety and integrity of material storage, and indirectly lowering manufacturing costs.

[0025] 8. The present invention aims to solve the problem of high loss rate of complete set materials in the equipment manufacturing industry due to lack of real-time monitoring. By collecting data such as storage time, ambient temperature and humidity, and number of transportation of complete set sub-items in real time, the material loss warning index is calculated, thereby realizing timely warning of material loss risks. It can accurately capture key factors affecting material loss, such as excessive humidity in the storage environment of electrical components and frequent transportation of precision mechanical parts, and quantify loss risks through the warning index; when the warning index reaches the set threshold, the system will issue a warning in time, prompting management personnel to take targeted measures (such as drying components affected by moisture and strengthening transportation protection of vulnerable parts), thereby solving the problem of material damage and loss caused by untimely discovery of loss in traditional management, effectively reducing the material loss rate, ensuring the integrity of materials, and thus controlling the material cost in production processes such as shipbuilding, and shortening the production cycle delay caused by re-procurement of lost materials.

[0026] Advantages of additional aspects of the present invention will be given in part in the following description and in part will be obvious from the following description, or will be learned through practice of the present invention. BRIEF DESCRIPTION OF THE DRAWINGS

[0027] The accompanying drawings, which constitute a part of the present invention, are used to provide a further understanding of the present invention. The exemplary embodiments of the present invention and their descriptions are used to explain the present invention and do not constitute improper limitations on the present invention.

[0028] Figure 1 A schematic flow chart of a complete set of material management and control method provided by an exemplary embodiment of the present invention; Figure 2 A schematic flow chart of a complete set of material management and control system provided by an exemplary embodiment of the present invention; Figure 3 A schematic diagram of a computer device is provided for an exemplary embodiment of the present invention. DETAILED DESCRIPTION

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

[0030] It should be noted that the following detailed descriptions are exemplary and intended to provide further explanation of the present invention. Unless otherwise specified, all technical and scientific terms used herein have the same meaning as commonly understood by those skilled in the art to which the present invention belongs.

[0031] This implementation method proposes a complete set of material management and control method, such as Figure 1 As shown, the following process is included: S101: Kit maintenance.

[0032] After logging into the ERP system, users click "Supply Chain Management" on the main interface. From the expanded submenu, select "Kit Management," then "Kit Maintenance" to enter the Kit Maintenance module. The system automatically loads the initial interface for this module. The top section displays a filter area with input fields for filter criteria such as contract number, project number, supplier, kit name, and signing date. The center section displays the kit list, and the bottom section features action buttons such as "Add," "Edit," "Delete," and "Sub-item Maintenance."

[0033] In the kit maintenance module interface, click the "Add" button, and the system will pop up the basic information entry window for the kit. The user needs to enter the kit number, name, specifications, model, auxiliary information, quantity, unit of measurement, auxiliary quantity, auxiliary unit of measurement and other information in sequence. Among them, the kit number must be compiled in accordance with the coding rules specified by the company to ensure uniqueness; the name should accurately reflect the purpose and composition of the kit; the specifications and models must be consistent with the actual materials to facilitate subsequent procurement, warehousing, and outbound operations. After the input is completed, click the "Save" button, and the system will verify the entered information. If there are errors such as duplicate numbers, a prompt message will pop up, and the user needs to modify and save again; if the verification passes, the basic information of the kit will be stored in the system database, and a new record will be added to the kit list.

[0034] Select the newly added complete set record and click the "Sub-item Maintenance" button. The system will pop up the sub-item maintenance window. The left side of the window is the sub-item list area, and the right side is the sub-item information entry area. Click the "Add Row" button to add a blank row to the sub-item list. Users can enter the sub-item number, name, specification, model, quantity, unit, and other information in the entry area on the right. The sub-item number must also follow the coding rules and form an association with the complete set. For each sub-item, the accuracy of its information must be ensured, as this information will directly affect subsequent procurement, arrival, and delivery.

[0035] More specifically, when adding sub-item information, the system automatically establishes a bidirectional association index between the kit and the sub-item. When entering the sub-item quantity, the system not only stores the sub-item information itself, but also synchronously records the weight of the sub-item in the kit (for example, if the number of a sub-item is 5 and the total number of sub-items in the kit is 20, then the weight is 25%), and generates an association relationship table containing fields such as the kit number, sub-item number, and association timestamp.

[0036] When entering sub-item specifications, the system calls a pre-set industry specification database (including standard specifications for mechanical, electrical, and piping sub-items commonly used in the shipbuilding industry) and automatically compares the entered value with the standard value. For example, if you enter the specification of "DN100×5mm" for a pipe sub-item, the system will detect that the standard specification should be "DN100×4.5mm" and immediately prompt a prompt, such as "This specification deviates from the industry standard by 11%. Do you want to use the standard specification or note the reason for the deviation?"

[0037] During the process of entering sub-item information, the system will perform real-time verification. When entering the sub-item quantity, the system will check whether it is a positive integer. When entering the sub-item number, the system will check whether it is a duplicate of an existing sub-item number. If an error is found, an error message will be displayed next to the corresponding input box. Users must correct the error message according to the prompt until all sub-item information has been verified.

[0038] After all sub-item information has been entered and verified, click the "Save" button in the sub-item maintenance window; the system will associate the sub-item information with the corresponding kit and update the kit's sub-item row number and sub-item quantity information; in the kit list, the "Sub-item Row Number" and "Sub-item Quantity" fields of the kit record will display the corresponding values; click the "Close" button to return to the main interface of the kit maintenance module.

[0039] More specifically, for sub-items with non-standard specifications, the system automatically generates standardized mapping codes when saving. For example, if a custom motor sub-item has the specification "380V 5.5kW 1450r / min," the system maps it to "M-380-5.5-1450" and associates it with the specification code of similar standard motors, facilitating fuzzy queries during subsequent procurement and procurement (for example, searching for "5.5kW motor" matches both standard and custom models).

[0040] To modify the information of a kit or its sub-items, select the corresponding kit record in the kit list and click the "Edit" button to modify the basic information of the kit; click the "Sub-item Maintenance" button, select the sub-item record in the pop-up window, and click "Edit" to modify the sub-item information; after the modification is completed, click the "Save" button and the system will update the information in the database.

[0041] More specifically, if you modify the specifications or quantities of a sub-item, the system triggers a correlation verification mechanism. For example, if the quantity of a sub-item is adjusted from 10 to 15, the system automatically checks whether the quantity ratios of other sub-items within the kit meet the preset matching threshold (for example, a mechanical kit requires that the quantity deviation of each sub-item does not exceed 10%). If the threshold is exceeded, a prompt will pop up, such as "The sub-item quantity ratio is unbalanced. Do you want to adjust other related sub-items simultaneously?"

[0042] When a kit is no longer in use or contains errors and needs to be deleted, select the record in the kit list and click the "Delete" button. The system will pop up a confirmation dialog box. After the user clicks "Confirm", if no purchase, delivery, or other business has occurred for the kit, the system will delete it and its associated sub-item information from the database; if relevant business has occurred, the system will prompt "Business data already exists for this kit and cannot be deleted." The user must first process the relevant business data before deleting it. In the filter area of ​​the kit maintenance module, users can enter specific criteria, such as contract number, supplier, or signing date range. Click the "Filter" button. The system will then search the database for matching kit records based on the criteria and display them in a list. Select a kit record and click the "View Sub-items" button to view all sub-items within the kit. Click "Default Filter Scheme" to select a pre-set filter scheme for quick search.

[0043] More specifically, the system supports reverse-searching kits by sub-item. After entering a sub-item number, the system retrieves the associated table within 0.5 seconds, displaying a list of all kits to which the sub-item belongs. It also notes the usage status of each sub-item within the kit (e.g., "purchased but not yet delivered" or "partially shipped"), resolving the traditional management issue of knowing the sub-item but not the kit to which it belongs.

[0044] When searching, sorting by specification similarity is supported. For example, if you enter "DN100 pipe", the system will not only display the sub-items with exact matches, but also display sub-items with similar specifications such as "DN90" and "DN110" in descending order of similarity, and mark the kits to which they belong, helping users quickly find alternative materials.

[0045] S102: Purchase order creation.

[0046] On the ERP system's main interface, click "Purchase Management" and select "Purchase Order" from the drop-down menu to enter the purchase order module. This interface includes an area for basic order information, a purchase details area, and an action button area. The basic order information area is used to enter information such as the purchase order number, supplier, order date, and delivery date. The purchase details area is used to add information about the materials to be purchased. Action buttons include "Add," "Save," "Submit," and "Approve."

[0047] Click the "Add" button. The system will generate a new purchase order number and display it in the basic order information area. The user will then need to select a supplier by entering their name or number to search for them. Set the order date to the current date and set the delivery date based on production plans and material requirements. Additionally, the user can enter any special requirements or instructions related to this purchase order in the "Remarks" column.

[0048] More specifically, when filling in the basic information of a purchase order, the system adds a new "production node association" option. Users can select the corresponding shipbuilding production node (such as the hull assembly stage, the main engine installation stage), and the system automatically retrieves the time window period of the node from the production planning module (such as June 1 to June 30, 2024), and sets the delivery date by default to 7 days before the start date of the window period (reserving a buffer period).

[0049] Click the "Reference Kit" button in the Purchase Details area. The Kit Selection window will pop up. This window displays all maintained kit information, allowing users to filter by entering kit numbers, names, and other information. After selecting the kit to purchase, click "OK." The system will add the kit information to the Purchase Details area, including the kit number, name, specifications, model, quantity, and unit. Users can modify information such as the purchase quantity based on their actual purchasing needs.

[0050] More specifically, after adding kit purchase information, the system automatically compares the kit's demand node in the production BOM. For example, if a kit is used for cabin piping installation, and the production plan shows that node will start in three months, the system will prompt, "The current procurement cycle is one month. It is recommended to delay the purchase order creation to two months to reduce inventory backlogs."

[0051] Select a kit record in the Purchase Details area and click "Sub-item Query." A sub-item information window will pop up. This window displays the number, name, specification, model, quantity, unit, and other information for all sub-items included in the kit, allowing you to confirm whether the sub-item meets your purchase requirements. If you find any sub-item information is incorrect or does not meet your requirements, return to the kit maintenance module to modify it and then add it back to the purchase order.

[0052] In the Purchase Details area, the system automatically displays sub-item information for added kits. Users must enter information such as the net price, unit price including tax, and tax code for each sub-item. The net price is the unit price excluding tax. Unit price including tax = net price × (1 + the tax rate corresponding to the tax code). Tax amount = net price × quantity × the tax rate corresponding to the tax code. Total amount including tax = unit price including tax × quantity. The system automatically calculates the unit price including tax, tax amount, and total amount including tax based on the net price and tax code entered by the user and displays them in the corresponding fields.

[0053] After filling in all the information, click the "Save" button. The system will verify the purchase order information, checking whether the supplier is valid, the purchase quantity is correct, and the price information is complete. If there are any errors, the system will prompt an error message, and the user can modify and save again. If the verification passes, the purchase order information is stored in the database and the order status is "Compiled".

[0054] Click the "Submit" button, and the system will submit the purchase order to the reviewer for review. After logging in, the reviewer will see the purchase order in the "Awaiting Review" list and click to view the details. If the review passes, click the "Approved" button, and the order status will change to "Reviewed." If there are any issues, click the "Reject" button and enter the reason for rejection. The order status will return to "Preparing," and the user will need to modify the rejection reason and resubmit for review.

[0055] More specifically, when submitting for review, the system attaches a "Production Compatibility Report." This report includes the overlap between the purchase order's delivery date and the production milestone, as well as the compatibility verification results between the kit sub-items and the production process (for example, whether an electrical sub-item meets classification society certification requirements). Reviewers can use this report to quickly determine the rationality of the purchase order, reducing mis-purchases and missed purchases due to information asymmetry.

[0056] When a purchase order is submitted, the system automatically determines the approval level based on the order amount and the importance of the kit. For example, orders exceeding 500,000 yuan or including key powertrain kits are automatically transferred to the company level for approval; orders between 100,000 and 500,000 yuan for common structural parts are transferred to the department level for approval; and orders under 100,000 yuan are directly approved by the purchasing manager.

[0057] During the approval process, the system pushes relevant data to the approver's interface in real time. When a department-level approver views an order, the system automatically displays the production milestone progress for that kit (e.g., "Only 15 days left until the hull welding deadline") and current inventory alerts (e.g., "Only three kits of the same sub-item remain"). Company-level approvers also see historical price curves (e.g., "The purchase price of this kit has fluctuated by ±3% over the past six months") to aid in quick decision-making.

[0058] If an approval is rejected, the system automatically locates the modification node corresponding to the rejection reason. For example, if the approver rejects the application due to "sub-item price being too high," the system will directly jump to the price entry area and display the reference prices of the last three purchases, reducing repetitive operations.

[0059] S103: Procurement arrival processing.

[0060] In the ERP system, users click "Inventory Management" and select "Purchase Arrivals" to enter the purchase order arrival module. The top section of the interface contains a filter area, allowing users to filter by inventory organization, purchasing organization, order type, order number, supplier, and other criteria. The center section contains a purchase order arrival list, displaying information such as order number, material drawing number, delivery date, order quantity, and current arrival quantity. At the bottom are action buttons, such as "Maintain Sub-Item Arrivals," "Directly Enter Warehouse," and "Generate Arrival Note."

[0061] Enter or select the appropriate filter criteria in the filter area, such as order number, supplier, order date range, etc. Click the "Filter" button. The system will query and display the purchase order arrival records that meet the criteria in a list. Users can select the purchase orders to be processed based on the actual arrival status.

[0062] Select the purchase order record that needs to be processed, click the "Maintain Sub-item Arrival" button, and the system will pop up the sub-item arrival window. The window displays the kit information corresponding to the purchase order, including the order number, project number, kit number, name, etc. Click the "Reference Sub-item Information" button, and the system will load all the sub-item information contained in the kit into the sub-item arrival list. Users fill in the arrival quantity of each sub-item in the "Quantity of This Arrival" column based on the actual arrival situation. If the sub-items arrive in batches, the arrival process can be performed multiple times, and the corresponding arrival quantity can be filled in each time. At the same time, select the warehouse and location for arrival. If there is a difference between the actual arrival sub-item and the purchased sub-item, click "Add Row" in the "Actual Arrival Sub-item" area, fill in the number, name, quantity, unit and other information of the arrival supplier sub-item, and maintain the correspondence between the two.

[0063] In the Sub-item Arrival window, select the "Last Arrival" checkbox if this is the last arrival for the kit sub-item; otherwise, leave it unchecked. The system will mark and remind you accordingly during subsequent arrival processing based on this setting.

[0064] After completing the form, click "Save." The system will verify the arrival information, checking whether the arrival quantity exceeds the order quantity (taking into account the excess tolerance) and whether the warehouse and storage location are valid. If there are any errors, the system will prompt an error message and the user can modify and resave the form. If the verification passes, the sub-item arrival information will be stored and the cumulative arrival quantity and other information will be updated.

[0065] More specifically, when saving sub-item arrival information, the system generates a unique "arrival traceability code" for each sub-item. This code contains information such as the supplier code, arrival batch, and quality inspection results, and is tied to the purchase order number. For example, in the arrival traceability code "GY20240508-003-1," "GY" represents the supplier "Guangyuan Machinery," "20240508" is the arrival date, "003" is the batch number, and "1" indicates that the product passed quality inspection.

[0066] After confirming the sub-item's arrival quantity, the system immediately compares it with the total number of requisitions for that sub-item. When the arrival quantity of a particular sub-item exceeds 120% of the outstanding requisitions, an inventory alert is automatically triggered. The generated arrival note is marked with "Excess arrival, recommended for prioritization in subsequent requisition plans." This alert is also pushed to the inventory management module, prompting adjustments to storage locations (e.g., moving the excess quantity to long-term storage).

[0067] Click the "Generate Arrival Note" button. The system will generate an arrival note based on the sub-item arrival information. The arrival note includes information such as the order number, supplier, arrival date, and sub-item arrival details. The generated arrival note will be in the "Waiting for Warehousing" status and will be recorded in the system.

[0068] For materials that do not require further inspection, click the "Directly Enter Warehouse" button. The system will automatically process the warehouse entry based on the arrival note information, update the warehouse inventory quantity, and change the arrival note status to "Entered Warehouse." For materials that require inspection, they must first be inspected and qualified before entering the warehouse.

[0069] If a return is requested, click the "Generate Return Order" button. A window will pop up to fill in the return order. Enter the return item number, name, quantity, reason, and other information, then click "Save" to generate the return order. After review, the return order is processed for receipt, reducing the warehouse inventory and updating information such as the cumulative receipt quantity.

[0070] S104: Application for collection.

[0071] Production demand department personnel log in to the ERP system, click "Inventory Management," select "Pickup Request," and then click "Kit Sub-item Pickup Request" to enter the Pickup Request module. This interface includes the Pickup Request Basic Information area and the Sub-item Pickup Details area. The Basic Information area requires information such as the movement type, transaction date, warehouse, and delivery location. The Sub-item Pickup Details area is used to add information about the sub-items to be picked up.

[0072] In the Basic Information area, select "Production Collection" as the movement type; set the business date to the current date; select the warehouse where the collected materials are located, such as "Steel Plate Warehouse"; enter the specific location of the production workshop as the delivery location; and enter the consignee and consignee's contact information.

[0073] Click the "Refer to Sub-item Information" button to open the sub-item selection window. This window displays all available kit sub-items in the warehouse. Users can filter by entering project number, kit number, sub-item number, etc. After selecting the sub-item to be collected, click "OK." The system will add the sub-item information to the sub-item collection details area. Users must enter the collection quantity for each sub-item in the "Requested Quantity" column and set the required date to the date the materials need to be delivered to the production site.

[0074] More specifically, when adding a sub-item for collection, the system automatically associates it with an arrival traceability code. After the user selects a sub-item, the system displays the inventory distribution of all incoming batches for that sub-item. Based on a "first-in, first-out" basis, the system recommends the earliest batch for collection and annotates the storage environment records for that batch (e.g., average humidity of 55% over the past 30 days), making it easier for the collecting department to determine the status of the supplies.

[0075] When submitting a requisition, the system displays the "Available Inventory Dynamic Value" for that sub-item, which is the current inventory minus the approved but unissued requisition quantity. For example, if a sub-item has 100 units in stock and 20 units are already locked by a requisition from another department, the system will display "Available Inventory 80 units" to the current applicant, preventing conflicts caused by over-requests.

[0076] The system verifies requisition information in real time, checking whether the requested quantity exceeds the sub-item's inventory and whether the requested date is reasonable. If the requested quantity exceeds the inventory, the system prompts "Insufficient inventory, unable to apply." If the requested date is earlier than the current date, the system prompts "Invalid requested date." Users must modify the relevant information according to the prompts.

[0077] After all the information is filled in and verified, click the "Save" button. The system will store the application information in the database and the application form status will be "Compiled".

[0078] Click the "Approve" button to submit the application to the warehouse manager for approval. The warehouse manager reviews the application. If inventory is sufficient and the application is reasonable, they click the "Approved" button, and the application status changes to "Approved." If there are any issues, the application is rejected with a clear explanation, and the application status returns to "Preparing." The applicant can then make revisions and resubmit the application.

[0079] S105: Sub-item is shipped out.

[0080] Warehouse managers log in to the ERP system, click "Inventory Management," select "Outbound Management," and then click "Sub-item Outbound" to enter the sub-item outbound module. This interface displays a list of requisitions, including information such as the requisition number, project, receiving department, and warehouse. Specific requisitions can also be found by filtering criteria.

[0081] In the requisition list, select the approved requisition and click the "Process" button. The system will then display the sub-item requisition details of the requisition, including sub-item number, name, specification, model, application quantity, etc.

[0082] Warehouse management matches sub-items based on their storage locations and inventory levels. On the sub-item delivery screen, they assign corresponding storage locations to each sub-item and confirm the actual quantity available for delivery. If the actual quantity available matches the requested quantity, they proceed directly to the next step. If there is a discrepancy, they note the reason in the system and communicate with the receiving department for confirmation.

[0083] After confirming the match, click the "Confirm Shipment" button. The system will then process the shipment, reduce the inventory quantity of the corresponding sub-item, and update the sub-item shipment quantity and cumulative shipment quantity. At the same time, a shipment order will be generated, which will include the requisition number, sub-item details, shipment quantity, shipment date, and other information.

[0084] During outbound delivery, the system links the delivery information with the arrival traceability code, forming a closed-loop chain of "purchase order - arrival batch - receipt record." For example, when a sub-item is shipped, the system records "Traceability code GY20240508-003-1 corresponds to an outbound quantity of 2 pieces, the receiving department is the hull workshop, and it is used for the port section of Ship No. 3." This record can then be traced back to the corresponding purchase order and arrival quality inspection report, solving the problem of "unclear where materials are used" in traditional management.

[0085] When processing the outbound shipment, if the actual outbound quantity is different from the applied quantity (for example, 5 items are applied for but only 3 items can be shipped out in reality), the system will automatically generate a "difference association form", mark the unshipped part as "to be replenished", and link it to the corresponding purchase order (if the sub-item has an unfinished arrival plan), and prompt the supplier in S3 to make up the difference quantity first, forming a closed-loop adjustment of "receipt - outbound - purchase".

[0086] Based on the delivery note, the warehouse manager removes the sub-item materials from the warehouse and delivers them to the production workshop according to the delivery location. The consignee signs the delivery note for confirmation. The warehouse manager files the signed delivery note as proof of material transfer.

[0087] After the delivery is completed, the system automatically updates the relevant data, including the inventory quantity of the sub-item, delivery records, etc. At the same time, the delivery information is fed back to other related modules of the ERP system, such as the production management module, so that the production department can track the arrival of materials.

[0088] During the different stages of large-scale equipment product construction, such as hull construction, equipment installation, and electrical wiring, the demand for various kit sub-items, both in quantity and time, varies significantly. For example, during the hull construction phase, there is a greater demand for structural sub-items such as steel plates and profiles; while during the equipment installation phase, there is an increased demand for various mechanical parts, electrical components, and other sub-items. Traditional allocation methods are difficult to flexibly adjust to these fluctuations, resulting in excess materials in some stages and shortages in others. Therefore, among other implementation methods, a material allocation optimization method based on production demand fluctuations is proposed, which includes the following steps: First, calculate the production demand fluctuation coefficient: (1); in, Indicates the The kit item is in The production demand fluctuation coefficient during the production phase; For the The kit item is in The actual demand quantity during the production phase; For the The average demand quantity of a kit item during the entire production cycle; For the The standard deviation of the demand quantity of a kit item throughout the entire production cycle.

[0089] Formula (1) reflects the demand fluctuation of sub-items at different production stages by calculating the deviation between actual demand and average demand and combining it with the discrete degree of demand. The larger the value, the greater the demand fluctuation of the sub-item in the production stage, and its allocation needs to be paid special attention.

[0090] Secondly, calculate the material allocation weight, including: (2); in, Indicates the The kit item is in the allocation weights of the production stages; 、 、 is the weight coefficient, and , can be adjusted according to actual production conditions, for example , , , For the The kit item is in The urgency score of the production phase requirements ranges from 1 to 10, with higher scores indicating greater urgency; For the the total duration of the production phase; For the The kit item is in Inventory quantity at the beginning of the production phase; For the The maximum inventory capacity of this kit item.

[0091] Formula (2) comprehensively considers the production demand fluctuation coefficient, demand urgency and inventory situation, and calculates the allocation weight of each sub-item in each production stage. The larger the value, the higher the allocation priority of the sub-item in this production stage.

[0092] Specifically, the following implementation steps are provided: Collect the first The actual required quantity of each kit item at each production stage , the average demand quantity during the entire production cycle , standard deviation of demand quantity , in the Demand urgency score during the production phase , the total duration of the jth production stage , the inventory quantity at the beginning of the jth production stage and maximum inventory capacity ; According to The actual required quantity of each kit item at each production stage , the average demand quantity during the entire production cycle , standard deviation of demand quantity , combined with formula (1), calculate the The production demand fluctuation coefficient of the kit sub-item in the jth production stage ; According to the importance of production and actual situation, set 、 、 For example, if the demand fluctuation has a greater impact on production, the value of The value of Will 、 、 、 and Substituting into formula (2), we get The kit item is in Allocation weight of production stage ,according to The order of allocation of each sub-item in each production stage is sorted according to the size of the sub-item, and the sub-items with higher weights are allocated materials first; in the material allocation module of the ERP system, the calculated allocation weight is entered, and the system automatically generates a material allocation plan to guide the issuance and use of materials.

[0093] The kits required for large-scale equipment construction come in a wide variety of sub-items, with significant variations in size and weight. These include large mechanical parts, small electrical components, and long pipes. These sub-items require different amounts of storage space. Improper storage layouts waste storage space and increase the difficulty of accessing materials. For example, storing large components in a confined space wastes surrounding space, while storing frequently used sub-items in remote locations increases access time. To improve storage utilization and reduce material damage and loss, a method for optimizing inventory layout based on storage utilization is optionally proposed in other implementations. Specifically, the method involves the following steps: Perform storage location weight calculation: (3); in, Indicates the The kit item is in The storage location weight of each storage location, 、 and is the weight coefficient, and ; For the The space utilization rate of each storage location is the ratio of the volume of the materials actually stored at that location to the total volume of that location; For the The access frequency of a kit item, that is, the number of times the item is taken out of the warehouse per unit time; For the The kit item is in The access cost coefficient of a storage location is related to factors such as the distance from the storage location to the entrance and exit, and the weight and size of the sub-item.

[0094] Set the inventory layout optimization objective function, specifically including: (4); The constraints are: (5); (6); (7); (8); in, The number of types of kit items; is the number of storage locations; is a decision variable, if the kth kit item is stored in the storage location, then ,otherwise, ; For the The volume of the kit item; For the The objective function aims to maximize the total storage location weight. This means that by rationally arranging the storage locations of sub-items, high-weight storage combinations (sub-item - location) are selected, thereby improving storage utilization and access efficiency. The constraints ensure that the capacity of each storage location is not exceeded and each sub-item is stored in only one location.

[0095] Specifically, the following implementation steps are provided: Collect the volume of each storage location , Current space utilization , the volume of each kit item , access frequency And the access cost coefficient of each sub-item in different storage locations , access cost coefficient The comprehensive assessment can be made based on factors such as the distance from the storage location to the entrance and exit, the weight and size of the sub-items, etc. According to the storage management goals, set 、 and For example, if you pay more attention to space utilization, you can increase If you pay more attention to access efficiency, you can increase The value of .

[0096] Will 、 、 as well as 、 and Substitute into formula (3) and calculate ; Will 、 、 Substitute into formula (4) - formula (8), use linear programming algorithm to solve the model in the inventory layout optimization module of the ERP system, and obtain the decision variables The value of , which determines the best storage location for each sub-item.

[0097] Based on the solution, the storage location of each kit sub-item in the warehouse is adjusted. The sub-item storage location information is updated in the inventory management module of the ERP system. The system generates an inventory layout diagram to guide warehouse managers in the handling and placement of materials. The adjusted storage utilization rate is also recorded to facilitate subsequent evaluation of the optimization results.

[0098] During storage and use, kit sub-items may suffer wear and tear due to environmental factors (such as humidity and temperature), improper handling, or prolonged storage. For example, electrical components are susceptible to moisture damage in humid environments, and precision mechanical parts may lose accuracy due to collisions during handling. Real-time monitoring of these factors and timely issuance of wear and tear warnings can reduce unnecessary wear and tear. Alternatively, in other implementations, a material wear and tear warning method based on real-time monitoring is proposed, including the following steps: Calculate the material loss warning index, including: (9); in, Indicates the The kit item is Material loss warning index at all times; 、 、 、 is the weight coefficient, and ; For the The kit item is The storage time loss factor at the moment is proportional to the storage time; for The storage environment humidity at all times The loss factor of the kit item, the higher the humidity, the greater the factor; For the The kit item is The loss factor of the number of transports at a given moment. The more transports there are, the greater the factor. For the The kit item is The ambient temperature loss factor at all times. Too high or too low a temperature will increase the factor.

[0099] Install monitoring equipment such as temperature and humidity sensors, cameras, and RFID tags in warehouses and production sites to collect real-time data on the storage time, ambient temperature and humidity, and handling times of the kit sub-items. This data is then transmitted to the real-time monitoring module of the ERP system via the network. According to the characteristics of the kit sub-item, determine 、 、 、 For example, It can be determined based on the ratio of storage time to shelf life; 、 It can be determined based on the degree to which the temperature and humidity deviate from the appropriate range; It can be determined based on the number of transports and the impact strength of each transport; According to the influence of different loss factors on material loss, set 、 、 、 For example, for items that are susceptible to humidity, increase For sub-items that are easily damaged during transportation, increase The value of According to the historical loss data and the importance of the sub-item, the loss warning threshold is set for each sub-item of the kit in the ERP system. ,when , the system issues a loss warning.

[0100] When the system issues a loss warning, the warning information, including the sub-item number, name, warning index, and warning reason, is displayed in the ERP system's warning module. Warehouse managers and production personnel, upon receiving the warning, promptly inspect and address the corresponding sub-items. For example, they can dry damp electrical components or repair or replace damaged mechanical parts. Once the action is complete, the results are recorded in the system, the sub-item status information is updated, and the loss warning index is recalculated until the warning is lifted.

[0101] Optimizing material allocation in response to fluctuations in production demand ensures the rational allocation of materials at different production stages; optimizing inventory layout to improve storage utilization efficiency improves the utilization efficiency of storage space; and real-time monitoring of material loss warnings reduces the material loss rate. These three innovations work together to form an organic whole, jointly improving the level of kit material management, reducing manufacturing costs, and shortening manufacturing cycles.

[0102] Figure 2 A complete set of material management and control system is shown, including: The association relationship determination unit 201 is configured to: establish a bidirectional association index between the kit and the sub-items, and when a kit purchase requisition is received, associate and display the kit to be purchased and the sub-items contained therein according to the bidirectional association index; The sub-item traceability code generating unit 202 is configured to: generate an arrival traceability code for the sub-item that has arrived based on the received purchase order arrival information; The kit disbursement unit 203 is configured to: determine the sub-items of the kit based on the received kit disbursement application according to the bidirectional association index; determine the kits to be shipped based on the traceability code of the determined sub-items and the approved disbursement application form; and update the kit inventory; The sub-item requisition unit 204 is configured to: upon receiving a sub-item requisition application, determine the sub-item to be shipped based on the sub-item's arrival traceability code and the approved requisition form, update the sub-item inventory, and update the kit inventory based on the bidirectional association index and the updated sub-item inventory; The sub-item editing prompt unit 205 is configured to: trigger association verification when sub-item information is edited, and if the quantity ratio between sub-items exceeds a preset ratio threshold, issue a prompt message to remind the user to adjust the quantity of related sub-items.

[0103] It is understandable that each of the above-mentioned units can be separately or completely combined into one or several other units to form a whole, or one (or more) of the units can be further divided into multiple functionally smaller units to form a whole, which can achieve the same operation without affecting the realization of the technical effects of the embodiments of the present invention. The above-mentioned units are divided based on logical functions. In actual applications, the functions of one unit can also be implemented by multiple units, or the functions of multiple units can be implemented by one unit. In other embodiments of the present invention, the system can also include other units. In actual applications, these functions can also be implemented with the assistance of other units, and can be implemented by the collaboration of multiple units.

[0104] According to another embodiment of the present invention, the system described in this embodiment can be constructed by running a computer program (including program code) capable of executing the steps involved in the corresponding method of the present invention on a general-purpose computing device such as a computer, which includes processing elements and storage elements such as a central processing unit (CPU), random access memory (RAM), and read-only memory (ROM). The computer program can be recorded on, for example, a computer-readable recording medium, and loaded into the above-mentioned computing device via the computer-readable recording medium and run therein.

[0105] Figure 3 A computer device is shown, which includes a processor 301, a communication interface 302, and a computer-readable storage medium 303. The processor 301, the communication interface 302, and the computer-readable storage medium 303 may be connected via a bus or other means.

[0106] Among them, the communication interface 302 is used to receive and send data, the computer-readable storage medium 303 can be stored in the memory of the electronic device, the computer-readable storage medium 303 is used to store computer programs, the computer programs include program instructions, and the processor 301 is used to execute the program instructions stored in the computer-readable storage medium 303.

[0107] The processor 301 is the computing core and control core of the electronic device, which is suitable for implementing one or more instructions, and is specifically suitable for loading and executing one or more instructions to implement corresponding method processes or corresponding functions.

[0108] The processor 301 is configured to perform the following process: Create a bidirectional association index between kits and sub-items. When a kit purchase requisition is received, the kit to be purchased and its included sub-items are displayed based on the bidirectional association index. Generate the arrival traceability code of the sub-item according to the received purchase order arrival information; Based on the received kit requisition, the sub-items of the kit are determined based on the bidirectional association index. Based on the traceability code of the determined sub-item and the approved requisition form, the kit to be shipped is determined and the kit inventory is updated; When a sub-item requisition is received, the sub-item to be shipped is determined based on the sub-item's arrival traceability code and the approved requisition form, and the sub-item inventory is updated simultaneously. The kit inventory is also updated based on the bidirectional association index and the updated sub-item inventory. When the sub-item information is edited, the association check is triggered. If the quantity ratio between the sub-items exceeds the preset ratio threshold, a prompt message is issued to remind the user to adjust the quantity of related sub-items.

[0109] The foregoing description is merely a preferred embodiment of the present invention and is not intended to limit the present invention. Those skilled in the art will readily appreciate that various modifications and variations of the present invention are possible. Any modifications, equivalent substitutions, or improvements made within the spirit and principles of the present invention are intended to be within the scope of protection of the present invention.

Claims

1. A complete set of material management and control method, characterized in that: The following processes are included: Create a bidirectional association index between kits and sub-items. When a kit purchase requisition is received, the kit to be purchased and its included sub-items are displayed based on the bidirectional association index. Generate the arrival traceability code of the sub-item according to the received purchase order arrival information; Based on the received kit requisition, the sub-items of the kit are determined based on the bidirectional association index. Based on the traceability code of the determined sub-item and the approved requisition form, the kit to be shipped is determined and the kit inventory is updated; When a sub-item requisition is received, the sub-item to be shipped is determined based on the sub-item's arrival traceability code and the approved requisition form, and the sub-item inventory is updated simultaneously. The kit inventory is also updated based on the bidirectional association index and the updated sub-item inventory. When the sub-item information is edited, the association check is triggered. If the quantity ratio between the sub-items exceeds the preset ratio threshold, a prompt message is issued to remind the user to adjust the quantity of related sub-items.

2. The complete set material management and control method according to claim 1, characterized in that: When establishing a bidirectional association index between a kit and its sub-items, the weight of the sub-items in the kit is recorded to verify the matching degree between the number of sub-items and the overall requirement of the kit.

3. The complete set material management and control method according to claim 1, characterized in that: When binding a purchase order to a production node, call the production node time window in the production planning module and set the delivery date to the preset number of days before the start date of the window period. This allows time for incoming material inspection and deployment. When verifying the sub-item information of the requisition, the dynamic value of the available inventory of the sub-item is displayed. The dynamic value of the available inventory is the current inventory minus the approved but not shipped requisition quantity.

4. The method for controlling complete sets of materials according to claim 1, wherein: During the outbound delivery procedure, if the actual outbound quantity differs from the requested quantity, a discrepancy association document is generated, marking the undelivered portion as pending replenishment and linking it to the corresponding purchase order. When obtaining sub-item information, the industry specification database is called to compare the deviation between the input value and the standard value, and a standardized mapping code is generated for the sub-item of non-standard specifications, which is used to realize the associated retrieval of non-standard sub-items and standard sub-items during procurement and issuance inquiries.

5. The method for controlling complete sets of materials according to any one of claims 1 to 4, characterized in that: Collect the first The actual required quantity of each kit item at each production stage , the average demand quantity during the entire production cycle , standard deviation of demand quantity , in the Demand urgency score during the production phase , No. Total duration of the production phase , in the Inventory quantity at the beginning of the production phase and maximum inventory capacity ; According to The actual required quantity of each kit item at each production stage , the average demand quantity during the entire production cycle , standard deviation of demand quantity , calculate the The kit item is in Production demand fluctuation coefficient in the production stage ; According to the production demand fluctuation coefficient , Demand urgency score , No. Total duration of the production phase , in the Inventory quantity at the beginning of the production phase and maximum inventory capacity , get the The kit item is in Allocation weight of production stage , according to the distribution weight The order of allocation of each sub-item in each production stage is sorted according to the size of the sub-item, and the sub-item with higher weight is allocated materials first.

6. The method for controlling complete sets of materials according to any one of claims 1 to 4, characterized in that: Collect the capacity of each storage location, current space utilization, volume of each kit item, access frequency, and access cost coefficient of each item in different storage locations; Calculate the storage location weight based on the current space utilization, the volume of each component in the kit, and the access cost coefficient of each component in different storage locations; Based on the storage location weights, the volume of each kit sub-item, the capacity of each storage location, and the inventory layout optimization objective function, a linear programming algorithm is used to solve and determine the optimal storage location for each sub-item.

7. The method for controlling complete sets of materials according to any one of claims 1 to 4, characterized in that: According to The kit item is Storage time loss factor at the moment, The storage environment humidity at all times The loss factor of the kit sub-item, The kit item is The loss factor of the number of times of transportation at the moment and the The kit item is The ambient temperature loss factor at the moment is used to obtain the material loss warning index ; Set a loss warning threshold for each kit sub-item based on historical loss data and the importance of the sub-item ,when , the system issues a loss warning.

8. The method for controlling complete sets of materials according to claim 7, wherein: Material loss warning index ,include: ; in, Indicates the The kit item is Material loss warning index at all times; 、 、 、 is the weight coefficient, and ; For the The kit item is Storage time loss factor at the moment; for The storage environment humidity at all times The loss factor of the kit item; For the The kit item is Loss factor of number of transports at a time; For the The kit item is Ambient temperature loss factor at the moment.

9. A complete set of material management and control system, characterized in that: include: The association relationship determination unit is configured to: establish a bidirectional association index between the kit and the sub-items, and when a kit purchase requisition is received, associate and display the kit to be purchased and the sub-items contained therein according to the bidirectional association index; The sub-item traceability code generating unit is configured to: generate an arrival traceability code for the sub-item that has arrived according to the received purchase order arrival information; The kit requisition unit is configured to: based on a received kit requisition application, determine the sub-items of the kit using a bidirectional association index; and based on the traceability code of the determined sub-item and the approved requisition form, determine the kit to be shipped and update the kit inventory; The sub-item requisition unit is configured to: upon receiving a sub-item requisition application, determine the sub-item to be shipped based on the sub-item's arrival traceability code and the approved requisition form, update the sub-item inventory, and update the kit inventory based on the bidirectional association index and the updated sub-item inventory; The sub-item editing prompt unit is configured to: trigger association verification when sub-item information is edited, and if the quantity ratio between sub-items exceeds a preset ratio threshold, issue a prompt message to remind the user to adjust the quantity of related sub-items.

10. A computer device, characterized in that: include: a processor and a computer-readable storage medium; a processor adapted to execute a computer program; A computer-readable storage medium having a computer program stored therein, wherein the computer program, when executed by the processor, implements the method for controlling a complete set of materials according to any one of claims 1 to 8.

Citation Information

Patent Citations

  • Product stock distribution method and device

    CN101894322A

  • Ship construction suite management method and system, storage medium and equipment

    CN115271597A

  • Complete-set supply equipment management method and system

    CN117893143A

  • Intelligent warehouse management system and method, electronic equipment and storage medium

    CN118154093A

  • Management system and method for goods to enter and exit from warehouse

    CN118505131A

Cited By

  • Construction quality tracing control system based on sludge incineration project

    CN121212567A