JP2015101424A - Commodity inventory system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To achieve inventory work at low cost and with a simple system, based on inventory target commodities collected by a portable terminal using a scanner and a place where the commodities are placed.SOLUTION: A scanner 11 reads identification display for identifying commodities 14 which are inventory targets and identification display for identifying a place 13 where the commodities 14 are placed, and by receiving actual number data of the commodities 14 read by the scanner 11, and place data where the commodities 14 are placed, a portable terminal 12 compares the actual number data and commodity data stored in a database 23 corresponding to the place where the commodities are placed, and when there is difference between these pieces of data, by executing inventory management program, commodity stock record of the database 23 is rewritten for adjusting the difference.

Description

  The present invention relates to a product inventory system that performs inventory of products stored in a storage shelf or the like.

  The inventory is an operation for confirming the actual inventory quantity (physical inventory) that is periodically performed in order to grasp the difference between the inventory quantity described in the book and the actual inventory quantity. Conventionally, the operator counts the products in stock stored in the storage shelf, compares the actual number of products in stock with a personal computer, and the product inventory recorded in the database after the previous inventory, and the comparison result Is displayed on the display. In this case, the inventory quantity (in the book) stored in the database and the actual inventory quantity must match, but often do not match due to circumstances such as theft, loss, or entry error. For this reason, the difference is accurately grasped, and an adjustment is made so that the book value conforms to the actual inventory amount.

  For example, the operator carries an inventory product table and enters the number of products on the storage shelf (the number of inventory) visually counted in the inventory product table. When the entry of the number of products in this inventory table is completed for all the products on the storage shelf, the entry result is input to the terminal computer, and the inventory product number data input to this terminal computer is transmitted to the host computer. Is done. The host computer compares the actual number of inventory products counted visually with the number of inventory products recorded in the database since the previous inventory, and the actual number of inventory products differs from the number of product inventory recorded in the database. In such a case, the operator is urged to reconfirm the actual number of the inventory items.

  However, in the inventory method described above, when keying the actual number of inventory products entered in the inventory product table into the entry frame of the calculation table displayed on the terminal computer, the correspondence between the inventory product table and the entry frame is visually checked. However, the response is insufficient, leading to an error in the number of products in stock in the entry frame.

On the other hand, for example, a handy terminal is used to avoid human input errors when keying the number of products entered in the inventory product table as described above into the entry frame of the calculation table displayed on the terminal computer. A stocktaking method has also been proposed. In this inventory method, each identification display of a place display label affixed to the place to identify the place where the inventory product is placed and a product label affixed to the inventory product to identify the inventory product Is read using a handy terminal. This reading is performed for all of the inventory products placed at the planned location, and the real number data of the inventory products is accumulated in the handy terminal without any input error.

  However, in the method using the handy terminal for the inventory as described above, the handy terminal only stores the real number data of the inventory product, and the offline use is separated from the network and other devices. The determination information as to whether or not the data has been correctly input cannot be obtained. On the other hand, the manager can only grasp the actual number of the inventoried products and the progress of the work only by the report of the worker.

  In addition, after the operator finishes reading the number of items in stock at the planned location, the worker transfers the actual number data of the items stored in the handy terminal to a terminal computer connected to the handy terminal via a cable. It is necessary to transfer from this terminal computer to the host computer on the manager side. In order to transfer various kinds of data including real number data of inventory products between these handy terminals, terminal computers, and host computers, it is necessary to prepare a special transfer program and execute it. This complicates the system configuration and operation. In this case, at the site of reading the number of products in stock, the administrator can only confirm the list of products and locations printed on the manager side.

  Furthermore, in order to confirm (add) the product data in the list, one person must read the product code in the list, and one person can visually check the product in stock. This is handwritten in the list. After the confirmation work at the site, the host computer rewrites the number of inventory items recorded in the database based on the written list. Since the rewriting work of inventory is performed collectively later, the rewriting of the rewriting may occur.

  The present invention solves the above-described conventional problems, and the object of the present invention is to perform inventory work based on a product to be stocked collected by a portable terminal using a scanner and a place where the product is placed. Is to provide a product inventory system that can be realized at a low cost with a simple system.

  In order to achieve the above object, a product inventory system according to the present invention includes an identification display for specifying a product to be inventoried and a scanner for reading an identification display for specifying a place where the product is placed, Receive the real number data of the product read by the scanner and the location data where the product is placed, compare the real number data with the product data stored in the database corresponding to the location where the product is placed, and And a portable terminal that rewrites the product inventory record in the database so as to adjust the difference when the inventory management program is executed.

  With this configuration, the inventory control process performed in the portable terminal simultaneously with the reading of the actual number of the product by the scanner, the difference between the actual number of the product read by the scanner and the number of the inventory products to be recorded in the database in the portable terminal This makes it possible to check quickly and reliably at the hand of the inventory operator, thus avoiding the occurrence of double counting of the same product and mistakes in rewriting the number of products in stock due to the conventional manual work. In addition, it is possible to identify the cause of wrong work and display a warning in real time.

