JPH08137970A - Medicine stock management system device - Google Patents

Abstract

PURPOSE: To inexpensively attain efficient management also for articles such as dangerous substances requiring rigid management in addition to simple inventory management by updating data at real time by a magnetic card or an optical card owned by each user in the case of managing the total quantity of order and inventory at the time of warehousing and shipping. CONSTITUTION: Warhousing and shipping management for purchased medicines is executed by a computer. When a magnetic card or an optical card is inputted to an input device 1, stored management data are read out and inventory management information stored in a main storage device 4 or an external storage device 3 can be retrieved/checked through a central processing unit (CPU) 2. The retrieved inventory management information can be printed out by a printer or the like to be an output device and also transmitted through a facsimile. The CPU is respectively connected to the input device 1 and the output device 5 respectively through networks such as an 'Ethernet' or a token ring.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a drug inventory management system device, and more specifically, to a drug inventory management system for managing from a stock confirmation to ordering and carrying in of a stock of various drugs by using a computer in a prescribed quantity. Regarding the device.

[0002]

2. Description of the Related Art In recent years, an inventory management system apparatus for performing inventory management on a computer has emerged as one of the FA conversion flows. In particular, the handling of dangerous substances such as chemicals is regulated by the Fire Service Law. In general, dangerous materials often refer to dangerous materials such as flammable substances, explosive substances, poisonous substances and radioactive substances. Hazardous substances under the Fire Service Law are oxidizing solids, flammable solids, spontaneously ignitable substances and water-prohibiting substances in Article 2, Paragraph 7 of the Fire Service Law.
It is defined as a flammable liquid, self-reactive substance, and oxidizing liquid. Further, regarding the storage and handling of a dangerous substance in a specified quantity or more, it is prohibited to store it in a place other than the storage place or handle it in a place other than the equipment place, the storage place and the handling place.

A known document describing a conventional inventory management system device is, for example, Japanese Patent Laid-Open No. 4-27835.
There is No. 6 publication. According to this publication, by connecting terminals to a plurality of printing machines and connecting them to a host computer through a communication line, it is possible to perform accurate inventory management and process management without requiring labor. for,
Terminals associated with a plurality of printing machines are connected to a host computer via a local area network (LAN). When the number of prints is input to the terminal, the host computer transmits the scheduled print type and the number of prints to be input to the terminal. When receiving the print start signal from the printing machine, the terminal stores the start time,
Manage uptime, downtime, and setup time. After printing is completed, the terminal device calculates the number of non-defective products and the number of products in process. The host computer calculates the operation rate and the like based on the data of the terminal and the data input in advance, predicts the work and scheduled production completion time, and displays them together with the data from the terminal. That is, the terminal is connected to a plurality of printing machines and connected to the host computer via a communication line,
It manages inventory and processes, and is related to host system management.

In the order point management system disclosed in Japanese Unexamined Patent Publication No. 5-28172, there is no excess stock or out-of-stock, and the order point stock quantity and the replenishment point stock quantity are minimized. In order to provide an appropriate inventory amount calculation device that can be set, sales plan data for each item and annual production frequency data are input, and as an initial setting, one production frequency is assigned to all items, and then production is assigned to each item. Increase the number of times once, and based on the change in the running inventory of the item that has increased once, assign the number of times of production to the item with the highest inventory reduction effect until the number of times indicated by the annual number of production data is reached. Based on the annual production count calculation unit that calculates the annual production count for each item by repeating the process, and the existing production count for each item based on the calculated annual production count for each item. And reorder point inventory amount indicating the amount, it is an arrangement that includes a stock amount calculation unit for calculating the replenishment point inventory amount indicating the upper limit of the stock amount.

Further, the one disclosed in Japanese Patent Laid-Open No. 5-12304 provides an integrated production management system capable of reducing the time required for ordering, receiving orders, producing, and delivering, and reducing the labor of staff in each department. In order to do so, when the customer inputs inventory information regarding product inventory into the order support device, order information is automatically created based on this inventory information and is online transmitted to the order support device on the producer side. In response to this, the order acceptance support device transmits the order confirmation information and the delivery schedule to the order acceptance support device. The schedule planning device makes a production schedule based on the order information. The production line management device manages the production line based on this production schedule. Information on each department
It is centrally managed by the host computer.

Further, the one disclosed in Japanese Unexamined Patent Publication No. 5-216905 discloses a case where a wholesaler predicts an ordering period and an order quantity from a retailer and compares the quantity with the stock quantity of the retailer, and there is a possibility that stock may be out of stock. In order to prevent stock-out before ordering in advance to a higher-ranking wholesaler based on the forecast, the retailer from the computer retained by the wholesaler and the personal computer (personal computer) of the online store connected to the retailer Send the current quantity information of the inventory kept by the store to the computer of the wholesaler. The received wholesaler stores the current quantity information in the current information quantity file, predicts the order timing and order quantity of the retail store from the accumulated information, and there is a possibility that the wholesaler may run out of stock for the order. In this case, place an order with a higher-ranking wholesaler to secure the required inventory in advance. As a result, it is possible to minimize the occurrence of stock-out in response to an order from a retail store, and it is possible to quickly respond to the request of the retail store.

[0007]

As described above, in the conventional medicine inventory management system device, the management method of the host / terminal system using the large computer as the host was used. For this reason, the price of the system to be purchased is extremely high, and there is a need for a small-to-medium-sized system, and it has been necessary to efficiently manage the inventory while suppressing the cost. In addition, since the production side manages the shortage of inventory, no method was devised for the receiving side, for example, the ordering side. Moreover, in order to store dangerous substances such as nitric acid and hydrochloric acid in the chemical storage, the Fire Defense Law is applied from the viewpoint of ensuring safety, and only a predetermined amount can be stored. Therefore, more detailed management is required for the management of these chemicals.

The present invention has been made in view of such a situation, and updates the data in real time by a magnetic card or an optical card in which each user manages the total amount of orders and inventory at the time of loading and unloading. Therefore, it is an object of the present invention to provide not only simple inventory management but also a drug inventory management system device capable of efficiently managing dangerous goods such as dangerous goods at low cost. I am trying.

[0009]

In order to solve the above-mentioned problems, the present invention provides (1) an input device for inputting the type of purchased medicine, the date of receipt and exit of the purchased medicine, and the operator name code. A first storage device for storing data input by the input device, a second storage device for storing a program for processing the drug inventory management system, data from the storage device, and data from the input device. A computer system having a central processing unit for processing based on data, and an output device for outputting based on processing of the central processing unit, and managing receipt and delivery of purchased medicines using the computer. Further, (2) managing the keys of the medicine storage and the medicine rack to be managed by interlocking the computer, and (3) Ethernet between the respective devices or Connection using a network such as Kuhnling, and (4) management of the management status from any client device connected to the network can be operated by a server / client method. , And even
(5) Drug data to be managed, administrator data, drug storage data, management data such as monthly data and access status data are recorded on the server, and inventory confirmation and data are made according to the order from the client device. Renewal is possible, and (6) a magnetic card or an optical card is used as a key for the medicine storage and the medicine rack, and (7) various menu operations and data input operations on the client. Processing using a mouse, and (8) as an external output device, a facsimile, a composite copying machine, a composite printer, or a FAX.
Connecting a modem, and (9) automatically ordering the drug ordering business to the drug supplier using the output device according to the drug usage status, and (10) preliminarily defining the quantity of the drug. The feature is that the data is recorded in the server, the frequency of drug use is calculated, and a warning is given to the orderer as an alarm when a drug is newly ordered.

[0010]

