Information determination method, device and computer readable storage medium

By establishing the correspondence between the purchase order and the warehouse entry order and generating the warehouse position mark, the problem of high cost and difficulty in determining the goods supplier in the prior art is solved, and efficient and low-cost supplier determination is achieved.

CN113743858BActive Publication Date: 2025-02-25BEIJING WODONG TIANJUN INFORMATION TECH CO LTD +1
View PDF 2 Cites 0 Cited by

Patent Information

Application Number
CN202110153172.2
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2021-02-03
Publication Date
2025-02-25
Estimated Expiration
2041-02-03

AI Technical Summary

Technical Problem

In the prior art, the solution to determine the corresponding supplier of goods is high and difficult to realize, making it difficult to accurately locate the corresponding supplier of goods.

Method used

By obtaining the purchase order and the storage order, establishing the corresponding relationship between the purchase order and the storage order, generating the warehouse position identification, and determining the supply of the goods based on the position identification and storage order.

Benefits of technology

It realizes that the supplier of goods can be accurately positioned without adding a separate code to the goods, reducing costs and implementation difficulties, and improving determination efficiency.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN113743858B_ABST
    Figure CN113743858B_ABST
Patent Text Reader

Abstract

The embodiment of the present application discloses an information determination method, the method comprising: obtaining a purchase order and a warehouse entry order, and establishing a corresponding relationship between the purchase order and the warehouse entry order; wherein the purchase order at least includes the supplier of the goods; the warehouse entry order at least includes the goods number; generating a warehouse location identification for a warehouse for storing goods; wherein the warehouse location identification uniquely identifies the warehouse; the warehouse stores the same type of goods of the same batch from the same supplier; if it is necessary to determine the supplier of the goods to be processed that have been warehoused, obtain the target warehouse location identification of the target warehouse corresponding to the goods to be processed, and obtain the first goods number of the goods to be processed based on the target warehouse location identification; based on the first goods number, the warehouse entry order, the corresponding relationship and the purchase order, determine the supplier of the goods to be processed. The embodiment of the present application also discloses an information determination device and a computer-readable storage medium.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present application relates to information determination technology in the computer field, and in particular to an information determination method, device and computer-readable storage medium. Background Art

[0002] At present, the same goods of many merchants are supplied by different suppliers. If there are problems with the goods, such as quality problems, poor sales and the need to return goods, the merchant cannot accurately locate the supplier of the goods. In order to solve the above problems, the relevant technology needs to add a separate code to each product, so as to determine the supplier of the goods based on the code. However, the solution for determining the supplier of goods in the relevant technology is too costly and difficult to implement. Summary of the invention

[0003] In order to solve the above technical problems, the embodiments of the present application provide an information determination method, device and computer-readable storage medium, which solve the problem in the related art that the solution for determining the supplier corresponding to the goods is too costly and difficult to implement.

[0004] The technical solution of this application is implemented as follows:

[0005] A method for determining information, the method comprising:

[0006] Obtain a purchase order and a warehouse entry order, and establish a corresponding relationship between the purchase order and the warehouse entry order; wherein the purchase order at least includes the supplier of the goods; and the warehouse entry order at least includes the goods number;

[0007] Generate a warehouse location identifier for storing goods; wherein the warehouse location identifier uniquely identifies the warehouse; the warehouse stores the same type of goods from the same batch of the same supplier;

[0008] Obtaining a target warehouse identifier of a target warehouse corresponding to the goods to be processed, and obtaining a first cargo number of the goods to be processed based on the target warehouse identifier;

[0009] Based on the first cargo number, the warehousing order, the corresponding relationship and the purchase order, the supplier of the cargo to be processed is determined.

[0010] In the above solution, the step of determining the supplier of the goods to be processed based on the first goods number, the warehousing order, the corresponding relationship and the purchase order includes:

[0011] Determine the target purchase order number corresponding to the goods to be processed based on the first goods number, the warehousing order and the corresponding relationship;

[0012] Based on the target purchase order number and the purchase order, a supplier of the goods to be processed is determined.

[0013] In the above solution, the step of determining the target purchase order number corresponding to the goods to be processed based on the first goods number, the warehousing order and the corresponding relationship includes:

[0014] Determine a target entry order corresponding to the first cargo number from the entry order; wherein the entry order includes an entry order number;

[0015] The target incoming order number of the target incoming order is obtained, and the target purchase order number is determined based on the target incoming order number and the corresponding relationship.

[0016] In the above solution, determining the supplier of the goods to be processed based on the target purchase order number and the purchase order includes:

[0017] According to the target purchase order number, a target purchase order is obtained; wherein the purchase order includes the purchase order number;

[0018] The supplier of the goods to be processed is obtained from the target purchase order.

[0019] In the above scheme, the method further includes:

[0020] Obtaining an outbound shipment order, and determining a second cargo number of each type of outbound cargo and a first outbound quantity of each type of outbound cargo from the outbound shipment order;

[0021] Based on the second cargo number, the first outbound quantity, the incoming cargo order, the corresponding relationship and the purchase order, the inventory quantity of each type of cargo of each supplier is determined.

[0022] In the above solution, the step of determining the inventory quantity of each type of goods of each supplier based on the second goods number, the first outbound quantity, the incoming order, the corresponding relationship and the purchase order includes:

[0023] Based on the second cargo number, obtaining from the inbound order a first inbound quantity of each category of cargo corresponding to the category of the outbound cargo;

[0024] Determine the supplier of each type of outbound goods based on the second goods number, the incoming order, the corresponding relationship and the purchase order;

[0025] Based on the first outbound quantity, the first inbound quantity and the suppliers, the inventory quantity of each type of goods corresponding to the category of each supplier and the category of the outbound goods is determined.

[0026] In the above scheme, the method further includes:

[0027] Get the return quantity of each type of goods;

[0028] Obtaining the second incoming quantity of each type of goods and the third goods number of each type of goods from the incoming order;

[0029] Obtaining an outbound shipment order, and obtaining a second outbound quantity of each type of goods from the outbound shipment order based on the third goods number;

[0030] Determine the supplier of each type of goods based on the third goods number, the warehousing order, the corresponding relationship and the purchase order;