Further, the product inventory system according to the present invention is characterized in that the mobile terminal can display product data stored in a database corresponding to a place where a product to be inventoried is placed on a display unit.
Thereby, it is possible to compare the actual number of products placed in a storage shelf or the like and the number of stock products to be recorded in the database while monitoring on the display unit, and based on the comparison result, the actual number of products and the number of stock products Can be confirmed accurately and promptly on the mobile terminal.

The product inventory system according to the present invention is characterized in that the product data stored in the database includes at least a product code and a product name of a product to be inventoried.
This makes it possible to carry out the inventory work for each product quickly and without error while visually checking the product code and product name of the product to be inventoried.

In the commodity inventory system according to the present invention, the portable terminal is a tablet terminal.
As a result, the worker can complete all inventory processing on the tablet-type mobile terminal that is carried at the inventory site, and if necessary, the number of products in stock with the external inventory management device Exchange and sharing of product data such as can be confirmed on a large and easy-to-read screen.

  According to the present invention, data collected using a scanner is directly processed on a portable terminal, thereby making it possible to avoid movement and setting work between the site and the management device as in the past, Efficiency can be improved.

  The present invention has been briefly described above. Further, embodiments of the present invention will be described below in detail with reference to the accompanying drawings.

1 is a system configuration diagram showing a product inventory system according to the present invention. It is a block connection diagram of the portable terminal in FIG. It is a flowchart which shows the inventory procedure by the inventory system of this invention.

  FIG. 1 is a system configuration diagram of a product inventory system according to the present embodiment. The inventory system includes a scanner 11 and a mobile terminal 12. Among these, the scanner 11 can be carried by a person in charge of inventory work (inventory worker), and has a size and shape that can be held and easily operated by being held by a hand. The scanner 11 reads an identification display for specifying a plurality of inventory target products 14 stored in the storage shelf 13 and an identification display for specifying a storage location of the storage shelf 13 storing the inventory target products 14 at the inventory site. Operated.

  These identification displays are printed on the labels L1 and L2 attached to the storage location and the product 14, and the scanner 11 photoelectrically reads the identification displays on the labels L1 and L2. For example, a label L1 printed with an identification display for specifying the location is attached to the product storage location partitioned in the storage shelf 13, and each product 14 stored in each product storage location has its inventory target. A label L2 on which an identification display for specifying the product is printed is attached. The scanner 11 reads the identification display on the labels L1 and L2 to identify the product data such as the product code, quantity, and product name of the product 14 and the location data of the place where the product 14 is placed. Output information.

  As the identification display, a bar code or QR code widely used for photoelectric identification, or an IC tag for identification using radio waves can be used. Then, by holding the reading unit of the scanner 11 over the labels L1 and L2, and reading the identification display on the labels L1 and L2, the product data and the location data of the place where the product 14 is placed, It can be temporarily stored in a readable / writable inventory product information file (not shown). Further, the product 14 and the location information read in this way can be displayed in an entry frame on the display unit (display) of the mobile terminal 12 according to a predetermined format.

  As the mobile terminal 12, a multi-function mobile phone called a smartphone or a tablet-type mobile terminal can be used. However, in the present invention, the amount of information to be processed is large, the display screen is large and easy to see, and information input / output operations are easy. It is desirable to use the tablet type portable terminal 12. The portable terminal 12 receives the inventory information 14 and location information read from the identification display on the labels L1 and L2 from the scanner 11 and records them in the inventory information file or database as described above in the portable terminal 12. Or make it storable. Note that the portable terminal 12 can be transmitted to an external inventory management device (host computer) or the like via a wireless LAN (not shown) and the Internet as necessary.

  The mobile terminal 12 receives the real number data of the inventory item read by the scanner 11 and the location data, and compares it with the product data in stock stored in the database provided for the real number data and location data. Thus, it is possible to confirm whether or not there is a difference in the number of products, and when there is a difference, according to a predetermined inventory management program, it functions to rewrite the records in the database so that the correct inventory quantity is obtained. The rewriting result can be immediately confirmed on the display unit, and the rewriting result can be transmitted to the above-described inventory management apparatus via the Internet or a wireless LAN as necessary.

  The database stores (stores) product data including data on product codes, product names, product numbers, and stock locations (such as shelf numbers) for each stock product according to a predetermined format. Also, a printing device or the like can be connected to the mobile terminal 12, and in this case, product data such as the product code, product name, and inventory location stored in a database or the like can be printed out.

  The mobile terminal 12 has a hardware configuration that realizes functions unique to the inventory system in addition to a hardware configuration that is originally provided for the multifunctional function. For example, as shown in FIG. 2, the hardware configuration includes a communication unit 21 that manages reception of real number data of inventory products (stock products) transmitted from the scanner 11, and quantity data and locations of inventory products received by the communication unit 21. An information management server (CPU) 22 that executes arithmetic processing for inventory using data in accordance with an inventory management program stored in the program memory 24, and the information management server 22 stores and reads product data and location data. A database 23 and a display processing unit 25 are included. The database 23 records (stores) product data of product codes, product names, product numbers, and stock locations (such as shelf numbers) for each stock product according to a predetermined format.

  In this embodiment, as shown in FIG. 3, the information management server 22 fetches real number data of the inventory target product 14 from the scanner 11 through the communication unit 21 (step S <b> 1), and the inventory target product 14 imported to the mobile terminal 12. Are compared with the inventory data (product number data) of the products stored in the database 23 corresponding to the location data in accordance with the inventory management program described above (step S2). Whether or not there is a difference is confirmed. If there is a difference, the record in the database 23 is rewritten so that the stock quantity is correct (step S3), and a series of inventory work is finished. Then, the inventory process is performed for the next inventory target product 14, and the inventory process is further performed for all the inventory target products 14. Then, the display processing unit 25 can display the result on the screen of the display unit, or can print it out using the printing apparatus as necessary.

  In the present embodiment, the person in charge of inventory uses the scanner 11 to transmit the product data of the inventory target product 14 and the location data of the place where the product 14 is placed to the mobile terminal 12, so that the inventory target product The difference between the real number data of 14 and the number of in-stock items stored in the database 23 can be confirmed on the terminal device 12 in real time. Therefore, in order to confirm the difference or correct the difference as in the conventional case, the time and effort required for the operator to travel between the site where the inventory product is located and the management device that performs the inventory processing away from the site. And the work efficiency of the whole inventory work can be greatly improved.

