Project

General

Profile

Actions

Bug #691

open
MN DS

Drug master: add number of tablets per pack, MRP and supplier price

Bug #691: Drug master: add number of tablets per pack, MRP and supplier price

Added by Medha N. 13 days ago. Updated 9 days ago.

Status:
Resolved
Priority:
Normal
Assignee:
Target version:
-
Start date:
10/30/2026
Due date:
% Done:

0%

Estimated time:
Resolved By:

Description

The Edit Drug form in Admin > Drug Master already captures MRP (confirmed: TAB.STAMINA-OD shows MRP ₹170), but has no field for pack size (how many tablets/units come in a strip or pack) and no field for supplier price (the purchase/cost price the hospital pays, distinct from the patient-facing MRP). Both are commonly needed for pharmacy stock and costing but aren’t captured anywhere in the drug’s master record today.

Impact
Without pack size, pharmacy staff and any stock/ordering logic have no authoritative source for how many units are in a strip or pack — needed for ordering in whole packs, converting pack-level purchase quantities into individual-unit stock, and dispensing calculations.

Without a supplier/purchase price distinct from MRP, there’s no way to track margin, compare supplier costs, or calculate the true cost basis of inventory — MRP alone only reflects the patient-facing retail price, not what the hospital actually pays. Together these gaps limit the stock and procurement accuracy that would normally live in the drug master record itself, pushing that tracking into spreadsheets or manual notes instead.

Environment
Tenant: Vetri Vivega Medical Center. Module: Admin > Drug Master > Edit Drug. Example: TAB.STAMINA-OD (DRG-354), Form Tablet, Strength 1, Schedule OTC, MRP ₹170, HSN Code blank, GST % Not set, Category Vitamin/Supplement.

Steps to Reproduce

Go to Admin > Drug Master, open any drug’s Edit Drug panel (e.g. TAB.STAMINA-OD).
Review the fields present: Drug name, Code, Generic name, Manufacturer, Form, Strength, Schedule, MRP, HSN Code, GST %, Category.
Note MRP is already captured (₹170 in this example).
Note there is no field anywhere on this form for pack size / units per strip (e.g. “10 tablets per strip”), and no field for supplier/purchase price (the cost price the hospital pays, as distinct from MRP).

Expected vs Actual
Expected: Drug Master should also capture pack size (number of tablets/units per strip or pack) and supplier price (purchase/cost price from the supplier), alongside the MRP it already has.

Actual: MRP is present; pack size and supplier price are not captured anywhere on this form.

Notes
MRP is flagged here as already implemented so it isn’t miscounted as part of the gap — the two genuine additions needed are pack size and supplier price.


Files

RH Updated by Roshni Harish. 11 days ago Actions #1

Screenshot 2026-11-02 at 12.21.21 PM.png

RH Updated by Roshni Harish. 11 days ago Actions #2

  • Assignee changed from Jessin J to Dilbar S.

DS Updated by Dilbar S. 10 days ago Actions #3

  • Status changed from New to Resolved
  • Assignee changed from Dilbar S. to Roshni Harish.
  • Resolved By set to Dilbar S.

RH Updated by Roshni Harish. 10 days ago Actions #4

  • Assignee changed from Roshni Harish. to Dilbar S.

RH Updated by Roshni Harish. 9 days ago Actions #5

Screenshot 2026-11-04 at 10.20.23 AM.png
Screenshot 2026-11-04 at 10.32.59 AM.png

Current Behavior / Steps to Reproduce

Tenant: San Jose St. Bonaventure. Drug: Dolo 123 (code DRG-712), configured in Admin > Drug Master with Units per pack = 10.

In Admin > Drug Master, edit Dolo 123 — Units per pack is set to 10, Supplier price (per pack) and MRP are present as separate optional fields. A helper note under these fields already shows “MRP works out to ₹0.00 per unit” (computed live from MRP ÷ Units per pack), confirming the system already has this calculation available at the drug-master level.
Go to Purchasing > receive goods against a PO that includes this drug (e.g. PO-20261104-FFA2A7, MedPlus Pharma Distributors, Dolo 123 × 50 ordered).
In the Receive Goods modal for this line, enter a value into “MRP (₹ PER PACK)” (described as “printed on the pack”).
“UNIT PRICE (₹ PER UNIT)” (described as “what the patient pays”, and marked required) stays blank — it does not get filled in or calculated from the MRP just entered and the drug’s known Units per pack.
Expected Result

As soon as a value is entered into “MRP (₹ PER PACK)” on the Receive Goods screen, “UNIT PRICE (₹ PER UNIT)” should auto-fill as MRP ÷ the drug’s Units per pack (looked up from Admin > Drug Master — 10, for Dolo 123). The auto-filled value should remain editable, since staff may occasionally need to override it (for example, a promotional price or a rounding adjustment), not be locked or read-only.

Actual Result

Unit Price stays blank regardless of what’s entered into MRP. Staff must calculate MRP ÷ Units per pack themselves and type it into Unit Price manually, every single time goods are received against a PO, even though both numbers needed for that calculation are already in the system.

Actions

Also available in: PDF Atom