JP2001206515A - Inventory control device - Google Patents

Abstract

PROBLEM TO BE SOLVED: To ensure inventory control by unnecessitating entering in a complicated receiving/paying card, make the number of stock proper and extremely reduce stock space. SOLUTION: When various kinds of articles are taken out of an article storing house 1, kind and quantity data of articles taken out are inputted by a handy terminal 37, the inputted data is transferred to a control server 29 and the control server 29 updates stock data. The control server 29 automatically calculates the proper number of stock of various kinds of articles from past data. When short articles exist, an order request output is performed for the article. Based on the output, a controller orders the article and stores the article in the articles storing house 1. In a warehouse PC 21 incorporated into the article storing house 1, stock data of the article is updated by performing a receiving and inspecting operations of the stored articles.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

[0001] 1. Field of the Invention [0002] The present invention relates to an inventory management device for managing inventory of various articles.

[0002]

2. Description of the Related Art In a telephone construction company or the like, for managing articles such as telephone repair parts, various articles are usually stored in a plurality of article storage boxes arranged on steel shelves in a warehouse. When a worker goes to telephone work, he takes out a necessary number of necessary articles from an article storage box on a steel shelf and loads it into a vehicle. At this time, the worker enters necessary items such as a take-out person name and the number of take-outs on a payment card arranged for each storage box of various articles. The inventory manager periodically checks the inventory of the steel shelves from which the goods have been taken out, and places an order for each item that is less than the appropriate number of inventory set by the inventory manager. And replenish the storage box.

[0003]

However, such a conventional inventory management device has the following problems.

[0004] (1) Since the entry into the payment card is complicated,
Depending on the operator, it may not be executed, and inventory management becomes sparse.

[0005] (2) The setting of the appropriate stock quantity is not reliable because the stock manager is merely based on experience, and there is a case where more articles than necessary are stored in order to prevent a shortage. Become.

SUMMARY OF THE INVENTION Accordingly, an object of the present invention is to make inventory management reliable by eliminating the need for complicated entry and exit cards, and to minimize the inventory space by optimizing the number of articles in stock.

[0007]

In order to achieve the above object, according to the first aspect of the present invention, an appropriate inventory quantity of various articles is calculated based on past data, and the number of articles stored in a storage position is calculated. A management server that stores the stock numbers of various articles and outputs an order request for articles that are insufficient for an appropriate stock number, and stores the ordered articles in accordance with the order request output in the storage position. At this time, the storage side PC on which an input operation is performed to incorporate the data of the article into the inventory data stored in the management server, and the data of the article taken out when the various articles are taken out of the storage position are input. And a handy terminal for transferring the input data of various articles to the management server.

According to the inventory management device having such a configuration,
When taking out various articles from the storage position, the type and quantity data of the articles taken out are input at the handy terminal, and the input data is transferred to the management server to update the stock data. The management server automatically calculates the appropriate stock quantity of various articles from the past data, and if there is a missing article, outputs an order request for the article, and retrieves the ordered article after the order, according to a predetermined order. Store in the storage position. The storage-side PC performs an acceptance and acceptance operation of the stored article to update the inventory data of the article.

According to the second aspect of the present invention, in the configuration of the first aspect, various articles are stored in an article storage provided with an opening / closing portion having a lock mechanism, and the storage PC is provided in the article storage. There is a configuration built in.

[0010] According to the above configuration, the lock mechanism is unlocked to open the opening / closing part when taking out or storing various articles in the article storage, and after the work is completed, the opening / closing part is closed. Lock the locking mechanism. The storage PC is easy to operate because it is integrated with the article storage.

According to a third aspect of the present invention, in the configuration of the first or second aspect, the management server transmits the article order data to the article ordering party based on the output of the order request data of the missing article. It is configured to include transmission means.

According to the above configuration, when the management server outputs the order request data for the missing article, the transmitting means receives the request data and transmits it to the ordering party of the article.

According to a fourth aspect of the present invention, in the configuration according to any one of the first to third aspects, the management server can calculate the total inventory value of the entire inventory item, and is used when a certain item is taken out of the storage position. In calculating the total inventory amount, the unit price corresponding to the same type of article stored first in the storage position is subtracted from the total inventory amount up to now.

According to the above configuration, when taking out an article,
The unit price of the same type of article stored earlier is subtracted from the total inventory amount so far, whereby the best total inventory amount is calculated without the need for complicated work of managing data of individual articles.

