JP2018076149A - Inventory system, inventory program and inventory method - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide an inventory system reduced in reference and confirmation time for product data collected by a portable terminal.SOLUTION: An inventory system 10 includes a portable terminal 18 equipped with a code reading part. In a first inventory data processing unit, first inventory data based on code data of all products in an inventory management place which are read in the code reading part are stored in a first inventory data storage unit. In a second inventory data processing unit, second inventory data based on the code data of all products in the same inventory management place which are read again in the code reading part are stored in a second inventory data storage unit. In a comparison unit, the first inventory data are compared with the second inventory data for a product total number of the same product code. In a difference list display unit, a difference list including at least the product codes and the respective total numbers of the products in the first inventory data and the second inventory data is displayed when a difference is found in the comparison unit. However, in an inventory aggregation database, the inventory data are updated when a difference is not found between the first inventory data and the second inventory data or when they have been corrected.SELECTED DRAWING: Figure 1

Description

  The present invention relates to an inventory system, an inventory program, and an inventory method, and in particular, for example, an inventory system, an inventory program, and an inventory method for generating inventory data by reading a code such as a barcode using a portable terminal such as a handy terminal. About.

  An example of background art is disclosed in Patent Document 1. In this patent document 1, the information on the product or place read by the scanner is input to a portable terminal such as a tablet terminal, and the real number data is compared with the inventory data stored in the database, thereby making a difference in the number of products. If there is a difference, the database is rewritten.

  In the technique of Patent Document 1, the database is corrected if there is a difference on the assumption that the number of products collected by the mobile terminal is correct.

JP2015-101424A [B65G 1/137]

  However, there is a possibility that the number of products collected by the mobile terminal may be wrong. In order to eliminate this possibility, it is necessary to collate the contents input to the mobile terminal with the actual product. There is a problem that it takes time to collate and confirm with the actual product.

  Therefore, a main object of the present invention is to provide a novel inventory system, inventory program, and inventory method.

  Another object of the present invention is to provide an inventory system, an inventory program, and an inventory method that can reduce the time taken for inventory.

  A first invention is an inventory system that performs inventory management by checking the number of products in inventory management place by a portable terminal including a code reading unit that reads a code label attached to the product, and the inventory management place The total number of each product is calculated from the code data obtained by reading the code labels of all the products in the code reading unit, and the first inventory data including the total number and the product code associated with each product is stored in the first inventory data storage. The first inventory data processing unit that performs processing stored in the unit, the total number of each product is calculated from the code data obtained by re-reading the code labels of all the products in the same inventory management location by the code reading unit, the total number and each A second inventory data processing unit that performs processing for storing the second inventory data including the product code of the product in the second inventory data storage unit, and the first inventory data and the second inventory data are the same The comparison unit for comparing the total number of products associated with the code, and when there is a difference in the comparison in the comparison unit, at least the total number and the first number in the first inventory data of the product code and the product associated with the product code The inventory system includes a difference list display unit (68, S37, 26, 84) that displays a difference list including the total number of two inventory data.

  In the first invention, the inventory system (10) is like a shelf in a warehouse, for example, by a portable terminal (18) including a code reading unit (42) that reads a code label (16) attached to a product (14). Check the number of items in stock at the correct inventory management location and perform inventory management. The first inventory data processing unit (68, S1, S7, 94a) calculates the total number of each product from the code data obtained by reading the code labels of all the products in the inventory management place with the code reading unit, and the total number and The first inventory data including the product code related to each product is stored in the first inventory data storage unit. As an example, the mobile terminal outputs the first inventory data. The second inventory data processing unit (68, S1, S23, 94b) calculates the sum of each product from the code data obtained by re-reading the code labels of all the products in the same inventory management location where the first inventory data was obtained by the code reading unit. The second inventory data including the total number and the product code of each product for which the number has been calculated is stored in the second inventory data storage unit. As an example, the second inventory data is output by the mobile terminal. The comparison unit (68, S35) uses the same product for the first inventory data stored in the first inventory data storage unit (94a) and the second inventory data stored in the second inventory data storage unit (94b). Compare the total number of products associated with the code. When there is a difference in the comparison in the comparison unit, the difference list display unit (68, S37, 26, 84) includes at least the total number in the first inventory data of the product code and the product associated with the product code. A difference list including the total number in the second inventory data is displayed. As an example, the difference list is displayed on the display (26) of the portable terminal.

  According to the first invention, the inventory data of the same inventory management place is compared twice and displayed as a difference list when a difference occurs. Well, the time taken for inventory can be shortened compared to the conventional method of checking all products on site.

  The second invention is dependent on the first invention, the difference list includes a total number of products having a difference and a total number of products having no difference, and a difference list display unit displays a product having no difference from a product having a difference. This is an inventory system that displays in a distinguishable manner.

  In the second invention, in the difference list (88), a product having a difference and a product having no difference are displayed in a distinguishable manner, for example, by changing the color.

  According to the second aspect of the invention, it is easy to visually recognize a product with a difference in the difference list, so that the confirmation operation can be performed easily and reliably.

  A third invention is dependent on the first or second invention, and is provided with a code label related to the inventory management place, and the inventory management place data read by the code reading unit is the first inventory data and The comparison unit is an inventory system that performs comparison on the first inventory data and the second inventory data that are included in the second inventory data, respectively, and include the same inventory management location data.

  In the third invention, since the first inventory data and the second inventory data each include data indicating an inventory management location such as a shelf number, the comparison unit includes the first inventory data and the first inventory data having the same inventory management location data. Compare two inventory data.

  A fourth invention is dependent on any one of the first to third inventions, and each of the first inventory data and the second inventory data includes a person-in-charge ID that specifies a person in charge who operates the portable terminal, The 2-inventory data processing unit is an inventory system including a reception unit that accepts only second inventory data including a person-in-charge ID different from the person-in-charge ID of the first inventory data.

  In the fourth invention, each of the first inventory data and the second inventory data includes a person-in-charge ID for identifying a person in charge who has operated the mobile terminal, and the receiving unit (68, S13, S15) of the second inventory data processing unit. Accepts only second inventory data including a person ID different from the person ID of the first inventory data.

  According to the fourth invention, the effect of comparing the first inventory data and the second inventory data can be further expected. In general, when performing inventory work, a person has a certain habit in how to hold a portable terminal or how to read a code label, and therefore, the first inventory data acquired by each person in charge by different methods and By comparing the second inventory data, an improvement in inventory accuracy can be expected.

  5th invention is dependent on 4th invention, and the reception part has the same person in charge ID when the person in charge ID of 2nd inventory data is the same person in charge ID as 1st inventory data, or It is an inventory system including an informing unit for informing that the second inventory data is not accepted.

  In the fifth invention, when the person in charge ID of the second inventory data is the same person ID as the first inventory data, the notification unit (S15) has the same person in charge ID or the second inventory data. Notify that you will not accept For example, when the portable terminal transmits the first inventory data and the second inventory data, such a warning is given to the portable terminal.

  According to the fifth aspect, since it is understood that the second inventory data is not accepted, correct inventory using the acceptable second inventory data can be performed.

  A sixth invention is dependent on any one of the first to fifth inventions, wherein the mobile terminal has a communication function, constructs a server and a network, and receives the first inventory data and the first inventory data from one or two communication terminals. The second inventory data is transmitted to the server, and the server executes each process in the first inventory data processing unit, the second inventory data processing unit, and the comparison unit, and the portable terminal transmits an inventory confirmation instruction to the server. Including a confirmation instruction transmission unit, when the server receives an inventory confirmation instruction, if there is a difference in comparison in the comparison unit, a difference list is created and transmitted to one or two portable terminals. This is an inventory system in which a portable terminal displays a difference list on a display.

  In the sixth invention, the mobile terminal (18) has a communication function, and constructs a server (22) and a network (20). The first inventory data and the second inventory data are transmitted to the server from one or two communication terminals, and the server receives the first inventory data and the second inventory data, and receives the first inventory data processing unit, 2. Each process in an inventory data processing part and a comparison part is performed. After transmitting the second inventory data to the server, the portable terminal transmits an inventory confirmation instruction to the server by operating the inventory confirmation instruction transmission unit (64). When the comparison unit that functions as a server receives the inventory check instruction, the comparison unit compares the first inventory data and the second inventory data, and creates a difference list when there is a difference in the comparison, and creates one or two mobile phones. Send to the terminal. Then, one or two portable terminals display the difference list on the display (26).

  According to the sixth aspect of the present invention, a highly convenient inventory system can be obtained by constructing a network with mobile terminals and servers.

  A seventh aspect of the invention is an inventory executed by a computer of an inventory system that performs inventory management by confirming the inventory quantity of an item in an inventory management place by a portable terminal having a code reading unit that reads a code label attached to the product. The program includes a computer that calculates the total number of each product from the code data obtained by reading the code labels of all products in the inventory management location with the code reading unit, and includes the total number and the product code associated with each product. A first inventory data processing unit that performs processing for storing the first inventory data in the first inventory data storage unit, and the code data of each product in the same inventory management location is read again by the code reading unit. The second inventory data including the total number and the product code of each product for which the total number has been calculated is stored in the second inventory data storage unit. Two inventory data processing units, a comparison unit that compares the first inventory data and the second inventory data with respect to the total number of products associated with the same product code, and when there is a difference in the comparison in the comparison unit, at least the product code And an inventory program that functions as a difference list display unit that displays a difference list including the total number in the first inventory data and the total number in the second inventory data of the products associated with the product code.

  According to the seventh aspect, the same effect as in the first aspect can be expected.

  An eighth invention is an inventory executed by a computer of an inventory system that performs inventory management by confirming the number of inventory of products in an inventory management place by a portable terminal provided with a code reading unit that reads a code label attached to the product. (A) calculating the total number of each product from the code data obtained by reading the code labels of all the products in the inventory management place with the code reading unit, including the total number and the product code associated with each product A first inventory data processing step for storing the first inventory data in the first inventory data storage unit; (b) from the code data obtained by re-reading the code labels of all products in the same inventory management location by the code reading unit; The second inventory data for performing the process of storing the second inventory data including the total number and the product code of each commodity calculated in the second inventory data storage unit. (C) a comparison step for comparing the first inventory data and the second inventory data for the total number of products associated with the same product code, and (d) when there is a difference in the comparison in the comparison step, The inventory method includes a difference list display step of displaying a difference list including at least the product code and the total number of the products associated with the product code in the first inventory data and the total number in the second inventory data.

  According to the eighth aspect, the same effect as in the first aspect can be expected.

  According to the present invention, the time taken for inventory can be shortened.

  The above object, other objects, features and advantages of the present invention will become more apparent from the following detailed description of embodiments with reference to the drawings.

1 is an illustrative view schematically showing one embodiment of the present invention. FIG. 2 is an illustrative view showing one example of a portable terminal that can be used in the embodiment of FIG. FIG. 3 is a block diagram showing an example of the electrical configuration of the mobile terminal of FIG. FIG. 4 is an illustrative view showing one example of an inventory input screen displayed on the touch display of the portable terminal of FIG. FIG. 5 is a block diagram showing an example of the electrical configuration of the server shown in FIG. FIG. 6 is a time chart showing an example of the procedure of the inventory work in the embodiment of FIG. FIG. 7 is an illustrative view showing one example of inventory data acquired by the portable terminal and transmitted to the server in the embodiment of FIG. FIG. 8 is an illustrative view showing one example of a difference list output by the server. FIG. 9 is an illustrative view showing one example of a memory map of the storage device shown in FIG. FIG. 10 is a flowchart showing an example of the inventory data acquisition process in the server inventory process in the FIG. 1 embodiment. FIG. 11 is a flowchart showing an example of an inventory confirmation process in the inventory process of the server in FIG. 1 embodiment.

