receivables_health
Assess accounts receivable and payable aging in one call. Get aging buckets, overdue share, top overdue customers, and a verdict (on-track, at-risk, off-track).
Instructions
Report AR/AP aging and who owes what, in one call.
Composes open posted invoices and vendor bills into standard aging buckets (not_due / 1-30 / 31-60 / 61-90 / 90+), the share of receivables overdue, the top overdue customers, and a verdict.
Args: top_n: Rows in the top-overdue-customers list (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. overdue_pct_at_risk: Overdue AR share (%) that drops the verdict to at_risk (default 25). overdue_pct_off_track: Overdue AR share (%) that drops the verdict to off_track (default 50).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| top_n | No | ||
| company | No | ||
| timezone_offset | No | ||
| overdue_pct_at_risk | No | ||
| overdue_pct_off_track | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |