KR20080009882A - Medical erp system - Google Patents

Abstract

An ERP(Enterprise Resource Planning) system for managing medicines is provided to improve business process, productivity, and correctness, optimize a management environment, and maximize competitive power of a company by integrating/systematizing related processes having business connection and constructing a database server for managing process results integrally. A plurality of client terminals(10) collect data by using individual applications and a GUI(Graphic User Interface) corresponding to each application, and stores the data temporarily. A web server(30) communicates the data with the client terminals through the network, and the database server(40) collects and integrally manages the data communicated between the web server and the client terminals. The database server includes a code management database, an inventory management database, a warehousing management database, a shipping management database, a return management database, an accounting management database, an order management database, a delivery management database and a small package management database.

Description

ERP system for pharmaceutical business management {Medical ERP System}

1 is a block diagram of an ERP system for managing pharmaceutical work according to an embodiment of the present invention,

Figure 2 is a view showing a data storage structure of the database server of the ERP system for pharmaceutical business management according to an embodiment of the present invention.

<Description of Symbols for Main Parts of Drawings>

10: client terminal,

30: web server,

40: database server,

70: network,

700: database,

701: code management DB,

702: inventory management DB,

703: receipt management DB,

704: delivery management DB,

705: return management DB,

706: accounting database,

707: order management DB,

708: delivery management DB,

709: subdivision management DB.

The present invention relates to an enterprise resource planning (Enterprise Resource Planning) system, and more specifically, to manage drug distribution, and to efficiently manage related processes having a business linkage for the efficient management of a pharmaceutical manufacturing company by integrating and systematically building the above. ERP system for managing pharmaceutical business implemented to improve work process, improve productivity, secure accuracy, optimize business environment and maximize corporate competitiveness by establishing data server to manage the result produced by the process It is about.

Typically, Enterprise Resource Planning (ERP) refers to the integration of multiple modules to help manage key processes, including manufacturing, purchasing, inventory, ordering, trading with suppliers, and providing customer service in various business areas, including manufacturing. This is referred to collectively as an application software package. In other words, as part of the large-scale software that manages the human and material resources of the enterprise, it integrates the processes related to each of the various tasks such as production management, logistics management, and accounting management, and establishes a unified information utilization base. To secure. In particular, the introduction of the ERP system enables a coherent connection between the company's management and the information system, and in order to establish a successful information system, a systematic approach to logically solve problems according to clear principles by dividing the entire system into manageable units. In other words, it is proceeded by the construction methodology. In order to construct such an enterprise information system or an ERP system, an ERP supplier or a consulting company develops and possesses itself. Examples include SAP's Accelerated SAP (ASAP), Oracle's AIM (Application Implementation Methodology), BPCS, BAAN's Orgware, and UniERP's Innovator.

However, the above-mentioned conventional construction methods are mostly derived from the construction methods and tools for the construction of the ERP system of the advanced ERP vendors, and thus may not be suitable for the scale, management environment, and work flow of domestic pharmaceutical distribution companies or pharmaceutical companies. In addition, the procedures and contents are complicated and vast, and therefore, it is unrealistic to apply them to drug distribution companies or drug companies. In addition, construction methods provided by domestic ERP companies include Samsung SDS's Innovator, Korea Management Association's KEIM (KMA ERP Implementation Methodology), and Chemis's Standard Operating Procedure (SOP). It is not a systematic because it is imitated, and this also has a problem that it is not suitable to apply to pharmaceutical distribution companies or pharmaceutical companies.

Accordingly, the present invention has been made to solve the above problems, the object of the present invention is to systematically build a systematic process by integrating related processes having a business connection for the efficient management of pharmaceutical distribution, pharmaceutical manufacturers ERP system is implemented for the management of medicines that is implemented to improve the process of work, improve productivity, secure accuracy, optimize the business environment and maximize the company's competitiveness by establishing a data server for integrated management of the outputs. To provide.

An object of the present invention as described above is a plurality of client terminals for collecting data in a separate application and a corresponding Graphic User Interface (GUI), and temporarily storing the data;