[0031] For each type of goods, each supplier is rated based on the third goods number, the return quantity, the second inbound quantity and the second outbound quantity.

[0032] In the above solution, for each type of goods, rating each supplier based on the third goods number, the returned goods quantity, the second incoming goods quantity and the second outgoing goods quantity includes:

[0033] For each type of goods, calculating a first ratio of the returned quantity to the second incoming quantity based on the third goods number;

[0034] For each type of goods, calculating a second ratio of the second outbound quantity to the second inbound quantity based on the third goods number;

[0035] For each type of goods, each supplier is rated based on the third goods number, the first ratio and the second ratio.

[0036] An information determination device, the device comprising: a processor, a memory, and a communication bus;

[0037] The communication bus is used to realize the communication connection between the processor and the memory;

[0038] The processor is used to execute the information determination program stored in the memory to implement the following steps:

[0039] Obtain a purchase order and a warehouse entry order, and establish a corresponding relationship between the purchase order and the warehouse entry order; wherein the purchase order at least includes the supplier of the goods; and the warehouse entry order at least includes the goods number;

[0040] Generate a warehouse location identifier for storing goods; wherein the warehouse location identifier uniquely identifies the warehouse; the warehouse stores the same type of goods from the same batch of the same supplier;

[0041] Obtaining a target warehouse identifier of a target warehouse corresponding to the goods to be processed, and obtaining a first cargo number of the goods to be processed based on the target warehouse identifier;

[0042] Based on the first cargo number, the warehousing order, the corresponding relationship and the purchase order, the supplier of the cargo to be processed is determined.

[0043] A computer-readable storage medium stores one or more programs, and the one or more programs can be executed by one or more processors to implement the steps of the information determination method described above.

[0044] Because the purchase order and the warehouse entry order can be obtained, and the corresponding relationship between the purchase order and the warehouse entry order can be established; wherein, the purchase order at least includes the supplier of the goods; the warehouse entry order at least includes the goods number; a bin identification of the warehouse for storing the goods is generated; the bin identification uniquely identifies the warehouse; the same kind of goods from the same batch of the same supplier are stored in the warehouse; the target bin identification of the target warehouse corresponding to the goods to be processed is obtained, and the first goods number of the goods to be processed is obtained based on the target bin identification; the supplier of the goods to be processed is determined based on the first goods number, the warehouse entry order, the corresponding relationship and the purchase order, so the supplier corresponding to the goods can be determined based on the first goods number determined by the target bin identification of the goods warehouse, the goods warehouse entry order, the corresponding relationship between the warehouse entry order and the purchase order, and the purchase order of the goods, without adding a separate code to the goods, solving the problems of low efficiency and high cost in determining the supplier corresponding to the goods in the related technology, reducing the difficulty of implementation and improving the determination efficiency. BRIEF DESCRIPTION OF THE DRAWINGS

[0045] Figure 1 A flowchart of an information determination method provided in an embodiment of the present application;

[0046] Figure 2 A flowchart of another information determination method provided in an embodiment of the present application;

[0047] Figure 3 A schematic diagram of a process for determining the inventory quantity of each type of goods of each supplier provided in an embodiment of the present application;

[0048] Figure 4 A schematic diagram of a flow chart of a method for determining a supplier level provided in an embodiment of the present application;

[0049] Figure 5 An architecture diagram of an information determination system corresponding to an information determination method provided in an embodiment of the present application;

[0050] Figure 6 A schematic diagram of the structure of an information determination device provided in an embodiment of the present application. DETAILED DESCRIPTION

[0051] The technical solutions 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.

[0052] The embodiment of the present application provides an information determination method, which can be applied to an information determination device, referring to Figure 1 As shown, the method comprises the following steps:

[0053] Step 101: Obtain a purchase order and a warehouse entry order, and establish a corresponding relationship between the purchase order and the warehouse entry order.

[0054] Among them, the purchase order at least includes the supplier of the goods; the warehouse entry order at least includes the goods number.

[0055] In the embodiment of the present application, the purchase order can be determined by the merchant based on the actual demand and the inventory of the goods in the warehouse. In a feasible implementation, the purchase order may include: purchase order number, goods type, goods quantity, goods supplier, etc. The warehouse entry order is provided when the goods enter the warehouse; the warehouse entry order may include: warehouse entry order number, goods type, goods quantity, and goods number.

[0056] It should be noted that one purchase order corresponds to one supplier, and one purchase order corresponds to multiple warehouse entry orders; and each warehouse entry order corresponds to one type of goods; the purchase order and warehouse entry order can be input into the information determination device by the operator.

[0057] Step 102: Generate a warehouse location identifier for storing goods.

[0058] Among them, the warehouse location identification uniquely identifies the warehouse; the warehouse stores the same batch of the same kind of goods from the same supplier.

[0059] In the embodiment of the present application, the warehouse identification is identification information that uniquely identifies the warehouse location; the warehouse identification is generated based on the warehouse number and the warehouse number, and only the same batch of the same type of goods from the same supplier are stored in the warehouse. In a feasible implementation, the warehouse identification can be image information.

[0060] Step 103: Obtain the target warehouse location identifier of the target warehouse corresponding to the goods to be processed, and obtain the target goods number of the goods to be processed based on the target warehouse location identifier.

[0061] Among them, the target warehouse is the warehouse of the goods to be processed, and the target warehouse location identifier is the warehouse location identifier of the goods to be processed; in the embodiment of the present application, the target warehouse location identifier can be parsed to obtain the goods number of the goods to be processed.

[0062] Step 104: Determine the supplier of the goods to be processed based on the first goods number, the warehousing order, the corresponding relationship and the purchase order.

[0063] In an embodiment of the present application, a target purchase order corresponding to the goods to be processed is determined based on the first goods number, the warehouse entry form, and the correspondence between the purchase order and the warehouse entry form, and then the supplier corresponding to the goods to be processed is determined based on the target purchase order; that is, the warehouse entry form of the goods to be processed can be first determined based on the first goods number and the warehouse entry form, and then the target purchase order is obtained based on the correspondence between the purchase order and the warehouse entry form, and the warehouse entry form of the goods to be processed, and finally the supplier corresponding to the goods to be processed is obtained from the target purchase order.

