Inventory business data processing method, system, device and medium
By automatically processing the incoming and picking data of goods under the VMI business model, the problem of unclear property rights and data errors caused by manual accounting of HUB warehouses is solved, and the automated inventory control and data accuracy and timeliness are achieved.
Patent Information
- Application Number
- CN202111523146.0
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2021-12-13
- Publication Date
- 2025-03-18
- Estimated Expiration
- 2041-12-13
AI Technical Summary
Under the existing VMI business model, HUB warehouses rely on manual accounting, and there are problems such as unclear property rights of goods, difficulty in data verification, low timeliness, high labor costs and high risk of data errors.
By obtaining the goods inlet data of the supply target, carrying out delivery posting processing, detecting the customer's pickup data for property rights transfer, realizing that the goods are automatically posted to the HUB warehouse and finally to the customer, and business settlement processing is carried out based on the posting data.
It realizes automatic control of HUB warehouse cargo inventory under the VMI business model, improves data accuracy and timeliness, and reduces labor costs and data error risks.
Smart Images

Figure CN114240286B_ABST
Abstract
Description
Technical Field
[0001] The embodiments of the present application relate to the field of display technology, and in particular, to an inventory business data processing method, system, device and medium. Background Art
[0002] Vendor Managed Inventory (VMI) is a cooperative strategy that aims to achieve the lowest cost for both users and suppliers. Under a common agreement, the supplier manages the inventory, and constantly monitors the implementation of the agreement and amends the content of the agreement to continuously improve inventory management. This inventory management strategy breaks the traditional independent inventory management model, allowing suppliers to share users' current inventory and actual consumption data, and make practical replenishment according to actual consumption models, consumption trends and replenishment strategies, thereby minimizing the waste of business flow, logistics and information flow caused by the uncertainty of independent predictions by both parties to the transaction, thereby reducing the total cost of the supply chain.
[0003] At present, the VMI business model is often used between suppliers and customers in the manufacturing industry to improve supply efficiency, but the existing VMI business model of the hub warehouse, which relies on manual accounting, has many risks. Specifically, when the goods are delivered from the supplier to the hub warehouse but the customer does not pick them up, the property rights of the goods belong to the supplier, but the warehouse where the goods are physically located does not belong to the supplier. Therefore, the supplier's outbound data and the hub warehouse's inbound data need to be recorded and checked by employees of both parties, and it is difficult to find the cause of the difference when a difference occurs. In addition, after the customer picks up the goods from the hub warehouse, the employees of both the hub warehouse and the customer need to record and check the hub warehouse's outbound data, and the customer needs to feedback the picked-up goods data to the supplier, which has problems such as low timeliness, high labor costs, and high risk of data errors. Summary of the invention
[0004] In view of this, in order to solve the above-mentioned technical problems or part of the technical problems, the embodiments of the present application provide an inventory business data processing method, system, device and medium.
[0005] In a first aspect, an embodiment of the present application provides an inventory business data processing method, including: acquiring the goods entry data of a supply object; performing delivery posting processing based on the goods entry data to obtain first posting data; when the customer pick-up data of the supply object is detected, transferring the property right based on the customer pick-up data to obtain the goods transfer data of the supply object; performing delivery posting processing based on the goods transfer data to obtain second posting data; performing business settlement processing based on the first posting data and the second posting data to obtain the business settlement processing result corresponding to the supply object.
[0006] In a possible implementation, the obtaining of the goods entry data of the supply object includes: when a entry operation submitted for the delivery order data is detected, based on the entry operation, extracting the supplier identification and goods information from the delivery order data; and using the supplier identification and the goods information as the goods entry data of the supply object. The performing delivery posting processing according to the goods entry data to obtain the first posting data includes: obtaining the supply posting operation submitted for the goods entry data; if the supply posting operation meets the preset posting trigger condition, obtaining the first delivery order data associated with the delivery order data, and performing the goods receipt posting on the first delivery order data to obtain the warehouse goods receipt posting result as the first posting data.
[0007] In a possible implementation, before obtaining the goods warehousing data of the supply object, it also includes: obtaining target sales order data corresponding to the supply object, the target sales order data is associated with the quotation data of the supply object; determining the delivery order data of the supply object based on the target sales order data; and creating first delivery order data associated with the delivery order data based on the target purchase order data, the target purchase order data being purchase order data created based on the target sales order data.
[0008] In a possible implementation, the above-mentioned inventory business data processing method also includes: obtaining quotation data of the supply object; creating sales order data associated with the quotation data based on the approval operation corresponding to the quotation data; and creating purchase order data corresponding to the supply object based on the sales order data.
[0009] In a possible implementation, the transfer of property rights based on the customer pickup data to obtain the goods transfer data of the supply object includes: obtaining target customer information for the customer pickup data; if the target customer information meets the preset shipment posting conditions, obtaining the target goods inventory quantity of the supply object based on the goods identifier in the customer pickup data; if the target goods inventory quantity is greater than or equal to the pickup quantity corresponding to the goods identifier, extracting the goods to be transferred corresponding to the quantity from the target goods of the supply object; based on the customer identifier in the customer pickup data, transferring the property rights of the goods to be transferred to obtain the goods transfer data.
[0010] In a possible implementation, performing shipment posting processing according to the goods transfer data to obtain second posting data includes: acquiring target quotation data based on the goods transfer data; creating settlement sales order data associated with the target quotation data; creating customer delivery order data based on the settlement sales order data; and performing shipment posting based on the customer delivery order data to obtain second posting data.
[0011] In one possible implementation, business settlement processing is performed based on the first posting data and the second posting data to obtain a business settlement processing result corresponding to the supply object, including: creating settlement bill data corresponding to the second posting data based on the delivery note identifier of the second posting data; and performing business settlement based on the settlement bill data and the first posting data to obtain a business settlement processing result corresponding to the supply object.
[0012] In a second aspect, an embodiment of the present application provides an inventory business data processing system, including:
[0013] The incoming data acquisition module is used to obtain the incoming goods data of the supply object;
[0014] A delivery posting processing module, used for performing delivery posting processing according to the goods warehousing data to obtain first posting data;
[0015] A property rights transfer module, for, when detecting the customer's goods pick-up data of the supply object, transferring the property rights according to the customer's goods pick-up data, and obtaining the goods transfer data of the supply object;
[0016] A shipment posting processing module, used for performing shipment posting processing according to the goods transfer data to obtain second posting data;
[0017] The business settlement processing module is used to perform business settlement processing according to the first posting data and the second posting data to obtain the business settlement processing result corresponding to the supply object.
[0018] In a third aspect, an embodiment of the present application provides an electronic device, comprising: a processor, and a memory for storing executable instructions of the processor; wherein the processor is configured to execute the inventory business data processing method as described in any one of the first aspects.
[0019] In a fourth aspect, an embodiment of the present application provides a computer-readable storage medium, wherein the computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the inventory business data processing method as described in any one of the first aspects is implemented.
[0020] The inventory business data processing method, system, device and medium provided in the embodiments of the present application obtain the goods warehousing data of the supply object, perform delivery posting processing based on the goods warehousing data, obtain the first posting data, and when the customer pick-up data of the supply object is detected, transfer the property right based on the customer pick-up data to obtain the goods transfer data of the supply object, perform delivery posting processing based on the goods transfer data, so that the goods shipped by the supply object are automatically posted to the HUB warehouse and then automatically posted to the customer to obtain the second posting data, and then perform business settlement processing based on the first posting data and the second posting data to obtain the business settlement processing result corresponding to the supply object, thereby realizing the automatic control of the HUB warehouse goods inventory under the VMI business model, eliminating the need to manually create inbound delivery (Inbound Delivery, IN) data and manually post receipt of IN, manually create settlement document data and manually post shipment of settlement documents in the prior art, thereby improving the accuracy and timeliness of IN data and VMI shipment data, and reducing the labor cost and data error risk of the VMI business model. BRIEF DESCRIPTION OF THE DRAWINGS
[0021] Figure 1 A flowchart of a method for processing inventory business data provided by an embodiment of the present application;
[0022] Figure 2 A flowchart of a method for processing inventory business data provided in an optional embodiment of the present application;
[0023] Figure 3 A structural block diagram of an inventory business data processing system provided in an embodiment of the present application. DETAILED DESCRIPTION
[0024] In order to make the purpose, technical solution and advantages of the embodiments of the present application clearer, the technical solution in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments are part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of this application.
[0025] One of the core concepts of the embodiments of the present application is to provide an inventory business data processing method, which ensures the accuracy of the HUB warehouse cargo inventory data under the VMI business model by automatically updating the cargo inventory data under the VMI business model, thereby reducing the labor cost and data error risk of the VMI business model, and realizing the automated management and control of the HUB warehouse cargo inventory under the VMI business model.
[0026] It should be noted that VMI means that the supplier places the product in the customer's warehouse. The customer consumes one piece and pays for it. The product property belongs to the supplier before the customer consumes it. This supply method can eliminate unnecessary inventory for customers, reduce capital occupation and backlog, and improve supply efficiency.
[0027] To facilitate understanding of the embodiments of the present application, further explanation will be given below with reference to specific embodiments in conjunction with the accompanying drawings. The embodiments do not constitute a limitation on the embodiments of the present application.
[0028] Reference Figure 1 , shows a flowchart of the steps of an inventory business data processing method provided by an embodiment of the present application. Specifically, the inventory business data processing method provided by an embodiment of the present application may include the following steps:
[0029] Step 110, obtaining the goods warehousing data of the supply object.
[0030] In the implementation of this application, the supply object can be used to represent the object that provides goods, such as a supplier object, which is used to represent the supplier under the VMI business model. Specifically, when the goods provided by the supply object are transported to the HUB warehouse under the VMI business model, that is, when the HUB warehouse receives the physical goods, the corresponding data can be recorded for the goods information received by the HUB warehouse as the goods warehousing data of the supply object. The goods warehousing data of the supply object may include various data that need to be recorded when the supplier's goods are warehousing in the HUB warehouse, such as supplier identification information, goods information, delivery type, etc., and the embodiments of this application do not limit this.
[0031] Furthermore, the embodiments of the present application obtain the goods warehousing data of the supply object, which may specifically include: when detecting the warehousing operation submitted for the delivery order data, based on the warehousing operation, extracting the supplier identification and goods information from the delivery order data; using the supplier identification and the goods information as the goods warehousing data of the supply object. Among them, the supplier identification information can be used to determine the supply object of the goods, such as the supplier identification, which is the unique identification of the supplier, and specifically can be the supplier code, supplier name, etc.; the goods information can be used to determine the goods currently in storage and the quantity of the goods in storage, such as it can include the goods identification, the quantity of goods, etc. The goods identification can be used to determine the goods, such as the goods code, the name of the goods, etc., and the embodiments of the present application do not make specific restrictions on this.
[0032] Step 120: Perform delivery posting processing according to the goods warehousing data to obtain first posting data.
[0033] Specifically, after obtaining the goods warehousing data of the supply object, the embodiment of the present application can feed back the goods warehousing data to the enterprise resource management system of the supply object, so that the enterprise resource management system of the supply object can receive the goods warehousing data, so as to trigger the enterprise resource management system to perform delivery posting processing on the goods warehousing data and generate corresponding first posting data. The first posting data can include various receipt posting information required to be recorded for inbound delivery (IN) between the supply object and the HUB warehouse system, and the receipt posting information can be used to mark that the goods provided by the supply object have been transferred to the inventory of the HUB warehouse.
[0034] As an example of the present application, when the goods provided by the supplier are shipped from the supplier's inventory to the HUB warehouse, after the HUB warehouse receives the physical goods, the goods information received by the HUB warehouse can be used as the goods warehousing data of the supply object, and fed back to the supplier's enterprise resource management system SAP through the interface between the HUB warehouse system and the supplier's enterprise resource management system SAP, so that after receiving the goods information, the supplier's enterprise resource management system SAP automatically posts the IN data corresponding to the goods information, and generates the corresponding first posting data, so as to mark the goods provided by the supplier through the first posting data that have been transferred to the inventory of the HUB warehouse, thereby realizing the automatic warehousing function of the HUB warehouse managed by the supplier. It should be noted that IN in this example can refer to transactions between different legal entities of the supplier.
[0035] In actual processing, the HUB warehouse can be used as a virtual company of the supplier, so that the supplier can automatically post the IN internally according to the goods warehousing data transmitted from the HUB warehouse, marking that the goods have been transferred to the inventory of the HUB warehouse. For example, the system batch data conversion (Batch Data Conversion, BDC) technology can be used to build VL32N screen recording input information for the goods warehousing data of the supply object, and execute the posting button operation to realize IN posting. The code implementation logic can refer to the following code:
[0036]
[0037]
[0038] Furthermore, the embodiment of the present application performs delivery posting processing based on the goods warehousing data to obtain the first posting data, which may specifically include: obtaining the supply posting operation submitted for the goods warehousing data; if the supply posting operation meets the preset posting trigger condition, then obtaining the first delivery order data associated with the delivery order data, and performing the goods receipt posting for the first delivery order data to obtain the warehouse goods receipt posting result as the first posting data. Among them, the supply posting operation may include various operations submitted by the user for the goods warehousing data to trigger the system to automatically perform the goods receipt posting, such as the operation that after the supplier's enterprise resource management system SAP receives the goods warehousing data on the display page output, the supplier clicks the posting button on the display page for the goods warehousing data, and the operation of clicking the posting button can be used to trigger the system to automatically post the goods warehousing data.
[0039] Step 130, when the customer pick-up data of the supply object is detected, the property right is transferred according to the customer pick-up data to obtain the goods transfer data of the supply object.
[0040] Specifically, when a customer extracts goods provided by a supply object from a HUB warehouse, corresponding data can be recorded for the goods extracted by the customer as the customer's pick-up data of the supply object. When the customer's pick-up data of a supply object is detected, the embodiment of the present application can use the customer's pick-up data as the HUB warehouse shipping data, so as to automatically transfer the property rights of the goods from the supplier to the customer according to the HUB warehouse shipping data, thereby automatically transferring the property rights of the goods to the customer and generating corresponding goods transfer data, that is, generating the goods transfer data of the supply object. The goods transfer data can be used to mark that the goods that the customer needs to extract have automatically transferred the supplier's property rights to the customer's property rights, so that the subsequent shipment posting processing can be performed based on the goods transfer data.
[0041] Step 140: Perform shipment posting processing according to the goods transfer data to obtain second posting data.
[0042] Specifically, after obtaining the goods transfer data, the embodiment of the present application can automatically create settlement sales order data according to the goods transfer data, so as to automatically create, pick and post the settlement delivery note (DN) according to the settlement sales order data, and generate corresponding second posting data. The second posting data can be used to mark that the goods have been shipped out of the HUB warehouse, and can specifically include various shipping posting information that needs to be recorded for the goods to be shipped out of the HUB warehouse. For example, the second posting data can be the system invoice data created by automatically calling the billing program according to the settlement delivery note after the shipment posting, so as to complete the automatic creation of the HUB warehouse shipping business data, and realize the automatic shipping function of the HUB warehouse managed by the supplier.
[0043] Step 150: Perform business settlement processing according to the first posting data and the second posting data to obtain a business settlement processing result corresponding to the supply object.
[0044] Specifically, after obtaining the first posting data and the second posting data, the embodiment of the present application can use the first posting data and the second posting data corresponding to each supply object to perform business settlement processing, and obtain the business settlement processing result corresponding to the supply object, thereby realizing the automated management and control of the HUB warehouse goods inventory under the VMI business model. Among them, the business settlement processing result can be used to determine the result of the business processing of the goods provided by the supply object through the HUB warehouse, such as the profit data generated by the shipment through the HUB warehouse, the number of goods entering the HUB warehouse, the number of goods shipped out of the HUB warehouse, the inventory quantity of goods in the HUB warehouse, etc., and the embodiment of the present application does not impose specific restrictions on this.
[0045] In summary, the embodiment of the present application obtains the goods warehousing data of the supply object, performs delivery posting processing based on the goods warehousing data, obtains the first posting data, and when the customer pick-up data of the supply object is detected, performs property rights transfer based on the customer pick-up data to obtain the goods transfer data of the supply object, performs shipment posting processing based on the goods transfer data, so that the goods shipped by the supply object are automatically posted to the HUB warehouse and then automatically posted to the customer, obtains the second posting data, and then performs business settlement processing based on the first posting data and the second posting data to obtain the business settlement processing result corresponding to the supply object, thereby realizing the automatic management and control of the HUB warehouse goods inventory under the VMI business model, and can automatically update the HUB warehouse goods inventory data and goods property rights data under the VMI business model, that is, eliminates the need to manually create IN and manually post receipt of IN, manually create settlement document data and manually post shipment of settlement documents in the prior art, thereby improving the accuracy and timeliness of IN data and VMI shipment data, and reducing the labor cost and data error risk of the VMI business model.
[0046] In actual processing, the inventory business data processing method provided in the embodiment of the present application can be used as a method for automated control of HUB warehouse goods inventory under the VMI business model, and the main links may include: HUB warehouse receiving business link and HUB warehouse shipping business link. Among them, the HUB warehouse receiving business link may include 3 technical support steps, which are: creating a purchase order (Purchase Order, PO) from the HUB warehouse to the supplier based on the sales order (Sales Order, SO) sold by the supplier to the HUB warehouse, automatically creating an inbound delivery note IN based on the delivery note (Delivery Note, DN) shipped by the supplier to the HUB warehouse, and the supplier automatically posts the internal delivery note IN based on the HUB warehouse's warehousing data; the HUB warehouse shipping business link may include 4 technical support steps, which are: the supplier automatically transfers the property rights of the goods based on the HUB warehouse's outbound data, automatically creates a customer settlement SO based on the transfer of the property rights of the goods, automatically creates a settlement DN and posts the shipment based on the settlement SO, and automatically creates a settlement Billing based on the settlement DN after the shipment posting. By automatically updating the HUB warehouse cargo inventory and property rights data under the VMI business model, the labor cost and data error risk of the VMI business model can be reduced, and automated control of the HUB warehouse cargo inventory under the VMI business model can be achieved.
[0047] Specifically, when the customer and the supplier agree to adopt the VMI mode for the delivery of goods and specify that the goods are delivered to a certain HUB warehouse, in order to realize the automatic receipt of goods by the supplier-managed HUB warehouse, the sales order data SO2 for the supplier to deliver goods to the HUB warehouse can be created based on the delivery quotation data QT2 between the supplier and the HUB warehouse, and then the purchase order data PO between the HUB warehouse and the supplier can be created based on the sales order data SO2 for the supplier to deliver goods to the HUB warehouse, and the delivery order data DN2 for the supplier to deliver goods to the HUB warehouse can be created based on the sales order data SO2. At the same time, the internal delivery order data IN corresponding to the above purchase order data PO can be automatically created, and then the delivery order data DN can be posted for delivery. After the HUB warehouse receives the physical goods, the receipt information can be sent back to the supplier system SAP as the goods warehousing data of the supply object, so that the supplier system SAP can automatically post IN based on the receipt information sent back by the HUB warehouse, thereby realizing the transfer of the supplier's inventory to the HUB warehouse inventory and achieving the purpose of automatic receipt of the HUB warehouse inventory managed by the supplier.
[0048] Furthermore, based on the above-mentioned embodiments, the inventory business data processing method provided in the embodiments of the present application may also include, before obtaining the goods warehousing data of the supply object: obtaining the target sales order data corresponding to the supply object, the target sales order data being associated with the quotation data of the supply object; determining the delivery order data of the supply object based on the target sales order data; creating the first delivery order data associated with the delivery order data based on the target purchase order data, the target purchase order data being the purchase order data created based on the target sales order data. Among them, the target sales order data corresponding to the supply object may include the sales order data of the supply object selling goods to the HUB warehouse, such as the sales order data SO2 of the supplier selling goods to the HUB warehouse. Specifically, after acquiring the target sales order data, the embodiment of the present application can create purchase order data between the HUB warehouse and the supply object based on the target sales order data as the target purchase order data, and can create delivery note data for the supply object to deliver the goods to the HUB warehouse based on the target sales order data, and then the created delivery note data can be determined as the delivery note data of the supply object, so that for the delivery note data of the supply object, a first delivery note data associated with the delivery note data can be created based on the target purchase order data as an accounting record of inbound delivery between the supply object and the HUB warehouse, so that the receipt can be posted later based on the first delivery note data, so that the goods sent by the supplier are automatically posted to the HUB warehouse, thereby realizing the automatic warehousing function of the HUB warehouse goods managed by the supplier.
[0049] In actual processing, the target sales order data is associated with the quotation data of the supply object, such as the unit price of the goods in the target sales order data is determined by the quotation in the quotation data. Therefore, in an optional implementation of the present application, the sales order data associated with the quotation data can be automatically created according to the quotation data of the supply object as the target sales order data corresponding to the supply object, and the purchase order data of the HUB warehouse for the supply object can be created according to the target sales order data, so that the associated target sales order data and purchase order data can be automatically created based on the inheritance relationship between the data by entering the data information once, avoiding repeated input of information, ensuring the integrity of the three business data of quotation, sales order and purchase order and the consistency between the data, and solving the problem of information differences in the prior art by manually creating data separately. Optionally, the inventory business data processing method provided in the embodiment of the present application can also include: obtaining the quotation data of the supply object; creating the sales order data associated with the quotation data according to the approval operation corresponding to the quotation data; creating the purchase order data corresponding to the supply object according to the sales order data.
[0050] Reference Figure 2, shows a flowchart of the steps of an inventory business data processing method provided by an optional embodiment of the present application. Specifically, the inventory business data processing method provided by an optional embodiment of the present application may include the following steps:
[0051] Step 201, obtaining the quotation data of the supply object.
[0052] Among them, the quotation data of the supply object can be used to represent the quotation that the supply object gives to the HUB warehouse, and specifically may include various data that need to be filled in the quotation that the supply object gives to the HUB warehouse, such as the header data and line item data of the quotation, etc. The embodiment of the present application does not impose any specific restrictions on this.
[0053] Step 202: Create sales order data associated with the quotation data according to the approval operation corresponding to the quotation data.
[0054] Among them, the approval operation corresponding to the quotation data may refer to the approval operation submitted for the quotation data, such as the approval operation submitted by the user for the quotation data provided by the supplier to the HUB warehouse, and the approval operation may be used to indicate whether the user agrees to the quotation data provided to the HUB warehouse through the supplier; if the user agrees to the quotation data provided to the HUB warehouse through the supplier, sales order data associated with the quotation data may be created based on the quotation data; the sales order data may be used as the sales order data sold by the supplier to the HUB warehouse, so that the purchase order data from the HUB warehouse to the supplier may be created based on the sales order data subsequently, thereby ensuring the consistency between the data and avoiding information differences caused by manual separate recording of data.
[0055] Step 203: Create purchase order data corresponding to the supply object based on the sales order data.
[0056] In the embodiment of the present application, the purchase order data corresponding to the supply object can be used to represent the purchase order from the HUB warehouse to the supply object, and can specifically include various data that need to be filled in the purchase order from the HUB warehouse to the supply object, such as the sales order identifier sold by the HUB warehouse to the client, the sold-to information of the sales order sold by the HUB warehouse to the client, the sales order creation information sold by the HUB warehouse to the client, etc., and the embodiment of the present application does not impose specific restrictions on this. Among them, the sales order identifier can be used to identify the sales order sold by the HUB warehouse to the client, such as the sales order code SO1_Number sold by the HUB warehouse to the client; the sales order creation information sold by the HUB warehouse to the client can include various creation information of the sales order, such as the sales order creation date SO1_Creation_Date sold by the HUB warehouse to the client, and the sales order creation method SO1_Created by sold by the HUB warehouse to the client.
[0057] As an example of the present application, after the supplier system SAP creates the quotation data QT2 from the supplier to the HUB warehouse, the quotation data QT2 can be obtained, and the quotation data QT2 can be displayed on the user operation interface to submit the quotation data QT2 to the user for approval. When the user submits an approval operation for the quotation data QT2 displayed on the user operation interface, it can be determined whether the user has approved the quotation data QT2 based on the approval operation. After the quotation data QT2 is approved, the sales order data SO2 sold by the supplier to the HUB warehouse can be created based on the quotation data QT2. At this time, the approval status of the sales order data SO2 is the same as the approval status of the quotation data QT2, that is, the approval status of the quotation data QT2 is also approved. Subsequently, the purchase order data PO from the HUB warehouse to the supplier can be created based on the sales order data SO2. In this way, the data information only needs to be entered once to ensure the integrity of the three business data QT2, SO2, and PO in this example, avoiding repeated input of information; at the same time, due to the inheritance relationship between the data, the consistency between the data is guaranteed, avoiding information differences caused by manual creation of data separately.
[0058] Specifically, after creating the quotation data QT2 from the supplier to the HUB warehouse, the quotation data QT2 can be submitted for approval, and after the quotation data QT2 is approved, the sales order data SO2 from the supplier to the HUB warehouse can be created based on the quotation data QT2. For example, if the header data and line item data of the quotation data QT2 are complete, and the quotation QT2 is within the quotation validity period, the sales order data SO2 can be approved, and then the sales organization of the sales order data SO2 and the code of the quotation data QT2 can be filled in, and the program with the SAP standard transaction code VA21 can be called to automatically create the sales order data SO2, so as to achieve the purpose of creating the sales order data SO2 based on the quotation data QT2.
[0059] Specifically, this example can refer to the header data in the quotation data QT2 to build the input parameter wa_header, and refer to the line item data in the quotation data QT2 to build the input parameter items_in, and refer to the partner search data to build the input parameter partners, and refer to the line item price to build the input parameter order_conditions_in. By calling the SAP standard BAPI function for creating sales orders: 'BAPI_SALESORDER_CREATEFROMDAT2', the sales order SO2 code: p_so is generated. The code implementation logic can refer to the following code:
[0060]
[0061]
[0062] After creating sales order data SO2 according to quotation data QT2, the order status of sales order data SO2 can be synchronized. For example, according to the object code corresponding to the order code of sales order data SO2, the SAP system standard BAPI function for modifying sales order status can be called: 'STATUS_CHANGE_EXTERN' to change the status of sales order data SO2 to the approval completed status. The code implementation logic can refer to the following code:
[0063]
[0064] After synchronizing the order status of sales order data SO2, purchase order data PO can be created according to sales order data SO2. For example, the code of sales order data SO2 can be filled in and the program can be called to automatically create purchase order data PO. Specifically, the program can refer to the header data of sales order data SO2 to build the purchase order header input parameter gt_poheader, refer to the line item data of sales order data SO2 to build the purchase order line item input parameter gt_poitemy, and refer to the purchase order schedule line data input parameter gt_poschedule and line item price to build the purchase order condition type input parameter gt_pocond. By calling SAP to create the purchase order standard BAPI function: 'BAPI_PO_CREATE1', the purchase order PO code: po_num is generated. The code implementation logic can refer to the following code:
[0065]
[0066] Step 204, obtaining target sales order data corresponding to the supply object.
[0067] The target sales order data is associated with the quotation data of the supply object.
[0068] Step 205: Determine the delivery order data of the supply object based on the target sales order data.
[0069] Specifically, after creating sales order data associated with the quotation data of the supply object, the embodiment of the present application can obtain the sales order data as the target sales order data corresponding to the supply object, and then create delivery note data for the supply object to ship to the HUB warehouse based on the target sales order data, and can determine the delivery note data for the supply object to ship to the HUB warehouse as the delivery note data of the supply object, so that an inbound delivery note can be automatically created based on the delivery note data of the supply object.
[0070] Step 206: Create first delivery order data associated with the delivery order data based on the target purchase order data.
[0071] Among them, the target purchase order data is the purchase order data created based on the target sales order data. Specifically, after creating the delivery order data for the supply object to ship to the HUB warehouse, the embodiment of the present application can determine whether it is necessary to create the first delivery order data associated with the delivery order data by judging whether the sold party of the delivery order data is the HUB warehouse; if the sold party of the delivery order data is the HUB warehouse, the sales order sold information in the target purchase order data can be obtained, and the system program can be called to automatically create the delivery order IN data as the first delivery order data associated with the delivery order data; if the sold party of the delivery order data is not the HUB warehouse, the delivery order data can be ignored without any other processing.
[0072] For example, in combination with the above example, based on the sales order data SO2 from the supplier to the HUB warehouse created in the previous step, the delivery order data DN2 can be created by calling the SAP system standard program VL01N to determine the created delivery order data DN2 as the supplier's delivery order data, so that the supplier can pick and dispatch according to the delivery order data DN2 to transport the supplier's goods to the HUB warehouse for warehousing, and realize the physical receipt of the HUB warehouse; at the same time, the inbound delivery order IN data of the above purchase order data PO can be created in conjunction, and the inbound delivery order IN data can be determined as the first delivery order data associated with the delivery order data, as the accounting record of the inbound delivery between the supplier and the HUB warehouse. Specifically, the input parameters xkomdlgn and the input parameters vbsk can be constructed according to the basic data of the generated purchase order, and the inbound delivery order IN can be generated by calling the SAP system to create the standard BAPI function of the inbound delivery order: 'GN_DELIVERY_CREATE'. The code implementation logic can refer to the following code:
[0073]
[0074] Step 207, obtaining the goods warehousing data of the supply object.
[0075] Specifically, when an embodiment of the present application detects a warehousing operation submitted for delivery order data, the supplier identification and goods information can be extracted from the delivery order data for the warehousing operation, so as to use the extracted supplier identification and goods information as the goods warehousing data of the supply object.
[0076] Step 208: Obtain the supply posting operation submitted for the goods warehousing data.
[0077] Specifically, after obtaining the goods warehousing data of the supply object, the embodiment of the present application can detect the supply posting operation submitted by the user for the goods warehousing data, and can determine whether the supply posting operation meets the preset posting trigger condition based on the operation information of the supply posting operation, so as to obtain the first delivery note data associated with the delivery note data for receiving the goods posting when the supply posting operation meets the preset posting trigger condition, that is, execute step 209; and when the supply posting operation does not meet the preset posting trigger condition, the supply posting operation can be ignored, such as not responding to the supply posting operation, that is, not obtaining the first delivery note data associated with the delivery note data for receiving the goods posting.
[0078] Step 209: if the supply posting operation meets the preset posting trigger condition, first delivery order data associated with the delivery order data is obtained, and receipt posting is performed on the first delivery order data to obtain a warehouse receipt posting result as the first posting data.
[0079] For example, when the supplier posts the delivery order data DN2 for delivery to the HUB warehouse, when the goods are shipped from the supplier's inventory to the HUB warehouse, after the HUB warehouse receives the physical goods, the goods information received by the HUB warehouse can be used as the goods entry data, and fed back to the supplier's SAP system through the interface between the HUB warehouse system and the supplier's SAP system, so that the supplier's SAP system can determine whether the customer passing through the HUB warehouse can automatically post after receiving the goods entry data. When it is determined that the customer of the HUB warehouse can automatically post, the inbound delivery order IN (i.e., the first delivery order data) associated with the delivery order data DN2 can be searched, and the inbound delivery order IN can be called by calling the program to post the receipt, and the warehouse receipt posting result as the first posting data is obtained to mark that the goods have been transferred to the inventory of the HUB warehouse, thereby realizing the automatic warehousing function of the HUB warehouse goods managed by the supplier; and when it is determined that the customer of the HUB warehouse cannot automatically post, the IN posting failure information can be output to prompt the supplier to replenish the goods to the HUB warehouse.
[0080] Step 210, when the customer pick-up data of the supply object is detected, the property right is transferred according to the customer pick-up data to obtain the goods transfer data of the supply object.
[0081] In actual processing, customers can pick up goods from the HUB warehouse on demand. When customers pick up goods from the HUB warehouse, customer pick-up data of the supply object can be generated based on the information of the goods picked up by the customer, so that when the customer pick-up data of a certain supply object is detected, the property rights can be transferred according to the customer pick-up data, so as to automatically transfer the goods from the supplier's property rights warehouse in the HUB warehouse to the customer's property rights warehouse, and obtain the goods transfer data of the supply object. Further, the embodiment of the present application transfers the property rights according to the customer pick-up data to obtain the goods transfer data of the supply object, which may specifically include: obtaining target customer information for the customer pick-up data; if the target customer information meets the preset shipment posting conditions, then obtaining the target goods inventory quantity of the supply object based on the goods identifier in the customer pick-up data; if the target goods inventory quantity is greater than or equal to the pick-up quantity corresponding to the goods identifier, then extracting the goods to be transferred corresponding to the goods quantity from the target goods of the supply object; based on the customer identifier in the customer pick-up data, transferring the property rights of the goods to be transferred, and obtaining the goods transfer data. If the target goods inventory quantity is less than the pickup quantity corresponding to the goods identifier, it can be determined that the goods inventory in the HUB warehouse is insufficient, and a corresponding prompt message can be output to prompt that the goods inventory in the HUB warehouse is insufficient. Among them, the customer pickup data of the supply object is used as the HUB warehouse goods outbound data, which can be used to determine the goods that the customer extracts from the HUB warehouse on demand and the quantity of the goods extracted. The target customer information can be used to determine whether the property rights of the goods can be transferred to the customer, and specifically can include customer information, warehouse location information, material information, etc. of the goods, which is not limited in this embodiment.
[0082] Step 211, performing shipment posting processing according to the goods transfer data to obtain second posting data.
[0083] Furthermore, the embodiment of the present application performs shipment posting processing based on the goods transfer data to obtain second posting data, which may specifically include: obtaining target quotation data based on the goods transfer data; creating settlement sales order data associated with the target quotation data; creating customer delivery order data based on the settlement sales order data; performing shipment posting based on the customer delivery order data to obtain second posting data. Among them, the target quotation data may refer to the quotation data that the HUB warehouse gives to the customer; the settlement sales order data may refer to the sales order data that the HUB warehouse sells to the client. Specifically, after the HUB warehouse transmits the goods warehousing data to the supplier, it may create quotation data from the HUB warehouse to the client for the goods warehousing data as the target quotation data. When the customer picks up goods from the HUB warehouse, that is, when the goods are shipped out of the HUB warehouse, the sales order data sold by the HUB warehouse to the client can be automatically created by obtaining the target quotation data, that is, the settlement sales order data associated with the target quotation data is created, so as to create the customer delivery order data according to the settlement sales order data, so as to perform the shipment posting according to the customer delivery order data, and obtain the warehouse shipment posting result as the second posting data; the warehouse shipment posting result can include the system invoice data Billing1 from the HUB warehouse to the client, so as to perform the business settlement according to the system invoice data Billing1 later.
[0084] For example, after the HUB warehouse transmits the goods incoming data to the supplier, the HUB warehouse can create the quotation data QT1 for the customer based on the goods incoming data, and the quotation data QT1 can be used as the target quotation data and maintained in the preset configuration table 1; when the customer picks up the goods from the HUB warehouse, that is, when the goods are shipped out of the HUB warehouse, the information of the goods picked up by the customer can be used as the HUB warehouse goods outbound data, and passed to the supplier through the interface between the HUB warehouse system and the supplier's SAP system, so that when the supplier receives the HUB warehouse goods outbound data, it can obtain the customer, warehouse location, material and other information of the goods based on the HUB warehouse goods outbound data, so as to determine whether the customer of the HUB warehouse can automatically post based on the information obtained. If the customer of the HUB warehouse cannot automatically post, a posting failure prompt message can be output to prompt the failure of automatic posting. If the customer of the HUB warehouse can automatically post, it is possible to determine whether the inventory of the goods in the supplier's property location of the customer in the HUB warehouse is sufficient, so that if the inventory of the goods is sufficient, the goods can be automatically transferred from the supplier's property location of the HUB warehouse to the customer's property location, thereby marking that this part of the goods has been automatically transferred from the supplier's property right to the customer's property right; and in the case of insufficient inventory of goods, an insufficient inventory prompt message can be output to prompt the customer that the inventory of the goods in the supplier's property location is insufficient. After the goods are moved from the supplier's property location to the customer's property location, that is, after the supplier transfers the property rights of the goods to the customer, the target quotation data can be obtained based on the goods transfer data generated after the transfer of the property rights of the goods. For example, it can be determined whether the only valid quotation data QT1 can be found in configuration table 1 according to "customer + goods code"; if in configuration table 1 If the only valid quotation data QT1 cannot be found in the configuration table 1, it can be prompted that the valid quotation data QT1 cannot be found; if the only valid quotation data QT1 can be found in the configuration table 1, the settlement sales order data SO1 from the HUB warehouse to the customer can be automatically created, and then it can be determined whether the customer's credit limit is sufficient, so that when the customer's credit limit is sufficient, the customer delivery order data DN1 can be automatically created based on the settlement sales order data SO1, and the customer delivery order data DN1 can be used as the settlement delivery order data, so that after the automatic creation of the customer delivery order data DN1 is successful, picking and delivery posting can be automatically performed according to the customer delivery order data DN1 to generate the system invoice data Billing1 from the HUB warehouse to the customer, and the system invoice data Billing1 can be used as the second posting data, so that the business settlement can be performed according to the system invoice data Billing1 later; and when the customer's credit limit is insufficient, a prompt message that the automatic creation of the settlement sales order data SO1 failed can be output to prompt that the automatic creation of the settlement sales order data SO1 failed.
[0085] As an example of this application, the input parameters gmhead and mitem for executing goods movement can be constructed based on the HUB warehouse outbound data, and the standard BAPI function for creating goods movement vouchers in the SAP system can be called: BAPI_GOODSMVT_CREATE to generate the goods material voucher: mat_doc. The code implementation logic can refer to the following code:
[0086]
[0087]
[0088] As can be seen, in this example, when the property rights of the goods are transferred, the material voucher is automatically generated as the voucher data for the property rights transfer. Once the material voucher is generated, it means that the property rights of this part of the goods have been transferred to the customer. At this time, the material voucher can be used as the goods transfer data to create a settlement sales order SO1 for the customer to purchase this part of the goods. Since the same customer may pick up the same goods multiple times a day, in this case, the pick-up data can be summarized according to "customer + goods number + pick-up date", and the multiple pick-up data can be summarized to automatically generate a settlement sales order, without automatically generating multiple settlement sales orders. This can not only meet business needs, but also avoid a large burden on the system due to the surge in data volume.
[0089] Specifically, after the supplier transfers the property rights of the goods, such as starting at 0:00 am the next day, the unique valid QT1 of this customer can be checked according to the data of the property rights transfer on the previous day and "customer + material", and then according to the dimension of "customer + material code + delivery date", the settlement sales order SO1 is automatically created according to the found QT1 (that is, the SAP standard program VA01 is automatically called), and the approval status of this SO1 is changed to "approved", such as the SAP standard program VA02 can be automatically called to modify the approval status of this sales order. It should be noted that the code implementation process of creating a settlement sales order SO1 and changing the approval status of the synchronous settlement sales order SO1 to "approved" is the same as that of creating a sales order SO2 and setting the approval status of the synchronous sales order SO2 to "approved", which will not be repeated in this example.
[0090] After the settlement sales order SO1 is automatically created in this example, the customer delivery order data DN1 of the settlement sales order SO1 can be automatically created by automatically calling the program for creating the delivery order, and the customer delivery order data DN1 can be automatically picked and shipped, thereby completing the automatic creation, picking and shipping of the customer delivery order data DN1, reducing manual operations and labor costs. For example, according to the settlement sales order SO1 code, the input parameter so_item for creating the customer delivery order data DN1 can be constructed, and the SAP system can be called to create the outbound delivery order standard BAPI function: BAPI_OUTB_DELIVERY_CREATE_SLS, and the delivery order DN1 code: p_dn can be generated. The code implementation logic can refer to the following code:
[0091]
[0092] After the customer delivery order data DN1 is created, the picking and delivery posting can be automatically performed according to the customer delivery order data DN1. Specifically, the input parameter vbkok_wa for the delivery posting of the customer delivery order data DN1 can be constructed according to the customer delivery order data DN1 coding, and the delivery posting of DN1 can be realized by calling the SAP system posting outbound delivery order standard BAPI function: 'WS_DELIVERY_UPDATE'. The code implementation logic can refer to the following code:
[0093]
[0094]
[0095] After the delivery is posted, the customer delivery order data DN1 can be used as the settlement delivery order to automatically settle according to the settlement delivery order. For example, according to the customer delivery order data DN1, the program for creating Billing is automatically called for settlement, thereby automatically creating the system invoice data Billing1 as the second posting data, thereby completing the automatic creation of the HUB warehouse business data. For example, the input parameter lt_datain for executing Billing creation of the customer delivery order data DN1 can be constructed according to the customer delivery order data DN1 coding, and the SAP system can be called to create the Billing standard BAPI function: 'BAPI_BILLINGDOC_CREATEMULTIPLE', automatically create the system invoice data Billing1, and realize the creation of the settlement Billing. The code implementation logic can refer to the following code:
[0096]
[0097] Optional, in this example, when the HUB warehouse managed by the supplier automatically ships, after the customer picks up the goods from the HUB warehouse, the customer's delivery data (i.e., HUB warehouse delivery data) is automatically transmitted to the supplier's SAP system through the HUB warehouse, so that the supplier automatically transfers the property rights of the goods to the customer based on the customer's delivery data fed back by the HUB warehouse, and can automatically create customer settlement sales order data SO1 after the property rights of the goods in the supplier's HUB warehouse are transferred. Subsequently, the settlement delivery note DN can be automatically created, picked, and shipped based on the settlement sales order data SO1, and the settlement Billing can be automatically created based on the settlement delivery note DN after the shipment is posted, thereby realizing the automatic delivery of goods from the HUB warehouse managed by the supplier, and then automatically updating the inventory status of the HUB warehouse goods, ensuring the accuracy of the HUB warehouse goods inventory data under the VMI business model, and updating it in a timely manner, reducing the manpower cost of manual recording and the resulting data error risks.
[0098] Step 212: Perform business settlement processing according to the first posting data and the second posting data to obtain a business settlement processing result corresponding to the supply object.
[0099] Further, the embodiment of the present application performs business settlement processing based on the first posting data and the second posting data to obtain the business settlement processing result corresponding to the supply object, including: creating settlement bill data corresponding to the second posting data based on the delivery note identifier of the second posting data; performing business settlement based on the settlement bill data and the first posting data to obtain the business settlement processing result corresponding to the supply object. Specifically, after determining the second posting data of the supply object, this embodiment can automatically create a corresponding settlement bill based on the delivery note identifier in the second posting data to determine the various data contained in the settlement bill as settlement bill data, and then perform business settlement based on the settlement bill data and the first posting data, such as performing a goods receipt and clearing process to generate a corresponding goods receipt and clearing bill as the business settlement processing result corresponding to the supply object, thereby achieving the purpose of automatic control of HUB warehouse inventory under the VMI business model.
[0100] In summary, the inventory business data processing method provided in the embodiment of the present application realizes the automatic recording of HUB warehouse receipt data and HUB warehouse goods outbound data, thereby being able to automatically update the HUB warehouse inbound and outbound data under the VMI business model, and by automatically transmitting the inbound and outbound data between the supplier system and the HUB warehouse system, the goods shipped by the supplier are automatically posted to the HUB warehouse and then automatically posted to the customer, thereby eliminating the processes in the prior art that require manual creation of IN and manual receipt posting of IN, manual creation of settlement document data and manual delivery posting of settlement documents, thereby improving the accuracy and timeliness of IN data and VMI delivery data, and reducing the labor cost and data error risk of the VMI business model.
[0101] It should be noted that, for the purpose of simple description, the method embodiments are expressed as a series of action combinations, but those skilled in the art should be aware that the embodiments of the present application are not limited to the described order of actions, because according to the embodiments of the present application, certain steps may be performed in other orders or simultaneously.
[0102] The present application also provides an inventory business data processing system. Figure 3 As shown, the inventory business data processing system 300 may include the following modules:
[0103] The warehouse entry data acquisition module 310 is used to acquire the warehouse entry data of the goods of the supply object;
[0104] A delivery posting processing module 320 is used to perform delivery posting processing according to the goods warehousing data to obtain first posting data;
[0105] The property rights transfer module 330 is used to transfer the property rights according to the customer's goods pick-up data when the customer's goods pick-up data of the supply object is detected, and obtain the goods transfer data of the supply object;
[0106] A shipment posting processing module 340 is used to perform shipment posting processing according to the goods transfer data to obtain second posting data;
[0107] The business settlement processing module 350 is used to perform business settlement processing according to the first posting data and the second posting data to obtain a business settlement processing result corresponding to the supply object.
[0108] Optionally, the storage data acquisition module 310 may include the following submodules:
[0109] An acquisition submodule, for extracting a supplier identifier and goods information from the delivery order data based on the delivery order data when a warehousing operation submitted for the delivery order data is detected;
[0110] The warehousing data submodule is used to use the supplier identification and the goods information as the goods warehousing data of the supply object.
[0111] Optionally, the delivery posting processing module 320 may include the following submodules:
[0112] A posting operation acquisition submodule, used to acquire the supply posting operation submitted for the goods warehousing data;
[0113] A first delivery order acquisition submodule, configured to acquire first delivery order data associated with the delivery order data when the supply posting operation meets a preset posting trigger condition;
[0114] The goods receipt posting submodule is used to perform goods receipt posting on the first delivery order data to obtain a warehouse goods receipt posting result as the first posting data.
[0115] Optionally, the inventory business data processing system in the embodiment of the present application may further include the following modules:
[0116] A target sales order acquisition module is used to acquire target sales order data corresponding to a supply object, wherein the target sales order data is associated with the quotation sheet data of the supply object;
[0117] A delivery order determination module, used to determine the delivery order data of the supply object according to the target sales order data;
[0118] The first delivery order creation module is used to create first delivery order data associated with the delivery order data based on the target purchase order data, and the target purchase order data is purchase order data created based on the target sales order data.
[0119] For example, the target sales order acquisition module can acquire the target sales order data corresponding to the supply object before the inbound data acquisition module acquires the goods inbound data of the supply object, so that the delivery order data determination module can determine the delivery order data of the supply object based on the target sales order data acquired by the target sales order acquisition module, and then the first delivery order data creation module can create the first delivery order data associated with the delivery order data of the supply object based on the target purchase order data. The target purchase order data is the purchase order data created based on the target sales order data.
[0120] Optionally, based on the above embodiment, the inventory business data processing system in the embodiment of the present application further includes the following modules:
[0121] The quotation acquisition module is used to obtain the quotation data of the supply object;
[0122] A sales order creation module, used to create sales order data associated with the quotation data according to the approval operation corresponding to the quotation data;
[0123] The purchase order creation module is used to create purchase order data corresponding to the supply object based on the sales order data.
[0124] Optionally, the property rights transfer module 330 includes the following submodules:
[0125] A customer information acquisition submodule is used to acquire target customer information based on the customer delivery data;
[0126] The inventory quantity acquisition submodule is used to acquire the target inventory quantity of the supply object based on the goods identifier in the customer delivery data when the target customer information meets the preset delivery posting conditions;
[0127] The goods to be transferred extraction submodule is used to extract the goods to be transferred corresponding to the quantity of goods from the target goods of the supply object when the inventory quantity of the target goods is greater than or equal to the quantity of goods to be picked up corresponding to the goods identifier;
[0128] The transfer submodule is used to transfer the property rights of the goods to be transferred based on the customer identification in the customer pick-up data to obtain the goods transfer data.
[0129] Optionally, the delivery posting processing module 340 may include the following submodules:
[0130] A target quotation acquisition submodule, used for acquiring target quotation data based on the goods transfer data;
[0131] A settlement sales order creation submodule, used for creating settlement sales order data associated with the target quotation data;
[0132] A customer delivery note creation submodule, used to create customer delivery note data based on the settlement sales order data;
[0133] The delivery posting submodule is used to perform delivery posting based on the customer delivery order data to obtain second posting data.
[0134] Optionally, the business settlement processing module 350 may include the following submodules:
[0135] A settlement bill creation submodule, configured to create settlement bill data corresponding to the second posting data based on the delivery note identifier of the second posting data;
[0136] The business settlement submodule is used to perform business settlement based on the settlement bill data and the first posting data, and obtain the business settlement processing result corresponding to the supply object.
[0137] It should be noted that the inventory business data processing system provided above can execute the inventory business data processing method provided in any embodiment of the present application, and has the corresponding functions and beneficial effects of the execution method.
[0138] In a specific implementation, the above inventory business data processing system can be applied in electronic devices, so that the electronic devices can automatically update the inventory data of goods under the VMI business model, ensure the accuracy of the inventory data of HUB warehouse goods under the VMI business model, thereby reducing the labor cost and data error risk of the VMI business model, and realizing the automated management and control of HUB warehouse goods inventory under the VMI business model. Furthermore, an embodiment of the present application also provides an electronic device, comprising: a processor, and a memory for storing executable instructions of the processor; wherein the processor is configured to execute the inventory business data processing method as described in any of the above method embodiments.
[0139] An embodiment of the present application further provides a computer-readable storage medium having a computer program stored thereon. When the computer program is executed by a processor, the steps of the inventory business data processing method as described in any one of the above method embodiments are implemented.
[0140] It should be noted that, for the system, device, and storage medium embodiments, since they are basically similar to the method embodiments, the description is relatively simple, and the relevant parts can be referred to the partial description of the method embodiments.
[0141] The various embodiments in this specification are described in a progressive manner, and each embodiment focuses on the differences from other embodiments. The same or similar parts between the various embodiments can be referenced to each other.
[0142] The professionals should also be further aware that the units and algorithm steps of each example described in conjunction with the embodiments disclosed herein can be implemented with electronic hardware, computer software, or a combination of the two. In order to clearly illustrate the interchangeability of hardware and software, the composition and steps of each example have been generally described in terms of function in the above description. Whether these functions are performed in hardware or software depends on the specific application and design constraints of the technical solution. Professional and technical personnel can use different methods to implement the described functions for each specific application, but such implementation should not be considered to be beyond the scope of this application.
[0143] The specific implementation methods described above further illustrate the purpose, technical solutions and beneficial effects of the present application in detail. It should be understood that the above description is only the specific implementation method of the present application and is not intended to limit the scope of protection of the present application. Any modifications, equivalent substitutions, improvements, etc. made within the spirit and principles of the present application should be included in the scope of protection of the present application.
Claims
1. A method for processing inventory business data, characterized in that: include: Acquire the goods warehousing data of the supply object; the supply object is a supplier under the VMI business model; The goods warehousing data includes various data that need to be recorded when the supplier's goods are warehousing in the HUB warehouse; Perform delivery posting processing according to the goods warehousing data to obtain first posting data; When the customer pick-up data of the supply object is detected, the property right is transferred according to the customer pick-up data to obtain the goods transfer data of the supply object; Performing shipment posting processing according to the goods transfer data to obtain second posting data; Performing business settlement processing according to the first posting data and the second posting data to obtain a business settlement processing result corresponding to the supply object; Wherein, the obtaining of the goods warehousing data of the supply object includes: when detecting a warehousing operation submitted for the delivery order data, based on the warehousing operation, extracting the supplier identification and goods information from the delivery order data; using the supplier identification and the goods information as the goods warehousing data of the supply object; The delivery posting processing is performed according to the goods warehousing data to obtain the first posting data, including: obtaining a supply posting operation submitted for the goods warehousing data; if the supply posting operation meets the preset posting trigger condition, obtaining the first delivery order data associated with the delivery order data, and performing receipt posting on the first delivery order data to obtain the warehouse receipt posting result as the first posting data.
2. The inventory business data processing method according to claim 1, characterized in that: Before obtaining the goods warehousing data of the supply object, the method further includes: Acquire target sales order data corresponding to a supply object, wherein the target sales order data is associated with the quotation data of the supply object; Determine the delivery order data of the supply object according to the target sales order data; Based on the target purchase order data, first delivery order data associated with the delivery order data is created, and the target purchase order data is purchase order data created based on the target sales order data.
3. The inventory business data processing method according to claim 2, characterized in that: Also includes: Get the quotation data of the supply object; According to the approval operation corresponding to the quotation data, create sales order data associated with the quotation data; Based on the sales order data, purchase order data corresponding to the supply object is created.
4. The inventory business data processing method according to claim 1, characterized in that: The transfer of property rights based on the customer's delivery data to obtain the goods transfer data of the supply object includes: Acquire target customer information based on the customer delivery data; If the target customer information meets the preset shipment posting conditions, the target goods inventory quantity of the supply object is obtained based on the goods identifier in the customer's delivery data; If the target goods inventory quantity is greater than or equal to the pick-up quantity corresponding to the goods identifier, then extract the to-be-transferred goods corresponding to the pick-up quantity from the target goods of the supply object; Based on the customer identification in the customer pickup data, the property right of the goods to be transferred is transferred to obtain the goods transfer data.
5. The inventory business data processing method according to claim 4, characterized in that: The shipment posting process is performed according to the goods transfer data to obtain second posting data, including: acquiring target quotation data based on the goods transfer data; Creating settlement sales order data associated with the target quotation data; Creating customer delivery note data based on the settled sales order data; The shipment posting is performed based on the customer delivery note data to obtain second posting data.
6. The inventory business data processing method according to claim 1, characterized in that: Performing business settlement processing according to the first posting data and the second posting data to obtain a business settlement processing result corresponding to the supply object includes: Creating settlement bill data corresponding to the second posting data based on the delivery note identifier of the second posting data; Business settlement is performed based on the settlement bill data and the first posting data to obtain a business settlement processing result corresponding to the supply object.
7. An inventory business data processing system, characterized in that: include: The incoming data acquisition module is used to obtain the incoming goods data of the supply object; The supply object is a supplier under the VMI business model; The goods warehousing data includes various data that need to be recorded when the supplier's goods are warehousing in the HUB warehouse; A delivery posting processing module, used for performing delivery posting processing according to the goods warehousing data to obtain first posting data; A property rights transfer module, for, when detecting the customer's goods pick-up data of the supply object, transferring the property rights according to the customer's goods pick-up data, and obtaining the goods transfer data of the supply object; A shipment posting processing module, used for performing shipment posting processing according to the goods transfer data to obtain second posting data; A business settlement processing module, used to perform business settlement processing according to the first posting data and the second posting data, and obtain a business settlement processing result corresponding to the supply object; The storage data acquisition module includes the following submodules: An acquisition submodule, for extracting a supplier identifier and goods information from the delivery order data based on the delivery order data when a warehousing operation submitted for the delivery order data is detected; A warehousing data submodule, used to use the supplier identification and the goods information as the goods warehousing data of the supply object; The delivery posting processing module includes the following submodules: A posting operation acquisition submodule, used to acquire the supply posting operation submitted for the goods warehousing data; A first delivery order acquisition submodule, configured to acquire first delivery order data associated with the delivery order data when the supply posting operation meets a preset posting trigger condition; The goods receipt posting submodule is used to perform goods receipt posting on the first delivery order data to obtain a warehouse goods receipt posting result as the first posting data.
8. An electronic device, characterized in that: include: A processor, and a memory for storing executable instructions of the processor; wherein the processor is configured to execute the inventory business data processing method as described in any one of claims 1 to 6.
9. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the inventory business data processing method according to any one of claims 1 to 6 is implemented.
Citation Information
Patent Citations
System and method for realizing business operation automation and storage medium
CN111260178A
Dump automatic goods receiving and account passing method and system
CN111950997A