A web server configured as a communication network with the plurality of client terminals, and configured to communicate data with the plurality of client terminals; And

It is achieved by an ERP system for pharmaceutical business management, characterized in that the database server is connected to the network to collect and manage the data communication data between the plurality of client terminals and the web server integrated management.

Here, the database of the database server,

A code management database for storing product management, company management, employee management, and department management data;

An inventory management database for storing inventory inquiry and payment management data;

A receipt management database for storing receipt price management, receipt confirmation, and receipt inquiry data;

A warehouse management database for storing orders, shipping goods confirmation, potion shipping confirmation, shipping inquiry, transaction statement, best care, order order, and payment order data;

A return management database for storing and storing purchased goods, sales returns, and return transaction details;

An accounting database for exclusively storing accounting slips, accounting slip payments, sales ledgers, purchase ledgers, purchase account clearance, sales account clearance, salesperson performance, and salesperson allowance data;

It is divided into order management database, delivery management database, and subdivision management database. It is characterized by quick inquiry and management when the web server requests the data.

Other objects, specific advantages and novel features of the invention will become more apparent from the following detailed description and the preferred embodiments described in conjunction with the accompanying drawings.

Hereinafter will be described in detail with reference to the accompanying drawings a preferred embodiment of the ERP system for pharmaceutical business management according to an embodiment of the present invention.

1 is a configuration diagram of an ERP system for pharmaceutical business management according to an embodiment of the present invention, the present invention is input data such as receipt history, shipment history, order history to the user interface largely due to the application, A plurality of client terminals 10 for temporarily storing data and a plurality of client terminals 10 and a communication network 70 are constructed to establish a network, and are connected to the network and the web server 30 for data communication. It consists of a database server 40 for collecting and managing data communication data made between the client terminal 10 and the web server 30.

The plurality of client terminals 10 are equipped with an application and a corresponding user interface that are designed for a corresponding process such as goods management, goods issue management, inventory management, accounting management, and the like, and such a terminal may be a personal PC or the Internet. It may be a PDA.

Looking at the application and the corresponding user interface of the goods receipt management process among the various processes as an example, first, the goods receipt management is also carried out in a place equipped with a logistics facility, so that the goods receipt management can be performed at the same time. You can implement an application and user interface that integrates. Therefore, a table and a field for temporarily storing the data are provided to input data such as the quantity of goods received by each kind, the quantity of goods issued by each kind, and the transaction specification. When the data are temporarily stored in the field, the application calculates the data or transmits the data to the outside.

The web server 30 is connected to the plurality of client terminals 10 and the communication network 70 to form a network. Therefore, it is possible to exchange data with the plurality of client terminals 10, and services that provide independently, that is, posts, product introduction, drug introduction and drug search. In addition, the communication network 70 used for network construction may include an intranet, an internet line, or an internet line and an intranet established in the enterprise.

When the data collected through the plurality of client terminals 10 are classified in the web server 30, the database server 40 forms and stores a space for storing each data. That is, for example, when the client terminal 10 inputs a newly received medicine list and transmits it to the web server 30, a corresponding storage space (formation management) previously formed of the newly received medicine list data from the web server 30. Database, inventory management database).

 2 is a diagram illustrating a data storage structure of a database server 40 of an ERP system for managing medicines according to an embodiment of the present invention, wherein the database 700 of the database server 40 includes a code management database ( 701, inventory management database 702, goods management database 703, goods issue management database 704, return management database 705, accounting management database 706, order management database 707, delivery management database 708 ) And subdivision management database 709.

The code management database 701 is dedicated to storing data such as product management, company management, employee management, department management, and the inventory management database 702 is dedicated to storing data such as inventory inquiry, payment management, and the receipt management database. (703) is dedicated to storing data such as receipt price management, receipt confirmation, and receipt inquiry. In addition, the warehouse management database 704 stores and stores data such as ordering, goods checking, potion checking, shipping inquiry, transaction specification, best care, order order, and payout, where the goods management database 704 and goods receipt management are stored. Although the database 703 may be integrated and managed, a separate storage space may be provided so as to facilitate a quick search and resolution of a problem in case of a problem with the receipt or release data, which is one storage space. This is due to the fact that large amounts of data are stored in the search engine, which slows down the search and hinders rapid problem solving. On the other hand, the return management database 705 is dedicated to storing data such as purchase goods, sales returns, return transaction details, etc., the accounting management database 706 is the payment of the payment slip, payment of the payment slip, sales ledger, purchase ledger, purchase Clearly store data such as account bookkeeping, sales account bookkeeping, salesperson performance and salesperson allowance.

