CN111738658A - A kind of pharmaceutical material management method - Google Patents

Abstract

The invention relates to a drug manufacturing management method, which takes a unique material code in basic data of drug materials as a first code of the drug materials, takes a unique manufacturer dimensional code in the basic data of a supplier as a second code of the drug materials, and makes the first code and the second code jointly form the unique code of the drug materials, and simultaneously associates the unique code of the drug materials with a pharmaceutical formula and a pharmaceutical prescription; and then, carrying out production batching according to the medicine prescription and the production plan, matching inventory data according to the medicine prescription and generating a material-taking order according to a first-in first-out principle. Therefore, the behavior of wrong material taking can be effectively avoided, the production management risk is reduced to the maximum extent, the medicine quality is ensured, the minimization of the number of pharmaceutical formulations and the maximization of the flexibility are achieved, the continuous production requirement is met, the difficulty of inventory planning management is reduced, the supplier resources are increased, and the foundation is laid for cost reduction and quality improvement of enterprises and flexible production.

Description

A kind of pharmaceutical material management method

technical field

The invention belongs to the technical field of the pharmaceutical industry, in particular to a pharmaceutical material management method.

Background technique

At present, manufacturing enterprises basically introduce ERP systems for production management, which is of great significance to enterprise operation management and product quality assurance. For pharmaceutical companies in the manufacturing industry, one item, one code should be strictly followed; the material coding of pharmaceutical companies is managed by one item and one code, and the key information of materials is roughly the same, including: material description, specification, model, manufacturer, etc. . However, the applicant found that: from the perspective of pharmaceutical technology, the materials produced by different manufacturers of the same material may have certain differences due to the similarities and differences in the manufacturers' processes. Confirm the scope of use of the material; after the introduction of the ERP system for production management, it is necessary to complete the collection of key production basic data in advance, including material information, prescription information (including formula, process, process route), etc., and based on the management of one item and one code It is required that different manufacturers should code different materials, and the same product may be used for the same material and codes of different manufacturers, which will lead to an increase in the number of recipes for the same product and increase the difficulty of management. If it is not properly managed, there may be the risk of throwing the wrong material and the whole batch of products will be scrapped.

SUMMARY OF THE INVENTION

In order to solve the above-mentioned problems in the prior art, the present invention provides a pharmaceutical material management method which effectively avoids the wrong picking behavior and reduces the production management risk to the greatest extent.

In order to solve the above-mentioned technical problems, the present invention adopts the following technical solutions:

A pharmaceutical material management method, which uses the unique material code in the basic data of the pharmaceutical material as the first code of the pharmaceutical material, and uses the unique manufacturer dimensional code in the supplier's basic data as the first code of the pharmaceutical material. Second code, and the first code and the second code together constitute the unique code of the drug material, and the unique code of the drug material is associated with the pharmaceutical formula and the drug prescription; then produce ingredients according to the drug prescription and production plan, and match according to the pharmaceutical formula Inventory data and generate picking orders on a first-in, first-out basis.

Further, the pharmaceutical material management method specifically includes the following steps:

a1. Define the first code of the drug material - take the unique material code in the basic data of the drug material as the first code of the drug material;

a2. Define the second code of the drug material - use the unique manufacturer's dimensional code in the supplier's basic data as the second code of the drug material;

a3. Define the unique code of the drug material - combine the first code and the second code to form the unique code of the drug material, and establish a mapping relationship table between the material code of the drug material and the manufacturer's code;

a4. Maintain pharmaceutical formula information - establish a mapping relationship table between associated drug materials and manufacturer codes in the pharmaceutical formula, and associate the pharmaceutical formula with the drug prescription;

a5. Generate a production plan - generate a production plan based on prescription information, drug inventory, in-production work orders and sales plans;

a6. Create a production work order - create a production work order according to the production plan and prescription information, issue the work order, and start producing ingredients;

a7. Generate picking orders - match inventory data according to the pharmaceutical formula and manufacturer relationship, and generate picking orders according to the FIFO principle.

Further, the "establishing a mapping relationship table of associated drug materials and manufacturer codes in the pharmaceutical formula, and associating the pharmaceutical formula with the drug prescription" is specifically: first, establish a production basic data formula in the formula of the production module of the system. , the data of the production basic data formula is the combination relationship between the production output and the drug material. In principle, one output and outlet establishes an effective formula; then the formula is associated with the drug prescription, and the prescription combines the drug formula, process, process route and The relationships of prescriptions are matched one by one, and in principle, there is only one effective prescription for a product; wherein, the data of the basic production data formula mainly includes formula code, output code, output product description, unique material code, material description , Unique manufacturer code.

Further, the "establishing the mapping relationship table between the material code of the drug material and the manufacturer code" is specifically: adding a data mapping table to the basic data module of the system, and establishing the relationship between the material basic data and the manufacturer in this form. , the mapping relationship is one-to-many, that is, one material code can correspond to multiple manufacturer codes.

Further, before defining the first code of the drug material, the master data of the drug material and the material code base data of the production drug material are maintained according to the attributes and characteristics of the drug material.

