JPH04238570A - Processing system for inventory data - Google Patents

Abstract

(57) [Summary] This bulletin contains application data before electronic filing, so abstract data is not recorded.

Description

[Detailed description of the invention]

0001

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a method for processing inventory data. The quantity of products in stock is checked when taking inventory of products, but in order to understand the best-selling products and perform appropriate inventory management, data on the number of items in stock by product from the previous inventory is required, and the product master file of the host computer is required. The data was acquired by reading it out to the on-site processing device via a line.

[0002] It is necessary to be able to grasp the previous inventory quantity using a simple method when taking inventory.

0003

2. Description of the Related Art FIG. 5 shows a conventional system configuration diagram, and FIG. 6 shows a conventional inventory processing procedure diagram. In inventory processing,
Since it is necessary to refer to the inventory data etc. at the time of the previous inventory for each product, in a processing step 91 prior to the start of inventory work, using the on-site processing device 15 (for example, a personal computer or an office computer), The product master file secured on the host computer 16 side is read out via the communication line and stored in the external storage device 14.
The product master file 12 is stored in the product master file 12. The product file 12 stores data such as the product code and name of the product to be inventoried, and the inventory quantity of the product recorded at the time of the previous inventory.

[0004] To collect inventory data, an operator brings a handy terminal 11 that can be easily carried to a warehouse where products are stored, and in processing step 92 reads the product code from the label affixed to the product as a barcode. reader 22
This is done by reading the

[0005] In processing step 93, the operator inputs the current quantity (stock quantity) of the product corresponding to the product code to the operation unit 3.
Enter keystrokes from 1. In processing step 94, the control unit 13 stores data on the number of items in stock for each product in the memory unit 19. The display unit 32 displays input data when data is input. When the input of the inventory quantity for a predetermined product is completed, in a processing step 95, the handy terminal 11 is connected to the processing device 15 in order to transfer the data of the inventory quantity by product stored in the memory section 19 to the processing device 15.

[0006] When a data transfer command is input from the operation unit 13 in processing step 96, the control unit 13 transfers the data to the memory unit 19.
The product-specific inventory data stored in is transferred to the processing device 15. In processing step 97, the processing device 15 inputs the transfer data from the handy terminal 11 and creates a product master file 12 having data on the previous inventory quantity and the current inventory inventory quantity.

[0007]

[Problem to be Solved by the Invention] In order to understand changes in the quantity of products in stock by comparing them with the data from the previous inventory, it is necessary to check the data from the previous inventory recorded in the product master file held by the host computer. Data at the time was once received into an external storage device on the processing device side, and changes in data were ascertained at the inventory site.

[0008] During inventory, it is necessary to obtain the previous inventory data in a simple manner without reading it from the master file of the host computer.

[0009]

[Means for Solving the Problems] FIG. 1 is a block diagram of the principle of the present invention. A handy terminal 10 comprising a control section 1, a barcode reader 2, an operation section 3, a printing section 4, a memory section 55, and a transmission section 18, and a label holding data printed with a barcode. It has a part 42,
The control unit 1 creates predetermined data from the data of the label unit 42 read from the barcode reader 2 and the data entered by keystrokes from the operation unit 3, and stores it in the memory unit 55.
The data is transferred to the processing device via the transmission section 18, and the printing section 4 prints the data as a bar code, thereby generating data for the label section 42.

0010

[Operation] In the label part 42 created corresponding to the product to be inventoried, the data of the inventory quantity at the time of the previous inventory is recorded in the form of a barcode, and the data in the label part 42 is transferred to the barcode reader 2 By reading it, the previous inventory quantity can be obtained at the inventory site. In addition, the current stock quantity is input from the operation unit 3 and the label part 42 corresponding to the product is updated by printing the label part 42 from the printing part 4, thereby quickly changing the stock quantity of the product. It can be grasped on the spot.

[0011]

