NSS suggestions

Module: Pharmacy → Inventory / Purchase → Stock inward (GRN)
Environment: NSSH
Type: Enhancement + Spike
Priority: P1 for Direct GRN, P3 for the app integration spike

Background
NSSH orders medicines through B2B ordering apps (Medvol, BB-MedsCart), not through Clinq purchase orders. When the medicines arrive, they need to be added to pharmacy stock. Today stock inward probably depends on a PO in Clinq, so app orders can’t be added to stock, or staff have to create a dummy PO first.

Part 1: Direct GRN (stock inward without PO), must-have

Expected behaviour

Pharmacy → Stock Inward → New (without PO).
Select the supplier or source: Medvol, BB-MedsCart, or another distributor in the supplier master.
Enter the supplier invoice / order number, invoice date and app order ID.
Add line items: medicine (from the drug master), batch number, expiry, quantity, free quantity, MRP, purchase rate, GST %, discount.
Save, and the stock is added to pharmacy inventory immediately, batch-wise.

Acceptance criteria

A GRN can be created with no PO linked.
Batch, expiry, MRP, purchase rate and GST are required for each line.
Stock and batch availability update right after saving.
A duplicate supplier invoice number from the same supplier is flagged.
The source is recorded on the GRN (Medvol, BB-MedsCart or other) for reports.
A medicine that isn’t in the drug master can be quick-added or mapped, with pharmacist approval.
The GRN shows in the purchase register and supplier ledger, and is included in the GST input report.
The audit trail records who added the stock and when.

Part 2: Spike, integration with Medvol and BB-MedsCart

Findings so far

Neither app has a public developer API that I could find. Both look like closed, app-only ordering platforms.
So automatic integration needs the vendors’ cooperation.

What to explore

Ask both vendors whether they offer:
An order or invoice API, or a webhook when an order is delivered.
An invoice export (CSV, Excel or e-invoice JSON) with batch, expiry, MRP, rate and GST per line.
Invoice import, the realistic option: upload the supplier’s invoice file in Direct GRN, auto-fill the line items, and have the pharmacist review, map medicines and confirm.
PDF invoice OCR (optional): extract the lines from the PDF invoice with AI or OCR, then the pharmacist reviews. This can reuse the Azure AI work.
Product mapping: keep a mapping of each vendor’s product code to the Clinq drug master, so repeat imports map automatically.

Spike deliverables

The vendors’ replies on API or export availability.
Sample invoices from both apps, to design the import format.
A recommended approach (API, file import or OCR) and an effort estimate.