Further, before defining the second code of the drug material, the basic data of the manufacturer and the manufacturer code are maintained according to the manufacturer's qualification information.

The present invention mainly has the following beneficial effects:

Through the above technical solutions, the present invention can effectively avoid the wrong picking behavior, minimize the production management risk, ensure the quality of medicines, and at the same time achieve the minimization of the number of pharmaceutical formulations, the maximization of flexibility, the satisfaction of continuous production requirements, and the reduction of inventory plans. Management difficulty, increase supplier resources, and lay the foundation for enterprises to reduce costs and improve quality and flexible production.

Description of drawings

FIG. 1 is a schematic flowchart of a pharmaceutical material management method according to Embodiment 1 of the present invention.

Detailed ways

In order to make the objectives, technical solutions and advantages of the present invention clearer, the present invention will be further described in detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present invention, but not to limit the present invention.

In the pharmaceutical material management method of the present invention, the unique material code in the basic data of the pharmaceutical material is used as the first code of the pharmaceutical material, and the unique manufacturer dimensional code in the supplier's basic data is used as the first code of the pharmaceutical material. As the second code of the drug material, the first code and the second code together constitute the unique code of the drug material, and the unique code of the drug material is associated with the pharmaceutical formula and the drug prescription; then produce ingredients according to the drug prescription and production plan , match the inventory data according to the pharmaceutical formula and generate picking orders according to the first-in, first-out principle.

As shown in Figure 1: the pharmaceutical material management method described in the embodiment of the present invention specifically includes the following steps:

S100. Define the first code of the drug material—use the unique material code in the basic data of the drug material as the first code of the drug material.

S200. Define the second code of the drug material—use the unique manufacturer dimensional code in the supplier's basic data as the second code of the drug material.

S300. Define the unique code of the drug material - combine the first code and the second code to form the unique code of the drug material (for example: directly combine the first code and the second code to form the unique code of the drug material), and establish the drug material The mapping relationship table between the material code of the drug material and the manufacturer's code; the "establishing the mapping relationship table between the material code of the drug material and the manufacturer's code" is specifically: adding a data mapping table to the basic data module of the system, the material basic data The relationship with the manufacturer is established in this form, and the mapping relationship is one-to-many, that is, one material code can correspond to multiple manufacturer codes, and one material code has multiple sets of mapping relationships. In the following, for some types of data relationships, the association relationship group between the material code and the manufacturer is called.

S400. Maintain pharmaceutical formula information - establish a mapping relationship table between associated drug materials and manufacturer codes in the pharmaceutical formula, and associate the pharmaceutical formula with the drug formula; specifically: the formula in the production module of the system (eg: ERP system) The production basic data formula is established in the formula. The data of the production basic data formula is the combination relationship between the production output and the drug material. In principle, one output and export establishes an effective formula; the data of the production basic data formula mainly includes the formula code and the output code. , output product description, unique material code (first code), material description, unique manufacturer dimensional code (second code); among them, a unique material code can correspond to multiple unique Manufacturer code, although there is only one material code in a pharmaceutical formula, there are multiple groups associated with the manufacturer of the material code. For example, a drug material A has 3 manufacturers. In actual production management, the drug material and the manufacturer will meet each other. There are multiple mapping situations (Material A of manufacturers 1 and 2 can be used for Drug 1, Drug Material A of manufacturers 2 and 3 can be used for Drug 2, and Drug Material A of manufacturers 1 and 3 can be used For drug 3, drug material A of manufacturers No. 1 to 3 can be used for drug four, etc.), the mapping relationship between drug materials and manufacturers is flexibly used in the management of pharmaceutical formulas, which improves the flexibility of pharmaceutical formulas. When the material code corresponds to the manufacturer code, the relationship group between the material code and the manufacturer may not be completely maintained in the formula, and only the material manufacturer whose formula has been verified is maintained in order to achieve a true sense of unity. One-code management of the product, and then associate the formula with the drug prescription. The prescription matches the relationship between the drug formula, process, process route and prescription one by one, and in principle, there is only one effective prescription for a product.

S500. Generate production plan - generate production plan according to prescription information, drug inventory, work order in production and sales plan; specifically: input sales forecast data in the planning module of the system (such as: ERP system), and then the system will pass the fixed The operation logic completes the calculation of the production plan (the operation logic belongs to the prior art, such as the planning operation logic of the existing ERP system, which will not be described in detail here.), the production schedule.

S600. Create a production work order - create a production work order according to the production plan and prescription information, issue the work order, and start the production of ingredients. The creation of a production work order can be performed by the operator according to the production plan and prescription information in the system (such as: ERP system) to manually create production work orders.

