Pharmaceutical History - hmislk/hmis GitHub Wiki
The History view shows movements and balances for a single selected pharmaceutical item. The item name appears at the top.
Set the From Date and To Date to define the period. Click View Detail to refresh all sub-tabs. The same date range applies across every sub-tab.
Figures reflect transactions posted within the selected period. All quantities use the item’s base unit unless specified.
Navigation tabs segment the same item and date range by transaction type. Switching tabs does not change the item or dates.
The logged department transactions are listed by default. It can be configured to show all department transaction from configuration options.
The history is available ONLY for AMPs and AMPPs. It is NOT available for VMPs and VMPPs.
Stock Tab
Shows the current stock of the selected item, expressed in base units.
Department Level Stocks lists one row per holding department. Columns: Department Name, Institution Name, Site Name, Stock Quantity.
Institution Level Stocks aggregates by institution. Columns: Institution Name, Total Stock Quantity.
Site Level Stocks aggregates by site. Columns: Site Name, Total Stock Quantity.
The Total Stock banner displays the grand total across all departments.
Sale Tab
Shows quantities sold and returned for the selected item, in base units, grouped by Bill Type. The Quantity column displays the signed total per bill type within the date range: sales appear as negative numbers (stock out), returns as positive numbers (stock in). The Total row is the net movement across all sale-related bills. Typical bill types include Pharmacy Retail Sale, Pre-Bill to Settle at Cashier, Retail Sale Return (Items Only), and Retail Sale Return (Items and Payments).
BHT Issue Tab
Shows issues to inpatients for the selected item within the period.
Columns: Department Name. Qty (units, issued as negative). Value (issue value for the quantity).
Grouping: Rows are listed by department under the institution. Total sums the department. Total Institution shows the institution-wide sum.
Interpretation: Negative Qty indicates stock issued to inpatients. Values express the monetary amount for those issues.
Transfer Issue Tab
Shows inter-department stock issued out, in base units.
Columns: Transferred out department and Quantity. Quantities are negative to indicate stock leaving the source department. Total is the net quantity transferred out within the date range.
Transfer Receive Tab
Shows inter-department stock received, in base units.
Columns: Sent from and Quantity. Quantities are positive to indicate stock received into the current department. Total is the net quantity received within the date range.
Consumption Tab
Shows non-sale internal consumption of the item, in base units.
Columns: Consumed department and Quantity. Quantities are positive and represent stock used/consumed by the listed department. Total is the sum of consumption within the date range.
GRN Tab
Lists posted Goods Received Notes for the selected item.
Columns: GRN No, Department, Date, PO No, Supplier, Item, Qty, Free Qty, Unit Purchase Rate, Unit Cost Rate, Sale Rate, Value at Cost Rate.
Item shows the purchased catalogue entry: AMPP entries are in packs; AMP entries are in units. Qty is recorded in the purchased unit (packs for AMPP, units for AMP). Free Qty records free-of-charge quantities. Unit Purchase Rate is the price per purchased unit. Unit Cost Rate is the cost per base unit after pack conversion. Value at Cost Rate equals total base-unit quantity × Unit Cost Rate.
Pending GRN Tab
Displays Goods Received Notes (GRNs) that have been entered and saved by the pharmacist but not yet approved by the authorised officer.
Columns: PO Number, Department, GRN Date, Supplier, Item, Qty, Free Qty, Status.
Items may appear as AMP (units) or AMPP (packs). Qty and Free Qty show the quantities entered. Status indicates the current workflow stage (Saved = pending finalization, Finalized = pending approval).
Pending POs
There are the finalised Purchase Orders (PO), usually by a pharmacist, to be approved by the accounting team. All quantities are listed in Units, not packs.
POs
These are approved Purchase orders. The quantities of items are listed as requested. In units of in packs. THe ordered qty, received qty, and remaining quantities are given in columns.
GRNs
There are approved GRNs with PO and Return details