[0064] It should be noted that the supplier is the provider of the goods (supplier); in a feasible implementation method, when a large amount of food stored in the warehouse has deteriorated before the expiration date, the warehouse manager can use the camera of the information determination device to scan the QR code image of the warehouse where the food is stored to obtain the first cargo number C1 of the food, and then search for the target incoming order of the goods with cargo number C1 from all incoming orders, and obtain the incoming order number m from this target incoming order; then, based on the correspondence between the incoming order and the purchase order, search for the target purchase order corresponding to the target incoming order with incoming order number m from all purchase orders, and obtain the purchase order number n from the target purchase order; next, search for the target purchase order with purchase order number n from all purchase orders, and finally determine the supplier of the deteriorated food from the target purchase order, and then find the supplier for corresponding claims or returns.

[0065] The information determination method provided by the embodiment of the present application can obtain a purchase order and a warehouse entry order, and establish a corresponding relationship between the purchase order and the warehouse entry order; wherein the purchase order at least includes the supplier of the goods; the warehouse entry order at least includes the goods number; a bin identification of a warehouse for storing goods is generated; the bin identification uniquely identifies the warehouse; the same type of goods of the same batch from the same supplier are stored in the warehouse; the target bin identification of the target warehouse corresponding to the goods to be processed is obtained, and the first goods number of the goods to be processed is obtained based on the target bin identification; the supplier of the goods to be processed is determined based on the first goods number, the warehouse entry order, the corresponding relationship and the purchase order, so that the supplier corresponding to the goods can be determined based on the first goods number determined by the target bin identification of the warehouse of the goods, the warehouse entry order of the goods, the corresponding relationship between the warehouse entry order and the purchase order, and the purchase order of the goods, without adding a separate code to the goods, thereby solving the problem of low efficiency and high cost in determining the supplier corresponding to the goods in the related art.

[0066] Based on the above embodiments, the embodiments of the present application provide an information determination method, referring to Figure 2 As shown, the method comprises the following steps:

[0067] Step 201: The information determination device obtains a purchase order and a storage order, and establishes a corresponding relationship between the purchase order and the storage order.

[0068] Among them, the purchase order at least includes the supplier of the goods; the warehouse entry order at least includes the goods number.

[0069] In a feasible implementation, supplier a corresponds to a purchase order, the purchase order number corresponding to the purchase order is A, the purchase order corresponds to 100 incoming orders, and the incoming order numbers corresponding to the incoming orders are A1, A2, ..., A99 and A100 respectively; the incoming order with the incoming order number A1 corresponds to 100 bottles of mineral water from supplier a; the incoming order with the incoming order number A2 corresponds to 200 bottles of spray from supplier a, and so on.

[0070] Step 202: The information determination device generates a warehouse location identifier for storing goods.

[0071] Among them, the warehouse location identification uniquely identifies the warehouse; the warehouse stores the same batch of the same kind of goods from the same supplier.

[0072] In the embodiment of the present application, the bin identification is a QR code image that identifies the bin of the warehouse; wherein the bin QR code image is generated based on the bin number and the warehouse number of the warehouse, and the warehouse only stores the same type of goods of the same batch from the same supplier. In a feasible implementation, the warehouse number is 2, the bin number of the warehouse in the warehouse is 1006, a string of QR code numbers is generated based on the warehouse number and the bin number of the warehouse; a corresponding QR code image is generated based on the string of QR code numbers; 100 bottles of mineral water from supplier a with the number A11 are stored in this warehouse.

[0073] Step 203: The information determination device obtains the target warehouse identifier of the target warehouse corresponding to the goods to be processed, and obtains the first goods number of the goods to be processed based on the target warehouse identifier.

[0074] In an embodiment of the present application, the obtained identification image of the warehouse location of the goods to be processed can be analyzed to determine the cargo number of the goods in this warehouse location; in a feasible implementation method, the target warehouse location identification can be a target QR code image; at this time, the camera of the information determination device can be used to scan the target QR code image to identify and analyze to obtain the first cargo number of the goods to be processed, or the target QR code image can be input into the information determination device for identification and analysis to obtain the first cargo number of the goods to be processed.

[0075] Among them, taking the supplier as supplier a, the first cargo number of the cargo to be processed as A11 and the target QR code image of the first cargo to be processed as an example, the camera of the information determination device can be used to scan the target QR code image of the warehouse where the first cargo is located, thereby identifying that the first cargo number of the first cargo is A11.

[0076] It should be noted that by identifying and analyzing the storage location identification of the storage location in the warehouse, the quantity of goods in the storage location can also be obtained.

[0077] Step 204: The information determination device determines the target purchase order number corresponding to the goods to be processed based on the first goods number, the warehousing order and the corresponding relationship.

[0078] Wherein, step 204 can be implemented in the following manner:

[0079] Step 204a: The information determination device determines a target entry order corresponding to the first goods number from the entry order.

[0080] Among them, the incoming order includes the incoming order number.

[0081] It should be noted that the incoming orders whose goods numbers include the first goods number can be searched from all incoming orders, so as to determine the incoming order with the first goods number as the target incoming order. In a feasible implementation, the target incoming order with the goods whose first goods number is A11 is searched from all incoming orders, and the incoming order number of the target incoming order is obtained from the target incoming order as A1.

[0082] Step 204b, the information determination device obtains the target incoming order number of the target incoming order, and determines the target purchase order number based on the target incoming order number and the corresponding relationship.

[0083] In the embodiment of the present application, the corresponding target warehouse entry order can be determined according to the target warehouse entry order number, and then according to the relationship between the warehouse entry order and the purchase order, the target purchase order corresponding to the target warehouse entry order is found from all purchase orders, and then the target purchase order number is obtained from the target purchase order. In a feasible implementation method, the target warehouse entry order number of the target warehouse entry order corresponding to the first cargo number A11 is A1, and according to the corresponding relationship between the warehouse entry order and the purchase order, the target purchase order corresponding to the target warehouse entry order with the target warehouse entry number of A1 is found from all purchase orders, and the target purchase order number A is obtained from the target purchase order.

