Feature #619
Updated by Roshni Harish. 14 days ago
Module: **Raised by NSS** Pharmacy → Inventory → Purchasing → Payables Environment: Test, VVMC: https://vvmc.test.clinq.health/pharmacy/inventory/purchase-orders?tab=payables (v2026.10.38) Type: Enhancement Priority: Medium–High Description The pharmacy needs a clear view of which bills are unpaid for each supplier, so it knows whom to pay, how much and by when. The current Payables tab shows supplier totals, and an expandable GRN list for each supplier, but it doesn’t work as an outstanding-bills view. Current behaviour Supplier totals: Invoiced, Paid, Advance, Credits, Outstanding, Overdue, Balance. “Show GRNs” per supplier lists GRN number, received date, invoice number and amount, paid, outstanding, and “No due date.” Gaps: Only GRNs with a recorded invoice count as outstanding. GRNs that are “Awaiting invoice” show as “Invoice not recorded” with no amount, even though showing the goods were received and are owed. (On VVMC production, all 85 GRNs are in this state.) No due date or ageing. Bills can’t be sorted or filtered by how long they’ve been unpaid, and the Overdue column stays ₹0. No consolidated list. There’s no single list of all unpaid bills across suppliers; each supplier has to be expanded one at a time. No filter for “Outstanding only,” “Overdue,” or a specific supplier. No export or print of the outstanding bill list for accounts or for supplier reconciliation. Expected behaviour Add an “Outstanding Bills” view, either as a new tab under Purchasing or as a mode of the Payables tab: Columns Supplier GRN # Invoice # Invoice date Due date Invoice amount Paid Outstanding Days outstanding / overdue Status Behaviour Shows every unpaid or part-paid bill, grouped by supplier, with a subtotal per supplier and a grand total. Includes GRNs awaiting invoice at their GRN value, tagged “Invoice pending,” so received goods aren’t missed. Filters: supplier, status (Unpaid / Part-paid / Overdue / Invoice pending), and date range. Sort by due date, by days outstanding, or by amount. Ageing buckets: 0–30, 31–60, 61–90 and 90+ days. A “Pay” action on each bill, or on a selection of bills, which opens Record payment with those (unpaid) bills already selected. Export to Excel / CSV, and Print a supplier statement. Acceptance criteria There’s a single list of all unpaid and part-paid supplier bills, with a subtotal per supplier and a grand total. GRNs awaiting invoice appear at their GRN value, tagged “Invoice pending.” The view can be filtered by supplier, status and date, and sorted by due date, age or amount. Ageing buckets (0–30 / 31–60 / 61–90 / 90+) are shown. Bills can be selected and paid from the view. Export (Excel / CSV) and print (supplier statement) work. Totals match the Payables tab’s Outstanding for each supplier.