Module 10, Pharmacy & Inventory

Pharmacy &
Meds Control

The Pharmacy module manages the hospital's entire medication supply chain—from purchasing medicines from suppliers, to storing them in inventory, to dispensing them to patients based on doctor prescriptions.

What is Pharmacy Management?

Pharmacy Management covers two main areas: Inventory control(purchasing medicines, tracking stock levels, managing batches and expiry dates, conducting audits) and Dispensing (receiving prescriptions from doctors, verifying them, preparing the medicines, and handing them to patients with proper instructions). Formulary masters and alerts are clinical Branch / Working-in scoped; dual-gate view geography before lists load.

The system also manages Purchase Orders to suppliers,low-stock alerts that trigger reordering, batch trackingfor recalls, expiry management to prevent dispensing expired medication, and inventory valuation for financial reporting.

Why Does It Exist?

Medication management is critical for patient safety and hospital finances:

  • → Expired meds — Dispensing expired medication can harm patients and lead to legal liability
  • → Stockouts — Running out of critical medicines (e.g., antibiotics, insulin) is dangerous
  • → Wastage — Over-ordering leads to expired stock and financial loss
  • → Dispensing errors — Wrong medication or wrong dose can be life-threatening
Step by Step

How Pharmacy Works

1

Stock Arrival

Medicines arrive from a supplier against a Purchase Order (PO). The pharmacy team verifies the delivery: correct items, correct quantities, correct batch numbers, and valid expiry dates. Stock is added to the inventory.

Behind the scenes: Each batch is recorded with manufacturer, supplier, batch number, manufacturing date, expiry date, and purchase price for valuation.
2

Prescription Received

A doctor's prescription arrives digitally from OPD or IPD. The pharmacist reviews it: right patient, right medicine, right dose, right route, right frequency. If there's a concern (e.g., allergy, interaction), they can contact the doctor.

Behind the scenes: Prescriptions from doctors appear instantly in the pharmacy queue. The system can flag potential drug interactions based on the patient's active medication list.
3

Dispensing

The pharmacist prepares the medication, labels it with patient name, medicine name, dosage, and instructions. The system deducts the dispensed quantity from inventory. For ward stock, medicines are dispensed in bulk to the ward.

Behind the scenes: Dispensing follows FIFO (First-In, First-Out) logic to ensure older batches are used before newer ones, reducing expiry wastage.
4

Audit & Reorder

Stock levels are continuously monitored. When a medicine drops below its reorder level, the system generates a low-stock alert and can automatically suggest a new Purchase Order. Regular cycle counts verify physical stock matches system records.

Behind the scenes: Inventory valuation reports calculate the total value of stock on hand for financial reporting and audit purposes.
Deep Dive

Every Feature Explained

Medicine Formulary

What it is

A master list of all medicines used in the hospital.

Why it exists

Standardizes medication names, strengths, and forms. Prevents confusion.

How it works

Each medicine has a generic name, brand name, strength, form (tablet, injection, syrup), and category. Only formulary items can be prescribed or ordered.

Batch & Expiry Tracking

What it is

Every stock receipt records batch number, mfg date, and expiry date.

Why it exists

Enables recall of specific batches, ensures expired meds aren't dispensed.

How it works

Items within 45 days of expiry appear on 'Near Expiry' reports. At 7 days, they are locked from dispensing. Expired items are quarantined.

Purchase Order Management

What it is

Create, approve, receive, and track purchase orders to suppliers.

Why it exists

Controls spending, ensures proper authorization, and tracks deliveries.

How it works

POs are created for items below reorder level. They go through approval workflow. Receiving updates inventory and records actual cost.

Low-Stock Alerts

What it is

Automatic notifications when stock falls below configured minimums.

Why it exists

Prevents stockouts of critical medicines.

How it works

Each medicine has a reorder level. When stock drops below it, the system alerts the pharmacy team and can auto-generate a PO suggestion.

Dispensing & Prescription Fulfillment

What it is

Process prescriptions and dispense medicines to patients or wards.

Why it exists

Ensures patients receive the right medication with proper instructions.

How it works

Pharmacist reviews the prescription, prepares the medication, labels it, and records the dispensing. Inventory is deducted automatically.

Inventory Valuation

What it is

Calculate the total financial value of stock on hand.

Why it exists

Required for financial reporting, audits, and insurance purposes.

How it works

Reports calculate value based on weighted average cost or FIFO cost of all items in stock. Can be exported to PDF or Excel.

Pharmacy
Architecture

Inventory is managed through a FIFO logic engine. Batches near expiry are quarantined automatically. Dispensing checks against the patient's allergy profile.

Technical Architecture

FieldTypeInstitutional Role
batch_numberVarchar(32)Unique supplier batch identifier for traceability.
stock_quantityDecimal(12,2)Real-time remaining stock unit count.
expiry_dateDateHard-coded threshold; dispensing is locked after this date.
reorder_levelIntMinimum stock threshold that triggers automated PO generation.

Note: Sensitive fields use AES-256 field-level encryption where applicable.

Governance & Power

pharmacy:dispense
pharmacy:po-receive
pharmacy:view
pharmacy:alerts
  • Expiry Guard

    Items within 45 days of expiry appear in 'Near Expiry' reports. Within 7 days, they are locked from any dispensing.

  • Closed-Loop Sync

    A prescription filled in OPD or IPD instantly deducts stock from the specific ward-pharmacy pod assigned to the patient.

  • L-Audit Protocol

    Randomized cycle-counting tasks are assigned to pharmacy staff with mandatory digital verification of physical counts.

Stock discrepancy rate < 0.01% via digital auditing.