According to a fifth aspect of the present invention, in the configuration of any one of the first to fourth aspects, the management server is capable of calculating the total inventory amount of the entire inventory item, and is used when returning a certain item to the storage position. In calculating the total inventory amount, the unit price of the same kind of article taken out from the storage position at the closest time is added to the total inventory amount up to now.

According to the above configuration, when returning an article to the storage position, the unit price of the same kind of article taken out at the closest time is added to the total inventory amount, thereby complicating the management of data of each article. The best total inventory is calculated without the need for work.

According to a sixth aspect of the present invention, in the configuration according to any one of the first to fifth aspects, the handy terminal comprises:
The management server is provided corresponding to a vehicle on which various articles are loaded, and is configured to manage various articles for each vehicle.

According to the above configuration, for example, by inputting the code name of the vehicle in addition to the data input of the brought-out article from the handy terminal, the article taken out for each vehicle can be managed.

According to a seventh aspect of the present invention, in the configuration according to the sixth aspect of the present invention, when an article on which a plurality of vehicles each having a handy terminal are respectively loaded is transferred between the vehicles, the handy terminal is connected to the vehicle. The data of the article loaded on the vehicle after the transfer is stored by an input operation.

According to the above configuration, when transferring articles between vehicles, it becomes possible to update the article data on the vehicle after the transfer by the handy terminal.

According to an eighth aspect of the present invention, in the configuration of any one of the first to seventh aspects, the storage-side PC can perform an input operation according to the condition of the article, such as a new article or a used article. Is stored in the management server.

According to the above configuration, it is easy to determine whether a product is new or used, and it is also possible to manage reusable products.

According to a ninth aspect of the present invention, in the configuration of any one of the first to eighth aspects, the storage-side PC includes means for detecting a locked / unlocked state of the lock mechanism of the opening / closing portion,
When the unlocked state continues for a predetermined time, an alarm signal is output to the management server.

According to the above configuration, when the unlocked state of the opening / closing portion continues for a predetermined time, the management server receives an alarm signal, whereby the administrator grasps the abnormality.

According to a tenth aspect of the present invention, in the configuration according to any one of the first to ninth aspects, the storage-side PC has a display for displaying various data, and an input operation can be performed on the display. The configuration is a touch panel type.

According to the above-described configuration, various input operations can be easily performed on the display unit and can be easily operated.

[0027]

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

FIG. 1 is an overall configuration diagram of an inventory management device showing an embodiment of the present invention. Articles managed by the inventory management device include various telephone repair parts handled by a telephone company or the like, but are not particularly limited thereto.

The above-mentioned various articles are stored in an article storage 1 which is a storage position of the articles. The article storage 1
A pair of left and right article storage doors 5, 7 open front and rear are provided on the front opening side of the article storage rack 3 having an opening on the front side.
Are mounted to be openable and closable left and right via hinges 9 provided on both right and left sides. A plurality of article storage shelves are provided in the component storage rack 3 in the vertical direction to store relatively large articles.

On the other hand, in the left and right article storage doors 5 and 7, containers for storing various articles, for example, for each type, are provided at portions other than the PC accommodating section 11 above the article storage door 7, respectively. A plurality of doors 5 and 7 are arranged on both front and rear sides. Relatively small articles are stored in this container. Doors 15 made of a transparent or translucent acrylic plate or the like are provided at the front openings of the article storage shelves 5 and 7.
17 can be opened and closed via hinges 19 provided on both left and right sides.

The above article storage doors 5, 7 and door 1
Reference numerals 5 and 17 each include an electromagnetic lock as a lock mechanism, and constitute an opening / closing portion.

The upper PC in the right door 17 in the figure
The storage section 11 has a warehouse PC 21 therein as a storage-side PC.
And a touch panel 23 provided on the front surface thereof, which is capable of inputting various data and having a display function, and an identification code for releasing the electromagnetic lock of each of the article storage doors 5, 7 and the doors 15, 17. A magnetic card reader 25 into which an ID card provided with an ID is inserted, and a bar code reader which reads a bar code which is printed on a label attached to each of various articles stored in the article storage 1 and constitutes data of various articles. 27.

