A method, apparatus, electronic device, and storage medium for canceling a purchase order.
By automating the purchase order cancellation process, the cancellation volume is allocated according to order type and priority, and a purchase order to be cancelled is generated and sent to the supplier. This solves the problem of high cost and low efficiency caused by traditional manual operation and achieves efficient inventory management.
Patent Information
- Application Number
- CN202210447008.7
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2022-04-26
- Publication Date
- 2025-12-02
- Estimated Expiration
- 2042-04-26
AI Technical Summary
Traditional methods for canceling futures orders rely heavily on manual operations, resulting in high labor costs and low work efficiency, especially when retail companies frequently cancel small orders, leading to excessively high communication costs.
By determining the quantity of futures orders to be cancelled, the corresponding resource pool is located, and the orders are allocated to unclaimed orders, shared orders, and normal orders according to priority. A proposed cancellation purchase plan is then generated and finally sent to the target supplier for negotiation on cancellation.
It reduced the frequency of communication with suppliers, lowered labor costs, improved work efficiency, and optimized inventory management.
Smart Images

Figure CN114781970B_ABST
Abstract
Description
Technical Field
[0001] This invention relates to the field of order processing technology, and in particular to a method, apparatus, electronic device, and storage medium for canceling a purchase order. Background Technology
[0002] Reducing inventory and minimizing warehouse stockpiling have always been research topics for enterprises. If goods are produced or purchased blindly without understanding the true market demand, there may be a backlog of inventory and unsold goods, which in turn leads to a decrease in inventory turnover and an increase in warehousing costs. On the other hand, insufficient production or procurement may result in insufficient inventory of best-selling products, leading to supply shortages and missed opportunities to increase market share.
[0003] To avoid the aforementioned situations, it's crucial to maintain a close correlation between shipment volume and order volume. This is especially important for retail businesses dealing with thousands of SKUs. Allowing customers to cancel futures orders under specific conditions, without compromising the company's profits, can effectively help businesses identify genuine order demand and achieve the goal of making production to order.
[0004] Because of futures orders between customers and businesses, a procurement planning agreement exists between the business and its suppliers, meaning they have long-term procurement contracts. Suppliers prepare materials in advance according to this agreement, produce according to plan, and deliver on time. If a customer cancels a futures order, it affects the planned procurement volume between the business and its suppliers. Currently, when a customer cancels a futures order, the business primarily deducts the amount cancelled from the supplier's planned procurement volume.
[0005] However, directly deducting the amount from the supplier's purchase plan based on the quantity of each customer's cancellation is only suitable for scenarios with large single transaction volumes, but it is very impractical for retail enterprises. Purchase plan agreements are long-term agreements between retail enterprises and suppliers; reducing purchase volume must be reviewed and approved by the supplier, otherwise it will be considered invalid. Retail customers typically have many small orders with high transaction frequency. If the purchase plan is directly deducted for every order cancellation, supplier reviews will be very frequent, significantly increasing communication costs. Furthermore, traditional futures order cancellation methods are mainly manual, resulting in high labor costs and low efficiency. Summary of the Invention
[0006] This invention provides a method, apparatus, electronic device, and storage medium for canceling purchase orders, which solves the technical problems of traditional futures order cancellation methods being mainly manual, resulting in high labor costs and low work efficiency.
[0007] This invention provides a method for canceling a purchase order, comprising:
[0008] In response to a cancellation operation for a preset futures order product, determine the quantity of the futures order product to be cancelled;
[0009] Locate the resource pool corresponding to the futures order product;
[0010] The quantity to be cancelled is allocated to the resource pool to determine the purchase order to be cancelled;
[0011] Send the proposed cancellation order to the corresponding target supplier.
[0012] Optionally, the step of finding the resource pool corresponding to the futures order product includes:
[0013] Obtain the product identifier and type identifier of the futures order product, wherein the type identifier includes a customized identifier and a non-customized identifier;
[0014] Locate the resource pool corresponding to the product identifier and the type identifier.
[0015] Optionally, the resource pool includes an unclaimed single resource pool, a shared single resource pool, and a normal single resource pool; the step of allocating the quantity to be cancelled to the resource pool and determining the purchase order to be cancelled includes:
[0016] The quantity to be cancelled is allocated to the unclaimed single resource pool to determine the first procurement plan to be cancelled;
[0017] Calculate the first remaining quantity to be cancelled based on the quantity to be cancelled and the first proposed cancellation purchase order;
[0018] When the first remaining quantity to be cancelled is not 0, the first remaining quantity to be cancelled is allocated to the shared single resource pool, and the second purchase plan to be cancelled is determined;
[0019] Calculate the second remaining quantity to be cancelled based on the first remaining quantity to be cancelled and the second proposed cancellation purchase order;
[0020] When the second remaining quantity to be cancelled is not 0, the second remaining quantity to be cancelled is allocated to the normal single resource pool, and the third purchase plan to be cancelled is determined;
[0021] Summarize the first proposed cancellation purchase plan, the second proposed cancellation purchase plan, and the third proposed cancellation purchase plan to determine the proposed cancellation purchase plan.
[0022] Optionally, the step of allocating the quantity to be cancelled to the unclaimed resource pool and determining the first purchase order to be cancelled includes:
[0023] Obtain the unclaimed orders in the unclaimed order resource pool, and obtain the first purchase order number and unclaimed allocable quantity for each unclaimed order;
[0024] The first allocation order is determined based on the first purchase order number;
[0025] Based on the first allocation order and the unclaimable quantity of each unclaimed order, the quantity to be cancelled is sequentially allocated to the unclaimed orders to determine the first procurement plan order to be cancelled.
[0026] Optionally, the step of allocating the first remaining quantity to be cancelled to the shared single resource pool and determining the second purchase order to be cancelled when the first remaining quantity to be cancelled is not 0 includes:
[0027] When the first remaining quantity to be cancelled is not 0, obtain the shared orders in the shared single resource pool, and obtain the second purchase order number and the shared allocable quantity for each shared single;
[0028] Obtain the shared marketplace order corresponding to each of the shared marketplace orders, and obtain the first creation time and first marketplace priority of each of the shared marketplace orders;
[0029] A second allocation order is generated based on the second purchase order number, the first creation time, and the first market priority;
[0030] Based on the second allocation order and the shareable quantity of each shared order, the first remaining quantity to be cancelled is allocated to the shared orders in sequence to determine the second proposed cancellation purchase plan order.
[0031] Optionally, the step of allocating the second remaining quantity to be cancelled to the normal in-stock resource pool and determining the third purchase order to be cancelled when the second remaining quantity to be cancelled is not 0 includes:
[0032] When the second number of pending cancellations is not 0, obtain the normal orders in the normal order resource pool, and obtain the third purchase order number for each normal order;
[0033] Obtain the normal market order corresponding to each normal order, and obtain the second creation time and second market priority of each normal market order;
[0034] A third allocation order is generated based on the third purchase order number, the second creation time, and the second market priority;
[0035] Calculate the number of normally allocable units for each of the aforementioned normal units;
[0036] Based on the third allocation order and the normal allocable quantity of each normal order, the second remaining quantity to be cancelled is allocated to the normal orders in sequence to determine the third procurement plan order to be cancelled.
[0037] Optionally, the step of calculating the normally allocable quantity for each of the normal units includes:
[0038] Obtain the planned purchase quantity, confirmed purchase quantity, and customer-transferred order quantity for each product in a normal order;
[0039] The normal allocable quantity of the normal order is obtained by subtracting the determined purchase quantity and the customer transfer order quantity from the purchase plan quantity in sequence.
[0040] The present invention also provides a purchase order cancellation device, comprising:
[0041] The module for determining the quantity to be cancelled is used to respond to cancellation operations for preset futures order products and determine the quantity of the futures order products to be cancelled.
[0042] The resource pool lookup module is used to find the resource pool corresponding to the futures order product;
[0043] The module for determining the proposed cancellation of a purchase order is used to allocate the quantity to be cancelled to the resource pool and determine the proposed cancellation of the purchase order.
[0044] The sending module is used to send the proposed cancellation purchase order to the corresponding target supplier.
[0045] The present invention also provides an electronic device, the device comprising a processor and a memory:
[0046] The memory is used to store program code and transmit the program code to the processor;
[0047] The processor is configured to execute the purchase order cancellation method as described above, according to the instructions in the program code.
[0048] The present invention also provides a computer-readable storage medium for storing program code for performing the purchase order cancellation method as described in any of the preceding claims.
[0049] As can be seen from the above technical solution, the present invention has the following advantages: The present invention obtains the cancellation volume of futures orders confirmed by the supplier, allocates them to various purchase plans in the resource pool to obtain the purchase plans to be cancelled, and sends the purchase plans to be cancelled to the target supplier to cancel the corresponding order requirements. This allows enterprises to negotiate the cancellation of purchase plans with suppliers all at once after accumulating a certain amount of cancellations, thereby reducing the frequency of communication with suppliers. Moreover, this process does not require manual intervention, reducing labor costs and improving work efficiency. Attached Figure Description
[0050] To more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.
[0051] Figure 1 A flowchart illustrating the steps of a purchase order cancellation method provided in this embodiment of the invention;
[0052] Figure 2 A flowchart illustrating the steps of a purchase order cancellation method according to another embodiment of the present invention;
[0053] Figure 3 This is a structural block diagram of a purchase order cancellation device provided in an embodiment of the present invention. Detailed Implementation
[0054] This invention provides a method, apparatus, electronic device, and storage medium for canceling purchase orders, which solves the technical problems of traditional futures order cancellation methods being mainly manual, resulting in high labor costs and low work efficiency.
[0055] To make the objectives, features, and advantages of this invention more apparent and understandable, the technical solutions of the embodiments of this invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the embodiments described below are only some embodiments of this invention, and not all embodiments. Based on the embodiments of this invention, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of this invention.
[0056] Please see Figure 1 , Figure 1 A flowchart illustrating the steps of a method for canceling a purchase order, as provided in an embodiment of the present invention.
[0057] The present invention provides a method for canceling a purchase order, which may specifically include the following steps:
[0058] Step 101: Respond to the cancellation operation for the preset futures order product and determine the quantity of futures order products to be cancelled;
[0059] Due to customer cancellations of futures orders, situations may arise where the quantity of products purchased from suppliers exceeds the quantity ordered by customers. Over time, this can lead to product accumulation and slow sales. Therefore, to reduce inventory, companies often need to proactively cancel a portion of their purchases from suppliers. Companies can determine the quantity of futures orders to be canceled based on actual needs.
[0060] Futures are contracts between buyers and sellers to trade a commodity at a specified price and at a future date. A futures order is an order between buyers and sellers to be placed at a future exchange.
[0061] In real-world scenarios, futures orders typically fall into four main states during their transfer process, as detailed below:
[0062] Category 1: Futures orders submitted without going through the batch processing stage can be cancelled directly by the customer;
[0063] Category 2: After the batch confirmation is completed and the supplier is confirming, the customer cannot directly cancel the futures order, but the enterprise can directly cancel the futures order;
[0064] Category 3: During product manufacturing, neither the customer nor the company can directly cancel the pickup order; cancellation is only permitted after the supplier's consent is obtained.
[0065] Category 4: Products have been returned and goods have been put into storage; customers, companies, and suppliers cannot cancel orders.
[0066] Among them, "batch processing" refers to the order volume of confirmed customers.
[0067] Of the four states mentioned above, the second and third states represent situations where purchase orders have been generated but the supplier has not yet delivered the goods. In these cases, the company can negotiate with the supplier to cancel the order. The cancellation operation for futures orders involved in this embodiment of the invention primarily targets the purchase quantities corresponding to futures orders in the second and third states.
[0068] In practical applications, when initiating a cancellation operation, it is necessary to check whether there are enough cancelable quantities. Only when the number of items to be cancelled is no greater than the number of items that can be cancelled can the complete cancellation of the items to be cancelled be guaranteed.
[0069] When filtering out cancellation operations for futures orders in the second and third categories, the number of products that can be cancelled can be determined from the corresponding futures orders.
[0070] In one example, the type of futures order to be cancelled can be determined by checking whether a confirmation message has been received from the supplier regarding the purchase order. If no confirmation message has been received from the supplier, it indicates that the futures order belongs to the first category and can be cancelled directly without cancelling the purchase order from the supplier. If a confirmation message has been received from the supplier, it indicates that the futures order belongs to one of the second, third, or fourth categories. In this case, it can be determined whether the futures order belongs to the fourth category by checking whether the goods have been delivered. If the goods have not been delivered, it indicates that the futures order belongs to the second or third category, which are futures orders that can be cancelled according to the embodiments of the present invention. The quantity of products in the futures order is the cancelable quantity according to the embodiments of the present invention.
[0071] Step 102: Locate the resource pool corresponding to the futures order product;
[0072] In this embodiment of the invention, a resource pool is used to store information in a single resource. This single resource includes normal purchase orders and purchase orders that can be flexibly allocated to customers. A normal purchase order refers to a purchase order that corresponds exactly to a customer's futures order. Purchase orders that can be flexibly allocated to customers include purchase orders that do not have a corresponding customer futures order, or purchase orders that have a corresponding futures order but can be shared with other futures orders.
[0073] Different products exist in different resource pools. Therefore, in this embodiment of the invention, it is necessary to locate the resource pool corresponding to the futures order product in order to query the corresponding purchase plan for that futures order product. This purchase plan consists of purchase plans that can be cancelled through negotiation with the supplier.
[0074] Step 103: Allocate the quantity to be cancelled to the resource pool and determine the purchase order to be cancelled;
[0075] In real-world scenarios, the number of products to be cancelled is not exactly equal to the number of products that can be cancelled from the purchase orders in the resource pool. In fact, only when the number of products that can be cancelled from a purchase order is no less than the number to be cancelled can the number of products to be cancelled be completely cancelled. Furthermore, considering that some purchase orders in the resource pool are left over from cancelled futures orders by customers, if buyers cannot be found for these orders, they will remain within the company as inventory, causing product accumulation and slow sales, resulting in economic losses. These purchase orders need to have a higher priority for cancellation than other types of purchase orders to minimize the company's losses. In other words, the cancellation of purchase orders in the resource pool needs to be prioritized.
[0076] In this embodiment of the invention, the quantities to be cancelled need to be allocated to different purchase orders according to a predetermined priority until all quantities to be cancelled have been allocated, thereby determining the purchase orders to be cancelled.
[0077] Step 104: Send the proposed cancellation order to the corresponding target supplier.
[0078] Once the proposed cancellation order is determined, it can be sent to the corresponding target supplier to negotiate the cancellation of the purchase of the relevant products.
[0079] This invention obtains the cancellation volume of futures orders confirmed by suppliers, allocates it to various purchase plans in the resource pool to obtain purchase plans to be cancelled, and sends these purchase plans to target suppliers to cancel the corresponding order requirements. This allows companies to negotiate the cancellation of purchase plans with suppliers all at once after accumulating a certain number of cancellations, thereby reducing the frequency of communication with suppliers. Moreover, this process does not require manual intervention, reducing labor costs and improving work efficiency.
[0080] Please see Figure 2 , Figure 2 A flowchart illustrating a method for canceling a purchase order, as provided in another embodiment of the present invention. Specifically, it may include the following steps:
[0081] Step 201: Respond to the cancellation operation for the preset futures order product and determine the quantity of futures order products to be cancelled;
[0082] In this embodiment of the invention, situations may arise where customers cancel futures orders, leading to a situation where the quantity of products purchased from suppliers exceeds the quantity ordered by customers. Over time, this can result in product accumulation and slow sales. Therefore, to reduce inventory, companies often need to proactively cancel a portion of their purchases from suppliers. Companies can determine the quantity of futures orders to be canceled based on actual needs.
[0083] Step 202: Obtain the product identifier and type identifier of the futures order product. The type identifier includes a customized identifier and a non-customized identifier.
[0084] In real-world scenarios, customer futures orders are categorized into two types: customized orders and non-customized orders. The return requirements differ between these two types of futures orders. Customized orders require direct shipment to the customer, while non-customized orders are returned to the company's warehouse. Therefore, the corresponding procurement plan types need to be differentiated. Procurement plans are also divided into customized and non-customized procurement plans. Customized procurement plans correspond to customized futures orders, and non-customized procurement plans correspond to non-customized futures orders. Specifically, customized futures orders require a full container load (FCL) shipment, while non-customized orders can be shipped in either FCL or medium-sized containers.
[0085] In practical applications, product identifiers can be used to identify futures order products, and type identifiers can be used to identify whether a futures order product belongs to a customized futures order or a non-customized futures order.
[0086] Step 203: Locate the resource pool corresponding to the product identifier and type identifier;
[0087] Different futures order products have different resource pools, and the same futures order product also has different resource pools depending on the type identifier.
[0088] In this embodiment of the invention, the resource pool corresponding to the futures order product can be located based on the product identifier and type identifier. This resource pool stores the purchase plan for the futures order product.
[0089] Step 204: Allocate the quantity to be cancelled to the resource pool and determine the purchase order to be cancelled;
[0090] In this embodiment of the invention, the quantities to be cancelled can be allocated to different purchase orders according to a predetermined priority until all quantities to be cancelled have been allocated, thereby determining the purchase orders to be cancelled.
[0091] In one example, a resource pool may include an unclaimed single resource pool, a shared single resource pool, and a normal single resource pool; the steps of allocating the quantity to be cancelled to the resource pool and determining the purchase order to be cancelled may include:
[0092] S41, allocate the quantity to be cancelled to the unclaimed resource pool, and determine the first proposed cancellation order;
[0093] Unclaimed orders refer to a situation where a supplier has confirmed a purchase order, but the company cancels the futures order, resulting in a purchase order quantity that has no corresponding customer futures order and thus becomes an unclaimed order quantity.
[0094] Unclaimed orders, lacking a corresponding customer to receive them, simply remain in the warehouse once the supplier returns the products, generating no real revenue. Therefore, unclaimed orders should be considered the primary type of order to be cancelled before the supplier returns the goods.
[0095] In one example, step S41 may include the following sub-steps:
[0096] S411, retrieve the unclaimed orders in the unclaimed order resource pool, and retrieve the first purchase order number and unclaimed allocable quantity for each unclaimed order;
[0097] S412, determine the first allocation order based on the first purchase order number;
[0098] S413, based on the first allocation order and the unclaimable allocation quantity of each unclaimed order, the quantity to be cancelled is allocated to the unclaimed orders in sequence to determine the first procurement plan to be cancelled.
[0099] Unclaimed allocatable quantity refers to the quantity of unclaimed futures orders that can be cancelled through negotiation with the supplier.
[0100] In practice, unclaimed orders in the unclaimed order resource pool can be sorted according to the first purchase order number of the corresponding purchase plan, such as sorting in ascending order, to obtain the first allocation order. Then, the quantities to be cancelled are allocated sequentially according to the first allocation order until all quantities to be cancelled are allocated or all available unclaimed quantities in the unclaimed orders are allocated. The unclaimed orders that have been allocated are the first purchase plan orders to be cancelled.
[0101] In a real-world scenario, a correlation table can be created between a purchase order and a futures order. This table can contain entries for unclaimed orders. When allocating unclaimed orders, information such as the product's department, type identifier (customized or non-customized), factory, and the allocable quantity for the unclaimed order can be obtained. Purchase orders are then matched against these unclaimed order entries, and allocation is performed in ascending order of the first purchase order number from the purchase order. Allocation is also based on the number of items out of stock in the correlation table.
[0102] S42, Calculate the first remaining quantity to be cancelled based on the quantity to be cancelled and the first proposed cancellation purchase order;
[0103] In this embodiment of the invention, the difference between the unclaimed allocable quantity and the quantity to be cancelled in the first proposed cancellation purchase order can be used to determine whether the unclaimed order has fully absorbed the quantity to be cancelled. This allows for the determination of whether other order resources need to be allocated to meet the cancellation requirements of the quantity to be cancelled. When the difference between the quantity to be cancelled and the first proposed cancellation purchase order (i.e., the first remaining quantity to be cancelled) is not 0, it indicates that there is a surplus of quantity to be cancelled, and the following steps need to be performed.
[0104] S43, when the first remaining quantity to be cancelled is not 0, allocate the first remaining quantity to be cancelled to the shared single resource pool and determine the second purchase plan to be cancelled;
[0105] Shared order refers to sharing the corresponding order resources without canceling a customer's futures order, so that other customers can use them when placing orders, thus eliminating the need to place a new purchase order with the supplier.
[0106] If the unclaimed single resource pool cannot fully absorb the number of futures orders to be cancelled, the remaining number of orders to be cancelled can be further absorbed by the shared single in the shared single resource pool.
[0107] In one example, step S43 may include the following sub-steps:
[0108] S431, when the first remaining quantity to be cancelled is not 0, obtain the shared orders in the shared order resource pool, and obtain the second purchase order number and the shared allocable quantity for each shared order;
[0109] S432, retrieve the shared marketplace order corresponding to each shared marketplace order, and retrieve the first creation time and first marketplace priority of each shared marketplace order;
[0110] S433, generate a second allocation order based on the second purchase order number, the first creation time, and the first market priority;
[0111] S434, according to the second allocation order and the shared allocable quantity of each shared order, the first remaining quantity to be cancelled is allocated to the shared orders in sequence to determine the second proposed cancellation purchase plan order.
[0112] Shared allocatable quantity refers to the number of futures orders that can be cancelled by negotiating with the supplier.
[0113] In practice, the number of shared items to be cancelled can be allocated sequentially according to a certain allocation order. The corresponding rules for setting the second allocation order are as follows:
[0114] First, obtain the first market priority of the shared marketplace orders corresponding to each shared order, and sort them according to the first market priority from smallest to largest. If a marketplace has multiple shared marketplace orders, then the shared orders corresponding to that marketplace are sorted according to the first creation time from latest to earliest. If the same shared order corresponds to multiple purchase orders, then they are sorted according to the corresponding second purchase order number from smallest to largest. By sorting all shared orders according to the above principles, the second allocation order of the shared orders can be obtained.
[0115] Next, according to the second allocation order and the allocatable quantity of each shared order, the first remaining quantity to be cancelled is allocated to the shared orders. The shared orders whose allocatable quantities are satisfied are the second procurement plan orders to be cancelled.
[0116] In one example, the aforementioned purchase plan order-futures order association table can also set up shared order entries. When allocating shared orders, information such as the product's department, type identifier (customized or non-customized), factory, and the quantity that can be allocated in the shared order can be obtained. Shared market orders are matched in the shared order entries, and allocation is first performed in ascending order of the first market priority. If there are multiple shared market orders in a market, allocation is performed in ascending order of the first creation time. If the same shared order corresponds to multiple purchase plans, allocation is performed in ascending order of the second purchase order number.
[0117] S44, Calculate the second remaining quantity to be cancelled based on the first remaining quantity to be cancelled and the second proposed cancellation purchase order;
[0118] In this embodiment of the invention, the difference between the shared allocable quantity and the quantity to be cancelled in the second proposed cancellation purchase order can be used to determine whether the shared order has fully absorbed the first remaining quantity to be cancelled. This allows for the determination of whether other order resources need to be allocated to meet the cancellation requirements for the first remaining quantity to be cancelled. When the difference between the first remaining quantity to be cancelled and the second proposed cancellation purchase order (i.e., the second remaining quantity to be cancelled) is not 0, it indicates that there is a surplus in the first remaining quantity to be cancelled, and the following steps need to be performed.
[0119] S45, when the second remaining quantity to be cancelled is not 0, allocate the second remaining quantity to be cancelled to the normal in-stock resource pool and determine the third purchase plan to be cancelled;
[0120] "Normal orders" refers to the purchase plans corresponding to normal futures orders. This means that, without interference, the products ordered by the supplier for the futures orders will be sent to the corresponding customers as normal.
[0121] If the first remaining quantity of futures orders to be cancelled cannot be fully absorbed by the shared single resource pool, the remaining second remaining quantity to be cancelled can be further absorbed by the normal single order in the normal single resource pool.
[0122] In one example, step S45 may include the following sub-steps:
[0123] S451, when the second number of pending cancellations is not 0, retrieve the normal orders in the normal order resource pool and retrieve the third purchase order number for each normal order;
[0124] S452, retrieve the normal market order corresponding to each normal order, and retrieve the second creation time and second market priority of each normal market order;
[0125] S453, generate a third allocation order based on the third purchase order number, the second creation time, and the second market priority;
[0126] In practice, the allocation can be done in a specific order, starting with the number of cancellations in each normal single allocation. The rules for setting the corresponding third allocation order are as follows:
[0127] First, obtain the second market priority of each normal order corresponding to a normal market order, and sort them according to the second market priority from smallest to largest. If a market has multiple normal market orders, then the normal orders in that market are sorted according to the second creation time from latest to earliest. If the same normal order corresponds to multiple purchase orders, then they are sorted according to the corresponding third purchase order number from smallest to largest. By sorting all normal orders according to the above principles, the third allocation order of normal orders can be obtained.
[0128] S454, calculate the normal allocatable quantity for each normal single;
[0129] S455, based on the third allocation order and the normal allocable quantity of each normal order, the second remaining quantity to be cancelled is allocated to the normal orders in sequence to determine the third proposed cancellation purchase plan order.
[0130] According to the third allocation order and the normal allocable quantity of each normal order, the second remaining quantity to be cancelled is allocated to the normal orders. The normal orders whose normal allocable quantities are satisfied are the third procurement plan orders to be cancelled.
[0131] In one example, step S454 may include the following sub-steps:
[0132] S4541, respectively obtain the planned purchase quantity, confirmed purchase quantity and customer-transferred order quantity for each product in a normal order;
[0133] S4542, subtract the confirmed purchase quantity and the customer transfer order quantity from the purchase plan quantity to obtain the normal allocable quantity of normal orders.
[0134] Among them, the planned procurement quantity is the number of products normally procured from one supplier; the confirmed procurement quantity refers to the quantity of goods that have been ordered and are confirmed for procurement; and the customer transfer order quantity is the planned procurement quantity that is currently being transferred from the normal order to other futures orders.
[0135] For example: For normal order A, there is a purchase plan of 1000 units, the confirmed purchase quantity is 200 units, the customer transfers 100 units of the order, and the final normal allocable quantity corresponding to normal order A is 700.
[0136] In one example, the aforementioned purchase plan order-futures order association table can also include a normal order entry. When allocating normal orders, the product's department, type identifier (customized or non-customized), factory, and allocable quantity in the normal order can be retrieved. Normal market orders are matched within the normal order entry, and allocation is first performed in ascending order of secondary market priority. If a market has multiple normal market orders, allocation is performed in ascending order of secondary creation time. If the same normal order corresponds to multiple purchase plans, allocation is performed in ascending order of tertiary purchase order number.
[0137] Furthermore, for normal orders, if there are remaining quantities to be allocated after following the above logic, the unallocated quantities can be handled as follows:
[0138] a. Subtract the shipping method and specifications from the corresponding purchase orders, and take the one with the smallest absolute value of the difference as the remaining quantity to be allocated in the purchase order;
[0139] b. Allocate the remaining unallocated quantity and the difference in shipping specifications to the unallocated purchase plan;
[0140] c. The difference in shipment specifications is deducted from the unclaimed invoices and shared invoices in reverse order of allocation.
[0141] Among them, the shipment specification difference refers to the difference between the allocable quantity in the pending purchase plan and the remaining pending quantity. In order to completely cancel the pending purchase plan, it is necessary to deduct the allocated quantity of some futures order products from the unclaimed and shared orders according to the shipment specification difference and supplement it to the pending purchase plan.
[0142] Understandably, while ownerless and shared invoices have higher cancellation priority, both require supplier approval before cancellation, making their cancellation uncertain. Normal invoices, although having lower cancellation priority, can be cancelled directly with the supplier; therefore, cancelling a single normal invoice is more likely to increase the cancellation percentage of the pending cancellations.
[0143] S46, summarize the first proposed cancellation purchase plan, the second proposed cancellation purchase plan, and the third proposed cancellation purchase plan to determine the proposed cancellation purchase plan.
[0144] After calculating and obtaining the first, second, and third proposed cancellation purchase orders, these can be used as proposed cancellation purchase orders to negotiate with the supplier for order cancellation.
[0145] It should be noted that when allocating the number of cancellations through the resource pool, enterprises need to go through the following three data verification steps:
[0146] 1) Unclaimed and Shared Orders: The total quantity to be cancelled, summarized under the dimensions of [Material (Product) + Business Unit (Resource Pool Ownership) + Supplier], cannot exceed the remaining quantity in the Spot Information Table (Unclaimed Orders + Shared Orders).
[0147] For example, if the total number of items to be cancelled under the "Materials + Business Unit + Supplier" dimension is 4080, and the number of cancelled orders in the two resource pools of "Unowned Orders" and "Shared Orders" is 1500, then 1500 of the 4080 items will be extracted first to occupy the resources in these two resource pools, and the remaining amount will be put into the normal order resource pool for data verification.
[0148] 2) Normal order: The cancellation allocation quantity based on the purchase plan + material dimension cannot exceed "the allocable quantity of each SKU in each purchase plan (i.e., the purchase plan quantity - confirmed purchase quantity - customer transfer order quantity)".
[0149] 3) The actual cancellation allocation quantity under the dimension of [Materials + Business Unit + Supplier] must be equal to the planned cancellation quantity in the area to be allocated under this dimension (i.e. the product quantity corresponding to the purchase order to be cancelled).
[0150] It should be noted that any dimension of
Materials + Business Unit + Suppliers
[0151] After verifying the data according to the above verification process, the results are shown in Table 1 below:
[0152]
[0153]
[0154] Table 1
[0155] Step 205: Send the proposed cancellation order to the corresponding target supplier.
[0156] Once the proposed cancellation order is determined, it can be sent to the corresponding target supplier to negotiate the cancellation of the purchase of the relevant products.
[0157] This invention obtains the cancellation volume of futures orders confirmed by suppliers, allocates them sequentially to unclaimed orders, shared orders, and normal orders to determine the purchase plans to be cancelled, and sends the purchase plans to be cancelled to the target suppliers to cancel the corresponding order requirements. This process requires no manual intervention, reduces labor costs, and improves work efficiency.
[0158] Please see Figure 3 , Figure 3This is a structural block diagram of a purchase order cancellation device provided in an embodiment of the present invention.
[0159] This invention provides a purchase order cancellation device, comprising:
[0160] The module 301 for determining the quantity to be cancelled is used to respond to cancellation operations for preset futures order products and determine the quantity of futures order products to be cancelled.
[0161] Resource pool lookup module 302 is used to find the resource pool corresponding to the futures order product;
[0162] The module 303 for determining the proposed cancellation of purchase orders is used to allocate the quantities to be cancelled to the resource pool and to determine the proposed cancellation of purchase orders.
[0163] The sending module 304 is used to send the proposed cancellation of the purchase order to the corresponding target supplier.
[0164] In this embodiment of the invention, the resource pool lookup module 302 includes:
[0165] The identifier acquisition submodule is used to acquire the product identifier and type identifier of the futures order product. The type identifier includes a customized identifier and a non-customized identifier.
[0166] The resource pool lookup submodule is used to find the resource pool corresponding to the product identifier and type identifier.
[0167] In this embodiment of the invention, the resource pool includes an ownerless single resource pool, a shared single resource pool, and a normal single resource pool; the proposed cancellation purchase order determination module 303 includes:
[0168] The first proposed cancellation purchase plan determination submodule is used to allocate the quantity to be cancelled to the unclaimed in-order resource pool and determine the first proposed cancellation purchase plan.
[0169] The first remaining quantity to be cancelled calculation submodule is used to calculate the first remaining quantity to be cancelled based on the quantity to be cancelled and the first proposed cancellation purchase plan.
[0170] The second proposed cancellation purchase plan determination submodule is used to allocate the first remaining quantity to be cancelled to the shared single resource pool when the first remaining quantity to be cancelled is not 0, and to determine the second proposed cancellation purchase plan.
[0171] The second remaining quantity to be cancelled calculation submodule is used to calculate the second remaining quantity to be cancelled based on the first remaining quantity to be cancelled and the second purchase plan to be cancelled.
[0172] The third proposed cancellation purchase plan determination submodule is used to allocate the second remaining quantity to be cancelled to the normal in-order resource pool when the second remaining quantity to be cancelled is not 0, and to determine the third proposed cancellation purchase plan.
[0173] The "Proposed Cancellation of Procurement Plans" submodule is used to summarize the first, second, and third proposed cancellation of procurement plans and determine the proposed cancellation of procurement plans.
[0174] In this embodiment of the invention, the first sub-module for determining the proposed cancellation of a purchase order includes:
[0175] The unclaimed order acquisition unit is used to acquire unclaimed orders in the unclaimed order resource pool, and to acquire the first purchase order number and unclaimed allocable quantity for each unclaimed order;
[0176] The first allocation order determination unit is used to determine the first allocation order based on the first purchase order number;
[0177] The first unit for determining the proposed cancellation of procurement plans is used to allocate the quantity to be cancelled to the unclaimed orders in sequence according to the first allocation order and the unclaimed allocable quantity of each unclaimed order, thereby determining the first proposed cancellation of procurement plans.
[0178] In this embodiment of the invention, the second sub-module for determining the proposed cancellation of the purchase order includes:
[0179] The shared order acquisition unit is used to acquire shared orders in the shared order resource pool when the first remaining quantity to be cancelled is not 0, and to acquire the second purchase order number and the shared allocable quantity for each shared order;
[0180] The shared marketplace order acquisition unit is used to acquire the shared marketplace order corresponding to each shared marketplace order, and to acquire the first creation time and first marketplace priority of each shared marketplace order;
[0181] The second allocation order generation unit is used to generate a second allocation order based on the second purchase order number, the first creation time, and the first market priority.
[0182] The second proposed cancellation purchase plan determination unit is used to allocate the first remaining quantity to be cancelled to the shared orders in sequence according to the second allocation order and the shared allocable quantity of each shared order, and determine the second proposed cancellation purchase plan.
[0183] In this embodiment of the invention, the third sub-module for determining the proposed cancellation of the purchase order includes:
[0184] The normal order acquisition unit is used to acquire normal orders in the normal order resource pool when the second number to be cancelled is not 0, and to acquire the third purchase order number of each normal order.
[0185] The normal market order acquisition unit is used to acquire the normal market order corresponding to each normal order, and to acquire the second creation time and second market priority of each normal market order;
[0186] The third allocation order generation unit is used to generate a third allocation order based on the third purchase order number, the second creation time, and the second market priority.
[0187] The normal allocable quantity calculation unit is used to calculate the normal allocable quantity for each normal unit.
[0188] The third unit for determining the proposed cancellation of purchase orders is used to allocate the remaining quantity to be cancelled in the second order to the existing orders in sequence according to the third allocation order and the normal allocable quantity of each existing order, and to determine the third proposed cancellation of purchase orders.
[0189] In this embodiment of the invention, the normally allocatable quantity calculation unit includes:
[0190] The purchase plan quantity, confirmed purchase quantity, and customer transfer order acquisition sub-unit are used to obtain the purchase plan quantity, confirmed purchase quantity, and customer transfer order quantity for each product in a normal order, respectively.
[0191] The normal allocable quantity calculation subunit is used to subtract the determined purchase quantity and the customer transfer order quantity from the purchase plan quantity in sequence to obtain the normal allocable quantity of the normal order.
[0192] This invention also provides an electronic device, which includes a processor and a memory:
[0193] The memory is used to store program code and transfer the program code to the processor;
[0194] The processor is used to execute the purchase order cancellation method of this embodiment of the invention according to the instructions in the program code.
[0195] This invention also provides a computer-readable storage medium for storing program code for executing the purchase order cancellation method of this invention.
[0196] Those skilled in the art will clearly understand that, for the sake of convenience and brevity, the specific working processes of the systems, devices, and units described above can be referred to the corresponding processes in the foregoing method embodiments, and will not be repeated here.
[0197] The various embodiments in this specification are described in a progressive manner, with each embodiment focusing on the differences from other embodiments. The same or similar parts between the various embodiments can be referred to each other.
[0198] Those skilled in the art will understand that embodiments of the present invention can be provided as methods, apparatus, or computer program products. Therefore, embodiments of the present invention can take the form of entirely hardware embodiments, entirely software embodiments, or embodiments combining software and hardware aspects. Furthermore, embodiments of the present invention can take the form of computer program products implemented on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.
[0199] This invention is described with reference to flowchart illustrations and / or block diagrams of methods, terminal devices (systems), and computer program products according to embodiments of the invention. It will be understood that each block of the flowchart illustrations and / or block diagrams, and combinations of blocks in the flowchart illustrations and / or block diagrams, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, special-purpose computer, embedded processor, or other programmable data processing terminal device to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing terminal device, generate instructions for implementing the flowchart illustrations and / or block diagrams. Figure 1 One or more processes and / or boxes Figure 1 A device that provides the functions specified in one or more boxes.
[0200] These computer program instructions may also be stored in a computer-readable storage medium that can direct a computer or other programmable data processing terminal device to operate in a particular manner, such that the instructions stored in the computer-readable storage medium produce an article of manufacture including instruction means, which are implemented in a process Figure 1 One or more processes and / or boxes Figure 1 The function specified in one or more boxes.
[0201] These computer program instructions can also be loaded onto a computer or other programmable data processing terminal equipment, causing a series of operational steps to be performed on the computer or other programmable terminal equipment to produce a computer-implemented process, thereby providing instructions that execute on the computer or other programmable terminal equipment for implementing the process. Figure 1 One or more processes and / or boxes Figure 1 The steps of the function specified in one or more boxes.
[0202] Although preferred embodiments of the present invention have been described, those skilled in the art, upon learning the basic inventive concept, can make other changes and modifications to these embodiments. Therefore, the appended claims are intended to be interpreted as including the preferred embodiments as well as all changes and modifications falling within the scope of the embodiments of the present invention.
[0203] Finally, it should be noted that in this document, relational terms such as "first" and "second" are used merely to distinguish one entity or operation from another, and do not necessarily require or imply any such actual relationship or order between these entities or operations, nor do they limit the entities or operations themselves. Furthermore, the terms "comprising," "including," or any other variations thereof are intended to cover non-exclusive inclusion, such that a process, method, article, or terminal device that comprises a list of elements includes not only those elements but also other elements not expressly listed, or elements inherent to such a process, method, article, or terminal device. Without further limitations, an element defined by the phrase "comprising one..." does not exclude the presence of other identical elements in the process, method, article, or terminal device that includes said element.
[0204] The above-described embodiments are only used to illustrate the technical solutions of the present invention, and are not intended to limit it. Although the present invention has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand that modifications can still be made to the technical solutions described in the foregoing embodiments, or equivalent substitutions can be made to some of the technical features. Such modifications or substitutions 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 invention.
Claims
1. A method for canceling a purchase order, characterized in that, include: In response to a cancellation operation for a preset futures order product, determine the quantity of the futures order product to be cancelled; Locate the resource pool corresponding to the futures order product; The quantity to be cancelled is allocated to the resource pool to determine the purchase order to be cancelled; Send the proposed cancellation order to the corresponding target supplier; The resource pool includes an unclaimed single resource pool, a shared single resource pool, and a normal single resource pool; the step of allocating the quantity to be cancelled to the resource pool and determining the purchase order to be cancelled includes: The quantity to be cancelled is allocated to the unclaimed single resource pool to determine the first procurement plan to be cancelled; Calculate the first remaining quantity to be cancelled based on the quantity to be cancelled and the first proposed cancellation purchase order; When the first remaining quantity to be cancelled is not 0, the first remaining quantity to be cancelled is allocated to the shared single resource pool, and the second purchase plan to be cancelled is determined; Calculate the second remaining quantity to be cancelled based on the first remaining quantity to be cancelled and the second proposed cancellation purchase order; When the second remaining quantity to be cancelled is not 0, the second remaining quantity to be cancelled is allocated to the normal single resource pool, and the third purchase plan to be cancelled is determined; Summarize the first proposed cancellation purchase plan, the second proposed cancellation purchase plan, and the third proposed cancellation purchase plan to determine the proposed cancellation purchase plan.
2. The method according to claim 1, characterized in that, The step of finding the resource pool corresponding to the futures order product includes: Obtain the product identifier and type identifier of the futures order product, wherein the type identifier includes a customized identifier and a non-customized identifier; Locate the resource pool corresponding to the product identifier and the type identifier.
3. The method according to claim 1, characterized in that, The step of allocating the quantity to be cancelled to the unclaimed resource pool and determining the first purchase order to be cancelled includes: Obtain the unclaimed orders in the unclaimed order resource pool, and obtain the first purchase order number and unclaimed allocable quantity for each unclaimed order; The first allocation order is determined based on the first purchase order number; Based on the first allocation order and the unclaimable quantity of each unclaimed order, the quantity to be cancelled is sequentially allocated to the unclaimed orders to determine the first procurement plan order to be cancelled.
4. The method according to claim 1, characterized in that, The step of allocating the first remaining quantity to be cancelled to the shared single resource pool when the first remaining quantity to be cancelled is not 0, and determining the second purchase order to be cancelled, includes: When the first remaining quantity to be cancelled is not 0, obtain the shared orders in the shared single resource pool, and obtain the second purchase order number and the shared allocable quantity for each shared single; Obtain the shared marketplace order corresponding to each of the shared marketplace orders, and obtain the first creation time and first marketplace priority of each of the shared marketplace orders; A second allocation order is generated based on the second purchase order number, the first creation time, and the first market priority; Based on the second allocation order and the shareable quantity of each shared order, the first remaining quantity to be cancelled is allocated to the shared orders in sequence to determine the second proposed cancellation purchase plan order.
5. The method according to claim 1, characterized in that, The step of allocating the second remaining quantity to be cancelled to the normal in-stock resource pool when the second remaining quantity to be cancelled is not 0, and determining the third purchase order to be cancelled, includes: When the second remaining number of cancellations is not 0, obtain the normal orders in the normal order resource pool, and obtain the third purchase order number for each normal order; Obtain the normal market order corresponding to each normal order, and obtain the second creation time and second market priority of each normal market order; A third allocation order is generated based on the third purchase order number, the second creation time, and the second market priority; Calculate the number of normally allocable units for each of the aforementioned normal units; Based on the third allocation order and the normal allocable quantity of each normal order, the second remaining quantity to be cancelled is allocated to the normal orders in sequence to determine the third procurement plan order to be cancelled.
6. The method according to claim 5, characterized in that, The step of calculating the number of normally allocable items for each of the normal singles includes: Obtain the planned purchase quantity, confirmed purchase quantity, and customer-transferred order quantity for each product in a normal order; The normal allocable quantity of the normal order is obtained by subtracting the determined purchase quantity and the customer transfer order quantity from the purchase plan quantity in sequence.
7. A purchase order cancellation device, characterized in that, include: The module for determining the quantity to be cancelled is used to respond to cancellation operations for preset futures order products and determine the quantity of the futures order products to be cancelled. The resource pool lookup module is used to find the resource pool corresponding to the futures order product; The module for determining the proposed cancellation of a purchase order is used to allocate the quantity to be cancelled to the resource pool and determine the proposed cancellation of the purchase order. The sending module is used to send the proposed canceled purchase order to the corresponding target supplier; The proposed cancellation of the procurement plan confirmation module includes: The first proposed cancellation purchase plan determination submodule is used to allocate the quantity to be cancelled to the unclaimed in-order resource pool and determine the first proposed cancellation purchase plan. The first remaining quantity to be cancelled calculation submodule is used to calculate the first remaining quantity to be cancelled based on the quantity to be cancelled and the first proposed cancellation purchase plan. The second proposed cancellation purchase plan determination submodule is used to allocate the first remaining quantity to be cancelled to the shared single resource pool when the first remaining quantity to be cancelled is not 0, and to determine the second proposed cancellation purchase plan. The second remaining quantity to be cancelled calculation submodule is used to calculate the second remaining quantity to be cancelled based on the first remaining quantity to be cancelled and the second purchase plan to be cancelled. The third proposed cancellation purchase plan determination submodule is used to allocate the second remaining quantity to be cancelled to the normal in-order resource pool when the second remaining quantity to be cancelled is not 0, and to determine the third proposed cancellation purchase plan. The "Proposed Cancellation of Procurement Plans" submodule is used to summarize the first, second, and third proposed cancellation of procurement plans and determine the proposed cancellation of procurement plans.
8. An electronic device, characterized in that, The device includes a processor and a memory: The memory is used to store program code and transmit the program code to the processor; The processor is used to execute the purchase order cancellation method according to any one of claims 1-6 according to the instructions in the program code.
9. A computer-readable storage medium, characterized in that, The computer-readable storage medium is used to store program code for executing the purchase order cancellation method according to any one of claims 1-6.
Citation Information
Patent Citations
Data processing method and device, electronic equipment and storage medium
CN113723892A