[0084] Step 205: The information determination device determines the supplier of the goods to be processed based on the target purchase order number and the purchase order.

[0085] Wherein, step 205 can be implemented by the following methods:

[0086] Step 205a: The information determination device obtains the target purchase order according to the target purchase order number.

[0087] The purchase order also includes a purchase order number.

[0088] In the embodiment of the present application, the purchase order corresponding to the target purchase order number can be found from all purchase orders to obtain the target purchase order. In a feasible implementation, the target purchase order corresponding to the target purchase order number A can be found from all purchase orders.

[0089] Step 205b: The information determination device obtains the supplier of the goods to be processed from the target purchase order.

[0090] It should be noted that the supplier of the goods to be processed can be directly found from the target purchase order. In a feasible implementation, it is determined from the target purchase order A that the supplier corresponding to the goods to be processed is a.

[0091] The information determination method provided in the embodiments of the present application can determine the supplier corresponding to the goods based on the first goods number determined by the target warehouse location identification of the goods warehouse, the goods entry form, the purchase order number, the correspondence between the entry form and the purchase order, and the purchase order of the goods, without adding a separate code to the goods. This solves the problem of low efficiency and high cost in determining the supplier corresponding to the goods in the related art, reduces the difficulty of implementation and improves the efficiency of determining the supplier corresponding to the goods.

[0092] Based on the above embodiments, in other embodiments of the present application, refer to Figure 3 As shown, the information determination method may further include the following steps:

[0093] Step 206: The information determination device obtains the outbound shipment order, and determines the second cargo number of each type of outbound cargo and the first outbound quantity of each type of outbound cargo from the outbound shipment order.

[0094] In a feasible implementation, the first outbound quantity of the outbound earphones can be directly found from the outbound order to be 17, and the second cargo number of the outbound earphones is B12. The outbound order can be input into the cargo information device by an operator, and the outbound order can include the outbound order number.

[0095] It should be noted that when goods are shipped out of the warehouse, the camera of the information determination device can be used to scan the QR code image of the warehouse location where the shipped goods are located, so as to update the QR code information of the warehouse location (the warehouse no longer stores the shipped goods), that is, to update the information of the goods stored in the warehouse.

[0096] Step 207: The information determination device determines the inventory quantity of each type of goods of each supplier based on the second goods number, the first outbound quantity, the incoming order, the corresponding relationship and the purchase order.

[0097] Wherein, step 207 can be implemented by the following methods:

[0098] Step 207a: The information determination device obtains, based on the second cargo number, from the cargo entry order a first inbound quantity of each category of cargo corresponding to the category of the outbound cargo.

[0099] In the embodiment of the present application, the first warehouse entry order with the second goods number is found from all warehouse entry orders, and the first warehouse entry quantity of each category of goods of the same category as the category of the outgoing goods is obtained from the first warehouse entry order. In a feasible implementation, the first warehouse entry order with the outgoing goods of the second goods number B12 is found from all warehouse entry orders, and the first warehouse entry quantity of the outgoing goods (earphones) of the same category as the second goods number B12 obtained from the first warehouse entry order is 90.

[0100] Step 207b: The information determination device determines the supplier of each type of outbound goods based on the second goods number, the incoming order, the corresponding relationship and the purchase order.

[0101] In an embodiment of the present application, the first purchase order corresponding to the outbound goods is determined based on the second goods number, the incoming order, and the correspondence between the purchase order and the incoming order, and then the supplier corresponding to the outbound goods is determined based on the first purchase order; wherein, the first incoming order can be first determined from all the incoming orders based on the second goods number, and then the first purchase order is obtained based on the correspondence between the purchase order and the incoming order and the first incoming order, and finally the supplier corresponding to the outbound goods is obtained from the first purchase order.

[0102] In a feasible implementation method, the first incoming order with the second goods number B12 can be found from all incoming orders, and the incoming order number of the first incoming order is B1; according to the correspondence between the purchase order and the incoming order, the first purchase order number corresponding to the incoming order number B1 is found from all purchase orders according to the incoming order number B1, which is B, and the supplier of the second goods number B12 is obtained from the purchase order of the first purchase order number B, which is b.

[0103] Step 207c: The information determination device determines the inventory quantity of each category of goods corresponding to the category of each supplier and the category of the outbound goods based on the first outbound quantity, the first inbound quantity and the supplier.

[0104] In the embodiment of the present application, for each type of goods of each supplier, the first warehouse-in quantity is subtracted from the first warehouse-out quantity to obtain the inventory quantity of each type of goods of each supplier. In a feasible implementation, the first warehouse-out quantity of the second goods number B12 earphones of the outgoing supplier b is 17, and the first warehouse-in quantity of the second goods number B12 earphones of the supplier b is 90. According to the first warehouse-in quantity of the second goods number B12 earphones of the supplier b minus the first warehouse-out quantity of the second goods number B12 earphones of the supplier b, it is determined that the inventory quantity of the earphones of the same category as the second goods number B12 of the supplier b is 73.

[0105] It should be noted that in the embodiment of the present application, the inventory quantity of each type of goods of each supplier can be determined, and it can be determined which supplier the goods that have been shipped out belong to; in this way, the inventory status of each type of goods of different suppliers can be understood in real time, thereby achieving effective management of the goods.

[0106] Based on the foregoing embodiments, in other embodiments of the present application, refer to Figure 4 As shown, the information determination method may further include the following steps:

[0107] Step 208: The information determination device obtains the return quantity of each type of goods.

[0108] In the embodiment of the present application, the goods are returned according to the return criteria, and the return quantity of each type of goods can be obtained. In a feasible implementation, if one bottle of milk tea C is expired and one bottle is damaged, it can be determined that the return quantity of milk tea C is 2.

[0109] Step 209: The information determination device obtains the second incoming quantity of each type of goods and the third goods number of each type of goods from the incoming order.

[0110] In the embodiment of the present application, the second incoming quantity of each type of goods and the third goods number of each type of goods can be directly found from the incoming order. In a feasible implementation, it can be found from the incoming order that the second incoming quantity of the goods milk tea C is 130 and the third goods number is C20.

