Procurement & suppliers

Spreadsheet tracker for needs ordering → ordered → received, plus supplier catalogue and PO control.

Refresh low-stock ──► Needs ordering (oos) ──┐
Refresh expired   ──► Needs ordering (exp) ──┼──► Items ordered ──► Items received
+ Add row (manual)──► Needs ordering       ──┘         │
                                                       │
                       Not needed ◄────────────────────┘
                         (any pending row)

Menu

Procurement dropdown: Tracker, Reorder forecast, Supplier performance, PO receipts invoice
Procurement menu. PO / receipts / invoice is admin-only.

Tracker

Procurement → Tracker is a single grid. Edit cells inline (each save is audited). Filter by Status / Route / Urgent; search item, PO, or comments.

Colour / statusMeaning
White — Needs ordering (oos)From low stock
Blue — Needs ordering (exp)From expiring/expired inventory (≤90 days)
Amber — Items orderedPO / ordered date / R12 requisition
Green — Items receivedReceived date or quantity
Grey — Not neededMarked not required
Red (Urgent column)Row marked urgent
Procurement tracker grid with status colours and bulk actions
Tracker: status, item, lab, project, supplier, catalogue #, price, qty. Footer shows row count, Refresh low-stock / expired-stock, Export CSV, Add row, and bulk actions (enabled when rows are selected).

Refresh and export

  1. Open the tracker — low-stock rows sync automatically.
  2. Refresh low-stock rows / Refresh expired-stock rows (optional Include transfer demand).
  3. Export CSV.

Bulk actions

  1. Select rows (checkbox / select-all).
  2. Mark as not needed — status → Not needed. The button stays disabled until that request finishes. Each selected line gets its own audit row.
  3. Copy selected — new pending row; clears PO/requisition/ordered/received dates and qty; keeps item/qty/price/need kind. Same disable-until-finished behaviour, and one audit row per copied line.

Edit locks

StageLockedUnlock by
OrderedEntry fields (item, qty, supplier…)Clear ordered date and PO/requisition
ReceivedOrdered details + entryClear received date / qty received

Comments stay editable. Clear later-stage fields to unlock earlier ones. Route can be R12, Manual PO, or Other; Manual PO does not require an R12 requisition.

Suppliers and catalogue (admin)

The supplier is the ordering source; the manufacturer is recorded separately on the reagent. Maintain manufacturers under Add / Edit Data → Manufacturer. Existing barcodes retain the manufacturer recorded at booking.

  1. Edit Data → Supplier — list, add, edit, or activate/deactivate.
  2. Edit Data → Manage Supplier Catalogue — SKU, price, pack.
  3. Manage Supplier Approvals — one default supplier per reagent.
  4. Change Default Supplier for a reagent without opening the full catalogue.
Suppliers list with Add supplier, Edit, Deactivate
Edit Data → Supplier. Deactivating hides the supplier from new bookings; existing stock is not changed.

PO / receipts (admin)

Procurement → PO / receipts / invoice — PO header and lines, goods receipts, approval and invoice. Book-in with the same PO reference to link inventory.

At book-in, Number Received counts barcoded lots and Received Quantity records the amount in each lot in the reagent's units. The linked receipt accounts for both values. See Stock lifecycle.

Procurement control purchase order form
Open an existing PO or create a header (reference, supplier, requisition, quote, budget, urgency, ordered date, fulfilment status).

Below-minimum stock

Use the tracker (refresh low-stock) or Reports → Inventory → Reagents below minimum stock. The dashboard Low Stock Reagents card is the live count.

Procurement → Reorder forecast and Supplier performance download as XLSX.