The management server 29 can store the stock numbers and the total amount of stock of various articles stored in the article storage 1 and calculate the appropriate stock numbers of various articles from past data. It is. In this calculation work, “constant setting” displayed on the display 31 is selected, and then, for example, a calculation period and an article to be calculated are set on another screen to be switched. As a result, an appropriate stock quantity during the set period is calculated.

As a process for calculating the stock quantity, for example, if the set period is one month in September, the average number of used articles in the past several years in September may be calculated and set as the proper stock quantity. . In this case, the days when the number of articles used in each month in September of the past several years is abnormally high and the days when the number of articles is abnormally low in the past are respectively excluded from the average calculation,
It is possible to calculate the stock quantity more accurately.

When the calculated current stock quantity of an article is smaller than the proper stock quantity or smaller than a predetermined quantity, "input article request" displayed on the display 31 is selected. After that, enter the code and quantity of the required goods. This input operation can be performed on the display 31 and the keyboard 33.

When the above input operation is completed and a predetermined print execution operation is performed, the printer 35 outputs an article request form on which the name and quantity of the article to be ordered are printed. The necessary article is ordered by sending the article request form to the ordering party by facsimile or the like. This article ordering is performed by connecting a facsimile machine as a transmission means to the management server 29 internally or externally, and performing a predetermined transmission operation on the display 3.
By performing the operation on the device 1 or on the keyboard 33, the article request form can be transmitted to the ordering party without being printed out by the printer 35.

When the ordered goods are ordered, the manager touches a "stock" button displayed on the touch panel 23 of the warehouse PC 21 and performs a receiving / accepting process operation on another screen which is switched thereafter. In other words, the reception and acceptance process checks whether or not there is an error in the type and quantity of the goods received after the order with respect to the goods request document data from the management server 29. If there is no error, a predetermined operation is performed, and the data of the goods received and accepted is stored in the management server 29.
And updates the stock data, and stores the article at a predetermined position in the article storage 1.

On the other hand, in the management server 29, after selecting "input receipt acceptance receipt" displayed on the display 31, the unit price of the various articles subjected to receipt acceptance by the warehouse PC 21 is set and inputted. As a result, the data of the total stock price of the articles stored in the article storage 1 is updated.

The articles once taken out are stored in the article storage 1
In the return processing to return to the above, the user touches the same “receiving” button on the touch panel 23 as described above, and then performs the return receiving processing operation on another screen to be switched thereafter. That is, the return receipt processing is performed by selecting whether the returned article is a new article or a used article, inputting the vehicle code of the vehicle 39 using the handy terminal 37 described later, the user code, and the bar code reader. 27, the article code (article type, unit price) is read, and the quantity of the article is input, and the data of the management server 29 is updated.

At this time, the management server 29 calculates the unit price of the returned article as the unit price of the same kind of article taken out at the closest time, and adds it to the total inventory amount. As a result, the best total inventory amount can be obtained without performing the complicated work of managing the data of each article.

The warehouse PC 21 can unlock the article storage doors 5 and 7 and the lock mechanisms of the doors 15 and 17 when the user sets his / her ID card in the card reader 25. In addition, the warehouse PC 21 includes the article storage doors 5 and 7.
And means for detecting the locked / unlocked state of each lock mechanism of the doors 15 and 17, and outputs an alarm signal to the management server 29 when the unlocked state of any of the doors continues for a predetermined time. ing. As a result, the management server 29 can grasp the abnormality of the article storage 1 and improve the reliability of article management.

The handy terminal 37 is used for each vehicle 39. An operator who handles the handy terminal 37 takes out necessary articles from the article storage 1 when going out to work such as telephone work. . At this time, the worker touches a “delivery” button on the touch panel 23 of the article storage 1. Next, by setting its own ID card in the card reader 25, the article storage doors 5, 7 or the doors 15, 17 are unlocked and can be opened. Here, the article storage doors 5, 7 or the doors 15, 17 are opened,
Take out the necessary goods, load them on the vehicle, and store the goods
7 or the doors 15 and 17 are closed and locked.

Then, from the handy terminal 37, an entry process to the vehicle, that is, an in-vehicle entry process is performed. That is, the barcode of the taken-out article is read by the built-in scanner, and the quantity, the user code, and the vehicle code are input. This input article is mounted on the vehicle.

When the work for taking out the articles is completed, the handy terminal 37 is set in the transmission device 41 connected to the management server 29, and the fetched data is transmitted to the management server 29. As a result, the management server 29 updates the stock quantity and the stock amount of the articles stored in the article storage 1 to new ones, and at the same time, stores the data of the type and quantity of the loaded articles for each vehicle.