[0111] Step 210: The information determination device obtains the delivery note, and obtains the second delivery quantity of each type of goods from the delivery note based on the third goods number.

[0112] In a feasible embodiment, it can be directly found from the delivery order that the second delivery quantity of the third cargo number C20 is 116.

[0113] Step 211: The information determination device determines the supplier of each type of goods based on the third goods number, the warehousing order, the corresponding relationship and the purchase order.

[0114] In an embodiment of the present application, a second purchase order corresponding to the returned goods is determined based on the third goods number, the incoming order, and the correspondence between the purchase order and the incoming order, and then the supplier corresponding to the returned goods is determined based on the second purchase order; that is, the incoming order with the third goods number can be first searched from all incoming orders to obtain the incoming order for the returned goods, and then the second purchase order corresponding to the incoming order for the returned goods is determined based on the correspondence between the purchase order and the incoming order, and finally the supplier corresponding to the returned goods is obtained from the second purchase order.

[0115] In a feasible implementation method, the corresponding incoming order is queried from all incoming orders based on the third goods number C20, and the incoming order number of the incoming order with the third goods number C20 is C2. According to the correspondence between the incoming order and the purchase order, it is determined that the second purchase order number corresponding to the incoming order number C2 is C. According to the second purchase order number C, the purchase order with the second purchase order number C is found from all purchase orders, and the supplier of the third goods number C20 obtained from the purchase order is c.

[0116] Step 212: The information determining device rates each supplier for each type of goods based on the third goods number, the return quantity, the second incoming quantity, and the second outgoing quantity.

[0117] Wherein, step 212 can be implemented by the following methods:

[0118] Step 212a: The information determination device calculates a first ratio of the return quantity to the second incoming quantity based on the third cargo number for each type of cargo.

[0119] In a feasible implementation, the third cargo number of the cargo milk tea C is C20, the return quantity of the cargo milk tea C is 2 bottles, and the second incoming quantity is 130 bottles. At this time, the first ratio of the return quantity of the cargo milk tea C to the second incoming quantity is calculated to be 1.54%.

[0120] Step 212b: The information determination device calculates, for each type of goods, a second ratio of the second outbound quantity to the second inbound quantity based on the third goods number.

[0121] Among them, the second outbound quantity and second inbound quantity corresponding to the goods with the third goods number can be obtained from the determined second outbound quantity and second inbound quantity, and then for the goods with the same third goods number, the second outbound quantity corresponding to the goods with the third goods number is divided by the second inbound quantity to obtain the second ratio.

[0122] In a feasible implementation, for the third cargo number C20 of the cargo milk tea C, the second outbound quantity of the cargo milk tea C is 116 bottles, and the second inbound quantity is 130 bottles. At this time, the second ratio of the second outbound quantity to the second inbound quantity of the cargo milk tea C is calculated to be 89.2%.

[0123] Step 212c: The information determination device rates each supplier for each type of goods based on the third goods number, the first ratio, and the second ratio.

[0124] In an embodiment of the present application, for each type of goods, the first ratio and the second ratio with the same third goods number are analyzed, and each supplier is scored according to the analysis results; in a feasible implementation method, each supplier can be scored according to the size of the first ratio and the first preset ratio, and the size of the second ratio and the second preset ratio; it should be noted that the smaller the first ratio and the larger the second ratio, the higher the score of the supplier will be; among them, a score greater than or equal to 95 points is excellent, a score greater than or equal to 80 points is good, a score greater than or equal to 70 points is medium, and a score less than 70 points is poor.

[0125] It should be noted that in the embodiment of the present application, it is possible to accurately know which supplier the actual customer returns, supplier returns, and unsalable goods belong to, and to determine the grade of each supplier, which not only enables merchants to select high-quality suppliers from suppliers of the same type of goods, but also ensures the quality of the merchant's goods. In addition, the depletion quantity of each type of goods of the supplier can be predicted.

[0126] In other embodiments of the present application, the information determination method in the embodiment of the present application can be applied to the following: Figure 5 In the information determination system shown in, the system may include an in-and-out warehouse management module, a commodity warehouse relationship management mobile device module, a warehouse management device module, a commodity warehouse inventory management and corresponding supplier management module and an inventory analysis module: wherein the in-and-out warehouse order management module can realize the process of obtaining in-warehouse tasks and out-warehouse tasks, receiving and recording in-warehouse tasks and types, and receiving and recording out-warehouse tasks and types; it should be noted that after obtaining the in-warehouse tasks and out-warehouse tasks, the corresponding in-warehouse orders, purchase orders and out-warehouse orders can be obtained; the commodity warehouse relationship management mobile device module can realize the actual in-warehouse operation, binding the in-warehouse with the warehouse scanning, the actual out-warehouse, and the unbinding of the out-warehouse with the warehouse scanning; that is to say, when the goods are actually in-warehouse and out-warehouse, the commodity warehouse relationship management mobile device can be used The module updates the QR code information of the warehouse; the warehouse management equipment module can establish the QR code corresponding to the warehouse, scan to increase the commodity inventory of the corresponding warehouse, and scan to reduce the inventory of the corresponding warehouse; when establishing the QR code corresponding to the warehouse and scanning to increase the commodity inventory of the corresponding warehouse, the QR code image of the warehouse where the goods are located can be obtained and the QR code image can be identified and analyzed; the commodity warehouse inventory management and the corresponding supplier management module can record the commodity warehouse, warehouse entry form, supplier information, calculate the corresponding supplier warehouse entry and inventory quantity, record the warehouse location, warehouse entry form, and supplier information of the outbound commodity; the inventory analysis module can summarize the remaining inventory quantity of the entire supplier, use the remaining quantity and business records to calculate and analyze the supplier, and then rate each supplier according to the analysis results.

[0127] Based on the above embodiments, the embodiments of the present application provide an information determination device 6, which can be applied to Figure 1 , 2 , 3 and 4 corresponding to the information determination method provided in the embodiments, refer to Figure 6 As shown, the device 6 may include: a processor 61, a memory 62 and a communication bus 63, wherein:

[0128] The communication bus 63 is used to realize the communication connection between the processor 61 and the memory 62;

[0129] The processor 61 is used to execute the information determination program stored in the memory 62 to implement the following steps:

[0130] Obtain the purchase order and the warehouse entry order, and establish a corresponding relationship between the purchase order and the warehouse entry order; wherein the purchase order at least includes the supplier of the goods; the warehouse entry order at least includes the goods number;

[0131] Generate a warehouse location identifier for storing goods; wherein the warehouse location identifier uniquely identifies the warehouse; the warehouse stores the same type of goods of the same batch from the same supplier;

[0132] Obtaining a target warehouse identifier of a target warehouse corresponding to the goods to be processed, and obtaining a first cargo number of the goods to be processed based on the target warehouse identifier;

[0133] The supplier of the goods to be processed is determined based on the first goods number, the warehousing order, the corresponding relationship and the purchase order.

[0134] In other embodiments of the present application, the processor 61 is used to execute the instructions stored in the memory 62 to determine the supplier of the goods to be processed based on the first goods number, the warehousing order, the corresponding relationship and the purchase order, so as to implement the following steps:

[0135] Based on the first goods number, the warehousing order and the corresponding relationship, determine the target purchase order number corresponding to the goods to be processed;

[0136] Determine the supplier of the goods to be processed based on the target purchase order number and purchase order.

[0137] In other embodiments of the present application, the processor 61 is used to execute the first goods number, the warehousing order and the corresponding relationship stored in the memory 62 to determine the target purchase order number corresponding to the goods to be processed, so as to implement the following steps:

[0138] Determine a target incoming order corresponding to the first goods number from the incoming orders; wherein the incoming order includes an incoming order number;

[0139] Obtain the target incoming order number of the target incoming order, and determine the target purchase order number based on the target incoming order number and the corresponding relationship.

[0140] In other embodiments of the present application, the processor 61 is used to execute the process stored in the memory 62 to determine the supplier of the goods to be processed based on the target purchase order number and the purchase order, so as to implement the following steps:

[0141] According to the target purchase order number, a target purchase order is obtained; wherein the purchase order also includes the purchase order number;

[0142] Get the supplier of the goods to be processed from the target purchase order.

[0143] In other embodiments of the present application, the processor 61 is used to execute the information determination program stored in the memory 62, and can also implement the following steps:

[0144] Obtain the outbound shipment order, and determine the second cargo number of each type of outbound cargo and the first outbound quantity of each type of outbound cargo from the outbound shipment order;

[0145] Based on the second goods number, the first outbound quantity, the incoming order, the corresponding relationship and the purchase order, the inventory quantity of each type of goods of each supplier is determined.

[0146] In other embodiments of the present application, the processor 61 is used to execute the second cargo number, the first outbound quantity, the incoming cargo order, the corresponding relationship and the purchase order stored in the memory 62 to determine the inventory quantity of each type of cargo of each supplier, so as to implement the following steps:

[0147] Based on the second cargo number, a first incoming quantity of each type of cargo corresponding to the type of the outgoing cargo is obtained from the incoming cargo order;

[0148] Determine the supplier of each type of outbound goods based on the second goods number, incoming order, corresponding relationship and purchase order;

[0149] Based on the first outbound quantity, the first inbound quantity and the supplier, the inventory quantity of each type of goods corresponding to the type of each supplier and the type of the outbound goods is determined.

[0150] In other embodiments of the present application, the processor 61 is used to execute the information determination program stored in the memory 62, and can also implement the following steps:

[0151] Get the return quantity of each type of goods;

[0152] Obtain the second incoming quantity of each type of goods and the third goods number of each type of goods from the incoming order;

[0153] Obtain the outbound delivery note, and obtain the second outbound quantity of each type of goods from the outbound delivery note based on the third goods number;

[0154] Determine the supplier of each type of goods based on the third-party goods number, warehouse entry order, correspondence and purchase order;

[0155] For each type of goods, each supplier is rated based on the third goods number, return quantity, second inbound quantity, and second outbound quantity.

[0156] In other embodiments of the present application, the processor 61 is used to execute the storage in the memory 62 to rate each supplier based on the three goods numbers, the return quantity, the second inbound quantity, and the second outbound quantity for each type of goods, so as to implement the following steps:

[0157] For each type of goods, a first ratio of the returned quantity to the second incoming quantity is calculated based on the third goods number;

[0158] For each type of goods, calculating a second ratio of the second outbound quantity to the second inbound quantity based on the third goods number;

[0159] For each type of goods, each supplier is rated based on the third goods number, the first ratio and the second ratio.

[0160] It should be noted that the specific implementation process of the steps executed by the processor in this embodiment can refer to Figure 1 , 2 The implementation process of the information determination method provided in the embodiments corresponding to , 3 and 4 will not be repeated here.

[0161] The information determination device provided in the embodiment of the present application determines different suppliers corresponding to the same kind of goods based on the goods number, the warehouse entry form, the warehouse entry form number, the purchase order, the purchase order number, the correspondence between the warehouse entry form and the purchase order, and the supplier; and solves the problem of quality problems with the same goods, poor sales of goods requiring returns, and the inability to accurately locate the corresponding supplier of the goods.

[0162] Based on the foregoing embodiments, an embodiment of the present application provides a computer-readable storage medium, which stores one or more programs, and the one or more programs can be executed by one or more processors to implement the following steps:

[0163] Obtain the purchase order and the warehouse entry order, and establish a corresponding relationship between the purchase order and the warehouse entry order; wherein the purchase order at least includes the supplier of the goods; the warehouse entry order at least includes the goods number;

[0164] Generate a warehouse location identifier for storing goods; wherein the warehouse location identifier uniquely identifies the warehouse; the warehouse stores the same type of goods of the same batch from the same supplier;

[0165] Obtaining a target warehouse identifier of a target warehouse corresponding to the goods to be processed, and obtaining a first cargo number of the goods to be processed based on the target warehouse identifier;

[0166] The supplier of the goods to be processed is determined based on the first goods number, the warehousing order, the corresponding relationship and the purchase order.