[First embodiment]
Referring to FIG. 1, an inventory system 10 according to an embodiment of the present invention includes a large number of products or articles (hereinafter referred to as “commodities”) 14 stored in respective shelves 13a, 13b,. Take an inventory about. However, inventories generally mean checking the inventory of goods etc. and confirming the quantity at the time of settlement. In the inventory system 10 of this embodiment, the product 14 is provided with a code, for example, a barcode 16, which is optically readable and represents data (characters, symbols, codes, etc.) according to a predetermined format. Moreover, each shelf 13a, 13b, ... in the warehouse 12 functions as an inventory management place.

  For example, the barcode 16 is obtained by encoding data such as a product code, a shelf number, and a quantity. Therefore, the barcode 16 can also be called a code label. However, the barcode 16 may be a one-dimensional barcode or a two-dimensional barcode. The barcode 16 is attached to each product, and is also attached to a box (carton) containing a plurality of products. The barcode attached to the carton is accommodated in the carton. It shows the number of products that have been sold and their number.

  Further, although not shown in FIG. 1, the shelves 13a and 13b store different commodities, and each of the shelves 13a, 13b,... Has a barcode (code label) indicating a shelf number. . This shelf number functions as inventory management location data for specifying the inventory management location.

  For example, the data represented by the barcode 16 is obtained by reading the code label, that is, the barcode 16 with the portable terminal 18 such as a handy terminal or PDA (Personal Data Assistance), and each shelf 13a, 13b,. , Generate inventory data. The inventory data generated by the portable terminal 18 is sent to a server 22 for managing inventory via a network 20 such as the Internet or a LAN. The server 22 executes an inventory process according to the data sent in this way. By building a network with the mobile terminal 18 and the server 22, a highly convenient inventory system can be obtained.

  As shown in FIG. 2A, the portable terminal 18 includes a deformed rectangular casing 24 that is vertically long when viewed from the front, and a touch display 26 and an input device 28 are provided on the front side of the casing 24. It is done. The housing 24 is formed in a size that the user can hold with one hand. Note that the shape and size of the housing 24 are examples and should not be limited.

  The touch display 26 is, for example, a device in which a touch panel is integrally provided on a general-purpose LCD, and is arranged so that the display surface of the LCD and the detection surface of the touch panel are exposed from the housing 24. However, a display using organic EL can also be used as the display. Further, the touch panel may not be provided.

  The input device 28 is a hardware key, and includes a numeric keypad 30, a scan key 32, an OK (decision) key 34, a cursor key 36, a clear key 38, and a power key 40 in the first embodiment.

  The scan key 32 is used to input a barcode reading instruction (reading process execution instruction). That is, when the barcode is read after operating the scan key 32, the barcode data is read. The OK key 34 is used to determine execution of various settings and various processes (excluding bar code reading processing). The cursor key 36 is used to move a cursor displayed on the touch display 26 or to select an object such as an icon displayed on the touch display 26.

  The clear key 38 is used to clear (reset) various settings. The power key 40 is used to turn on / off the main power of the mobile terminal 18.

  As shown in FIG. 2B, a barcode scanner 42 is provided on the back surface of the housing 24 and on the opposite side of the touch display 26. The barcode scanner 42 is, for example, a laser scanner, and the barcode 16 attached to the product 14 and other barcodes, for example, barcodes (not shown) attached to the shelves 13a, 13b,... A barcode (not shown) displayed on the employee ID can be read.

  However, the barcode scanner 42 functioning as a code reading unit may be replaced with a camera having an imaging unit such as a CMOS sensor. Various signal processing is required to read a code such as a bar code and output code data with a camera, but these are already well-known and will not be described in detail.

  As shown in FIG. 3, the portable terminal 18 includes a CPU 44 that performs overall control. The CPU 44 accesses a storage device such as the storage device 48 and the external storage device 50 through a bus 46, and transmits data to them. Write or read data from them. The storage device 48 is built in the portable terminal 18, and none of them is shown, but includes, for example, a RAM used as a program area, a work area, a buffer area, etc.

  The external storage device 50 is detachably attached to the portable terminal 18 by a connector (not shown) such as a memory card, for example, an SD card. When the external storage device 50 is attached, the CPU 44 can access the external storage device 50 via the bus 46. The external storage device 50 is mounted as necessary.

  The operation data from the input device 28 described above is stored in an operation data buffer (not shown) provided in the RAM of the storage device 48 via the bus 46 and is encoded by the barcode scanner 42 (or camera). Code data (barcode data) obtained as a result of reading is stored in a code data buffer (not shown) provided in the RAM.

  The display control circuit 52 includes, for example, a GPU (Graphics Processing Unit), a VRAM, and the like, and displays objects (characters, icons, etc.) on the touch display 26 under the control of the CPU 44. The touch display 26 is a display device having a touch panel function on the display surface.

  The touch panel control circuit 54 applies a necessary voltage to the touch panel, detects a touch operation (touch input) within the touch effective range of the touch panel, and sends the touch coordinate data indicating the position of the touch input to the CPU 44. This coordinate data is also stored in the operation data buffer as the above-mentioned operation data.

  The communication module 56 is wired or wirelessly connected to the network 20 (FIG. 1), communicates with the server 22 (FIG. 1), and exchanges data with the server 22.

  Note that GUI data for displaying an inventory input screen 58 displayed on the touch display 26 of the mobile terminal 18 as shown in FIG. 4 is preset in, for example, the RAM included in the storage device 48 described above. . In the portable terminal 18, when “inventory” is selected on a menu screen (not shown) displayed when the main power is turned on by operating the power key 40, the inventory input screen 58 is displayed on the touch display 26. The

  On the inventory input screen 58, an inventory process first button 60 that is operated before the first inventory process is executed, an inventory process second button 62 that is operated before the second inventory process is executed, and the server 22 are displayed. An inventory confirmation button 64 that is operated when an inventory confirmation is requested is displayed. The inventory input screen 58 further displays an end button 66 that is operated when the respective processes, that is, the first inventory process, the second inventory process, and the confirmation process are completed.

  Since the display 26 is a touch display as described above, the operation of these buttons 60-66 is performed by a touch operation.

  As shown in FIG. 5, the server 22 includes a CPU 68 that performs overall control. The CPU 68 is connected to an input device 72 through a bus 70, and the input device 72 is typically a keyboard or a pointing device (sometimes (Not shown). Further, the CPU 68 accesses storage devices such as the storage device 92 and the external storage device 94 via the bus 70, and writes data to or reads data from them. The storage device 92 is built in the server 22 and includes a RAM having a program storage area and a data storage area, an HDD (hard disk drive), and the like as will be described later.

  The external storage device 94 is, for example, an HDD, a USB memory, or an optical disc such as a Blu-ray disc. When the external storage device 94 is attached, the CPU 68 can access the external storage device 94 via the bus 70. The external storage device 94 is mounted as necessary.

  The display control circuit 78 has, for example, a GPU, a VRAM, etc., and displays objects (characters, icons, etc.) on the display 80 under the control of the CPU 68. The display 80 may be a touch display having a touch panel function on the display surface. In that case, a touch panel control circuit similar to that in FIG. 3 is provided.

  The communication module 82 is wired or wirelessly connected to the network 20 (FIG. 1), communicates with the mobile terminal 18 (FIG. 1), and exchanges data with the mobile terminal 18.

  In the inventory system 10 of FIG. 1 embodiment, as shown in FIG. 6, the inventory is basically performed using two portable terminals 18. However, it is assumed that a program for the same inventory system is set in the two portable terminals.

  The first person in charge (for example, Mr. A) goes to the warehouse 12 (FIG. 1), touches the first inventory button 60 shown in FIG. 4, for example, and then operates the scan key 32 and then performs the inventory to be performed. A bar code (a code label) indicating a shelf number (any one of 13a, 13b,... Shown in FIG. 1) is read, and the shelf number is input. Next, for example, the person-in-charge ID (personal ID) is input by reading his / her ID from his / her employee ID. After that, while operating the scan key 32, the barcodes 16 of all the products 14 included in the shelf 13a as the inventory management location are read by the scanner 42, and the first inventory for the shelf 13a is completed. When the first person in charge finishes the first inventory, for example, the first person operates an end button 66 shown in FIG. In response, inventory data (first time) as shown in FIG. 7A, for example, is transmitted to the server 22 from the communication module 56 shown in FIG. As described above, when the first inventory is performed, the first inventory button 60 shown in FIG. 4 is touch-operated. Therefore, the operation information indicating the first inventory is added to the inventory data (first), and the server 22 is transmitted. Then, the server 22 stores the inventory data (first time: FIG. 7A) in an appropriate storage location such as a RAM. However, as shown in FIG. 7A, the inventory data for the first time is associated with a shelf number that functions as inventory management location data, a product code of a product managed by the shelf number, and each product code. The total number of each product that is calculated is included (quantity) and the person-in-charge ID, and a time stamp is added to the server 22 if necessary.

  Subsequently, the second person in charge (for example, Mr. B) goes to the warehouse 12 (FIG. 1) and touches the second inventory button 62 shown in FIG. 4, for example, and then performs the same procedure as the first inventory described above. The shelf number and the person in charge ID (personal ID) are input. After that, while operating the scan key 32, the barcodes 16 of all the products 14 included in the shelf 13a (the same inventory management location) having the same shelf number as the first time are read by the scanner 42, and the products on the shelf with the same shelf number are read. The second inventory is completed for. When the second inventory is completed, the second person in charge operates, for example, an end button 66 shown in FIG. In response, the second inventory data as shown in FIG. 7B is transmitted to the server 22 from the communication module 56 shown in FIG. As described above, when the second inventory is performed, the inventory second button 62 shown in FIG. 4 is touch-operated. Therefore, the operation information indicating the second inventory is added to the inventory data (second), and the server 22 is transmitted. As shown in FIG. 7B, the inventory data for the second time is associated with a shelf number that functions as inventory management location data, a product code of a product managed by the shelf number, and each product code. The total number of each product that is calculated is included (quantity) and the person-in-charge ID, and a time stamp is added to the server 22 if necessary.

  As described above, the person-in-charge ID (identification information) is obtained by, for example, reading the barcode given to the employee ID card with the mobile terminal 18 or operating the input device 28 (FIG. 2). Can be entered. This person-in-charge ID indicates whether or not a different person has executed the inventory data (first time: FIG. 7A) and the inventory data (second time: FIG. 7B) for the products on the same shelf number. This is data necessary for the server 22 to make a determination.

  However, as a method of inputting the person-in-charge ID, a method of extracting the corresponding ID from a personal information database (not shown) by performing biometric authentication of the person-in-charge's face, fingerprint, palm print, etc.) It is done.

  Further, as the identification information for verifying the non-identity between the first inventory data shown in FIG. 7A and the second inventory data shown in FIG. In addition to the ID, instead of that, a time stamp indicating the time when the inventory data is transmitted to the server 22 may be added.

  However, in the inventory system 10 of the embodiment, the inventory data (first time) and the inventory data (second time) are provided on the condition that they are data collected by different persons in charge of products managed by the same storage bin. Therefore, the server 22 verifies the identity of the shelf numbers in the inventory data (first time) and the inventory data (second time), and also verifies the person-in-charge ID, for example, and first and second person-in-charge. Are the same person, in order not to use the inventory data (second time), for example, processing such as refusing acceptance of the inventory data (second time) is performed.

  When it is confirmed that the person in charge of the inventory data (first time) and the inventory data (second time) is different as a result of the verification, the server 22 stores the inventory data (second time: FIG. 7B) in the RAM. It is stored in an appropriate storage location (described later).

  When the inventory confirmation button 64 on the inventory input screen 58 (FIG. 4) displayed on the touch display 26 of the portable terminal 18 is operated, the operation signal is transmitted to the server 22.

  When the server 22 receives the operation signal of the inventory confirmation button 64, the server 22 compares the inventory data (first time) as shown in FIG. 7A with the inventory data (second time) as shown in FIG. 7B. Whether or not there is a difference is determined. If there is a difference, for example, a difference list 88 as shown in FIG. 8 is output and transmitted to the portable terminal 18 used by the second person in charge, for example. However, this may be transmitted to the portable terminal used by the first person in charge, or may be transmitted to both portable terminals. The difference list 88 is displayed on the difference list display screen 84 shown in FIG. 8 of the touch display 26 of the mobile terminal 18. The difference list 88 includes the quantity (total number for each product) in the inventory data (first time) and the quantity (total number for each product) in the inventory data (second time) of the product causing the difference. However, a product code associated with the product is also included.

  The difference list display screen 84 is provided with a shelf number display portion 86, and the shelf number display portion 86 displays the shelf numbers of the shelves 13a, 13b,. The difference list 88 on the difference list display screen 86 shown in FIG. 8 includes the product codes of all products included in the same shelf number and the first quantity of each product (total number for each product). Each of the second quantity (total number for each product), and a result (OK or NG) indicating whether or not there is a difference in quantity between the first inventory data and the second inventory data are also included.

  In the example of FIG. 8, since the quantity of the product code BB is different between the first time and the second time, “NG” is displayed in the corresponding result column, and the second time quantity data is displayed in red, for example. By doing so, attention is drawn. In other words, in the difference list 88, products having a difference between the first inventory data and the second inventory data are displayed in a display mode different from that having no difference so that the products can be distinguished from the products having no difference. Is done. If it does so, since it is easy to visually recognize the goods with a difference, the confirmation work when there is a difference can be performed easily and reliably.

  The second person in charge (or the first person in charge) who performed the inventory work refers to the difference list, goes to the warehouse, and causes a discrepancy between the inventory data (first time) and the inventory data (second time). The actual product is confirmed, the cursor 89 (FIG. 8) is set to the position of the quantity to be corrected, and the correct quantity is input and transmitted to the server 22. That is, after inputting the correct quantity, if the transfer button 90 displayed on the difference list display screen 84 is operated, the corrected inventory data is transferred to the server 22. In other words, this transfer button 90 is operated when correction data as a result of reconfirming the product 14 in the warehouse 12 according to the difference list 88 is transmitted, and functions as a completion notification button.

  When the correct inventory data can be confirmed, the server 22 can rewrite the inventory data in the inventory summary database (described later).

  FIG. 9 shows an example of a memory map of the storage device 92 of the server 22. The storage device 92 includes a program storage area 92 and a data storage area 94. The program storage area 92 stores an inventory data acquisition program 92a and an inventory confirmation program 92b. The inventory data acquisition program 92a is a program for acquiring the first and second inventory data described above from the portable terminal 18, for example. The inventory checking program 92b compares the acquired inventory data for two times, creates a difference list as needed, a program for sending the difference list to the portable terminal 18, and the correction from the portable terminal 18 as described above. Includes programs necessary for inventory processing, such as programs that receive inventory data and rewrite the database.

  In the data storage area 94, a first inventory database 94a which is a first inventory data storage unit for storing inventory data (first), and a second inventory for storing inventory data (second). A second inventory database base 94b which is a data storage unit, a difference list area 94c for storing a difference list, an inventory totaling database 94d, and the like are formed. However, inventory data of all shelves in the warehouse 12 (FIG. 1) is stored in the inventory totalization database 94d.

  Although not shown, the data storage area 94 is further provided with necessary flags and counters (timers).

  FIG. 10 is a flowchart showing an example of the inventory data acquisition process in the inventory process by the server 22 in the inventory system 10 of FIG. 1 embodiment. However, the inventory method using the portable terminal 18 is as described above. That is, the person in charge of inventory operates the first processing button 60 on the inventory input screen 58 (FIG. 4) of the portable terminal 18 to transmit the inventory data (first time) to the server 22 and operates the second processing button 62. Inventory data (second time) is transmitted to the server 22.

  In the first step S <b> 1, the CPU 68 (FIG. 5) of the server 22 acquires data from the mobile terminal 18. In subsequent step S3, the CPU 68 determines whether the data received in step S1 is the first data in the inventory process. As described above, since the first inventory data shown in FIG. 7A transmitted from the mobile terminal 18 includes the operation information indicating the first inventory data, the CPU 68 determines the operation information. It is possible to determine whether the data received at that time is the data of the first inventory process.

  When “YES” is determined in the step S3, the CPU 68 determines whether or not there is data in the first inventory database 94a (FIG. 9) in the next step S5.

  If “NO” in the step S5, that is, if the data is not yet stored in the first inventory database 94a, the CPU 68 sets the data acquired in the step S1 as the first inventory data in the first inventory database 94a. Store (S7). Since the data for the first inventory process includes the person-in-charge ID as described above, the person-in-charge ID is also stored in the first-time inventory database 94a.

  If the data has already been stored in the first inventory database 94a, the CPU 68 performs the inventory process for the portable terminal 18 that has received the first inventory data in step S1 in step S9. The first data informs that it has already been received.

  In the portable terminal 18 that has received this notification from the server 22 in step S9, the notification from the server 22 is displayed on the touch display 26 (FIG. 3). In response, the person in charge operates, for example, the end button 66 to end the data transmission to the server 22.

  After step S7 or step S9, the CPU 68 of the server 22 ends the data acquisition process of FIG.

  When “NO” is determined in the step S3, the CPU 68 determines whether or not the data acquired in the step S1 is the second inventory process in the step S11. As described above, since the second inventory data shown in FIG. 7B transmitted from the portable terminal 18 includes the operation information indicating the second inventory data, the CPU 68 determines the operation information. It is possible to determine whether the data received at that time is the data of the second inventory process.

  If “NO” is determined in the step S11, the process is terminated.

  When “YES” is determined in the step S11, the CPU 68 in the next step S13, the person-in-charge ID included in the second inventory data is the first inventory process data stored in the first inventory database 94a in the step S7. It is determined whether it is the same as the person-in-charge ID included in. That is, in step S13, it is determined whether or not the person in charge ID of the first inventory process and the person ID in charge of the second inventory process data match. When “YES” is determined in step S13, that is, when it is determined that the data in the first inventory process and the second data in the inventory process are acquired by the same person in charge, in the next step S15, the CPU 68 The portable terminal 18 that has received the data in the previous step S1 is notified that the second person-in-charge ID is the same as the first person-in-charge ID. Specifically, for example, this inventory data is the second data, but it cannot be accepted because it is sent from the same person ID as the first inventory data. Please try again with a different person. The display is transmitted to the corresponding mobile terminal 18. By performing the notification in step S15 as described above, it is understood that the second inventory data is not accepted, so that correct inventory using the acceptable second inventory data can be performed.

  In the portable terminal 18 that has received this notification from the server 22 in step S15, the notification from the server 22 is displayed on the touch display 26 (FIG. 3). In response, the person in charge operates, for example, the end button 66 to end the data transmission to the server 22.

  In step S15, after transmitting the above warning to the corresponding portable terminal 18, the CPU 68 of the server 22 ends the inventory data acquisition process of FIG.

  As described above, since the server 22 does not accept (adopt) the second inventory data having the same person ID as the first inventory data, the first inventory data and the second inventory data are acquired. The person in charge who made it can always be made different. Therefore, steps S13 and S15 function as a rejection unit or rejection unit that rejects or excludes the second data of the inventory process collected by the same person in charge. In other words, steps S13 and S15 function as a reception unit that accepts only the second inventory process data different from the first inventory process data for the same shelf number.

  When “NO” is determined in the step S13, the CPU 68 determines whether or not there is data in the first inventory database 94a (FIG. 9) in the next step S17. If “NO” in the step S17, that is, if the data is not yet stored in the first inventory database 94a, the CPU 68 receives the second inventory data in the step S1 in the next step S19. The portable terminal 18 is notified that there is no data for the first inventory process in the first inventory database 94a. Thereafter, the server 22 ends the inventory data processing operation shown in FIG.

  In the portable terminal 18 that has received this notification from the server 22 in step S 19, the notification from the server 22 is displayed on the touch display 26. In response, the person in charge operates, for example, the end button 66 to end the data transmission to the server 22.

  When “YES” is determined in the step S17, the CPU 68 determines whether or not there is data in the second inventory database 94b (FIG. 9) in the next step S21.

  If “NO” in the step S21, that is, if the data is not yet stored in the second inventory database 94b, the CPU 68 sets the data acquired in the step S1 as the second inventory data in the step S23. Store in the inventory database 94b. Since the data for the second inventory process includes the person-in-charge ID as described above, the person-in-charge ID is also stored in the second-inventory database 94b. At the same time, in this step S23, the CPU 68 causes the server 22 to receive the first inventory process data and the second inventory process data in step S1, and then the first inventory process and the second inventory process. Since the data is ready, it is notified that the reception of the inventory data is completed.

  If data is already stored in the second inventory database 94b, “YES” is determined in the step S21, and the CPU 68 receives the second inventory process data in the step S1 in the next step S25. The portable terminal 18 is informed that the second data of the inventory process has already been received.

  In the portable terminal 18 that has received this notification from the server 22 in step S25, the notification from the server 22 is displayed on the touch display 26 (FIG. 3). In response, the person in charge operates, for example, the end button 66 to end the data transmission to the server 22.

  After step S23 or step S25, the CPU 68 of the server 22 ends the data acquisition process of FIG.

  When the inventory confirmation button 64 is operated on the inventory input screen 58 of the portable terminal 18 shown in FIG. 4, the server 22 detects the operation information and checks the status of the first inventory and the second inventory in FIG. In addition, according to the flowchart shown in FIG. 11, a difference check between the data of the first inventory process and the data of the second inventory process is executed.

  When the server 22 receives the operation signal of the inventory confirmation button 64 from the portable terminal 18, the processing of FIG. 11 is started. In the first step S31, the CPU 68 stores the inventory in the second inventory database 94a and the second inventory database 94b. It is determined whether there is data for the first process and data for the second inventory process. If “NO” in this step S31, that is, if there is neither or either of the data of the first inventory process and the data of the second inventory process, the CPU 68 It is notified that the data for the first inventory process and the data for the second inventory process are not available.

  Such a situation occurs when the inventory check button 64 on the inventory input screen 58 shown in FIG. 4 is operated before transmitting the first inventory data and / or the second inventory data from the portable terminal 18. This is the case.

  In the portable terminal 18 that has received the notification in step S33 from the server 22, as described above, the first processing button 60 is operated to transmit the inventory data (first time) to the server 22, or the second processing. The button 62 is operated to transmit the inventory data (second time) to the server 22. Accordingly, “YES” can be determined in step S31.

  If “YES” is determined in the step S31, the CPU 68 compares the first inventory data and the second inventory data stored in the first inventory database 94a and the second inventory database 94b in a subsequent step S35. That is, in step S35, it is determined whether there is a difference between the first inventory process data and the second inventory process data.

  For example, when the inventory data (first time) is the data shown in FIG. 7A and the inventory data (second time) is the data shown in FIG. 7B, “YES” is determined in step S35. Then, when “YES” is determined in step S35, in step S37, the CPU 68 outputs a difference list 88 as shown in FIG. 8, for example, and / or the portable terminal 18 that transmitted the first data of the inventory process and / or The data is transmitted to the portable terminal 18 that has transmitted the second inventory data. The difference list 88 is temporarily stored in the difference list area 94c.

  The second person in charge (or the first person in charge) who has received the difference list 88 transmitted in the previous step S37 goes to the warehouse with reference to the difference list 88 (FIG. 8) as described above. The actual product is confirmed for the product in which the difference has occurred, the data is corrected to the correct quantity, and is transmitted from the portable terminal 18 to the server 22. At that time, the correction data is transmitted to the server 22 by operating the transfer button 90 (FIG. 8).

  When correction data is transmitted from the portable terminal 18, the CPU 68 determines "YES" in step S39, and in step S41, the inventory totaling database 94d (FIG. 9) is stored in accordance with the correction data transmitted from the portable terminal 18 at that time. Update.

  When “NO” is determined in step S35, that is, when it is determined that there is no difference between the inventory data (first time) and the inventory data (second time) as a result of the data comparison in step S35, in step S41, The CPU 68 updates the inventory counting database 94d using correct (no difference) inventory data. That is, the inventory counting database 94d is updated using either the inventory data (first time) or the inventory data (second time).

  As described above, according to the inventory system 10 of the first embodiment, for example, the inventory data as a result of the inventory performed by different persons are compared, and only the products related to the difference data are reconfirmed in the field and correct. Since data has only to be acquired, it is no longer necessary to collate the contents input to the portable terminal with all the actual items, and the work time of inventory can be reduced. Generally speaking, when a person performs an inventory work, the person who holds the portable terminal 18 and the method of reading the barcode 16 has a certain habit, so the same person can acquire the inventory data twice. However, it is very likely that the same product will be read incorrectly. Therefore, there is a high possibility that the two inventory data generated as a result of execution by the same person will be the same, and no significant result will be obtained even if two inventory data generated as a result of execution by the same person are compared. That is, as in this embodiment, it is meaningful that different persons acquire inventory data in the same warehouse by each method and compare the inventory data of the two times. That is, when the first inventory data and the second inventory data acquired by different persons in charge are compared, improvement in inventory accuracy can be expected.

  In the above description, when comparing the first data in the inventory process and the second data in the inventory process, it is assumed that the storage number indicating the inventory management location is the same in both data. This is because, if the shelf numbers of the first data in the inventory process and the data in the second data in the inventory process are different from each other, the two data are not compared.

Data with different shelf numbers is not accepted by the server as comparison target data in the first place. For example, as in step S13 in FIG. 10, it is possible to verify the match of the shelf numbers and to eliminate the unmatched inventory data. That is, inventory management is executed for each same storage bin (inventory management location).
[Second Embodiment]
In the first embodiment described above, the two portable terminals 18 are used by different persons to perform inventory for the same shelf number and generate inventory data for each. However, another person may use the same portable terminal 18 to generate inventory data for two times with different persons in charge, and transmit it to the server 22.

  In this case, the first person in charge (for example, Mr. A) executes the inventory to generate the inventory data (first time) as shown in FIG. 7A and transmits it to the server 22. For example, Mr. B may execute inventory to generate inventory data (second time) as shown in FIG. 7B and transmit it to the server 22.

However, since the same portable terminal 18 is used, the inventory data (first time) as shown in FIG. 7A generated by the first person in charge is temporarily stored in the storage device 48 (FIG. 3) in the portable terminal 18. In addition, it may be transmitted to the server 22 together with the inventory data (second time) as shown in FIG. 7B generated by the second person in charge.
[Third embodiment]
In the first embodiment, the difference data is created by comparing the inventory data for two times for the products of the same shelf number, which are generated by different persons using different mobile terminals 18, and the same in the second embodiment. The difference data is created by comparing the inventory data for two times for the products with the same shelf number generated by the person in charge using different portable terminals 18.

  On the other hand, in the third embodiment, the same person in charge uses the same or different portable terminal 18 to generate inventory data twice for a product with the same shelf number.

  In this case, the person-in-charge ID is the same for the first inventory data and the second inventory data, and in the example of FIG. 10, reception of the second inventory data is rejected in step S13.

  In contrast, in the third embodiment, the time stamp added to the inventory data at the time of transmission is compared as identification information in order to determine that the first inventory data and the second inventory data are not the same. . That is, in the third embodiment, if the time stamp (identification information) is not the same in step S11 of FIG. 10, even if the person-in-charge ID is the same, it is appropriate as the second inventory data (“YES”). ).

  Therefore, in the third embodiment, even when the same person in charge performs the inventory twice using the same portable terminal 18 for the product with the same shelf number, a correct inventory result can be obtained.

