WAREHOUSE DATA PROCESSING SYSTEM AND METHOD

• US 20160342938A1
• Filed: 06/23/2015
• Published: 11/24/2016
• Est. Priority Date: 12/16/2014
• Status: Active Grant

• Current Assignee: BOE Technology Group Co., Ltd., Hefei Xinsheng Optoelectronics Technology Company Limited (BOE Technology Group Co., Ltd.)
• Original Assignee: BOE Technology Group Co., Ltd., Hefei Xinsheng Optoelectronics Technology Company Limited (BOE Technology Group Co., Ltd.)
• Inventors: TIAN, Zhiming, WU, Jianmin, SU, Xieming
• Granted Patent: US 9,734,482 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/23 Updating
• CPC Class Codes: G06K 7/10861 sensing of data fields affixed to objects or articles, e.g. coded labels postal sorting B07C3/14, conveying articles B65G47/48
• CPC Class Codes: G06Q 10/08 Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
• CPC Class Codes: G06Q 10/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders

Abstract

A warehouse data processing system including a handheld terminal and a database server, wherein the handheld terminal is connected with the database server, the handheld terminal is used to scan goods information and/or stock location codes, acquire stock data including the goods information and/or the stock location codes from the database server, and perform warehouse data processing on the stock data according to the scanned goods information and/or stock location codes. The warehouse data processing is achieved in a mobile and portable manner by using the handheld terminal to scan goods information and/or stock location codes and performing warehouse data processing on the stock data according to the scanned goods information and/or stock location codes.

Claims

1. A warehouse data processing system comprising a handheld terminal and a database server, wherein the handheld terminal is connected with the database server, the handheld terminal is configured to scan goods information and/or stock location codes, to acquire stock data including the goods information and/or the stock location codes from the database server, and to perform warehouse data processing on the stock data according to the scanned goods information and/or stock location codes.

2. The warehouse data processing system according to claim 1, wherein the handheld terminal comprises a code-scanning unit and a data processing unit connected to the code-scanning unit, wherein the code-scanning unit is configured to transmit the scanned goods information and/or stock location codes to the data processing unit, and the data processing unit is connected to the database server and configured to perform warehouse data processing on the stock data according to the scanned goods information and/or stock location codes.

3. The warehouse data processing system according to claim 2, wherein the goods information comprises at least one of an outer package code of goods, an inner package code of goods and a goods code.

4. The warehouse data processing system according to claim 3, wherein the data processing unit comprises a stock-transfer unit connected to the code-scanning unit, wherein the stock-transfer unit is configured to send a stock-transfer instruction to the code-scanning unit, the code-scanning unit scans an outer package code of goods to be transferred and a new stock location code, and transmits the outer package code of the goods to be transferred and the new stock location code to the stock-transfer unit, the stock-transfer unit transmits the outer package code of goods and the new stock location code to the database server to allow the database server to update the previous stock location code in the stock data corresponding to the outer package code of goods to the new stock location code.

5. The warehouse data processing system according to claim 4, wherein the stock-transfer unit is further configured to query whether the new stock location code is labeled as an occupied state in the database server before transmitting the outer package code of goods and the new stock location code to the database server, and if it is labeled, the code-scanning unit is triggered to re-scan a new stock location code until a stock location which is not labeled as an occupied state is scanned.

6. The warehouse data processing system according to claim 3, wherein the data processing unit comprises an inventorying unit connected to the code-scanning unit, wherein the inventorying unit is configured to send an inventorying instruction to the code-scanning unit;

the code-scanning unit scans the outer package code of goods and the inner package code of goods and sends them to the inventorying unit, the inventorying unit establishes a package relation record corresponding to the fact that the inner package code of goods belongs to the outer package code of goods, generates a temporary datasheet comprising the outer package code of goods, the inner package code of goods and the package relation record, acquires a currently stored stock datasheet comprising the outer package code of goods, the inner package code of goods and the package relation record from the database server, compares the temporary datasheet and the stock datasheet, and if there is a difference, generates a difference report.

7. The warehouse data processing system according to claim 6, wherein after the inventorying unit receives the outer package code of goods sent from the code-scanning unit, the inventorying unit queries whether the corresponding outer package is full in the database server, if it is full, triggers the code-scanning unit to randomly scan an inner package code of goods within the outer package, and derives inner package codes of all the goods corresponding to the outer package code of goods from the database server, and if it is not full, triggers the code-scanning unit to scan inner package codes of all the goods in the outer package one by one, and sends the inner package codes of all the goods within the outer package to the inventorying unit.

8. The warehouse data processing system according to claim 3, wherein the data processing unit comprises a check unit connected to the code-scanning unit, the check unit is configured to send a check instruction to the code-scanning unit, the code-scanning unit transmits the scanned outer package code of goods, inner package code of goods and goods code to the check unit, the check unit queries in the database server, determines whether the packaging relation record of the scanned outer package code of goods, inner package code of goods and the goods code is consistent with the packaging relation record in the database, and if inconsistent, prompts packaging error information.

9. The warehouse data processing system according to claim 8, wherein after the check unit receives the outer package code of goods and the inner package code of goods sent from the code-scanning unit, the check unit queries whether the packaging relation of the outer package code and the inner package code of goods is correct in the database server, if incorrect, prompts a checking failure, and if correct, queries whether the inner package is full, if it is full, the check unit prompts that the check is successful, if it is not full, the check unit triggers the code-scanning unit to scan the codes of all the goods in the inner package one by one and determines whether the packaging relation between the goods and the inner package is correct, if correct, prompts that the check is successful, otherwise, prompts check failure.

10. The warehouse data processing system according claim 3, wherein the code-scanning unit is further configured to determine whether the scanned code exists in the database server after the scanning is completed, and if not exists, reports an error and triggers to continue a scanning.

11. The warehouse data processing system according to claim 1, wherein the handheld terminal is a palm computer, a tablet computer or a smart phone.

12. A warehouse data processing method, comprising:

scanning goods information and/or stock location codes;

acquiring stock data including the goods information and/or the stock location codes from a database server; and

performing warehouse data processing on the stock data according to the scanned goods information and/or stock location codes,

wherein the goods information comprises at least one of outer package code of goods, inner package code of goods and code of goods.

13. The warehouse data processing method according to claim 12, further comprising:

scanning an outer package code of goods to be transferred and a new stock location code according to a stock transfer instruction; and

transmitting the outer package code of goods and the new stock location code to the database server so that the database server updates the previous stock location code in the stock data corresponding to the outer package code of goods to the new stock location code.

14. The warehouse data processing method according to claim 12, further comprising:

scanning the outer package code and the inner package code of goods according to an inventorying instruction;

establishing a package relation record indicating that the inner package code of goods belongs to the outer package code of goods;

generating a temporary datasheet comprising the outer package code of goods, the inner package code of goods and the package relation record;

acquiring a currently stored stock datasheet comprising the outer package code of goods, the inner package code of goods and the package relation record from the database server; and

comparing the temporary datasheet and the stock datasheet, and if there is a different record, generating a difference report.

15. The warehouse data processing method according to claim 12, further comprising:

scanning the outer package code of goods, the inner package code of goods and the goods code according to a check instruction; and

inquiring the database server, and determining whether the packaging relation record of the scanned outer package code of goods, inner package code of goods and the goods code is consistent with the packaging relation record in the database, and if inconsistent, prompting packaging error information.