Feature #625
Updated by Roshni Harish. 14 days ago
Module: Pharmacy → Inventory / Purchase → Stock inward (GRN) Environment: NSSH Type: Enhancement + Spike Priority: P1 for Direct GRN, P3 for the app integration spike **Raised by NSS** Background NSSH The hospital orders medicines through B2B ordering apps (Medvol, BB-MedsCart), not through Clinq purchase orders. When the medicines arrive, they need (similar 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). 'Instamart for medicines'): Select the supplier or source: Medvol, BB-MedsCart, or another distributor in the supplier master. - Medvol (Google Play) 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. - BB-MedsCart (Google Play) Acceptance criteria A GRN can be created with no PO linked. Batch, expiry, MRP, Explore integrating 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 orders / 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. these apps.