procurement_watch
Monitor purchasing health by identifying late receipts and stale RFQs, then receive a verdict on procurement status.
Instructions
Report purchasing health — late receipts and stale RFQs — in one call.
Composes confirmed purchase orders into open value, receipts past their planned date, per-vendor open spend, plus a count of quotation requests (draft/sent) older than rfq_stale_days, and a rule-based verdict.
Args: late_grace_days: Days past date_planned before a receipt counts as late (default 0). rfq_stale_days: Age in days after which a draft/sent RFQ counts as stale (default 7). top_n: Rows in the late-receipts / top-vendors lists (default 5). timezone_offset: UTC offset for "today" (default 7 = Asia/Ho_Chi_Minh). company: Optional company name (ilike) or id to scope the report.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| top_n | No | ||
| company | No | ||
| rfq_stale_days | No | ||
| late_grace_days | No | ||
| timezone_offset | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |