Warehouse data processing system and method

• US 9,734,482 B2
• Filed: 06/23/2015
• Issued: 08/15/2017
• 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
• Primary Examiner(s): Brown, Claude J
• Application Number:
  US14/896,799
• Publication Number:
  US 20160342938A1
• Time in Patent Office: 784 Days
• Field of Search: 235385
• 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 goods management system comprising a handheld terminal and a database server connected with each other via a wireless communication, wherein the handheld terminal is configured to scan goods information comprising at least one of an outer package code, an inner package code and a goods code, and acquire stock data including the goods information from the database server;

wherein the handheld terminal comprises a code-scanning unit and a data processing unit connected to the code-scanning unit, and 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 so that the code-scanning unit scans the outer package code;

the inventorying unit is further configured to receive the scanned outer package code from the code-scanning unit, query in the database server whether an outer package corresponding to the received outer package code is full, if the outer package is full, trigger the code-scanning unit to randomly scan an inner package code of an inner package within the outer package and derive inner package codes of all the inner packages within the outer package from the database server.

2. The goods management system according to claim 1, wherein the handheld terminal is further configured to scan stock location codes, and the stock data acquired from the database server further comprises the stock location codes;

wherein the code-scanning unit is further configured to transmit the scanned goods information and stock location codes to the data processing unit, and the data processing unit is connected to the database server and configured to perform data processing on the stock data according to the scanned goods information and stock location codes.

3. The goods management system according to claim 1, 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, so that the code-scanning unit scans an outer package code corresponding to goods to be transferred and a new stock location code, and transmits the outer package code and the new stock location code to the stock-transfer unit, the stock-transfer unit transmits the outer package code 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 to the new stock location code.

4. The goods management system according to claim 3, 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 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.

5. The goods management system according to claim 1, wherein the code-scanning unit is further configured to scan the inner package code and sends the scanned outer package code and the inner package code to the inventorying unit;

the inventorying unit is configured to establish a package relation record indicating that the inner package corresponding to the inner package code is within the outer package corresponding the outer package code, generate a temporary datasheet comprising the outer package code, the inner package code and the package relation record, acquire a currently stored stock datasheet comprising the outer package code, the inner package code and the package relation record from the database server, compare the temporary datasheet and the stock datasheet, and if there is a difference, generate a difference report.

6. The goods management system according to claim 5, wherein the inventorying unit is further configured, if the outer package is not full, to trigger the code-scanning unit to scan inner package codes of all the inner packages within the outer package one by one, and send the inner package codes of all the inner packages within the outer package to the inventorying unit.

7. The goods management system according to claim 1, 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, so that the code-scanning unit transmits the scanned outer package code, inner package code and goods code to the check unit;

the check unit is configured to query in the database server, determine whether the packaging relation record of the scanned outer package code, inner package code and the goods code is consistent with the packaging relation record in the database, and if inconsistent, prompt packaging error information.

8. The goods management system according to claim 7, wherein the check unit is configured, after the check unit receives the outer package code and the inner package code sent from the code-scanning unit, to query whether the packaging relation of the outer package code and the inner package code is correct in the database server, if incorrect, prompt a checking failure, and if correct, query whether the inner package is full, if it is full, the check unit is configured to prompt that the check is successful, if it is not full, the check unit is configured to trigger the code-scanning unit to scan the codes of all the goods in the inner package one by one and determine whether the packaging relation between the goods and the inner package is correct, if correct, prompt that the check is successful, otherwise, prompt check failure.

9. The goods management system according to claim 1, 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, report an error and trigger to continue a scanning.

10. The goods management system according to claim 1, wherein the handheld terminal is a palm computer, a tablet computer or a smart phone.

11. A goods management method, comprising:

scanning, by a handheld terminal, goods information including at least one of an outer package code, an inner package code and a goods code; and

acquiring, from a database server connected to the handheld terminal via a wireless communication, stock data including the goods information;

wherein the handheld terminal comprises a code-scanning unit and a data processing unit connected to the code-scanning unit, and 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 so that the code-scanning unit scans the outer package code;

the inventorying unit is further configured to receive the scanned outer package code from the code-scanning unit, query in the database server whether an outer package corresponding to the received outer package code is full, if the outer package is full, trigger the code-scanning unit to randomly scan an inner package code of an inner package within the outer package and derive inner package codes of all the inner packages within the outer package from the database server.

12. The goods management method according to claim 11, wherein the handheld terminal is further configured to scan stock location codes, and the stock data acquired from the database server further comprises the stock location codes, and the data processing unit further comprises a stock-transfer unit connected to the code-scanning unit, and the goods management method further comprises:

scanning, by the code-scanning unit, an outer package code corresponding to goods to be transferred and a new stock location code according to a stock transfer instruction; and

transmitting, by the stock-transfer unit, the outer package code 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 to the new stock location code.

13. The goods management method according to claim 11, further comprising:

scanning, by the code-scanning unit, the inner package code according to the inventorying instruction;

establishing, by the inventory unit, a package relation record indicating that an inner package corresponding to the inner package code is within an outer package corresponding to the outer package code;

generating, by the inventory unit, a temporary datasheet comprising the outer package code, the inner package code and the package relation record;

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

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

14. The goods management method according to claim 11, wherein the data processing unit further comprises a check unit connected to the code-scanning unit, and the goods management method further comprises:

scanning, by the code-scanning unit, the outer package code, the inner package code and the goods code according to a check instruction; and

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