That is, in step S13, it is determined whether or not the person-in-charge IDs of the inventory data (first time) and the inventory data (second time) match in order to check the suitability as the second inventory data. The necessary condition for the inventory data (second time) is “the data must be different from the inventory data (first time)”. Instead of comparing the IDs, the time stamps are compared as in the third embodiment. The non-identity may be confirmed.
[Fourth embodiment]
In the above-described embodiment, the server 22 is described as executing the inventory process as shown in FIGS. However, the function of the server 22 can be given to the portable terminal 18.

  When two portable terminals 18 are used, a processing program as shown in FIGS. 10 and 11 may be set on one portable terminal, and when only one portable terminal is used, What is necessary is just to set a processing program like FIG. 10 and FIG. In either case, the program shown in FIGS. 10 and 11 can be easily incorporated into the portable terminal with a slight modification. However, when two portable terminals 18 are used, the portable terminals 18 can communicate with each other via the network 20 (FIG. 1) using the communication module 56 (FIG. 3). When only one portable terminal 18 is used, it is not necessary to communicate, and the storage device 48 may be configured as shown in FIG.

  In the flow chart of the inventory process shown in FIGS. 10 and 11, the order of steps can be arbitrarily changed when the same result is obtained.

DESCRIPTION OF SYMBOLS 10 ... Inventory system 13a, 13b ... Shelf 14 ... Goods 16 ... Bar code 18 ... Portable terminal 22 ... Server 68 ... CPU
88 ... Difference list 94a ... First inventory database 94a
94b ... Second inventory database 94b
94d ... Inventory counting database

