JPH0495158A - Inventory menagement system - Google Patents

Abstract

PURPOSE:To execute the inventory taking of the number of inventories in the course of processing of warehouse and delivery by providing book inventory data updating journal added updating time to book inventory data, and adding its input time to real inventory data. CONSTITUTION:Warehouse delivery data inputted from a data input device 10 is sent to a data processor 20 in a real tie, updates and account book stock data file 40, and simultaneously, outputs book inventory data added an updating time (store time) to an account stock data updating journal 60. On the other hand, being entirely independent form this processing, quantity data of real inventories is inputted from a read inventory data input device 30, an input time is added thereto, and it is stored in a real inventory data file 50. In such a way, by retrieving the book stock data updating journal 60 corresponding to the input time of the real inventory data, a collation inventory taking of the real inventory and the book inventory in a prescribed time can be executed in the course of processing for updating the inventories.

Description

DETAILED DESCRIPTION OF THE INVENTION [Prior Art] The present invention relates to an inventory management system, and is particularly applicable to a retail industry equipped with a POS, a wholesale industry in general, or an inventory management department of a manufacturing industry, etc., for managing inventory online or in batches. The present invention relates to an inventory management system that can be widely applied in fields where it is desired to carry out inventory inventory operations while performing update processing.

[Prior Art] Conventionally, in inventory management systems, methods for updating the same file from a plurality of input devices and methods for separating transaction processing and aggregation processing have been known regarding the inventory updating process itself.

Note that known documents related to this type of technology include, for example, JP-A-60-'27978 and JP-A-63-28.
Publication No. 8362 can be cited.

[Problem to be solved by the invention J] The above-mentioned conventional technology has the following problems:
No consideration was given to inputting actual inventory data independently and comparing book inventory data and actual inventory data (inventory taking), and ended the series of update processes for update data of warehouse receipts and shipments that occur irregularly. Otherwise, there was a problem in that book inventory data and actual inventory data could not be compared.

An object of the present invention is to provide inventory management that allows inventory update processing to be performed in real time while matching actual inventory data collected completely independently of the update processing with ledger inventory data obtained as a result of the update processing. The goal is to provide a system.

[Means to solve the problem]

In order to achieve the above object, the present invention provides a data input device capable of inputting warehousing data and warehousing (sales) data, a data processing device that processes the data, and an actual inventory data input device that inputs the quantity and type of actual inventory. In an inventory management system that includes a device, a book inventory data file that stores book inventory data calculated from warehouse inventory data, and an actual inventory data file that stores actual inventory data, the book inventory data is updated with an update time. A ledger inventory data update journal is provided, and the input time is added to the actual inventory data stored in the actual inventory data file.

[Function] The warehousing/output data input from the data input device is sent to the data processing device in real time, updates the book inventory data file, and at the same time converts the book inventory data to which the update time (storage time) has been added into the book inventory data. Output to update journal. On the other hand, completely independent of this processing, the quantity data of the actual inventory is inputted from the actual inventory data input device, the input time is added thereto, and the data is stored in the actual inventory data file.

As a result, by searching the ledger inventory data update journal corresponding to the input time of the actual inventory data, it is possible to check (inventory take) the actual inventory and the ledger inventory at a predetermined time during inventory update processing in real time.

〔Example〕

An embodiment of the present invention will be described below with reference to the drawings.

FIG. 1 is an overall configuration diagram of an embodiment of the inventory management system of the present invention. In FIG. 1, 10 is a data input device capable of inputting warehousing data and warehousing (sales) data;
3o is a data processing device, 3o is an actual inventory data input device for inputting the quantity and type of actual inventory, 40 is a ledger inventory data file that stores ledger inventory data calculated from warehouse input/output data, and 50 is a storage device for storing actual inventory data. The actual inventory data file 60 is a book inventory data update journal that stores book inventory data with the storage time added to the book inventory data file 40.

The outline of the operation in FIG. 1 is as follows. Incoming data and outgoing data are input irregularly from a data input device, and the data is sent to the processing device 2° in real time.The data processing device 20 calculates ledger inventory data from this incoming and outgoing data and creates a ledger inventory data file. At this time, the book inventory data to which the storage time (update time) in the book inventory data file 40 has been added is output to the book inventory data update journal 60. On the other hand, completely independently of this update process, actual inventory data such as the quantity and type of actual inventory is inputted from the actual inventory data input device 30, an input time is added thereto, and the data processing device 20 inputs the actual inventory data such as the quantity and type of actual inventory.
send to The data processing device 20 stores the actual inventory data to which this input time has been added to the actual inventory data file 50.

In this way, all the inventory data in the actual inventory data file 50 and the ledger inventory data update journal 60 have the input time or update time added, and while executing the inventory update process in real time, the ledger inventory data at a predetermined time can be updated. This makes it possible to check actual inventory data (inventory inventory).

FIG. 2 shows an example of the ledger inventory data update journal 60, in which items are stored as 61 for item A, 62° for item B, and so on. For example, for product A of 61, the time is 12:00.
There are 10 items in stock per minute, and the book inventory quantity is 50. At time 13:20, 20 items are delivered, and the book inventory quantity = 50-20 = 3' 0. In the same manner, a journal of the updated ledger inventory quantity is stored each time storage/output data is generated. Other products are also stored in the book inventory data update journal 60 in a similar manner.

FIG. 3 is an example of the actual inventory data file 50, in which the actual inventory quantity and input time for each product are stored. for example,
This means that for product A, the actual inventory quantity of 50 that was investigated at time 12:50 was input, and for product B, the actual inventory quantity of 30 that was investigated at time 13:30 was input. Similarly, the actual inventory quantity for each product is stored in the actual inventory data file 50 together with the input time (investigation time).

Note that FIG. 3 shows that the actual inventory quantity of 20 for product A was input again at time 15:00. The input order and input time of the actual stock quantity data for each product are arbitrary, and it is also possible to input the actual stock quantity data multiple times at different times, as in the case of product A.

FIG. 4 shows a procedure for comparing the book inventory data update journal 60 and the actual inventory data file 50. First, the ledger inventory data update journal 60 and the actual inventory data file 50 are sorted by the product code (product name) as the first key and the time as the second key (steps 101 and 102).
), check by product code and time (Step 1
03).

For example, in the example of FIGS. 2 and 3, in the case of product A, the actual inventory quantity 50 inputted to the actual inventory data file 50 at time 12:50 has a time difference of 61 in the ledger inventory data update journal 60. Search for key, 12:50
It is sufficient to check the book inventory quantity 50 at time 12:10, which is the book inventory data at the closest time within minutes.

Similarly, the actual inventory quantity 20 input at time 15:00 in the actual inventory data file 50 is obtained by searching for the same <61 in the ledger inventory data update journal 60 using the time as a key.
It is sufficient to check the book inventory quantity 25 at time 14:10, which is the actual inventory data at the closest time, without exceeding the time.

Next, output the above verification results as an inventory error list (
Step 104).

FIG. 5 shows an inventory error list for product A in FIGS. 2 and 3. From Figure 5, product A is at actual inventory input point 1.
At 2:50, the error between the actual inventory quantity and the book inventory quantity is O1.
At the actual inventory input time of 15:00, it is found that the actual inventory quantity is 5 items less than the ledger inventory quantity. Similar verification processing and inventory error list output can be performed for other products as well.

〔Effect of the invention〕

As is clear from the above description, according to the present invention, it is possible to check the actual inventory quantity and the book inventory quantity in parallel with the real-time inventory update process, and it is possible to check the inventory quantity during the stocking and issuing process. It has the effect of realizing Furthermore, according to the present invention, it is possible to perform verification by actual inventory survey time, and to track the time causes of inventory errors. It should be noted that the present invention has the effect of being able to take inventory not only online in real time but also in batch processing.

[Brief explanation of the drawing]

FIG. 1 is an overall configuration diagram of an embodiment of the inventory management system of the present invention, FIG. 2 is a diagram showing a specific example of a ledger inventory data update journal, and FIG. 3 is a diagram showing a specific example of an actual inventory data file. FIG. 4 is a process flow diagram showing a procedure for collating the ledger inventory data update journal and the actual inventory data file, and FIG. 5 is a diagram showing a specific example of the inventory error list. 10... Data input device, 0... Data processing device, O... Actual inventory data input device, 0... Book inventory data file, 0... Actual inventory data file, 0... Book inventory Data update journal. Figure 2 Figure 3

Claims (1)

[Claims] (1) A data input device that can input warehousing data and warehousing (sales) data, a data processing device that processes the data,
A physical inventory data input device for inputting the quantity and type of physical inventory;
In an inventory management system comprising a book inventory data file that stores book inventory data calculated from warehouse inventory data and an actual inventory data file that stores actual inventory data, an update time is added to the book inventory data. What is claimed is: 1. An inventory management system comprising: providing a ledger inventory data update journal; and adding the input time to the actual inventory data stored in the actual inventory data file.