In the drug inventory management system device of the present invention having the above-mentioned configuration, at the time of meeting the manager at the time of carrying-in, it is possible to carry out the current management by the magnetic card or the optical card of each person in the carry-in warehouse, and the drug rack. Since the total limit of delivery to is fixed, it is possible not only to eliminate shortage of stock but also to suppress over-ordering.

[0011]

Embodiments will be described below with reference to the drawings. FIG. 1 is a block diagram for explaining an embodiment of a drug inventory management system device according to the present invention, in which 1 is an input device, 2 is a central processing unit, 3 is an external storage device, and 4 is a main storage device. Reference numeral 5 is an output device.

The input device 1 is equipped with a magnetic card or an optical card and a reading device (hereinafter referred to as a card reader) in the medicine store. The kind of the purchased drug, the date of storing and releasing the purchased drug, and the name code of the operator. Is entered. The central processing unit 2, the main storage unit 4, and the external storage unit 3 serve as a server machine, for example, a so-called personal computer (hereinafter, PC) or a workstation (hereinafter, WS) as shown in FIG. 2 is used. The output device 5 has a printer in each client or server and is connected to a facsimile or the like.

The present invention has a configuration as described above, and manages storage and delivery of purchased chemicals by using a computer. A magnetic card or an optical card is used as an input device such as a card reader shown in FIG. When input to, the management data stored in the server machine is read using the magnetic card or the optical card as a key, and the inventory management information stored in the external storage device 3 is retrieved via the central processing unit 2. , You can check. The retrieved inventory management information can be printed out by a printer, which is an output device, or can be transmitted via a facsimile. Input device 1 and central processing unit 2, central processing unit 2
The output device 5 and the output device 5 are connected using a network such as Ethernet or token ring.

Ethernet is a LAN communication system jointly developed and commercialized by three American companies, Xerox Co., DEC Co., and Intem Co., and is a small-scale system composed of a personal computer, a workstation, and a minicomputer. Applies to LAN. A bus type LAN is characterized in that a LAN can be easily constructed with a single cable. A transceiver provided in the middle of the cable connects to a computer and can connect to another network through a gateway.

In addition, Token Ring
Is a ring type LAN communication system proposed by IBM Corporation. A token is a symbol or packet that represents a transmission right, and this token is circulated in the network.
The computer connected to the LAN can exchange data only when the signal is transmitted, and when the exchange of data is completed, the token is released and the computer goes to the next computer. This allows you to control the exchange of data and prevent confusion such that multiple computers can operate at the same time ("Computer Glossary" edited by Nippon Knowledge Industry Co., Ltd.,
Saitosha, 1991, 12, 25, pp40-41).

In this way, the total amount of orders and inventory can be managed at the time of loading and unloading in real time by the magnetic card or optical card possessed by each user. It is possible to centrally manage the delivery.

FIG. 4 is a diagram showing an example of the card reader connection shown in FIG. 3, in which 11 is a card reader, 12 is a card reader PC, and 13 is a server machine. The management data stored in the magnetic card or optical card input to the card reader 11 is stored in the card reader PC 1.
Server machine 1 via the network
3 is stored in the storage device.

FIG. 5 is a diagram showing an example of a network connection with a medicine store. In the figure, 21 is a medicine store, 22 is a client, 23 is a medicine rack, 24 and 25 are card readers, 2
6 and 27 are clients. A PC or WS as an operating client 22 is provided in the medicine cabinet 21, and a card reader 24 is provided in the medicine shelf 23. A card reader 25 is also provided on the outer wall of the medicine storage 21. The card reader 2
4 and 25 are connected to the client 22 and can be used both inside and outside the medicine storage 21 to read card readers 24 and 2.
5 can manage the medicine storage. Clients 26 and 27 are connected via a network to a client 22 provided in the medicine storage 21 as needed, and the client 27 is connected to the server machine 13.