S700. Generating a picking order - matching inventory data according to the drug prescription, pharmaceutical formula and manufacturer relationship in the production work order, and generating a picking order according to the first-in, first-out principle; specifically: according to the production order, carry out production picking, picking In the function, the picking data is controlled by the preset formula data, and the available materials are screened for the corresponding manufacturer batches of the available materials to ensure the correctness of material picking, and the first-in-first-out principle is added to the system ( The principle of first-out with the nearest expiration date and batch number first out) assists the workshop picking, that is, firstly, according to the production order, the pre-set drug prescription, the drug formula data and the drug materials that can be collected, the corresponding materials that can be collected are screened out. The manufacturer batches to ensure the correctness of material picking, and at the same time, the first-in, first-out principle (that is, the principle of first-out near the expiration date and batch number first-out) is added to the system (such as: ERP system) to assist workshop picking.

In this way, by using the pharmaceutical material management method of the present invention, it is possible to effectively avoid the behavior of wrong picking, reduce production management risks to the greatest extent, ensure the quality of medicines, and at the same time achieve the minimization of the number of pharmaceutical formulations, the maximization of flexibility, and the satisfaction of continuous production requirements. As well as reducing the difficulty of inventory planning management, increasing supplier resources, and laying the foundation for enterprises to reduce costs and improve quality and flexible production.

In addition, before defining the first code of the drug material, maintain the master data of the drug material and the material code basic data of the production drug material according to the attributes and characteristics of the drug material, specifically: creating the material basic data in the system basic data module , the creation principle is a unique material code + material description + material basic attributes (including: unit, rules, etc.); at the same time, before defining the second code of the drug material, according to the manufacturer's qualification information, the manufacturer's basic data and The manufacturer code is maintained, specifically: create the manufacturer's basic data in the supplier's basic data, and the creation principle is to create the manufacturer's basic data with a unique supplier code + supplier name + supplier basic attributes (including: business license, etc. ). In this way, the accuracy of the unique code of the drug material can be improved, and the risk of production management can be further reduced.

The above are the preferred embodiments of the present invention. It should be pointed out that for those skilled in the art, without departing from the principles of the present invention, several improvements and modifications can be made, and these improvements and modifications may also be regarded as It is the protection scope of the present invention.

Claims (6)

1. The medicine preparation management method is characterized in that a material code with uniqueness in basic data of medicine materials is used as a first code of the medicine materials, a manufacturer dimensional code with uniqueness in basic data of a supplier is used as a second code of the medicine materials, the first code and the second code jointly form the unique code of the medicine materials, and the unique code of the medicine materials is related to a pharmaceutical formula and a pharmaceutical prescription; and then, carrying out production batching according to the medicine prescription and the production plan, matching inventory data according to the medicine prescription and generating a material-taking order according to a first-in first-out principle.

2. The pharmaceutical material management method of claim 1, comprising the steps of:

a1. defining a first code of the medicine material, namely using a material code with uniqueness in the basic data of the medicine material as the first code of the medicine material;

a2. defining a second code of the drug material, namely using a unique manufacturer dimension code in the basic data of a supplier as the second code of the drug material;

a3. defining a unique code of the medicine material, namely forming the unique code of the medicine material by the first code and the second code together, and establishing a mapping relation table of the material code of the medicine material and the code of a manufacturer;

a4. maintaining pharmaceutical formulation information, namely establishing a mapping relation table between the relevant pharmaceutical materials and manufacturer codes in the pharmaceutical formulation, and relating the pharmaceutical formulation to a pharmaceutical formulation;

a5. generating a production plan, namely generating the production plan according to the prescription information, the drug inventory, the in-process work order and the sales plan;

a6. creating a production work order, namely creating the production work order according to the production plan and the prescription information, issuing the work order and starting to produce and prepare materials;

a7. and (4) generating a material getting order, namely matching stock data according to the pharmaceutical formula and the relation of manufacturers, and generating the material getting order according to a first-in first-out principle.

3. The method for managing pharmaceutical material according to claim 2, wherein said step of establishing a mapping table between the pharmaceutical material and the manufacturer code in the pharmaceutical formulation and associating the pharmaceutical formulation to the pharmaceutical formulation comprises: firstly, establishing a production basic data formula in a formula of a production module of a system, wherein the data of the production basic data formula is the combination relation between a production outlet and a medicine material, and an effective formula is established by one production outlet in principle; then, the formula is associated into a medicine prescription, the working procedures, the flow process routes and the prescription are matched one by one according to the prescription, and in principle, only one effective prescription exists for one product; the data of the production basic data formula mainly comprise a formula code, a production port code, a product description, a unique material code, a material description and a unique manufacturer code.

4. The method for managing pharmaceutical material according to claim 2, wherein said step of establishing a mapping table between material codes of pharmaceutical materials and manufacturer codes comprises: a data mapping table is added in a basic data module of the system, and the association relationship between the material basic data and the manufacturers is established in the table, wherein the mapping relationship is one-to-many, namely, one material code can correspond to a plurality of manufacturer codes.

5. The pharmaceutical material management method of claim 2, 3 or 4, wherein the material code of the pharmaceutical material is maintained according to the properties and characteristics of the pharmaceutical material before the first code of the pharmaceutical material is defined.

6. The method of claim 5, wherein the manufacturer's basic data is maintained based on manufacturer qualification information prior to defining the second code for the pharmaceutical material.

Images