Data interaction method between warehouse and purchasing system

Abstract

The invention relates to a data interaction method between a warehouse and a purchasing system. The method comprises the following steps: step 1, purchasing materials through an SRM system; after the purchased materials are sent out, a delivery order is generated in the SRM system, and the SRM system issues label codes on the materials; step 2, the SRM system and the ERP system are associated with each other by taking a purchase order number of the purchase order and a built-in id corresponding to the purchase order number as a unique identifier, after the purchased material arrives, the SRM system receives the material through a tag code on the material, and the ERP system grabs a material receiving notification sheet updated by the SRM system and writes the material receiving notification sheet back to the ERP system; step 3, the WMS system obtains purchase order and delivery order data in the SRM system and the ERP system, and stores the purchase order and delivery order data in a bus database; and step 4, an inspection module is arranged in the WMS system, the tag code issued before on the material is scanned, inspection is completed through the bus database, and the inspection data is written back to the ERP system.

Description

Technical Field

[0001] The present invention relates to the field of enterprise informationization and digital management, and in particular to a service bus that is a connection hub between a WMS (warehouse management system), an ERP (enterprise resource planning system) and an SRM (supplier relationship management system). Background Art

[0002] In modern enterprises, SRM, ERP and WMS are three independent but interdependent information systems. SRM focuses on relationship management with suppliers to ensure the efficiency and stability of the supply chain; ERP focuses on the overall resource management of the enterprise, including sales, planning, procurement, production, inventory status and other aspects; WMS is mainly responsible for the daily management and operation of the warehouse to ensure the accuracy and efficient circulation of inspection and warehousing. However, due to the differences in data formats, transmission protocols, etc. between the three systems, the data docking between the systems is complicated and difficult. With the development of enterprise informatization and digitalization and the increasingly fierce competition in the market, it is necessary to reduce costs in order to stand out in the competition. The manifestation in the warehouse is the need to operate materials more conveniently and quickly. Summary of the invention

[0003] In view of the above technical problems, the present invention provides a data interaction method between a warehouse and a procurement system, which optimizes the data interaction between the SRM, ERP and WMS systems and improves the efficiency of material management.

[0004] The technical solution of the present invention is: a data interaction method between a warehouse and a procurement system, Step 1: Purchase materials through the SRM system. After the purchased materials are shipped, a delivery note number is generated in the SRM system. The SRM system issues a label code on the material. The label code includes the purchase order number, delivery note number, material code, supplier code and other information.

[0005] Step 2: The SRM system and the ERP system are associated through the purchase order number of the purchase order and the built-in ID corresponding to the purchase order number as the unique identifier. After the purchased materials arrive, the SRM system receives the materials through the label code on the materials, and the ERP system captures the material receipt notice updated by the SRM system and writes it back to the ERP system.

[0006] Step 3, the WMS system obtains the purchase order and delivery note data from the SRM system and the ERP system; the WMS system includes a bus database, in which the purchase order and delivery note data are stored; the bus database is equivalent to a transmission hub, through which all subsequent information can be associated.

[0007] Step 4: There is an inspection module in the WMS system. When the purchased materials need to be inspected, the previously issued label code on the material is scanned, associated with the corresponding purchase order number and built-in ID, and the query interface of the inspection order module in the ERP system is called to obtain the unique corresponding data in the ERP system. After the WMS system confirms the inspection information, etc., it submits the inspection data. At the same time, the save, submit and review interface of the inspection order module in ERP is called to write the inspection data back to the ERP system to complete the inspection of the materials. This method reduces the workload of employees submitting for review and clerks, and improves work efficiency.

[0008] Furthermore, the WMS system has a warehouse entry module; when the material inspection is passed, a warehouse entry order in the ERP system has been generated. The label code of the material is scanned through the warehouse entry module of the WMS system. If there is an entry order, the query interface of the warehouse entry module of the ERP system is called to obtain the data created in the warehouse entry order in the ERP system, and then scan the label code of the warehouse location that needs to be entered; the WMS system calls the save, submit and review interface of the warehouse entry module in the ERP system to write the entry information back to the ERP system.

[0009] Furthermore, if the purchased materials are standard parts and do not need to be inspected, there will be no created warehouse entry information in the warehouse entry form. At this time, when scanning the material label code and calling the warehouse entry form module query interface, it is determined that the material is a standard part and does not need to be inspected. Then, the material receipt notice module in the ERP system finds the corresponding standard part data and pushes the material receipt notice to the warehouse entry form. Then, as mentioned above, according to the scanned warehouse location label code, the save, submit and review interface of the ERP warehouse entry form module is called for warehouse entry. This greatly reduces the workload of warehouse clerks and improves efficiency.

[0010] Furthermore, interfaces with the ERP system and the SRM system are configured in the WMS system. Encryption technology is used during data interaction among the WMS system, ERP system and SRM system to ensure data security and stable and timely data transmission.

[0011] Furthermore, after the SRM system receives the material receipt information, the ERP system grabs the updated material receipt information of the SRM system and writes it back to the ERP system; After the WMS system inspection module scans the label code on the material, it calls the query interface of the inspection order module in the ERP system to obtain the inspection order data in the ERP system; The WMS system's incoming warehouse module scans the material's label code. If there is an incoming warehouse order, it calls the query interface of the ERP system's incoming warehouse order module through the bus database to obtain the data in the incoming warehouse order in the ERP system. After the WMS system completes the warehousing, it calls the save, submit and review interface of the warehousing order module in the ERP through the bus database to write the warehousing data back to the ERP system.

[0012] Furthermore, a scheduled task is created in the bus database to capture the continuously generated purchase order data.

[0013] The present invention aims to realize a data interaction method between a procurement system, an enterprise resource planning system, and a warehouse system, which is equivalent to a connection hub for docking in each system, so that data between each system can be efficiently, accurately, and in real time docked, thereby improving the overall operational efficiency and coordination capabilities of the enterprise. First, the SRM system obtains procurement data from the ERP, and stores the procurement data in the database of the service bus after sorting it for subsequent use. The WMS system scans the material labels issued by the SRM system, locates the corresponding data in the database, and writes the data back to the system through the WMS system operation and the interface of the ERP system to complete operations such as material inspection or warehousing. The data in the system is updated to the audited data, which greatly reduces the workload of clerks and improves work efficiency. It can be summarized as the following beneficial effects: 1. It avoids the process of manually submitting inspection forms for review, saving human resources; 2. Reduce the workload of quality inspection clerks and improve inspection efficiency; 3. It avoids the process of warehouse keeper submitting the warehouse entry form for review, reduces the workload of warehouse clerks, and improves the efficiency of warehousing. BRIEF DESCRIPTION OF THE DRAWINGS

[0014] Figure 1 Schematic diagram of the data interaction system architecture between the warehouse and the procurement system according to an embodiment of the present invention.

[0015] Figure 2 The figure is a flow chart of a method for data interaction between a warehouse and a purchasing system according to an embodiment of the present invention. DETAILED DESCRIPTION

[0016] In order to make the purpose, technical solution and advantages of the present invention more clearly understood, the present invention is further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific examples described herein are only used to explain the present invention and are not intended to limit the present invention.

[0017] like Figure 1 As shown in the figure, the SRM system obtains the purchase order details through the webAPI interface provided by the ERP system, generates the delivery note number, and then integrates the data of the two systems and captures it into the material information database. The WMS system performs operations such as inspection and warehousing based on the obtained material information, and finally interacts with the ERP system.

[0018] like Figure 2 As shown, the flow chart of this embodiment is as follows.

[0019] Step 1: The buyer purchases materials through the SRM system; Step 2: The warehouse keeper receives the materials through the SRM system; Step 3: After inspecting the materials, the quality inspector scans the code and reports it through the WMS system, and the inspection data is reflected in the ERP system; Step 4: The warehouse keeper enters the materials into the warehouse through the WMS system, and the entry information is reflected in the ERP system.

[0020] Suppliers need to use the SRM system to ship goods and issue labels, and a delivery note number will be generated in the SRM system. Therefore, the purchase order data in the SRM system, including the generated delivery note number, is first obtained through the interface. The SRM system uses the purchase order number in the ERP system and the built-in ID corresponding to the purchase order number as the unique identifier of the document. The supplier uses the SRM system to issue a label code and affix it to the material. The label code includes information such as the purchase order number, delivery note number, material code, and supplier code.

[0021] After the arrival of the goods, the warehouse keeper uses the SRM system to receive the materials. The label code contains information about the purchase order and a built-in ID. The ERP system captures the updated material receipt notice from the SRM system and writes it back to the ERP system. After the WMS system obtains the purchase order and related detailed data from the SRM system, it creates a bus database through the preset barcode rules, and integrates the obtained purchase order, delivery note number, material information, supplier information and other data into the bus database. The bus database is equivalent to a transmission hub, and all subsequent information can be associated through it. Create a scheduled task in the bus database to capture the continuously generated purchase order data.

[0022] The WMS system is equipped with an inspection module and a warehousing module. When the purchased materials need to be inspected, the previously issued label code on the material is scanned, associated with the corresponding purchase order number and built-in ID, and the query interface of the inspection order module in the ERP system is called to obtain the unique corresponding data in the ERP system. After the WMS system confirms the inspection information, etc., it submits the inspection data. At the same time, the save, submit and review interface of the inspection order module in the ERP is called to write the inspection data back to the ERP system to complete the inspection of the materials. This method reduces the workload of employees submitting for review and clerks, and improves work efficiency.

[0023] When the material inspection is passed, a created warehouse entry order is generated in the ERP system. The label code of the material is scanned through the warehouse entry module of the WMS system. If there is an existing warehouse entry order, the query interface of the warehouse entry order module of the ERP system is called to obtain the data created in the warehouse entry order in the ERP system, and then scan the label code of the warehouse location to be entered; the WMS system calls the save, submit and review interface of the warehouse entry order module in the ERP system to write the warehouse entry information back to the ERP system.

[0024] If the purchased material is a standard part, it does not need to be inspected, and there will be no created entry order information in the entry order. At this time, when scanning the material label code and calling the entry order module query interface, it is determined that the material is a standard part and does not need to be inspected. Then the material receipt notice module in the ERP system finds the corresponding standard part data and pushes the material receipt notice to the entry order. Then, as mentioned above, according to the scanned storage location label code, call the save, submit and review interface of the ERP entry order module to enter the warehouse. This greatly reduces the workload of warehouse clerks and improves efficiency.

[0025] Interfaces to the ERP system and SRM system are configured in the WMS system. Encryption technology is used during data interaction between the WMS system, ERP system and SRM system to ensure data security and stable and timely data transmission.

[0026] The above embodiments are only for illustrating the technical idea of ​​the present invention, and cannot be used to limit the protection scope of the present invention. Any changes made on the basis of the technical solution in accordance with the technical idea proposed by the present invention shall fall within the protection scope of the present invention.

Claims

1. A data interaction method between a warehouse and a purchasing system, characterized in that: Step 1: Purchase materials through the SRM system. After the purchased materials are shipped, a delivery note number is generated in the SRM system. The SRM system issues a label code on the material, which includes the purchase order number, delivery note number, material code, and supplier code. Step 2: The SRM system and the ERP system are associated through the purchase order number and the built-in ID corresponding to the purchase order number as unique identifiers. After the purchased materials arrive, the SRM system receives the materials through the label code on the materials, and the ERP system captures the material receipt notice updated by the SRM system and writes it back to the ERP system. Step 3, the WMS system obtains the purchase order and delivery note data from the SRM system and the ERP system; the WMS system includes a bus database, and the purchase order and delivery note data are stored in the bus database; Step 4: The WMS system is equipped with an inspection module. When the purchased materials need to be inspected, the label code previously issued on the materials is scanned, and the purchase order number and the built-in ID corresponding to the purchase order number are associated through the bus database. The query interface of the inspection order module in the ERP system is called to obtain the unique corresponding data in the ERP system. After the WMS system confirms the inspection information, it submits the inspection data; at the same time, it calls the save, submit and review interface of the inspection order module in the ERP to write the inspection data back to the ERP system to complete the inspection of the materials.

2. The data interaction method between the warehouse and the procurement system according to claim 1, characterized in that: There is a warehousing module in the WMS system; After the material inspection is passed, a created entry order is generated in the ERP system; The WMS system's warehousing module scans the material's label code. If there is an incoming order, the data created in the incoming order in the ERP system is obtained through the bus database. The WMS system scans the label code of the storage location to be entered based on the data in the incoming order to complete the entry. The WMS system writes the material entry information back to the ERP system through the bus database.

3. The data interaction method between the warehouse and the procurement system according to claim 2, characterized in that: If the purchased material is a standard part, there is no created receipt information in the receipt. When the WMS system scans the label code of the material and obtains the warehouse receipt from the ERP system, it determines the data in the bus database and associates it with the material receipt notice that does not require inspection in the ERP system; The ERP system pushes the material receipt notification to the warehouse entry form, and the WMS system scans the label code of the storage location that needs to be entered according to the data of the warehouse entry form to complete the entry; the WMS system writes the material entry information back to the ERP system through the bus database.

4. The data interaction method between a warehouse and a purchasing system according to any one of claims 1 to 3, characterized in that: Configure interfaces with the ERP system and SRM system in the WMS system, and use encryption technology during data interaction between the WMS system, ERP system and SRM system.

5. The data interaction method between the warehouse and the procurement system according to claim 4, characterized in that: After the SRM system receives the material receipt information, the ERP system grabs the updated material receipt information of the SRM system and writes it back to the ERP system; After the WMS system inspection module scans the label code on the material, it calls the query interface of the inspection order module in the ERP system to obtain the inspection order data in the ERP system; The WMS system's incoming warehouse module scans the material's label code. If there is an incoming warehouse order, it calls the query interface of the ERP system's incoming warehouse order module to obtain the data in the incoming warehouse order in the ERP system. After the WMS system completes the warehousing, it calls the save, submit and review interface of the warehousing order module in the ERP to write the warehousing data back to the ERP system.

6. The data interaction method between the warehouse and the purchasing system according to claim 5, characterized in that: Create a scheduled task in the database to capture the continuously generated purchase order data.

Images