That is, when a magnetic card or an optical card is put into the card reader 24 provided in the medicine cabinet 21 in which a plurality of kinds of medicines are stored, the door of the medicine rack 23 opens. When a required amount of a certain drug is taken out from the drug rack 23, management data such as the type and number of the drug and the name code of the operator is stored in the server machine 13 via the network.

Even if a magnetic card or an optical card is inserted into the card reader 25 provided outside the medicine storage 21, the door of the desired medicine shelf 23 can be opened and the same management can be performed as described above. The quantity of medicines stored in the medicine rack 23 in the medicine storage 21 cannot be stored more than the quantity determined by the Fire Service Law. Therefore, there is an upper limit on the quantity of stored medicines. Therefore, the quantity of the medicine that has been taken out and reduced is immediately input as data to the server machine 13 and automatically ordered to the medicine supplier. The actual delivery is performed by the administrator of the medicine storage 21 in the medicine rack 2.
3 will be opened, and the ordered drug supplier will carry in the drug.

The clients 26 and 27 have both functions of inputting and outputting data, and are arranged in departments that use chemicals, such as laboratories, and receive data via the clients 26 and 27. You can enter and request the type and quantity of the required medicine. Although only two clients are shown in FIG. 5, the clients are provided in the required number of departments and are connected on the network. If necessary, the client 22 may be provided in the medicine storage 21 and used as a monitor.

The server / client method is a method in which a program called a server and a program called a client can be used in cooperation with the system. The server actually draws on the display,
Control the keyboard and mouse. On the other hand, the client uses the network to issue a request for processing to the server and receives information from the keyboard and mouse from the server.

The storage and delivery management of purchased medicines are managed using a computer, and the medicine storage 21 and the medicine rack 23 keys to be managed are interlocked with the computer for management. A magnetic card or an optical card is used as this key. The management status can be monitored from any of the clients 22, 26, 27 connected on the network. Data such as drug data to be managed, administrator data, drug storage data, monthly data and access status data are recorded on the server, and inventory confirmation and data update can be performed by an order from the client.

FIG. 6 is a view showing the medicine rack in FIG.
In the figure, 23a is a door, and 24a and 24b are card readers. Card readers 24a, 24b are provided on the wall portion between the doors 23a of the medicine rack 23. This is the door 23a
Card reader 24a,
This is because it is convenient to be provided near the door for inputting inventory information by using a magnetic card or an optical card for 24b. Further, the medicine rack 23 has a number of chambers corresponding to the types of medicines, and a card reader is provided for each chamber. Therefore, it is possible to manage each type of drug. Further, the medicine has an expiration date, and it is necessary to replace the medicine that is not used within a predetermined period and is old.

FIG. 7 is a diagram showing an example of connection by a client. In the figure, 31 is a laser printer, 32 is a facsimile, and other parts having the same operations as in FIG. A laser printer 31 is connected to the client 26 as the output device 5 via the network, and a facsimile 32 is connected to the client 27 as the output device 5 via the network. Various menu operations and data input operations on the clients 26 and 27 are performed using a mouse. As the external output device, in addition to the laser printer 31 and the facsimile 32 as shown in FIG.
It is also possible to connect an X modem or the like.

As described above, the card reader is connected to the server and the clients arranged in each department through the network, and each client or server has a printer as an output device, and the facsimile is also connected. According to the usage situation of medicines, it is possible to automatically place an ordering document for a medicine supplier to a medicine supplier by using the external output device. Further, it is also possible to record the prescribed amount of revision data of the drug in the server in advance, further calculate the usage frequency of the drug by a calculation formula, and give a warning to the orderer by an alarm when a new drug is ordered.

Further, the drug inventory management system device according to the present invention is applied to drug retailing, hospital drug management, laboratory drug management, and the like. Conventionally, there is a discrepancy between the management of the chemicals themselves and the management of the books, and for example, it was necessary to check the quantity on the books against the quantity of the actual articles every six months. According to this, inventory management at the present time can be realized without causing such a difference in quantity.

[0028]

