Inventory adjustment method and device, electronic equipment and readable storage medium
By dynamically adjusting the inventory quantity available for use at the time node of inventory usage demand, updating the inventory quantity according to the priority of demand, and formulating an inventory adjustment plan, the problem of inaccurate inventory adjustment in the existing technology is solved and the ability of inventory to meet demand is improved.
Patent Information
- Application Number
- CN202311602505.0
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2023-11-28
- Publication Date
- 2025-05-30
AI Technical Summary
When the existing inventory adjustment method handles inventory usage requirements with time node requirements, it cannot effectively balance different needs, resulting in low accuracy of inventory adjustments and may cause insufficient inventory to lead to unavailability of delivery.
By obtaining the time nodes, priority levels and demand quantity of inventory use requirements, dynamically adjust the quantity of inventory available, update the quantity of inventory according to the priority of demand, and formulate an inventory adjustment plan based on the adjusted quantity of inventory.
It improves the accuracy of inventory adjustments, ensures that inventory usage needs are met on time, and reduces the inability to deliver due to insufficient inventory.
Smart Images

Figure CN120069342A_ABST
Abstract
Description
Technical Field
[0001] This application relates to the field of computer application technologies, and particularly to an inventory adjustment method, apparatus, electronic device, and readable storage medium. Background Art
[0002] Inventory control is a core link in enterprise operation and management. With the development of information technologies such as the Internet, inventory control technologies have been gradually maturing and improving. From the initial simple spreadsheet management and inventory management systems for purchase, sales, and inventory, to the refined Enterprise Resource Planning (ERP) systems, inventory control technologies have gradually become mature.
[0003] With the development of the e-commerce and supply chain industries, inventory control involves a variety of complex application scenarios. In practical applications, the usage requirements for inventory in certain business scenarios often have time node requirements. For example, the demand instruction received on X month X day requires delivering M items to users at 14:00 on X month Y day. Then, according to this inventory usage requirement, the inventory needs to be adjusted so that the inventory meets the demand of delivering M items at 14:00 on X month Y day. When dealing with inventory usage requirements with time node requirements, existing inventory adjustment methods only consider the current demand and the inbound and outbound data of the inventory to allocate inventory or formulate a replenishment plan for the current demand, and cannot balance different inventory usage requirements to formulate a reasonable inventory adjustment plan. The formulated inventory adjustment plan may not conform to the actual outbound demand, resulting in a situation where there is insufficient inventory and delivery cannot be made, and the accuracy of inventory adjustment is relatively low. Summary of the Invention
[0004] In view of this, embodiments of this application at least provide an inventory adjustment method, apparatus, electronic device, and readable storage medium, which can dynamically adjust the available inventory quantity at the time node of the inventory usage requirement according to the priority of the inventory usage requirement and the priority of other inventory usage requirements existing at the current time node, and formulate an inventory adjustment plan based on the adjusted available inventory quantity. In this way, the inventory is adjusted according to the priority of the demand and the adjustment plan is updated to formulate an inventory plan that conforms to the actual outbound demand, which is beneficial to improving the accuracy of inventory adjustment.
[0005] This application mainly includes the following aspects:
[0006] In a first aspect, an embodiment of this application provides an inventory adjustment method, and the method includes:
[0007] Obtain an inventory usage requirement, and determine the time node of the inventory usage requirement, the priority of the inventory usage requirement, and the demand quantity of the inventory usage requirement;
[0008] Determine the available inventory quantity at the time node of the inventory usage requirement based on the outbound data and inbound data before the time node of the inventory usage requirement, and the data of other inventory usage requirements existing at the current time node;
[0009] If the available inventory quantity is less than the required quantity of the inventory usage requirement, update the available inventory quantity at the time node of the inventory usage requirement according to the priority of the inventory usage requirement and the priority of the other inventory usage requirements;
[0010] Determine the inventory adjustment plan according to the situation where the updated available inventory quantity meets the required quantity of the inventory usage requirement.
[0011] Further, the determining the available inventory quantity at the time node of the inventory usage requirement based on the outbound data and inbound data before the time node of the inventory usage requirement, and the data of other inventory usage requirements existing at the current time node includes:
[0012] Determine the available inventory quantity at the current time node according to the outbound data and inbound data before the current time node, and the data of other inventory usage requirements existing at the current time node;
[0013] If the available inventory quantity at the current time node is less than the required quantity of the inventory usage requirement, determine the available inventory quantity at the time node of the inventory usage requirement according to the available inventory quantity at the current time node, and the outbound data and inbound data from the current time node to the time node of the inventory usage requirement.
[0014] Further, the updating the available inventory quantity at the time node of the inventory usage requirement according to the priority of the inventory usage requirement and the priority of the other inventory usage requirements includes:
[0015] Sort the other inventory usage requirements in ascending order of priority, and delete the inventory usage requirement with the lowest priority;
[0016] Update the available inventory quantity at the time node of the inventory usage requirement according to the outbound data and inbound data before the time node of the inventory usage requirement, and the data of the remaining other inventory usage requirements existing at the current time node.
[0017] Further, the method further includes:
[0018] If the updated available inventory quantity is still less than the required quantity of the inventory usage requirement, delete the inventory usage requirement with the lowest priority among the other inventory usage requirements that have not been deleted until the updated available inventory quantity meets the required quantity of the inventory usage requirement, or until all the inventory usage requirements with priorities lower than that of the inventory usage requirement are deleted, and end the process of updating the available inventory quantity.
[0019] Further, after all the inventory usage requirements with priorities lower than that of the inventory usage requirement are deleted, the method further includes:
[0020] If the updated available inventory quantity is still less than the inventory usage requirement, delete, in the order of the time nodes, the inventory usage requirement with the same priority as the inventory usage requirement and with the last time node;
[0021] Update the available inventory quantity at the time node of the inventory usage requirement. If the updated available inventory quantity is still less than the required quantity of the inventory usage requirement, continue to delete the inventory usage requirement with the same priority as the inventory usage requirement and with the last time node among the other inventory usage requirements that have not been deleted until the updated available inventory quantity meets the required quantity of the inventory usage requirement, or until all the inventory usage requirements with the same priority as the inventory usage requirement and after the time node of the inventory usage requirement are deleted, and end the process of updating the available inventory quantity.
[0022] Further, after all the inventory usage requirements with the same priority as the inventory usage requirement and after the time node of the inventory usage requirement are temporarily deleted, the method further includes:
[0023] If, after all the inventory usage requirements with the same priority as the inventory usage requirement and after the time node of the inventory usage requirement are deleted, the updated available inventory quantity is still less than the required quantity of the inventory usage requirement, restore all the deleted inventory usage requirements, and determine an inventory adjustment plan according to the situation of whether the available inventory quantity at the time node of the inventory usage requirement before the update meets the required quantity of the inventory usage requirement.
[0024] Further, the determining of the inventory adjustment plan according to the situation of whether the updated available inventory quantity meets the required quantity of the inventory usage requirement includes:
[0025] If the updated available inventory quantity meets the required quantity of the inventory usage requirement, determine an inventory allocation plan according to the situation of the in-stock inventory at the current time node meeting the inventory usage requirement; determine an inbound delivery plan according to the situation of the inbound data after the current time node meeting the inventory usage requirement;
[0026] If the updated available inventory quantity is still less than the required quantity of the inventory usage requirement, after determining the inventory allocation plan and the inbound delivery plan, determine an inbound replenishment plan according to the difference between the required quantity of the inventory usage requirement and the available inventory quantity before the update.
[0027] In a second aspect, an embodiment of the present application further provides an inventory adjustment device, where the inventory adjustment device includes:
[0028] An acquisition module, configured to acquire an inventory usage requirement, and determine the time node of the inventory usage requirement, the priority of the inventory usage requirement, and the required quantity of the inventory usage requirement;
[0029] A first determination module, configured to determine the available inventory quantity at the time node of the inventory usage requirement according to the outbound data and inbound data before the time node of the inventory usage requirement, and the data of other inventory usage requirements existing at the current time node;
[0030] A second determination module, configured to, if the available inventory quantity is less than the required quantity of the inventory usage requirement, update the available inventory quantity at the time node of the inventory usage requirement according to the priority of the inventory usage requirement and the priority of the other inventory usage requirements;
[0031] An inventory adjustment module, configured to determine an inventory adjustment plan according to the situation of the updated available inventory quantity meeting the required quantity of the inventory usage requirement.
[0032] In a third aspect, an embodiment of the present application further provides an electronic device, including: a processor, a memory, and a bus, where the memory stores machine-readable instructions executable by the processor. When the electronic device runs, the processor communicates with the memory through the bus, and when the machine-readable instructions are run by the processor, the steps of the inventory adjustment method described above are executed.
[0033] In a fourth aspect, an embodiment of the present application further provides a computer-readable storage medium, on which a computer program is stored, and when the computer program is run by a processor, the steps of the inventory adjustment method described above are executed.
[0034] The method, device, electronic device, and readable storage medium for inventory adjustment provided by the embodiments of the present application obtain the inventory usage requirements, determine the time nodes, priorities, and required quantities of the inventory usage requirements; determine the inventory quantity available for use at the time node of the inventory usage requirements based on the outbound data and inbound data before the time node of the inventory usage requirements and other inventory usage requirements existing at the current time node; if the available inventory quantity is less than the required quantity of the inventory usage requirements, update the available inventory quantity at the time node of the inventory usage requirements according to the priorities of the inventory usage requirements and other inventory usage requirements; determine the inventory adjustment plan according to the situation of the updated available inventory quantity meeting the required quantity of the inventory usage requirements. In this way, adjusting the inventory according to the priorities of the requirements and updating the adjustment plan helps to improve the accuracy of inventory adjustment.
[0035] To make the above objects, features, and advantages of the present application more obvious and understandable, the following specifically enumerates preferred embodiments and, in conjunction with the accompanying drawings, makes a detailed description as follows. BRIEF DESCRIPTION OF THE DRAWINGS
[0036] To more clearly illustrate the technical solutions of the embodiments of the present application, the following briefly introduces the drawings required to be used in the embodiments. It should be understood that the following drawings only show some embodiments of the present application and should not be regarded as limiting the scope. For those of ordinary skill in the art, other related drawings can be obtained based on these drawings without creative efforts.
[0037] Figure 1 Shows a flowchart of an inventory adjustment method provided by an embodiment of the present application;
[0038] Figure 2 Shows a specific flowchart for determining the inventory quantity available for use at the time node of the inventory usage requirements in the inventory adjustment method provided by an embodiment of the present application;
[0039] Figure 3 Shows a specific flowchart for updating the inventory quantity available for use at the time node of the inventory usage requirements in the inventory adjustment method provided by an embodiment of the present application;
[0040] Figure 4 Shows a functional module diagram of an inventory adjustment device provided by an embodiment of the present application;
[0041] Figure 5 Shows a structural schematic diagram of an electronic device provided by an embodiment of the present application. DETAILED DESCRIPTION OF THE EMBODIMENTS
[0042] To make the objectives, technical solutions, and advantages of the embodiments of this application clearer, the technical solutions in the embodiments of this application will be clearly and completely described below with reference to the accompanying drawings in the embodiments of this application. Apparently, the described embodiments are only a part rather than all of the embodiments of this application. Components of the embodiments of this application usually described and illustrated in the accompanying drawings here can be arranged and designed in various different configurations. Therefore, the detailed description of the embodiments of this application provided in the accompanying drawings is not intended to limit the scope of the claimed application, but merely represents selected embodiments of this application. All other embodiments obtained by those skilled in the art based on the embodiments of this application without creative efforts fall within the scope of protection of this application.
[0043] To facilitate the understanding of this application, the technical solutions provided by this application will be described in detail below with reference to specific embodiments.
[0044] The embodiments of this application provide an inventory adjustment method, device, electronic device, and readable storage medium. By dynamically adjusting the inventory quantity available for use at the time node of the inventory use requirement according to the priority of the inventory use requirement and the priority of other inventory use requirements existing at the current time node, and formulating an inventory adjustment plan based on the adjusted available inventory quantity. In this way, adjusting the inventory according to the priority of the demand and updating the adjustment plan is beneficial to improving the accuracy of inventory adjustment and ensuring that the inventory use requirements are met on time.
[0045] Please refer to Figure 1 , Figure 1 which is a flowchart of an inventory adjustment method provided by the embodiments of this application. As Figure 1 shown, the inventory adjustment method provided by the embodiments of this application includes the following steps:
[0046] S101, obtain the inventory use requirement, and determine the time node of the inventory use requirement, the priority of the inventory use requirement, and the quantity of the inventory use requirement.
[0047] The embodiments of the present application are applied in an ERP system. The ERP system responds to the input operation of the user's inventory usage requirements or receives the inventory usage requirement information sent by other systems. Among them, the inventory usage requirement is the user's requirement for the quantity of inventory items at a certain time node, including information such as the time node of the inventory usage requirement, the priority of the inventory usage requirement, and the required quantity of the inventory usage requirement. The time node of the inventory usage requirement is the specific time when the inventory items need to be used. For example, the requirement received at 12:00 on November 1 indicates that 100 boxes of apples need to be delivered to the user at 14:00 on November 11. 12:00 on November 1 is the current time node, and 14:00 on November 11 is the time node of the inventory usage requirement; the priority of the inventory usage requirement is the requirement priority preset according to the actual situation such as the enterprise's production strategy and sales strategy, representing the importance of the inventory usage requirement. For example, the requirements put forward by important customers, the requirements with higher economic value, and the requirements with urgent time. The higher the priority, the more the inventory usage requirement needs to be satisfied first.
[0048] S102. Determine the available inventory quantity at the time node of the inventory usage requirement according to the outbound data and inbound data before the time node of the inventory usage requirement, and the data of other inventory usage requirements existing at the current time node.
[0049] In the embodiments of the present application, the outbound data before the time node of the inventory usage requirement includes the inventory data expected to be sold, the inventory data reserved as inventory, the inventory data planned for return, etc.; the inbound data before the time node of the inventory usage requirement includes the inventory data warehoused according to the production plan, the inventory data planned for procurement, the inventory data currently in transit after the procurement has been executed, etc. When allocating inventory data for a certain inventory usage requirement, the occupancy mark of the allocated inventory data will be recorded, indicating that this part of the inventory data is occupied by the inventory usage requirement and cannot be used as the inventory data allocated for subsequent inventory usage requirements. Therefore, when determining the available inventory quantity at the time node of the inventory usage requirement, it is necessary to consider the outbound data and inbound data before the time node of the inventory usage requirement, and the data of other inventory usage requirements existing at the current time node.
[0050] Specifically, the available inventory quantity at the time node of the inventory usage requirement can be statistically calculated by creating a calculation table, or can be calculated by other statistical methods, which are not specifically limited here. Here, the specific description of how to determine the available inventory quantity at the time node of the inventory usage requirement in the embodiments of the present application is given by adopting the method of creating a calculation table.
[0051] Specifically, when the user inputs the inventory usage demand at a certain time node, a calculation table is created to initiate the calculation of the available inventory quantity at the time node of the inventory usage demand.
[0052] First, sort the outbound data and inbound data before the time node of the inventory usage demand, as well as the inventory data occupied by other inventory usage demands existing at the current time node, in chronological order, and sequentially store the inventory quantities of each inventory data in the calculation table.
[0053] Then, according to the type of each inventory data, assign a negative sign to the inventory quantity of the inventory data of the outbound type in the calculation table, such as inventory data reserved as inventory, inventory data planned for return, inventory data occupied by other inventory usage demands, etc.
[0054] Finally, perform a signed summation of the outbound data and inbound data before the time node of the inventory usage demand, as well as the inventory data occupied by other inventory usage demands existing at the current time node, to calculate the available inventory quantity at the time node of the inventory usage demand.
[0055] S103, if the available inventory quantity is less than the required quantity of the inventory usage demand, update the available inventory quantity at the time node of the inventory usage demand according to the priority of the inventory usage demand and the priorities of other inventory usage demands.
[0056] In the embodiment of the present application, according to the calculation result in S102, if the calculated available inventory quantity at the time node of the inventory usage demand is still less than the required quantity of the inventory usage demand, it indicates that the available inventory at the time node of the inventory usage demand cannot meet the required quantity of the inventory usage demand. It is necessary to reallocate the inventory data occupied by other inventory usage demands according to the priority of this inventory usage demand and the priorities of other inventory usage demands, and calculate and update the available inventory quantity at the time node of the inventory usage demand according to the calculation method of the available inventory quantity at the time node of the inventory usage demand in S102.
[0057] S104, determine the inventory adjustment plan according to the situation where the updated available inventory quantity meets the required quantity of the inventory usage demand.
[0058] In the embodiments of the present application, the ERP system generates and outputs a corresponding inventory adjustment plan based on the situation where the updated available inventory quantity meets the input inventory usage requirements, and uses it as the basis for other business adjustments, so that the inventory usage requirements can be met at the time node of the inventory usage requirements after adjustment. Here, the inventory adjustment plan can be in the form of a report, including an inventory occupancy report, a delivery plan report, and a warehousing plan report. When the ERP system generates and outputs the corresponding inventory adjustment plan, it writes or updates the inventory adjustment data in the inventory occupancy report, the delivery plan report, and the warehousing plan report accordingly.
[0059] Please refer to Figure 2 , Figure 2 which is the specific flowchart for determining the available inventory quantity at the time node of the inventory usage requirements in the inventory adjustment method provided by the embodiments of the present application.
[0060] As Figure 2 shown, in the preferred solution of the embodiments of the present application, S102 specifically includes the following steps:
[0061] S1021, determine the available inventory quantity at the current time node according to the outbound data and inbound data before the current time node, and the data of other inventory usage requirements existing at the current time node;
[0062] S1022, if the available inventory quantity at the current time node is less than the required quantity of the inventory usage requirements, determine the available inventory quantity at the time node of the inventory usage requirements according to the available inventory quantity at the current time node, and the outbound data and inbound data from the current time node to the time node of the inventory usage requirements.
[0063] In the preferred solution of the embodiments of the present application, based on the calculation table created in step S102, the outbound data and inbound data before the current time node can be added with signs first to obtain the in-stock inventory quantity at the current time node, and then the in-stock inventory quantity at the current time node is added with signs to the inventory quantity of the inventory data occupied by other inventory usage requirements existing at the current time node to obtain the available inventory quantity at the current time node. Compare the available inventory quantity at the current time node with the required quantity of the input inventory usage requirements to determine whether the available inventory quantity at the current time node can meet the inventory usage requirements.
[0064] Here, the available inventory quantity at the current time node can be subtracted from the required quantity of the inventory usage requirements. If the calculation result is greater than or equal to 0, it means that the available inventory quantity at the current time node meets the inventory usage requirements, and the current in-stock inventory data can be directly allocated to the inventory usage requirements and an occupancy mark can be recorded for this part of the inventory data.
[0065] If the calculation result is less than 0, it indicates that the available inventory quantity at the current time node cannot meet the required quantity of the inventory usage demand. Then, the available inventory quantity at the current time node is added with the outgoing and incoming inventory data from the current time node to the time node of the inventory usage demand with signs to obtain the available inventory quantity at the time node of the inventory usage demand.
[0066] Please refer to Figure 3 , Figure 3 which is the specific flowchart for updating the available inventory quantity at the time node of the inventory usage demand in the inventory adjustment method provided by the embodiments of the present application.
[0067] As Figure 3 shown, in the preferred solution of the embodiments of the present application, S103 specifically includes the following steps:
[0068] S1031, sort other inventory usage demands in ascending order of priority, and delete the inventory usage demand with the lowest priority;
[0069] S1032, update the available inventory quantity at the time node of the inventory usage demand according to the outgoing and incoming inventory data before the time node of the inventory usage demand, and the data of other non-deleted inventory usage demands existing at the current time node.
[0070] In the preferred solution of the embodiments of the present application, if the available inventory quantity at the time node of the inventory usage demand is less than the required quantity of the inventory usage demand, sort other inventory usage demands existing at the current time node in ascending order of priority, and in the calculation table of step S102, delete the inventory quantity corresponding to the inventory data occupied by the inventory usage demand with the lowest priority. Then, add the outgoing and incoming inventory data before the time node of the inventory usage demand, and the inventory data occupied by other non-deleted inventory usage demands existing at the current time node with signs, and calculate to obtain the updated available inventory quantity at the time node of the inventory usage demand.
[0071] Here, since the inventory quantity corresponding to the inventory data occupied by the inventory usage demand is data with a negative sign in the calculation table, deleting this part of the data is equivalent to providing new inventory for the time node of the inventory usage demand.
[0072] As Figure 3 shown, in a possible implementation manner, after step S1032, the method further includes:
[0073] S1033. If the updated available inventory quantity is still less than the required quantity of the inventory usage requirement, delete the inventory usage requirement with the lowest priority among the other inventory usage requirements that have not been deleted until the updated available inventory quantity meets the required quantity of the inventory usage requirement, or until all the inventory usage requirements with priorities lower than that of the said inventory usage requirement are deleted, and end the process of updating the available inventory quantity.
[0074] In the embodiment of the present application, after deleting the inventory quantity of the inventory data occupied by the other inventory usage requirement with the lowest priority in the calculation table in S102, if the calculated available inventory quantity at the time node of the updated inventory usage requirement is still less than the required quantity of the inventory usage requirement, that is, it still cannot meet this inventory usage requirement, continue to delete the inventory quantity of the inventory data occupied by the other inventory usage requirement with the lowest priority in the calculation table, that is, delete the inventory quantity of the inventory data occupied by the inventory usage requirements with the two lowest priorities in the calculation table in S102. Then, perform a signed summation on the outbound data and inbound data before the time node of the inventory usage requirement, and the inventory data of the other existing inventory usage requirements at the current time node after deletion, and calculate the updated available inventory quantity at the time node of the inventory usage requirement. And so on, until it is calculated that the updated available inventory quantity is greater than or equal to the required quantity of the inventory usage requirement, that is, the updated available inventory quantity meets the required quantity of this inventory usage requirement; or until it is calculated that all the other inventory usage requirements with priorities lower than that of this inventory usage requirement are deleted, and end the calculation process of updating the available inventory quantity.
[0075] As Figure 3 shown, in a possible implementation manner, after step S1033, the method further includes:
[0076] S1034. If the updated available inventory quantity is still less than the said inventory usage requirement, delete the inventory usage requirement with the same priority as the said inventory usage requirement and with the last time node according to the sequence of time nodes.
[0077] S1035. Update the available inventory quantity at the time node of the said inventory usage requirement. If the updated available inventory quantity is still less than the required quantity of the inventory usage requirement, continue to delete the inventory usage requirement with the same priority as the said inventory usage requirement and with the last time node among the other inventory usage requirements that have not been deleted until the updated available inventory quantity meets the required quantity of the inventory usage requirement, or until all the inventory usage requirements with the same priority as the said inventory usage requirement after the time node of the said inventory usage requirement are deleted, and end the process of updating the available inventory quantity.
[0078] In the embodiment of the present application, after all other inventory usage requirements with priorities below the priority of the inventory usage requirement in the calculation table in S102 are deleted, if the available inventory quantity at the time node of the calculated updated inventory usage requirement is still less than the required quantity of the inventory usage requirement, other inventory usage requirements with the same priority as this inventory usage requirement are considered at this time. Since other inventory usage requirements with the same priority as this inventory usage requirement and with time nodes after this inventory usage requirement can be satisfied later relative to this inventory usage requirement, which is equivalent to being lower than the priority of this inventory usage requirement in terms of the priority at the time node. Therefore, in the calculation table, the inventory quantities of the inventory data occupied by other inventory usage requirements with the same priority as this inventory usage requirement and with time nodes after this inventory usage requirement are sequentially deleted in the order from the later time node to the earlier time node until the calculated available inventory quantity after update is greater than or equal to the required quantity of the inventory usage requirement; or until all inventory usage requirements with the same priority as this inventory usage requirement after the time node of this inventory usage requirement are deleted, the calculation process of updating the available inventory quantity ends.
[0079] As Figure 3 shown, in a possible implementation manner, after step S1035, the method further includes:
[0080] S1036, if after all inventory usage requirements with the same priority as the inventory usage requirement after the time node of the inventory usage requirement are deleted, the updated available inventory quantity is still less than the required quantity of the inventory usage requirement, restore all the deleted inventory usage requirements, and determine an inventory adjustment plan according to the situation of satisfying the required quantity of the inventory usage requirement with the available inventory quantity at the time node of the inventory usage requirement before the update.
[0081] In the embodiment of the present application, after all inventory usage requirements with the same priority as the inventory usage requirement after the time node of the inventory usage requirement are deleted, if the updated available inventory quantity is still less than the required quantity of the inventory usage requirement, it indicates that no matter how the available inventory quantity at the time node of the inventory usage requirement is adjusted based on the priority relationship between the inventory usage requirements, this inventory usage requirement cannot be met at the time node of this inventory usage requirement. In this case, adjusting other inventory usage requirements will not play a substantial role in improving inventory usage efficiency. Therefore, directly determine the inventory adjustment plan according to the situation of whether the available inventory quantity at the time node of the inventory usage requirement before the update can meet the required quantity of the inventory usage requirement. Other business systems adjust the inventory allocation, generate delivery plans, or formulate new warehousing plans according to the inventory adjustment plan, so that the inventory usage requirement can be met at the time node of the inventory usage requirement after the adjustment.
[0082] In the preferred solution of the embodiment of the present application, S104 specifically includes the following steps:
[0083] If the updated available inventory quantity meets the required quantity of the inventory usage requirement, determine the inventory allocation plan according to the situation of the in-stock inventory at the current time node meeting the inventory usage requirement; determine the inbound delivery plan according to the situation of the inbound data after the current time node meeting the inventory usage requirement;
[0084] If the updated available inventory quantity is still less than the required quantity of the inventory usage requirement, after determining the inventory allocation plan and the inbound delivery plan, determine the inbound replenishment plan according to the difference between the required quantity of the inventory usage requirement and the available inventory quantity before the update.
[0085] In the embodiment of the present application, if the available inventory quantity at the current time node meets the required quantity of the inventory usage requirement, allocate the in-stock inventory data at the current time node for the inventory usage requirement and record the occupancy mark, and write the allocated in-stock inventory data for the inventory usage requirement into the inventory occupancy report;
[0086] If the available inventory quantity at the current time node partially meets the inventory usage requirement, allocate the in-stock inventory data at the current time node for the inventory usage requirement and record the occupancy mark, write the allocated in-stock inventory data for the inventory usage requirement into the inventory occupancy report, and at the same time sum up the inventory quantities of the unoccupied inbound data from the current time node to the time node of the inventory usage requirement item by item, allocate inventory data for the part of the data of the available inventory quantity at the current time node that does not meet the inventory usage requirement and record the occupancy mark, and write the inbound data from the current time node to the time node of the inventory usage requirement allocated for the inventory usage requirement into the delivery plan report;
[0087] If the quantity of inventory available at the time node of the inventory usage requirement still does not meet the required quantity of the inventory usage requirement, allocate the in-stock inventory data of the current time node for the inventory usage requirement and record the occupancy mark, write the allocated in-stock inventory data for the inventory usage requirement into the inventory occupancy report, and at the same time sum up the quantity of the unoccupied inbound data from the current time node to the time node of the inventory usage requirement item by item. Allocate inventory data for the part of the data where the quantity of inventory available at the current time node does not meet the inventory usage requirement and record the occupancy mark, and write the inbound data from the current time node to the time node of the inventory usage requirement allocated for the inventory usage requirement into the delivery plan report; determine the remaining unmet required quantity of the inventory usage requirement, and use the remaining unmet required quantity of the inventory usage requirement as the replenishment plan and write it into the inbound plan report.
[0088] Further, in a possible implementation manner, after step S104, the method further includes:
[0089] If the updated available inventory quantity meets the required quantity of the inventory usage requirement, after determining the inventory adjustment plan, obtain the deleted inventory usage requirements one by one in the order from highest to lowest priority and, for the same priority, from earliest to latest time node; determine the available inventory quantity at the time node of the deleted inventory usage requirement according to the outbound data and inbound data before the time node of the deleted inventory usage requirement, and the data of other undeleted inventory usage requirements existing at the current time node; update the inventory adjustment plan of the deleted inventory usage requirement according to the situation where the available inventory quantity meets the required quantity of the deleted inventory usage requirement.
[0090] In the embodiment of the present application, after generating the inventory adjustment plan by allocating inventory for the currently input inventory usage requirement according to the priority, determine and update the inventory adjustment plan for other inventory usage requirements deleted when updating the available inventory quantity in the order of steps S101 to S104. Specifically, determine the inventory adjustment plan of the deleted inventory usage requirements in the order from highest to lowest priority and, for the same priority, from earliest to latest time node, and update the corresponding inventory adjustment data of the deleted inventory usage requirements in the inventory occupancy report, delivery plan report, and inbound plan report.
[0091] An embodiment of the present application provides an inventory adjustment method. By obtaining the inventory usage requirements, the time node, priority, and required quantity of the inventory usage requirements are determined; according to the outbound data and inbound data before the time node of the inventory usage requirements, and other inventory usage requirements existing at the current time node, the inventory quantity available for use at the time node of the inventory usage requirements is determined; if the available inventory quantity is less than the required quantity of the inventory usage requirements, according to the priority of the inventory usage requirements and the priority of other inventory usage requirements, the inventory quantity available for use at the time node of the inventory usage requirements is updated; according to the situation where the updated available inventory quantity meets the required quantity of the inventory usage requirements, an inventory adjustment plan is determined. In this way, adjusting the inventory according to the priority of the requirements and updating the adjustment plan is beneficial to improving the accuracy of inventory adjustment and ensuring that the inventory usage requirements are met on time.
[0092] Please refer to Figure 4 , Figure 4 which is a functional module diagram of an inventory adjustment device 400 provided by an embodiment of the present application. As Figure 4 shown, the inventory adjustment device 400 includes:
[0093] An acquisition module 410, configured to obtain inventory usage requirements, and determine the time node, priority, and required quantity of the inventory usage requirements;
[0094] A first determination module 420, configured to determine the inventory quantity available for use at the time node of the inventory usage requirements according to the outbound data and inbound data before the time node of the inventory usage requirements, and the data of other inventory usage requirements existing at the current time node;
[0095] A second determination module 430, configured to, if the available inventory quantity is less than the required quantity of the inventory usage requirements, update the inventory quantity available for use at the time node of the inventory usage requirements according to the priority of the inventory usage requirements and the priority of the other inventory usage requirements;
[0096] An inventory adjustment module 440, configured to determine an inventory adjustment plan according to the situation where the updated available inventory quantity meets the required quantity of the inventory usage requirements.
[0097] Further, when the first determination module 420 is used to determine the inventory quantity available for use at the time node of the inventory usage requirements according to the outbound data and inbound data before the time node of the inventory usage requirements, and the data of other inventory usage requirements existing at the current time node, the first determination module 420 is specifically configured to:
[0098] Determine the available inventory quantity at the current time node based on the outbound data and inbound data before the current time node, and the data of other inventory usage requirements existing at the current time node;
[0099] If the available inventory quantity at the current time node is less than the required quantity of the inventory usage requirement, determine the available inventory quantity at the time node of the inventory usage requirement based on the available inventory quantity at the current time node, and the outbound data and inbound data from the current time node to the time node of the inventory usage requirement.
[0100] Further, when the second determination module 430 is used to update the available inventory quantity at the time node of the inventory usage requirement according to the priority of the inventory usage requirement and the priority of the other inventory usage requirements, the second determination module 430 is specifically used for:
[0101] Sort the other inventory usage requirements in ascending order of priority, and delete the inventory usage requirement with the lowest priority;
[0102] Update the available inventory quantity at the time node of the inventory usage requirement according to the outbound data and inbound data before the time node of the inventory usage requirement, and the data of the other inventory usage requirements that have not been deleted and exist at the current time node.
[0103] In a possible implementation manner, the second determination module 430 is further used for:
[0104] If the updated available inventory quantity is still less than the required quantity of the inventory usage requirement, delete the inventory usage requirement with the lowest priority among the other inventory usage requirements that have not been deleted until the updated available inventory quantity meets the required quantity of the inventory usage requirement, or until all the inventory usage requirements with priorities lower than the priority of the inventory usage requirement are deleted, and end the process of updating the available inventory quantity.
[0105] In a possible implementation manner, the second determination module 430 is further used for:
[0106] If the updated available inventory quantity is still less than the inventory usage requirement, delete the inventory usage requirement with the same priority as the inventory usage requirement and with the last time node in the order of time nodes;
[0107] Update the inventory quantity available at the time node of the inventory usage requirement. If the updated available inventory quantity is still less than the required quantity of the inventory usage requirement, continue to delete the inventory usage requirement with the same priority as the inventory usage requirement and the latest time node among the other non-deleted inventory usage requirements until the updated available inventory quantity meets the required quantity of the inventory usage requirement, or until all the inventory usage requirements with the same priority as the inventory usage requirement after the time node of the inventory usage requirement are deleted, and then end the process of updating the available inventory quantity.
[0108] In a possible implementation manner, the second determination module 430 is further configured to:
[0109] If, after all the inventory usage requirements with the same priority as the inventory usage requirement after the time node of the inventory usage requirement are deleted, the updated available inventory quantity is still less than the required quantity of the inventory usage requirement, restore all the deleted inventory usage requirements, and determine an inventory adjustment plan according to the situation of whether the available inventory quantity before the update at the time node of the inventory usage requirement meets the required quantity of the inventory usage requirement.
[0110] Further, when the inventory adjustment module 440 is used to determine an inventory adjustment plan according to the situation of whether the updated available inventory quantity meets the required quantity of the inventory usage requirement, the inventory adjustment module 440 is specifically configured to:
[0111] If the updated available inventory quantity meets the required quantity of the inventory usage requirement, determine an inventory allocation plan according to the situation of whether the in-stock inventory at the current time node meets the inventory usage requirement; determine an inbound delivery plan according to the situation of whether the inbound data after the current time node meets the inventory usage requirement;
[0112] If the updated available inventory quantity is still less than the required quantity of the inventory usage requirement, after determining the inventory allocation plan and the inbound delivery plan, determine an inbound replenishment plan according to the difference between the required quantity of the inventory usage requirement and the available inventory quantity before the update.
[0113] In a possible implementation manner, the inventory adjustment module 440 is further configured to:
[0114] If the updated available inventory quantity meets the required quantity of the inventory usage demand, after determining the inventory adjustment plan, obtain the deleted inventory usage demands one by one in descending order of priority and, for the same priority, in the order from the earliest to the latest time node; based on the outbound data and inbound data before the time node of the deleted inventory usage demand, and the data of other non-deleted inventory usage demands existing at the current time node, determine the available inventory quantity at the time node of the deleted inventory usage demand; according to the situation where the available inventory quantity meets the required quantity of the deleted inventory usage demand, update the inventory adjustment plan of the deleted inventory usage demand.
[0115] An embodiment of the present application provides an inventory adjustment device, which obtains inventory usage demands, determines the time node, priority, and required quantity of the inventory usage demands; based on the outbound data and inbound data before the time node of the inventory usage demand, and other inventory usage demands existing at the current time node, determines the available inventory quantity at the time node of the inventory usage demand; if the available inventory quantity is less than the required quantity of the inventory usage demand, updates the available inventory quantity at the time node of the inventory usage demand according to the priority of the inventory usage demand and the priorities of other inventory usage demands; determines the inventory adjustment plan according to the situation where the updated available inventory quantity meets the required quantity of the inventory usage demand. In this way, adjusting the inventory according to the priority of the demand and updating the adjustment plan is beneficial to improving the accuracy of inventory adjustment and ensuring that the inventory usage demands are met on time.
[0116] Please refer to Figure 5 , Figure 5 which is a schematic structural diagram of an electronic device provided by an embodiment of the present application. As Figure 5 shown in
[0117] The memory 520 stores machine-readable instructions executable by the processor 510. When the electronic device 500 runs, the processor 510 communicates with the memory 520 through the bus 530. When the machine-readable instructions are run by the processor 510, they execute the steps of the inventory adjustment method provided in the above embodiment. The specific implementation manner can refer to the method embodiment and will not be elaborated here.
[0118] An embodiment of the present application further provides a computer-readable storage medium, on which a computer program is stored. When the computer program is run by a processor, it executes the steps of the inventory adjustment method provided in the above embodiment. The specific implementation manner can refer to the method embodiment and will not be elaborated here.
[0119] Those skilled in the art can clearly understand that for the convenience and brevity of description, the specific working processes of the above-described devices and units can refer to the corresponding processes in the foregoing method embodiments and will not be elaborated herein.
[0120] In the embodiments provided in the present application, it should be understood that the disclosed devices and methods can be implemented in other ways. The device embodiments described above are merely illustrative. For example, the division of the units is only a logical function division, and there may be other division methods in actual implementation. For another example, multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the couplings or direct couplings or communication connections shown or discussed with each other can be through some communication interfaces. The indirect couplings or communication connections of the devices or units can be in electrical, mechanical or other forms.
[0121] The units described as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, that is, they can be located in one place or distributed to multiple network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of this embodiment.
[0122] In addition, each functional unit in the embodiments provided in the present application can be integrated in a processing unit, or each unit can exist physically alone, or two or more units can be integrated in one unit.
[0123] If the functions are implemented in the form of software function units and sold or used as independent products, they can be stored in a computer-readable storage medium. Based on such an understanding, the technical solution of the present application, in essence, or the part that contributes to the prior art or part of this technical solution can be embodied in the form of a software product. The computer software product is stored in a storage medium and includes several instructions for causing a computer device (which can be a personal computer, a server, or a network device, etc.) to execute all or part of the steps of the methods described in the various embodiments of the present application. The foregoing storage medium includes: various media such as USB flash drives, mobile hard disks, read-only memories (ROM, Read-Only Memory), random access memories (RAM, Random Access Memory), magnetic disks, or optical discs that can store program codes.
[0124] It should be noted that like reference numerals and letters denote like items in the following drawings. Therefore, once an item is defined in one drawing, it does not need to be further defined and explained in subsequent drawings. In addition, the terms "first", "second", "third", etc. are only used for descriptive distinction and should not be construed as indicating or implying relative importance.
[0125] Finally, it should be noted that the above-described embodiments are only specific embodiments of the present application, used to illustrate the technical solutions of the present application, rather than limiting it. The protection scope of the present application is not limited thereto. Although the present application has been described in detail with reference to the foregoing embodiments, those of ordinary skill in the art should understand that any person skilled in the art within the technical scope disclosed by the present application can still modify the technical solutions recorded in the foregoing embodiments or can easily think of changes, or make equivalent replacements for some of the technical features; and these modifications, changes or replacements do not cause the essence of the corresponding technical solutions to deviate from the spirit and scope of the technical solutions of the embodiments of the present application. All should be covered within the protection scope of the present application. Therefore, the protection scope of the present application shall be subject to the protection scope of the claims.
Claims
1. An inventory adjustment method, characterized in that, the inventory adjustment method includes: Obtaining the inventory usage requirements, determining the time node of the inventory usage requirements, the priority of the inventory usage requirements, and the required quantity of the inventory usage requirements; Determining the available inventory quantity at the time node of the inventory usage requirements based on the outbound data and inbound data before the time node of the inventory usage requirements, and the data of other inventory usage requirements existing at the current time node; If the available inventory quantity is less than the required quantity of the inventory usage requirements, updating the available inventory quantity at the time node of the inventory usage requirements according to the priority of the inventory usage requirements and the priority of the other inventory usage requirements; Determining an inventory adjustment plan based on the situation where the updated available inventory quantity meets the required quantity of the inventory usage requirements.
2. The inventory adjustment method according to claim 1, characterized in that, the step of determining the available inventory quantity at the time node of the inventory usage requirements based on the outbound data and inbound data before the time node of the inventory usage requirements, and the data of other inventory usage requirements existing at the current time node includes: Determining the available inventory quantity at the current time node based on the outbound data and inbound data before the current time node, and the data of other inventory usage requirements existing at the current time node; If the available inventory quantity at the current time node is less than the required quantity of the inventory usage requirements, determining the available inventory quantity at the time node of the inventory usage requirements based on the available inventory quantity at the current time node, and the outbound data and inbound data from the current time node to the time node of the inventory usage requirements.
3. The inventory adjustment method according to claim 1, characterized in that, the step of updating the available inventory quantity at the time node of the inventory usage requirements according to the priority of the inventory usage requirements and the priority of the other inventory usage requirements includes: Sorting the other inventory usage requirements in ascending order of priority, and deleting the inventory usage requirement with the lowest priority; Updating the available inventory quantity at the time node of the inventory usage requirements based on the outbound data and inbound data before the time node of the inventory usage requirements, and the data of the remaining other inventory usage requirements that have not been deleted and exist at the current time node.
4. The inventory adjustment method according to claim 3, characterized in that, the inventory adjustment method further includes: If the updated available inventory quantity is still less than the required quantity of the inventory usage requirements, deleting the inventory usage requirement with the lowest priority among the remaining other inventory usage requirements that have not been deleted, until the updated available inventory quantity meets the required quantity of the inventory usage requirements, or until all the inventory usage requirements with priorities lower than the priority of the inventory usage requirements are deleted, and ending the process of updating the available inventory quantity.
5. The inventory adjustment method according to claim 4, characterized in that, After all inventory usage requirements with priorities below the priority of the inventory usage requirements are deleted, the inventory adjustment method further includes: If the updated available inventory quantity is still less than the inventory usage requirement, delete, in the order of the time nodes, the inventory usage requirements with the same priority as the inventory usage requirement and with the last time node; Update the available inventory quantity at the time node of the inventory usage requirement. If the updated available inventory quantity is still less than the required quantity of the inventory usage requirement, continue to delete the inventory usage requirements with the same priority as the inventory usage requirement and with the last time node among the other non-deleted inventory usage requirements until the updated available inventory quantity meets the required quantity of the inventory usage requirement, or until all inventory usage requirements with the same priority as the inventory usage requirement after the time node of the inventory usage requirement are deleted, and end the process of updating the available inventory quantity.
6. The inventory adjustment method according to claim 5, characterized in that After all inventory usage requirements with the same priority as the inventory usage requirement after the time node of the inventory usage requirement are temporarily deleted, the inventory adjustment method further includes: If, after all inventory usage requirements with the same priority as the inventory usage requirement after the time node of the inventory usage requirement are deleted, the updated available inventory quantity is still less than the required quantity of the inventory usage requirement, restore all the deleted inventory usage requirements, and determine an inventory adjustment plan according to whether the available inventory quantity at the time node of the inventory usage requirement before the update meets the required quantity of the inventory usage requirement.
7. The inventory adjustment method according to claim 1, characterized in that Determining an inventory adjustment plan according to whether the updated available inventory quantity meets the required quantity of the inventory usage requirement includes: If the updated available inventory quantity meets the required quantity of the inventory usage requirement, determine an inventory allocation plan according to the situation of the in-stock inventory at the current time node meeting the inventory usage requirement; determine an inbound delivery plan according to the situation of the inbound data after the current time node meeting the inventory usage requirement; If the updated available inventory quantity is still less than the required quantity of the inventory usage requirement, after determining the inventory allocation plan and the inbound delivery plan, determine an inbound replenishment plan according to the difference between the required quantity of the inventory usage requirement and the available inventory quantity before the update.
8. An inventory adjustment device, characterized in that The inventory adjustment device includes: An acquisition module for acquiring inventory usage requirements, determining the time node of the inventory usage requirement, the priority of the inventory usage requirement, and the required quantity of the inventory usage requirement; A first determination module, configured to determine the inventory quantity available for use at the time node of the inventory usage requirement according to the outbound data and inbound data before the time node of the inventory usage requirement, and the data of other inventory usage requirements existing at the current time node; A second determination module, configured to, if the available inventory quantity is less than the required quantity of the inventory usage requirement, update the available inventory quantity at the time node of the inventory usage requirement according to the priority of the inventory usage requirement and the priority of the other inventory usage requirements; An inventory adjustment module, configured to determine an inventory adjustment plan according to the situation where the updated available inventory quantity meets the required quantity of the inventory usage requirement.
9. An electronic device, characterized in that, it includes: a processor, a memory and a bus, where the memory stores machine-readable instructions executable by the processor. When the electronic device runs, communication is carried out between the processor and the memory through the bus. When the machine-readable instructions are run by the processor, the steps of the inventory adjustment method according to any one of claims 1 to 7 are executed.
10. A computer-readable storage medium, characterized in that, a computer program is stored on the computer-readable storage medium, and when the computer program is run by a processor, the steps of the inventory adjustment method according to any one of claims 1 to 7 are executed.