Hereinafter, the ERP system for managing pharmaceutical business according to an embodiment of the present invention will be described by applying to the entry / exit management process of a distribution company.

As described above, the receipt and release management manages the receipt price management, the receipt confirmation, the receipt inquiry, the order confirmation, the goods release confirmation, the goods receipt confirmation, the shipment inquiry, the transaction statement, the best care, the order for the payment, the deferred shipment, and the like. In order to check the product, it is necessary to go through the product verification step. To confirm the product, the product is checked by searching the barcode terminal that recognizes the barcode attached to one side of the product, and additionally enters the company information and quantity. In addition, by taking a sample of the product to determine whether or not wearing is determined. If the product is defective, process the return but note the return quantity and manufacturer information. On the other hand, in the case of normal products, check the distribution path of the product, and in the case of borrowing, receive and process the goods immediately.

In addition, check the product classification for products entering the normal distribution channel, if not a generic drug, input the product serial number, expiration date, barcode, and enter the warehouse storage location to receive and process the barcode. Enter the warehouse storage location without entering the item and process the goods receipt.

In the case of borrowing, the transaction specification table is entered only when the goods are normally received. And the product to be shipped through the product identification step as described above additionally input the customer information, quantity, serial number and the expiration date, and prepare a transaction specification table for the shipped product. Ships to Over-the-counter Drug / Ethical Drug (OTC / ETC). In case of normal (pharmacy closing business), OTC / ETC checks whether or not the returned product is normal. If it is normal (pharmacy closing business, etc.), return it to the normal warehouse, and if abnormal (damage, etc.), return warehouse for the return warehouse. Products that have been returned to the warehouse should be returned to the manufacturer.

The present invention is the use of the ERP system for pharmaceutical business management as described above, the drug distribution management, the related processes having the linkage of work for the efficient management of the pharmaceutical manufacturing company integrated and systematically established, and the process By establishing a data server to manage the results produced by the company's performance in an integrated manner, it has the effect of improving work processes, improving productivity, securing accuracy, optimizing the management environment and maximizing corporate competitiveness.

Although the invention has been described in connection with the preferred embodiments mentioned above, it will be readily apparent to those skilled in the art that various other modifications and variations can be made without departing from the spirit and scope of the invention. It is obvious that all modifications fall within the scope of the appended claims.

Claims (2)

A plurality of client terminals (10) for collecting data in individual applications and corresponding graphical user interfaces (GUIs), and temporarily storing the data; A web server 30 configured as a communication network with the plurality of client terminals 10 and a web server 30 for data communication with the plurality of client terminals 10; And ERP system for pharmaceutical business management is characterized in that it is connected to the network consisting of a database server 40 for collecting and managing data communication data made between a plurality of client terminals (10) and the web server (30). The method of claim 1, wherein the database 700 of the database server 40, A code management database 701 for storing product management, company management, employee management, and department management data; An inventory management database 702 dedicated to storing inventory inquiry and payment management data; A receipt management database 703 for storing receipt price management, receipt confirmation, and receipt inquiry data; An issue management database 704 that stores and stores orders, issues of shipments, confirmations of potions, issues of shipments, transaction details, best care, orders, and payments of goods; A return management database 705 for storing and storing the purchased goods, sales returns, and return transaction details; An accounting management database 706 dedicated to storing accounting slips, accounting slip payments, sales ledgers, purchase ledgers, purchase account clearance, sales account clearance, salesperson performance, and salesperson allowance data; It is divided into order management database 707, delivery management database 708 and subdivision management database 709, so that when the web server 30 requests the corresponding data, it is possible to quickly search and manage the pharmaceutical business management. For ERP system.

Images