[Example] A label section 42 created corresponding to a product to be inventoried is pasted on a predetermined shelf, and as shown in the explanatory diagram of the label section in FIG. 2, the label section 42 has a barcode printed thereon. Product data (product name, product code, barcode part (a1 to a3) representing inventory quantity, and corresponding character/numeric part (g1 to g1) for guidance that can be identified by the operator)
g3) is maintained.

FIG. 3 shows a system configuration diagram of the embodiment, and FIG. 4 shows an inventory processing procedure diagram of the embodiment. Bring the handy terminal 10 to the product warehouse and read the product data held by the label section 42 into the barcode reader 2 in processing step 81.
Read with 2. In processing step 82, the control section 1 displays the read product name, product code, and quantity (previous stock quantity) on the display section 35. In processing step 83, the operator inputs the current quantity (stock quantity) of the product using the operating unit 3. In processing step 84, the control unit 13 stores data on the previous inventory quantity and current inventory quantity corresponding to the product in the memory unit 55.
Store in. The display unit 35 displays input data when data is input. When a label printing command is received from the operation unit 3, the printing unit 4 prints the quantity (b) of the label portion 42 in processing step 85.
3) is output (
Print. The operator attaches the label to the product for which the inventory quantity check has been completed. When the reading of the product data regarding a predetermined product and the input of the inventory quantity of the product are completed, in a processing step 86, the handy terminal 1 transfers the product-specific inventory data stored in the memory section 55 to the processing device 20.
1 is connected to the processing device 20. The connection to the processing device 20 is made by either a connection method with the processing device 15 using an RS-232C cable, or a line connection via a telephone with a built-in modem.

When a data transfer command is input from the operation section 3 in processing step 87, the control section 1 transfers the inventory data by product stored in the memory section 55 from the transmission section 18 to the processing device 20. In processing step 88, the processing device 20 inputs the transfer data from the handy terminal 20, and creates a product data file 5 in the external storage device 50 having data on the previous inventory quantity and the current inventory inventory quantity. In processing step 89, the product data file 5 is sent to the host computer 40 in response to a command from the system console 25.

[0014]

[Effect of the invention] In inventory, product master file 1
2 from the host computer 16 to the handy terminal 11 via the communication line.
Since the inventory data of the product can be grasped by reading the data of 2 with the barcode reader 2, prompt inventory management at the site can be realized.

[Brief explanation of the drawing]

[Figure 1] Block diagram of the principle of the present invention

[Figure 2] Explanatory diagram of the label part

[Figure 3] System configuration diagram of the embodiment

[Figure 4] Example inventory processing procedure diagram

[Figure 5] Conventional system configuration diagram

[Figure 6] Conventional inventory processing procedure diagram

[Explanation of symbols]

1 and 13 are control units;
10 and 11 are handheld terminals, 12 is a product master file, 1
4 and 50 are external storage devices, 15 and 20 are processing devices,
16 and 40 are host computers, 17 and 18 are transmission units,
19 and 55 are memory parts, 2 and 22 are barcode readers, 3 and 31 are operation parts, 3
2 and 35 are display parts;
4 is a printing part 42, 43 is a label part,
5 indicates the product data file, b1 to b3 indicate the barcode section, g1 to g3 indicate the character/numeric section for guidance, 81 to 89, 91 to 9
7 represents a processing step.

Claims (1)

[Claims] [Claim 1] A control unit (1) and a barcode reader (
2), the operating section (3), the printing section (4), and the memory section (
55), a transmission section (18), and a label section (42) that holds data printed with a barcode, and the control section (1) includes:
Label part (4) read by barcode reader (2)
Predetermined data is created from the data in 2) and the data entered by keystrokes from the operation unit (3), stored in the memory unit (55), and transferred to the processing device via the transmission unit (18). A method for processing inventory data, characterized in that data for a label section (42) is generated by printing the data in a bar code in a printing section (4).