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
| Report | What it shows |
|---|---|
| Stock card and Stock ledger | One item's movements, and a broader movement view |
| Inventory valuation | Quantity and value by product, with as-of date, category and warehouse filters, a costing column, in-transit columns, and Excel export |
| Batch valuation | Value by lot |
| Kit sales report | Kits sold and the components they consumed |
| Standard cost variance | Actual against standard cost on receipts, and GL posting |
| Supplier scorecard | Vendor score 0 to 100, ranking, trend. See Supplier scorecard |
| Dead stock, Action History, Demand forecast, Supplier returns | Slow 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
| Report | Where |
|---|---|
| Stock reconciliation, Health dashboard | Inventory Operations |
| Expiry analytics, Shrink report | Inventory Tracking |
| Stock movement summary, Stock aging, Items below reorder level, Negative stock, ABC analysis, Inventory turnover, Batches by expiry | Reports hub → Inventory & warehouse |
| Serial number register, Stock adjustment register, Stock transfer register, Transfer discrepancies, Cycle count variance, Consignment settlements | Reports 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
| Activity | Effect |
|---|---|
| Post a GRN or Fast Receive | Increases |
| Sale invoice or POS checkout | Decreases (unless a delivery note already issued the goods) |
| Post a delivery note or complete Fast Dispatch | Decreases |
| Cancel a posted delivery note | Increases (reversal) |
| Stock transfer | Decreases the source when shipped; increases the destination when received |
| Approved adjustment, Quick count | Increases or decreases |
| Return to vendor or purchase return | Decreases |
| Sale return | Increases |
| Manufacturing issue or production | Decreases 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
Learn more about Biznsbook Inventory Management on biznsbook.com.