inventory_risk
Identify inventory shortages where demand exceeds supply and dead stock with no movement within a configurable window, valued at cost.
Instructions
Report stock at risk — shortages and dead stock — in one call.
Shortages are storable products with negative forecasted quantity (demand exceeds supply). Dead stock is on-hand product with no done stock move in dead_stock_days, valued at standard_price. The dead-stock check is a bounded heuristic: when the recently-moved product list hits the 200-group cap, a risk flags that the list may over-count.
Args: dead_stock_days: No-movement window for dead stock (default 90). top_n: Rows listed per breakdown section (default 10). timezone_offset: UTC offset for "today" (default 7 = Asia/Ho_Chi_Minh).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| top_n | No | ||
| dead_stock_days | No | ||
| timezone_offset | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |