Search

CN-122022695-A - Sales order intelligent merging delivery method and system

CN122022695ACN 122022695 ACN122022695 ACN 122022695ACN-122022695-A

Abstract

The invention relates to the technical field of enterprise informatization management, in particular to an intelligent sales order merging and delivery method and system; the method comprises the steps of obtaining a candidate sales order set, extracting a plurality of logistics service attributes of each order, determining grouping identification based on a combination value of the attributes, classifying orders with the same grouping identification into the same order grouping, arranging order rows in ascending order according to a combination of sales certificate creation date and sales certificate number in each order grouping, sequentially simulating and deducting the current available quantity of each material, marking the order rows as full distribution or insufficient inventory, generating an inventory distribution result of each order grouping, generating and submitting a delivery note in batches after receiving a confirmation instruction, and executing fusing and rollback on the grouping when submitting fails, wherein other groupings are not affected.

Inventors

  • HUANG JING
  • ZHANG HAIFENG

Assignees

  • 广东弗我智能制造有限公司

Dates

Publication Date
20260512
Application Date
20260320

Claims (10)

  1. 1. The intelligent combined delivery method for the sales order is characterized by comprising the following steps of: acquiring a candidate sales order set from a service management system through a service management system interface; Extracting a plurality of logistics business attributes for determining the combination compatibility of the delivery orders for each order in the candidate sales order set, determining the grouping identification of each order based on the combination value of the plurality of logistics business attributes, and classifying the orders with the same grouping identification into the same order grouping to obtain a plurality of order groupings; In each order group, the order lines in the order group are arranged in ascending order according to the combination of the sales certificate creation date and the sales certificate number to obtain the current available quantity corresponding to each material identifier, the current available quantity is simulated and deducted from each arranged order line, the current available quantity is reduced along with the sequential deduction operation, the residual quantity is the available quantity allowance, when the required quantity of a certain order line does not exceed the available quantity allowance of the corresponding material identifier, the order line is marked as full allocation and deducted from the corresponding available quantity allowance, when the required quantity of a certain order line exceeds the available quantity allowance of the corresponding material identifier, the order line is marked as stock shortage, the arrangement and the simulated deduction operation are repeatedly executed on each order group, and the stock allocation result of the order group is generated after all order lines are processed, so as to obtain the stock allocation result of each order group; And presenting previews of inventory allocation results of the order groups to an operation interface, generating delivery orders in batches according to the inventory allocation results of the order groups after receiving a confirmation instruction, submitting the delivery orders to the service management system through the service management system interface, stopping submitting subsequent delivery orders in an order group and canceling completed submitting operations in the order group when the delivery orders in the order group fail to be submitted, and wherein the submitting operations of other order groups are not affected.
  2. 2. The intelligent merge delivery method of sales orders according to claim 1, wherein after obtaining the candidate sales order sets through the service management system interface and before classifying the orders in the candidate sales order sets into each order group, pre-checking is performed on each order in the candidate sales order sets, the pre-checking includes a status check and a credit check, wherein the status check eliminates the order with the status of closed, frozen or in the approval process from the candidate sales order sets, the credit check inquires the credit line use condition of a customer to which each order belongs in real time through the service management system interface, the order with the credit line overrun is eliminated from the candidate sales order sets, and the retained order after the pre-checking participates in the subsequent grouping operation.
  3. 3. The method of claim 1, wherein the plurality of physical distribution attributes include a seller identifier, a sender identifier, a shipping point identifier, international trade terms, payment terms, and a means of transportation, and wherein the group identifier is obtained by performing a hash operation on a combined value of the seller identifier, the sender identifier, the shipping point identifier, the international trade terms, the payment terms, and the means of transportation.
  4. 4. The sales order intelligent merge delivery method as set forth in claim 1, wherein after placing orders with the same group identification into the same order group, a delivery date alignment process is further performed on the orders in each order group, the delivery date alignment process selecting one of a strict alignment mode and a tolerance alignment mode for execution, dividing orders with incomplete delivery dates within the same order group into independent sub-groups by respective delivery dates in the strict alignment mode, reading a preset tolerance days parameter in the tolerance alignment mode, holding orders with the absolute value of the difference between the delivery date of each order and the earliest delivery date not exceeding the tolerance days parameter in the same order group based on the earliest delivery date in all orders within the order group, taking the earliest delivery date or the latest delivery date in the order group as the unified delivery date of the order group, outputting the order identifications influenced by the alignment processing of the delivery dates and the adjustment directions corresponding to the order identifications to the operation interface, wherein the tolerance days parameter supports three granularity independent setting of system-level global configuration, client-level configuration and material-level configuration, the system-level global configuration uniformly takes effect on all client identifications and material identifications, the client-level configuration independently sets tolerance days for specific client identifications, the material-level configuration independently sets tolerance days for specific material identifications, and takes effect with the material-level configuration when the same order line is simultaneously applicable to the client-level configuration and the material-level configuration.
  5. 5. The intelligent merge delivery method of sales orders according to claim 1, wherein the partial delivery process, skip process or wait process is performed on the order line marked as inventory shortage, wherein the partial delivery process uses available quantity allowance corresponding to material identification as actual allocation quantity of the order line, uses the difference between the required quantity of the order line and the actual allocation quantity as the stock shortage quantity of the order line, and continues to perform simulated deduction on the next order line, the skip process does not allocate any available quantity on the order line, continues to perform simulated deduction on the next order line, and the wait process does not allocate any available quantity on the order line, marks the order line as to-be-restocked state, and does not perform simulated deduction on the subsequent order line under the material identification corresponding to the order line.
  6. 6. The intelligent sales order merge delivery method as set forth in claim 5, wherein for order lines with an order quantity after the partial shipment process, an order line with the partial shipment process and an order line with the skip process are separately displayed with different visual identifications, the order line with the partial shipment process simultaneously displays the actual allocation quantity and the order quantity after the delivery order is submitted to the service management system and a notification message including an order identification list and the corresponding order quantity is sent to a preset notification channel.
  7. 7. The intelligent sales order merging and delivery method as set forth in claim 1, wherein the preview of the inventory allocation result of each order group at least includes the number of the delivery orders to be generated, the detail of the order lines included in each delivery order, the inventory allocation status corresponding to each order line, the order identification and the corresponding reject cause removed by the pre-verification, and after receiving the confirmation instruction, the whole delivery orders in the order group are submitted in units of the same order group, and the whole delivery orders in the same order group are submitted successfully or not submitted in units.
  8. 8. The sales order intelligent merge delivery method as set forth in claim 1, wherein when a delivery form in a certain order group fails to be submitted, a revocation request for the submitted delivery form in the order group is sent to the service management system, the status of all relevant records in the order group is updated as the submission failure in the middle layer data storage, and alarm information including the failure group identification, the failure reason and the affected delivery form list is output to the operation interface.
  9. 9. The sales order intelligent merge delivery method as set forth in claim 1, wherein when said simulated deduction is performed in each order group, the ranking and simulated deduction are performed independently for each material identification by an order action minimization processing unit, and each material identification in the inventory allocation results of each order group corresponds to an independent delivery line.
  10. 10. A sales order intelligent consolidated delivery system, comprising: The business management system interface module is used for connecting a business management system and exchanging data with the business management system; The dynamic grouping module is configured to acquire a candidate sales order set from the service management system through the service management system interface module, extract a plurality of logistics service attributes for determining the combination compatibility of the delivery orders for each order in the candidate sales order set, determine the grouping identification of each order based on the combination value of the plurality of logistics service attributes, and classify the orders with the same grouping identification into the same order grouping to obtain a plurality of order groupings; the inventory simulation distribution module is configured to arrange order lines in order groups in ascending order according to the combination of the sales certificate creation date and the sales certificate number in each order group, obtain the current available quantity corresponding to each material identifier, simulate deduction of the current available quantity for each order line in sequence, the current available quantity is reduced along with the sequential deduction operation, the residual quantity is available quantity allowance, the order lines with the required quantity not exceeding the available quantity allowance of the corresponding material identifier are marked as full distribution and deduction of the corresponding available quantity allowance, the order lines with the required quantity exceeding the available quantity allowance of the corresponding material identifier are marked as inventory shortage, the arrangement and the simulated deduction operation are repeatedly executed for each order group, and an inventory distribution result of the order group is generated after all order lines are completely ordered, so that an inventory distribution result of each order group is obtained; And the delivery form execution module is configured to present the preview of the inventory allocation result of each order form group to the operation interface, execute integral submission of all delivery forms in the order form group by taking the same order form group as a unit after receiving a confirmation instruction, send a cancel request to the service management system when the delivery form in one order form group fails to be submitted so as to cancel the completed submit operation in the order form group and stop the submit of the subsequent delivery forms in the order form group, and the submit operation of other order form groups is not affected.

Description

Sales order intelligent merging delivery method and system Technical Field The invention relates to the technical field of enterprise informatization management, in particular to an intelligent sales order merging and delivery method and system. Background In the sales execution link of the manufacturing industry, the same customer often places a plurality of sales orders at different times, and enterprises usually combine the plurality of sales orders into the same batch for delivery together, so as to reduce the cost of the logistics and reduce the delivery pressure. However, in achieving the above objective in the context of a business management system (e.g., an enterprise resource planning system), the following problems are prevalent in the prior art: 1. Business personnel need to inquire the deliverable quantity of each sales order one by one in a business management system, manually screen, calculate and create delivery orders one by one, the operation steps are complex, the time consumption is remarkable, and the operation efficiency is low. In addition, since business management systems typically allow a sales order to create a delivery order in multiple batches, automatic consolidation is more difficult to achieve when multiple orders are handled in batches. 2. When multiple sales orders are combined into the same delivery order, it is often necessary that the physical distribution business attributes such as the seller, the sender, the shipping point, the international trade terms, the payment terms and the transportation mode between the orders remain consistent, and the party can complete the combining operation in the business management system. The prior art lacks a means for carrying out systematic compatibility verification on the attributes before merging, relies on manual comparison one by one, is extremely easy to miss, causes missing merging boundary judgment, and causes merging failure or receipt error. 3. The existing order batch processing scheme only supports filtering according to a single dimension, can not automatically match the order combination meeting the requirements according to the dynamically configured conditions, has insufficient condition screening flexibility, and is difficult to adapt to complex actual business scenes such as specific order elimination, purchase order range limitation, material range limitation and the like. 4. Manual operations cannot determine the delivery priority of each order strictly in terms of the chronological order in which the order was entered, there is a large risk in the scenario where there is a compliance requirement or inventory accounting requirement for the order of shipment, it is difficult to guarantee first-in first-out. 5. When a plurality of delivery orders are generated and submitted in batches, if partial failure occurs in the middle, the prior art is difficult to effectively control the failure range, and incomplete combined delivery orders with inconsistent quantity with the data of the service management system can be generated, the batch execution lacks safety guarantee, and high cost of subsequent check and error correction is easily caused. Therefore, a technical solution capable of automatically determining order merge compatibility, fully previewing inventory allocation process before formal submission, and providing grouping level exception isolation capability during batch execution is needed to overcome the above-mentioned drawbacks. Disclosure of Invention The invention aims to provide an intelligent sales order merging and delivery method and system, which are used for solving the technical problems of missing merging boundary judgment, lack of advance previewing of inventory allocation, insufficient abnormal isolation capability of batch execution and the like in the prior art. To achieve the purpose, the invention adopts the following technical scheme: in a first aspect, the present invention provides a sales order intelligent consolidated delivery method comprising the steps of: S1, acquiring a candidate sales order set from a service management system through a service management system interface; S2, extracting a plurality of logistics business attributes for determining the combination compatibility of the delivery orders for each order in the candidate sales order set, determining the grouping identification of each order based on the combination value of the plurality of logistics business attributes, and classifying the orders with the same grouping identification into the same order grouping to obtain a plurality of order groupings; S3, in each order group, the order lines in the order group are arranged in an ascending order according to the combination of the creation date of the sales certificate and the sales certificate number, the current available quantity corresponding to each material identifier is obtained, the current available quantity is simulated and deducted for each ordered line after