inventory_low_stock
Identifies stock items whose on-hand quantity has fallen to or below their reorder point, showing shortfall and estimated days of cover so you can prioritize replenishment.
Instructions
Die Liste tiefer Bestaende (low stock, US-J07.2): every stock-tracked item whose on-hand has fallen to or below its D00 reorder point, ordered by severity (deepest shortfall, then lowest days-of-cover, first). Each row carries current_qty, reorder_point, shortfall_qty, last_movement_at, a simple average daily usage derived from recent outbound movements and an estimated days-of-cover; when there is not enough usage history the cover is null with warning usage_history_insufficient. Optional location_ids / warehouse_ids narrow the on-hand, min_shortfall filters, include_zero keeps zero-reorder items. safety_stock / suggested_reorder_qty are null until a later item-master extension adds the columns. Empty is an ok empty list. Pure derivation over the ledger; posts nothing.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| thresholds | No | ||
| workspaceId | Yes | ||
| include_zero | No | ||
| location_ids | No | ||
| min_shortfall | No | ||
| warehouse_ids | No |