By the way, even if the articles are of the same kind, if the ordering time is different, the unit price may be different. In such a case, the management server 29 sets the unit price of the taken-out article as the unit price of the same kind of article stored in the article storage 1 at the farthest time, and subtracts this unit price from the total inventory amount before the taking-out. I do. As a result, the best total inventory amount can be obtained without performing the complicated work of managing the data of each article.

Also, when transferring and loading articles loaded on another vehicle, the in-vehicle warehousing process is performed at the handy terminal 37 in the same manner as described above. Conversely, when transferring the articles loaded in the own vehicle to another vehicle, the in-vehicle retrieval processing is performed at the handy terminal 37. The input data in the in-vehicle retrieval process is the same as that in the in-vehicle entry process. Corresponding to the warehousing process and the warehousing process of the own vehicle, the other vehicle also performs the warehousing process and the warehousing process at the corresponding handy terminal.

As described above, even after the transfer of articles between vehicles, the handy terminal 37 is set in the transmission device 41 and the data is transmitted to the management server 29.
Data management of loaded articles can be performed for each vehicle. Since article transfer management can be performed between vehicles, even if the vehicle is located at a position away from the article storage 1, if there is another vehicle nearby, articles can be transferred between the vehicles, which is convenient. improves.

When the worker uses the taken-out article at the work site, he inputs the code and quantity of the used article from the handy terminal 37. Thereby, the data of the articles loaded on the vehicle 39 after the articles are used is updated.

After the work is completed, the worker returns to the office, sets the handy terminal 37 in the transmission device 41, and transfers the updated data of the handy terminal 37 to the management server 29.

The handy terminal 37 may be used independently for each vehicle 39 as shown in FIG. 1A, or may be used alone as shown in FIG. In the case of single use, there is no need to input a vehicle code.

It is to be noted that the article storage 1 is not always necessary, and it is sufficient if there is a space for simply storing various articles.
A warehouse PC 21 provided with a touch panel 23, a card reader 25 and a barcode reader 27 near this storage position.
May be installed.

[0052]

As described above, according to the first aspect of the present invention, the management server automatically calculates the appropriate stock quantity of the article, so that the stock management is assured and the stock more than necessary is secured. And inventory space can be minimized. In addition, the management server outputs an article order request for an article that is insufficient for the proper stock quantity, so that the order for the missing article can be reliably performed.

The goods received after the order is received and inspected by the storage side P
C, which makes it easy to update inventory data after receipt and acceptance.

When an article is taken out of the storage position, the data of the article is input at the handy terminal and the input data is transferred to the management server, so that the management server can easily update the inventory data. .

According to the second aspect of the invention, various articles are stored in the article storage provided with the opening / closing portion having the lock mechanism, and the storage PC is built in the article storage. Articles can be taken out and replenished only by a specific user, article management can be performed more reliably, and input operations such as article receiving and acceptance work on the storage PC become easier.

According to the third aspect of the present invention, the management server:
Based on the output of the order request data for the missing items,
Since the transmission means for transmitting the article order data to the article ordering party is provided, the ordering work for the missing articles is simplified and the work efficiency is improved.

According to the invention of claim 4, the management server comprises:
It is possible to calculate the total inventory value of the entire inventory item, and the calculation of the total inventory value when taking out a certain item from the storage position,
The unit price corresponding to the same type of goods stored earlier in the storage position is subtracted from the total inventory amount so far, so the best total inventory amount can be calculated without the complicated work of managing the data of each item. Obtainable.

According to the fifth aspect of the present invention, the management server comprises:
The total inventory value of the entire inventory can be calculated, and the calculation of the total inventory price when returning an item to the storage position is based on the unit price of the same type of item taken out from the storage position at the closest time. Since it is added to the amount of money, the best total inventory amount can be obtained without performing the complicated work of managing the data of each article.

According to the invention of claim 6, the handy terminal is provided corresponding to a vehicle on which various articles are loaded,
Since the management server manages the various articles for each vehicle, the management server can manage the articles taken out for each vehicle, and the article management becomes more reliable.

