Skip to main content

Inventory Reports and the Health Dashboard

Most stock reports are under Inventory Reports. Others are in the Reports hub (top bar) under Inventory & warehouse, where each one exports to Excel, CSV, and PDF. All need View inventory reports.

Inventory Reports​

ReportWhat it shows
Stock card and Stock ledgerOne item's movements, and a broader movement view
Inventory valuationQuantity and value by product, with as-of date, category and warehouse filters, a costing column, in-transit columns, and Excel export
Batch valuationValue by lot
Kit sales reportKits sold and the components they consumed
Standard cost varianceActual against standard cost on receipts, and GL posting
Supplier scorecardVendor score 0 to 100, ranking, trend. See Supplier scorecard
Dead stock, Action History, Demand forecast, Supplier returnsSlow stock and decisions, weeks of cover, return rate and credit recovery

Some detail reports are reached from where they apply: the GRN variance report from the GRN list, the landed cost report from landed costs, FIFO cost layers from the item's costing section, the picking compliance report from Inventory setup, and the serial register and warranty expiry from the serial pages.

Other places to look​

ReportWhere
Stock reconciliation, Health dashboardInventory Operations
Expiry analytics, Shrink reportInventory Tracking
Stock movement summary, Stock aging, Items below reorder level, Negative stock, ABC analysis, Inventory turnover, Batches by expiryReports hub → Inventory & warehouse
Serial number register, Stock adjustment register, Stock transfer register, Transfer discrepancies, Cycle count variance, Consignment settlementsReports hub → Inventory & warehouse

Use the valuation as-of date and filters for month-end reviews.

Reading the stock ledger and stock card​

  • The Balance column is the item's stock in that row's warehouse after the movement, so each warehouse keeps its own balance. It shows when sorted by date; other sorts show a dash.
  • Closing Balance shows a number only when one item is picked.
  • Put-away into a bin shows as Bin move and isn't counted in Total In or Total Out.
  • References show the document number (credit note, debit note, delivery note, return-to-vendor) and open the document.
  • The Batch column on the stock card shows which batch each movement used.

How stock changes day to day​

ActivityEffect
Post a GRN or Fast ReceiveIncreases
Sale invoice or POS checkoutDecreases (unless a delivery note already issued the goods)
Post a delivery note or complete Fast DispatchDecreases
Cancel a posted delivery noteIncreases (reversal)
Stock transferDecreases the source when shipped; increases the destination when received
Approved adjustment, Quick countIncreases or decreases
Return to vendor or purchase returnDecreases
Sale returnIncreases
Manufacturing issue or productionDecreases inputs; increases finished goods

The Inventory Health Dashboard​

Open Inventory Operations → Inventory Health Dashboard for the one-screen version, with an overall status and metric cards you can click to drill into. See the Inventory overview for what each card covers.

Traceability​

Use Trace a lot to see everywhere one lot went. The Traceability module adds forward and backward tracing for regulated categories such as the FDA Food Traceability List.

Next step​