Next, the inventory process will be conceptually described.
First, the operator makes the prepared scanner 11 and portable terminal 12 operable in the work site, selects inventory data input (scanner) on the menu screen displayed on the portable terminal 12, and presses the execution key. The operator inputs the name of the person in charge of the inventory work in the entry field of the display screen obtained in this way, and then stores the storage location (location, identification display on the label L1) in the storage shelf 13 of the inventory on the scanner 11. Read it. As a result, the corresponding location number is taken into the portable terminal 12 from the scanner 11 and displayed on the display unit. Further, the selection of whether the inventory work is the first time or the second time is performed on the display screen.

  Further, the inventory target product (identification display on the label L2) 14 stored in the storage shelf 13 is scanned by the scanner 11, and the read product code, product name, quantity, and the like are sequentially displayed on the first line. When data collection at this location is completed, the identification display of the label L1 of another storage location is scanned, and the product code, product name, quantity, etc. for each storage location are sequentially displayed on the display unit. Thus, the inventory work performed for all the products 14 to be inventoried is performed twice, and the difference in the product code, product name, quantity, etc. of the products 14 is confirmed by these two inventories. If there is a difference, the same inventory operation is executed again, and the record in the database 23 is rewritten so that the difference between the data becomes zero. If there is no difference, the data is stored in the database 23 as inquiry inventory data.

  As described above, the product inventory system according to the present embodiment reads the identification display for specifying the product 14 to be inspected by the scanner 11 and the identification display for specifying the place 13 where the product 14 is placed. The mobile terminal 12 receives the real number data of the product 14 read by the scanner 11 and the location data where the product 14 is placed, and the mobile terminal 12 stores the real number data and the product data stored in the database 23 corresponding to the location where the product is placed. When there is a difference between these data, the inventory record in the database 23 is rewritten so that the difference is adjusted by executing the inventory management program, so that the inventory operator can quickly and surely check the inventory. You can check the processing status, double counting the same product and rewriting the number of products in stock, and this rewriting Thereby avoiding the occurrence of an error by, and thus also be implemented, such as the cause of a specific and warning display incorrect work in real time.

  The product inventory system of the present invention has the effect of enabling low-cost and efficient implementation of inventory work with a simple system based on the product to be collected collected using a scanner and the place where the product is placed. It can be widely used in an inventory system for products for inventorying products stored in storage shelves.

11 Scanner 12 Mobile terminal 13 Storage shelf 14 Product (product for inventory)
21 Communication Unit 22 Information Management Server (CPU)
23 Database 24 Program memory 25 Display processing part L1, L2 Label

In order to achieve the above object, a product inventory system according to the present invention includes an identification display for specifying a product to be inventoried and a scanner for reading an identification display for specifying a place where the product is placed, A communication unit responsible for receiving the real number data of inventory products sent from the scanner and the location data where the products are placed, and the calculation processing for inventory using the quantity data and location data of the inventory products received by this communication unit is programmed An information management server to be executed according to an inventory management program stored in a memory, a database in which product data and location data are stored and read out by the information management server, and a display processing unit, and real data of products read by the scanner And the location data where the product was placed, the real number data and the product were placed Compared with the product data stored in the database in correspondence with the place, when there is a difference between these data, a portable terminal that rewrites the product inventory record of the database so as to adjust the difference by execution of the inventory management program, It is characterized by providing.

Claims (4)

A scanner for reading an identification display for identifying a product to be inventoried and an identification display for identifying a place where the product is placed;
The real number data of the product read by this scanner and the location data where the product is placed are received, and the real number data is compared with the product data stored in the database corresponding to the place where the product is placed. When there is a difference between the portable terminal that rewrites the product inventory record of the database so as to adjust the difference by execution of the inventory management program,
A product inventory system characterized by comprising:   The product inventory system according to claim 1, wherein the portable terminal displays product data stored in a database corresponding to a place where a product to be inventoried is placed on a display unit.   The product inventory system according to claim 1, wherein the product data stored in the database includes at least a product code and a product name of a product to be inventoried.   2. The commodity inventory system according to claim 1, wherein the portable terminal is a tablet portable terminal.

Images