Claims (8)

An inventory system that performs inventory management by checking the inventory quantity of products in an inventory management place with a portable terminal that includes a code reading unit that reads code labels attached to products,
The total number of each product is calculated from the code data obtained by reading the code labels of all products in the inventory management location with the code reading unit, and the first inventory data including the total number and the product code associated with each product, A first inventory data processing unit for performing processing to be stored in the first inventory data storage unit;
The second inventory data including the total number and the product code of each product calculated from the code data obtained by re-reading the code labels of all the products in the same inventory management location by the code reading unit, A second inventory data processing unit for performing processing to be stored in the second inventory data storage unit;
A comparison unit that compares the first inventory data and the second inventory data for the total number of products associated with the same product code, and when there is a difference in the comparison in the comparison unit, at least the product code and the product An inventory system comprising: a difference list display unit for displaying a difference list including a total number of products associated with a code in the first inventory data and a total number in the second inventory data. The difference list includes the total number of products with differences and the total number of products with no differences,
The inventory system according to claim 1, wherein the difference list display unit displays the difference product and the difference product in a distinguishable manner. A code label is attached in association with the inventory management location, and the inventory management location data read by the code reading unit is included in the first inventory data and the second inventory data, respectively.
The inventory system according to claim 1 or 2, wherein the comparison unit compares the first inventory data and the second inventory data including the same inventory management location data. Each of the first inventory data and the second inventory data includes a person-in-charge ID that identifies a person in charge who has operated the mobile terminal,
4. The inventory system according to claim 1, wherein the second inventory data processing unit includes a reception unit that receives only second inventory data including a person-in-charge ID different from a person-in-charge ID of the first inventory data. 5. .   When the person-in-charge ID of the second inventory data is the same person-in-charge ID as the first inventory data, the reception unit informs that the person-in-charge ID is the same or does not accept the second inventory data. The inventory system of Claim 4 containing the alerting | reporting part which performs. The mobile terminal has a communication function, constructs a server and a network,
Transmitting the first inventory data and the second inventory data from one or two of the communication terminals to the server;
The server executes each process in the first inventory data processing unit, the second inventory data processing unit, and the comparison unit,
The portable terminal includes an inventory confirmation instruction transmission unit that transmits an inventory confirmation instruction to the server,
When the server receives the inventory check instruction, when there is a difference in the comparison in the comparison unit, the server creates the difference list and transmits the difference list to the one or two portable terminals,
The inventory system according to claim 1, wherein the one or two portable terminals display the difference list on a display. An inventory program that is executed by a computer of an inventory system that performs inventory management by checking the inventory quantity of products in an inventory management place by a portable terminal that includes a code reading unit that reads a code label attached to the product,
The computer,
The total number of each product is calculated from the code data obtained by reading the code labels of all products in the inventory management location with the code reading unit, and the first inventory data including the total number and the product code associated with each product, A first inventory data processing unit for performing processing to be stored in the first inventory data storage unit;
The second inventory data including the total number and the product code of each product calculated from the code data obtained by re-reading the code labels of all the products in the same inventory management location by the code reading unit, A second inventory data processing unit for performing processing to be stored in the second inventory data storage unit;
A comparison unit that compares the first inventory data and the second inventory data for the total number of products associated with the same product code, and when there is a difference in the comparison in the comparison unit, at least the product code and the product An inventory program that functions as a difference list display unit that displays a difference list that includes a total number of products associated with a code in the first inventory data and a total number in the second inventory data. An inventory method that is executed by a computer of an inventory system that performs inventory management by checking the inventory quantity of an item in an inventory management place by a portable terminal including a code reading unit that reads a code label attached to the product,
(a) The total number of each product calculated from the code data obtained by reading the code labels of all the products in the inventory management location by the code reading unit, and the first inventory including the total number and the product code associated with each product A first inventory data processing step for performing processing for storing data in the first inventory data storage unit;
(b) The second inventory including the total number and the product code of each product calculated from the code data obtained by re-reading the code labels of all products in the same inventory management location by the code reading unit. A second inventory data processing step for performing processing for storing data in the second inventory data storage unit;
(c) a comparing step of comparing the first inventory data and the second inventory data for the total number of products associated with the same product code; and
(d) When there is a difference in the comparison in the comparison step, a difference list including at least the total number in the first inventory data and the total number in the second inventory data of the product code and the product associated with the product code An inventory method that includes a difference list display step that displays.

Images