Supply Chain Reports - hmislk/hmis GitHub Wiki

Supply Chain Reports

Overview

Both the Pharmacy and Stores modules provide procurement and supply chain reports. This article lists the key reports available across both modules.

Pharmacy Procurement Reports

Navigation: Pharmacy → Reports → Procurement Reports

Procurement Report

A consolidated view of all pharmacy procurement activity for a selected period.

  • Filter by supplier, department, or item
  • Shows PO value, GRN value, and outstanding amounts

Purchase Item List

Lists all items procured within a date range with quantities and costs.

Useful for:

  • Cost analysis by item
  • Supplier spend analysis
  • Budget vs. actual comparisons

GRN Detail by Supplier

Shows each GRN grouped by supplier with line-item detail.

GRN Payment Detail

Reconciles GRNs against payments — identifies unpaid or partially paid GRNs.

Purchase Order Detail

Lists all POs with line items, quantities, and current status.

Store Procurement Reports

Navigation: Stores → Reports

Store GRN Report

Lists all store GRNs with receipt details.

Store Purchase Order Report

Lists store POs with status and line items.

Dealer Payment Report

Shows payments made to store suppliers.

Cross-Module Reports

Stock Valuation Report

Available in both modules — shows the current value of stock on hand using purchase cost rates.

Bin Card Report

A ledger-style report showing all in/out movements for a specific item, including the running balance.

Available in both Pharmacy and Stores.

Under Development

  • Automated three-way reconciliation (PO / GRN / Invoice) — currently requires manual comparison; automated matching is planned
  • Tender and RFQ reports — not yet implemented
  • Vendor performance reports — supplier delivery accuracy and quality metrics are planned

Related Articles