[0167] In other embodiments of the present application, the one or more programs may be executed by one or more processors to determine the supplier of the goods to be processed based on the first goods number, the warehousing order, the corresponding relationship and the purchase order to implement the following steps:

[0168] Based on the first goods number, the warehousing order and the corresponding relationship, determine the target purchase order number corresponding to the goods to be processed;

[0169] Determine the supplier of the goods to be processed based on the target purchase order number and purchase order.

[0170] In other embodiments of the present application, the one or more programs may be executed by one or more processors to determine the target purchase order number corresponding to the goods to be processed based on the first goods number, the warehousing order and the corresponding relationship, so as to implement the following steps:

[0171] Determine a target incoming order corresponding to the first goods number from the incoming orders; wherein the incoming order includes an incoming order number;

[0172] Obtain the target incoming order number of the target incoming order, and determine the target purchase order number based on the target incoming order number and the corresponding relationship.

[0173] In other embodiments of the present application, the one or more programs may be executed by one or more processors to determine the supplier of the goods to be processed based on the target purchase order number and the purchase order, so as to implement the following steps:

[0174] According to the target purchase order number, a target purchase order is obtained; wherein the purchase order also includes the purchase order number;

[0175] Get the supplier of the goods to be processed from the target purchase order.

[0176] In other embodiments of the present application, the one or more programs may be executed by one or more processors, and the following steps may also be implemented:

[0177] Obtain the outbound shipment order, and determine the second cargo number of each type of outbound cargo and the first outbound quantity of each type of outbound cargo from the outbound shipment order;

[0178] Based on the second goods number, the first outbound quantity, the incoming order, the corresponding relationship and the purchase order, the inventory quantity of each type of goods of each supplier is determined.

[0179] In other embodiments of the present application, the one or more programs may be executed by one or more processors to determine the inventory quantity of each type of goods of each supplier based on the second goods number, the first outbound quantity, the incoming order, the corresponding relationship, and the purchase order to implement the following steps:

[0180] Based on the second cargo number, a first incoming quantity of each type of cargo corresponding to the type of the outgoing cargo is obtained from the incoming cargo order;

[0181] Determine the supplier of each type of outbound goods based on the second goods number, incoming order, corresponding relationship and purchase order;

[0182] Based on the first outbound quantity, the first inbound quantity and the supplier, the inventory quantity of each type of goods corresponding to the type of each supplier and the type of the outbound goods is determined.

[0183] In other embodiments of the present application, the one or more programs may be executed by one or more processors, and the following steps may also be implemented:

[0184] Get the return quantity of each type of goods;

[0185] Obtain the second incoming quantity of each type of goods and the third goods number of each type of goods from the incoming order;

[0186] Obtain the outbound delivery note, and obtain the second outbound quantity of each type of goods from the outbound delivery note based on the third goods number;

[0187] Determine the supplier of each type of goods based on the third-party goods number, warehouse entry order, correspondence and purchase order;

[0188] For each type of goods, each supplier is rated based on the third goods number, return quantity, second inbound quantity, and second outbound quantity.

[0189] In other embodiments of the present application, the one or more programs may be executed by one or more processors to rate each supplier for each type of goods based on the third goods number, the return quantity, the second inbound quantity, and the second outbound quantity, so as to implement the following steps:

[0190] For each type of goods, a first ratio of the returned quantity to the second incoming quantity is calculated based on the third goods number;

[0191] For each type of goods, calculating a second ratio of the second outbound quantity to the second inbound quantity based on the third goods number;

[0192] For each type of goods, each supplier is rated based on the third goods number, the first ratio and the second ratio.

[0193] It should be noted that the specific implementation process of the steps executed by the processor in this embodiment can refer to Figure 1 , 2 The implementation process of the information determination method provided in the embodiments corresponding to , 3, and 4 will not be repeated here.

[0194] It should be understood that "one embodiment" or "an embodiment" mentioned throughout the specification means that specific features, structures or characteristics related to the embodiment are included in at least one embodiment of the present application. Therefore, "in one embodiment" or "in an embodiment" appearing throughout the specification does not necessarily refer to the same embodiment. In addition, these specific features, structures or characteristics can be combined in one or more embodiments in any suitable manner. It should be understood that in various embodiments of the present application, the size of the sequence number of the above-mentioned processes does not mean the order of execution, and the execution order of each process should be determined by its function and internal logic, and should not constitute any limitation on the implementation process of the embodiments of the present application. The above-mentioned sequence numbers of the embodiments of the present application are only for description and do not represent the advantages and disadvantages of the embodiments.

[0195] It should be noted that, in this article, the terms "include", "comprises" or any other variations thereof are intended to cover non-exclusive inclusion, so that a process, method, article or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or device. In the absence of further restrictions, an element defined by the sentence "comprises a ..." does not exclude the existence of other identical elements in the process, method, article or device including the element.

[0196] In the several embodiments provided in the present application, it should be understood that the disclosed devices and methods can be implemented in other ways. The device embodiments described above are only schematic. For example, the division of units is only a logical function division. There may be other division methods in actual implementation, such as: multiple units or components can be combined, or can be integrated into another system, or some features can be ignored or not executed. In addition, the coupling, direct coupling, or communication connection between the components shown or discussed can be through some interfaces, and the indirect coupling or communication connection of devices or units can be electrical, mechanical or other forms.

[0197] In addition, all functional units in the embodiments of the present application may be integrated into one processing unit, or each unit may be a separate unit, or two or more units may be integrated into one unit; the above-mentioned integrated units may be implemented in the form of hardware or in the form of hardware plus software functional units.

[0198] A person skilled in the art can understand that all or part of the steps of implementing the above method embodiment can be completed by hardware related to program instructions, and the aforementioned program can be stored in a computer-readable storage medium. When the program is executed, it executes the steps of the above method embodiment; and the aforementioned storage medium includes: mobile storage devices, read-only memories (ROM), magnetic disks or optical disks, etc., various media that can store program codes.