According to the seventh aspect of the present invention, when an article loaded by a plurality of vehicles each having a handy terminal is transferred between the vehicles, the handy terminal is operated by an input operation. Since the data of the articles loaded on the vehicle is stored, even if the vehicle is located away from the article storage position, if there is another vehicle nearby, the articles can be transferred and the data updated between the vehicles. Convenience is improved.

According to the eighth aspect of the present invention, the storage-side PC includes:
You can perform input operations according to the status of goods, such as new or used,
Since the input data is stored, it is easy to determine whether the product is new or used, and it is possible to manage reusable products.

According to the ninth aspect of the present invention, the storage-side PC includes:
A means for detecting the locked / unlocked state of the lock mechanism of the opening / closing part is provided. When the unlocked state continues for a predetermined time, an alarm signal is output to the management server. Can be grasped, and the reliability of article management is improved.

According to the tenth aspect of the present invention, the storage-side PC
Is equipped with a display that displays various data.
Since the touch panel is used on the display, various input operations can be easily performed on the display, and operability is improved.

[Brief description of the drawings]

FIG. 1 is an overall configuration diagram of an inventory management device according to an embodiment of the present invention.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 Article storage 5,7 Article storage door (opening / closing part) 15,17 Door (opening / closing part) 21 Warehouse PC (storage side PC) 37 Handy terminal 39 Vehicle

Continued on the front page (72) Inventor Osamu Oumi 8-14-24 Nishi-Shinjuku, Shinjuku-ku, Tokyo NTT FANNET SYSTEMS CORPORATION (72) Inventor Tadaaki Gunji Nishi-Shinjuku, Shinjuku-ku, Tokyo 8-14-24 NTT FANNET SYSTEMS CORPORATION (72) Inventor Naoya Fujimoto 8-14-24 Nishi Shinjuku, Shinjuku-ku, Tokyo NTT FANNET SYSTEMS Co., Ltd. F-term (reference) 3F022 EE09 FF01 MM08 MM28 MM35 MM70 PP04 5B049 CC27 DD02 FF01

Claims (10)

[Claims] 1. An appropriate inventory quantity of various articles is calculated based on past data, and an inventory quantity of the various articles stored in a storage position is stored. A management server that performs an order request output of an article that is present, and, when storing an article ordered and ordered according to the order request output in the storage position, the data of the article is stored in inventory data stored in the management server. A storage-side PC on which an input operation is performed to be incorporated, and a handy terminal for inputting data of the taken-out article when taking out the various articles from the storage position and transferring the input data of the various articles to the management server An inventory management device comprising: 2. The article storage apparatus according to claim 1, wherein the various articles are stored in an article storage provided with an opening / closing portion having a lock mechanism, and the storage PC is built in the article storage.
Inventory control device as described. 3. The management server according to claim 1, wherein the management server includes transmission means for transmitting the article order data to the article ordering party based on the output of the order request data of the missing article. Inventory control device as described. 4. The management server is capable of calculating the total inventory amount of the entire inventory item, and calculating the total inventory amount when taking out a certain item from the storage position is based on the same type of item stored first in the storage position. The inventory management device according to claim 1, wherein a corresponding unit price is subtracted from the total amount of inventory up to now. 5. The management server is capable of calculating a total inventory amount of the entire inventory item, and calculating the inventory total amount when returning a certain item to the storage position is based on the same type of item taken out at the closest time from the storage position. The inventory management device according to any one of claims 1 to 4, wherein a unit price of the article is added to the total amount of the inventory up to now. 6. The portable terminal according to claim 1, wherein the handy terminal is provided corresponding to a vehicle on which various articles are loaded, and the management server manages various articles for each vehicle. Inventory control device as described. 7. When transferring articles loaded by a plurality of vehicles each having a handy terminal between the vehicles, the handy terminal uses an input operation to input data of the article loaded on the vehicle after the transfer. The inventory management device according to claim 6, wherein: 8. The storage-side PC can perform an input operation according to the status of an article such as a new article or a used article, and data corresponding to the new article or a used article is stored in a management server. 8. The inventory management device according to any one of items 7 to 7. 9. The storage-side PC includes means for detecting a locked / unlocked state of a lock mechanism of an opening / closing portion, and outputs an alarm signal to the management server when the unlocked state continues for a predetermined time. The inventory management device according to any one of claims 1 to 8, wherein 10. The storage-side PC is provided with a display for displaying various data, and a touch panel type input operation can be performed on the display.
The inventory management device according to any one of the above.