As is apparent from the above description, the present invention has the following effects. (1) By the server / client type network connection, inventory management information can be searched and confirmed from each client connected to the network without imposing a large capacity and load on the server. (2) Since the server has drug information that is centrally managed,
It is possible to easily search and confirm information from a PC or WS connected to the network without having to manage each department independently. (3) By using a magnetic card or an IC card for the management of the medicine storage, it is possible to prevent human troubles such as not filling in properly. (4) Confirmation work is not complicated because the management data for warehousing and warehousing is entered immediately in the medicine storage. (5) Because the drug inventory is centrally managed on the server,
There is no difference based on personal data due to data backup. (6) Depending on the stock quantity of the medicines used, the purchase order is automatically sent through an external device such as a facsimile by the name of the person in charge, so purchase mistakes due to circulation of documents can be minimized. (7) Since it is not possible to order more than the control amount, the drug storage will not overflow and the management will be necessary and sufficient, and the drug storage can be used efficiently. (8) Since the input data can be obtained without the intervention of the person in charge of input, the labor is greatly saved.

[Brief description of drawings]

FIG. 1 is a configuration diagram for explaining an embodiment of a drug inventory management system device according to the present invention.

FIG. 2 is a diagram showing an example of a workstation according to the present invention.

FIG. 3 is a diagram showing a card reader according to the present invention.

FIG. 4 is a diagram showing a connection example of a card reader according to the present invention.

FIG. 5 is a diagram showing an example of network connection with a medicine store according to the present invention.

6 is a diagram showing a medicine rack in FIG. 5. FIG.

FIG. 7 is a diagram showing a connection example at a client in the present invention.

[Explanation of symbols]

1 ... Input device, 2 ... Central processing unit, 3 ... External storage device,
4 ... Main storage device, 5 ... Output device, 11 ... Card reader, 12 ... PC for card reader, 13 ... Server machine, 21 ... Drug store, 22 ... Client, 23 ... Drug shelf, 23a ... Door, 24, 25 ... Card reader, 24
a, 24b ... Card reader, 26, 27 ... Client, 31 ... Laser printer, 32 ... Facsimile.

─────────────────────────────────────────────────── ─── Continuation of the front page (51) Int.Cl. ⁶ Identification code Internal reference number FI technical display location G06F 17/60

Claims (8)

[Claims] 1. An input device for inputting a type of purchased medicine, a date of entering and leaving the purchased medicine, and a name code of a handler, and a first storage means for storing data input by the input device.
Storage device, a second storage device that stores a program for processing a drug inventory management system, a central processing unit that processes based on data from the storage device and data from the input device, and the central processing device. And an output device for outputting based on the processing of 1., a drug inventory management system device, characterized in that management of warehousing and warehousing of purchased drugs is managed using the computer. 2. The medicine inventory management system apparatus according to claim 1, wherein the keys of the medicine storage and the medicine rack to be managed are managed by interlocking the computer. 3. The drug inventory management system device according to claim 1, wherein the devices are connected to each other by using a network such as Ethernet or token ring. 4. The drug inventory management system according to claim 1, wherein the network is operated by a server / client system in which the management status can be monitored from any client device connected to the network. apparatus. 5. Drug data to be managed, administrator data, drug storage data, management data such as monthly data and access status data are recorded on the server,
2. The drug inventory management system device according to claim 1, wherein inventory confirmation and data update are possible according to an order from a client device. 6. The drug inventory management system device according to claim 1, wherein a magnetic card or an optical card is used as a key for the drug store and the drug rack. 7. The drug inventory management system device according to claim 1, wherein a drug ordering business automatically orders a drug supplier to a drug supplier using the output device according to a drug utilization situation. 8. The medicine according to claim 1, wherein the prescribed quantity data of the medicine is recorded in the server in advance, the usage frequency of the medicine is calculated, and a warning is given to the orderer as an alarm when the medicine is newly ordered. Inventory management system equipment.