[0199] Alternatively, if the above-mentioned integrated unit of the present application is implemented in the form of a software function module and sold or used as an independent product, it can also be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the embodiment of the present application can essentially or in other words, the part that contributes to the prior art can be embodied in the form of a software product, which is stored in a storage medium and includes a number of instructions for a computer device (which can be a personal computer, a server, or a network device, etc.) to execute all or part of the methods of each embodiment of the present application. The aforementioned storage medium includes: various media that can store program codes, such as mobile storage devices, ROMs, magnetic disks, or optical disks.

[0200] The above are only specific implementations of the present application, but the protection scope of the present application is not limited thereto. Any technician familiar with the technical field can easily think of changes or substitutions within the technical scope disclosed in the present application, which should be included in the protection scope of the present application. Therefore, the protection scope of the present application should be based on the protection scope of the claims.

Claims

1. A method for determining information, characterized in that: The method comprises: Obtain a purchase order and a storage entry order, and establish a corresponding relationship between the purchase order and the storage entry order; wherein the purchase order at least includes the supplier of the goods; each purchase order corresponds to one supplier, and each purchase order corresponds to multiple storage entry orders; the storage entry order at least includes the goods number, and each storage entry order corresponds to one type of goods; Generate a warehouse location identifier for storing goods; wherein the warehouse location identifier uniquely identifies the warehouse; the warehouse stores the same type of goods from the same batch of the same supplier; Obtaining a target warehouse identifier of a target warehouse corresponding to the goods to be processed, and obtaining a first cargo number of the goods to be processed based on the target warehouse identifier; Determine the supplier of the goods to be processed based on the first goods number, the warehousing order, the corresponding relationship and the purchase order; Rating each supplier based on the item number, return quantity, inbound quantity, and outbound quantity for each type of goods; Wherein, determining the supplier of the goods to be processed based on the first goods number, the warehousing order, the corresponding relationship and the purchase order includes: Determine a target entry order corresponding to the first cargo number from the entry order; wherein the entry order includes an entry order number; Determine the target purchase order number corresponding to the goods to be processed based on the target entry order number of the target entry order and the corresponding relationship; Based on the target purchase order number and the purchase order, a supplier corresponding to the goods to be processed is determined.

2. The method according to claim 1, characterized in that The determining, based on the first cargo number, the warehousing order and the corresponding relationship, a target purchase order number corresponding to the cargo to be processed includes: Get the target incoming order number of the target incoming order.

3. The method according to claim 1, characterized in that The step of determining the supplier of the goods to be processed based on the target purchase order number and the purchase order includes: According to the target purchase order number, a target purchase order is obtained; wherein the purchase order also includes the purchase order number; The supplier of the goods to be processed is obtained from the target purchase order.

4. The method according to claim 1, characterized in that: The method further comprises: Obtaining an outbound shipment order, and determining a second cargo number of each type of outbound cargo and a first outbound quantity of each type of outbound cargo from the outbound shipment order; Based on the second cargo number, the first outbound quantity, the incoming cargo order, the corresponding relationship and the purchase order, the inventory quantity of each type of cargo of each supplier is determined.

5. The method according to claim 4, characterized in that The step of determining the inventory quantity of each type of goods of each supplier based on the second goods number, the first outbound quantity, the incoming order, the corresponding relationship, and the purchase order includes: Based on the second cargo number, obtaining from the inbound order a first inbound quantity of each category of cargo corresponding to the category of the outbound cargo; Determine the supplier of each type of outbound goods based on the second goods number, the incoming order, the corresponding relationship and the purchase order; Based on the first outbound quantity, the first inbound quantity and the suppliers, the inventory quantity of each type of goods corresponding to the category of each supplier and the category of the outbound goods is determined.

6. The method according to claim 1, characterized in that The method comprises: Get the return quantity of each type of goods; Obtaining the second incoming quantity of each type of goods and the third goods number of each type of goods from the incoming order; Obtaining an outbound shipment order, and obtaining a second outbound quantity of each type of goods from the outbound shipment order based on the third goods number; Determine the supplier of each type of goods based on the third goods number, the warehousing order, the corresponding relationship and the purchase order; For each type of goods, each supplier is rated based on the third goods number, the return quantity, the second inbound quantity and the second outbound quantity.

7. The method according to claim 6, characterized in that For each type of goods, rating each supplier based on the third goods number, the return quantity, the second inbound quantity, and the second outbound quantity includes: For each type of goods, calculating a first ratio of the returned quantity to the second incoming quantity based on the third goods number; For each type of goods, calculating a second ratio of the second outbound quantity to the second inbound quantity based on the third goods number; For each type of goods, each supplier is rated based on the third goods number, the first ratio and the second ratio.

8. An information determination device, characterized in that The device comprises: a processor, a memory and a communication bus; The communication bus is used to realize the communication connection between the processor and the memory; The processor is used to execute the information determination program stored in the memory to implement the following steps: Obtain a purchase order and a storage entry order, and establish a corresponding relationship between the purchase order and the storage entry order; wherein the purchase order at least includes the supplier of the goods; each purchase order corresponds to one supplier, and each purchase order corresponds to multiple storage entry orders; the storage entry order at least includes the goods number, and each storage entry order corresponds to one type of goods; Generate a warehouse location identifier for storing goods; wherein the warehouse location identifier uniquely identifies the warehouse; the warehouse stores the same type of goods from the same batch of the same supplier; Obtaining a target warehouse identifier of a target warehouse corresponding to the goods to be processed, and obtaining a first cargo number of the goods to be processed based on the target warehouse identifier; Determine a target entry order corresponding to the first cargo number from the entry order; wherein the entry order includes an entry order number; Determine the target purchase order number corresponding to the goods to be processed based on the target entry order number of the target entry order and the corresponding relationship; Determining the supplier of the goods to be processed based on the target purchase order number and the purchase order; Rating each supplier based on the item number, return quantity, inbound quantity, and outbound quantity for each type of goods.

9. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores one or more programs, and the one or more programs can be executed by one or more processors to implement the steps of the information determination method according to any one of claims 1 to 7.

Citation Information

Patent Citations

  • A method for realizing reverse tracing at batch level in the pharmaceutical industry

    CN109299897A

  • Data object inventory information processing method, device and system

    CN110322186A