detect_slow_moving_stock
Flags slow-moving or dead stock in a warehouse by comparing on-hand quantity against days since last movement. Requires a map of material IDs to their days since last movement.
Instructions
Flags slow-moving/dead stock by on-hand quantity vs. days-since-last-movement. Pulls on-hand quantities live from get_stock_overview for the given warehouse. DEPENDS ON: caller-supplied daysSinceLastMovement per material — this CANNOT currently be derived from get_goods_movement_history (blocked, no date field on that CDS view). Pass a movementAgeByMaterial map keyed by MaterialId.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| warehouse | Yes | Required — used to pull current stock via get_stock_overview. | |
| minOnHandQty | No | ||
| staleDaysThreshold | No | ||
| movementAgeByMaterial | Yes | Map of MaterialId -> daysSinceLastMovement (required, no automatic source yet). |