Reports, alerts, exports

Dashboard for daily counts; Reports menu for PDF/Excel/CSV; scheduled email digests.

Application name → Dashboard ──► action lists (order / finish / validate / transfer)

Reports ──► Inventory / Barcode lookup / Project / Experiment / Recharge billing

Reports → Barcode lookup ──► Download table (PDF / Excel / CSV)
                          └── Reagent Usage Log (PDF)
Reports dropdown
Reports menu. Role review export is admin-only.

Dashboard and lists

The application name opens the dashboard — cards for low stock, expiring ≤90 days, open-vial warn/breach, not validated open, and pending transfers, each as a count against its total. Charts: stock per laboratory, open vs unopened, expiry profile, recent receipts.

Also use the Inventory lists: Expiring Soon, Not validated, All, In Stock. Analytics at /stock/reports/analytics/ redirects here.

Operational dashboard
Open on a card jumps to the matching work list. Expiry profile splits in date / ≤90 days / expired / no date.
Expiring Soon inventory list
Inventory → Expiring Soon is the list behind the expiry card.

Digests (schedule once/day)

Call these from the server itself, or send header X-Cron-Token matching CRON_TOKEN. Other callers are refused.

URLContent
/stock/low_emails/Low stock + expiry
/stock/open_vial_emails/Open-vial
/stock/transfer_pending_emails/Pending transfers

Standard exports

MenuOutput
Reports → InventoryValidation, expiry, locations, all in-stock, below-minimum, transfers, FEFO, procurement-linked (PDF/XLSX; catalogue # on item rows)
Reports → Barcode lookupStock snapshot + optional usage columns; table PDF/Excel/CSV or Reagent Usage Log PDF
Reports → ProjectShow results, then configurable PDF/Excel/CSV or Reagent Usage Log PDF (booked-in or used; finished optional)
Reports → ExperimentShow results, then configurable PDF/Excel/CSV or Reagent Usage Log PDF (attributed at open or used; finished optional)
Reports → Recharge billingOn-screen summary and reagent list, then PDF or XLSX
Procurement → Reorder forecast / Supplier performanceXLSX
Procurement → TrackerCSV (see 07)
Select Inventory Report To Generate
Reports → Inventory. Pick the report type, then Download .pdf or Download .xlsx.
Project report filters and Show results before output options appear
Reports → Project: choose project, booked-in versus used, and whether to include finished items. Start with Show results.
Experiment report filters and Show results
Reports → Experiment: choose Attributed at open or Used in usage records, then Show results.
Recharge billing export
Recharge billing: lookback (for example 90 days), summarise by project / laboratory / consumer.

Project and Experiment: results first, output below

  1. Choose the project or experiment, inclusion rule and finished-item filter. Click Show results.
  2. If items match, review the results table. Configure report output appears under that table. With no matching items, the output panel is hidden.
  3. Tick Stock columns and Usage & attribution columns. Keep at least one column. Update results refreshes the table using the choices and retains them.
  4. Download table (PDF / Excel / CSV) exports the selected columns for the current filters and laboratory scope. Downloads leave the page available for another export.
  5. Reagent Usage Log (PDF) uses a fixed printable worksheet layout, with an optional experiment reference. Column checkboxes control the table exports, not this worksheet.

Usage columns show each lot's current attribution, even if a report matched an earlier usage record. Export actions are audited. The worksheet is not the system audit log; use Inventory → Audit trail for saved record states.

Project results table above Configure report output and download controls
Project results first. Choose output columns below the table, then Update results or download PDF, Excel, CSV, or the Reagent Usage Log.
Experiment results above the output panel
Experiment reporting uses the same table-first layout and output controls.

Barcode lookup

Reports → Barcode lookup — paste barcodes or upload a list (active lab scope). Unmatched codes are highlighted. Short codes and labelled codes both match (J1G2, NGS-J1G2, and IOB-J1G2).

The results table includes current stock columns. Tick extra Usage & attribution columns if you need laboratory, project, process, experiment, consumers, notes, last updated, recorded by. The item page still has the full usage history (open → uses → finish).

Barcode lookup empty form
Paste one barcode per line, or upload a text/CSV file, then Look up barcodes.
Barcode lookup results and export checkboxes
Demonstration barcode matches in laboratory scope. Choose stock and usage columns, then download the table or the Reagent Usage Log PDF.

Search (top right) finds a single barcode plus reagent, catalogue #, supplier, lot, and PO. See Stock lifecycle.