get_aged_payables_summary_report
Retrieve aged payables summary filtered by property, group, portfolio, owner, company, balance, and as-of date.
Instructions
Returns aged payables summary for the given filters. IMPORTANT: All ID parameters must be numeric strings (e.g. '123'), NOT names.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| property_visibility | No | Filter properties by status | active |
| properties_ids | No | Filter by specific property IDs | |
| property_groups_ids | No | Filter by property group IDs | |
| portfolios_ids | No | Filter by portfolio IDs | |
| owners_ids | No | Filter by owner IDs | |
| occurred_on | Yes | As-of date (YYYY-MM-DD) | |
| party_company_id | No | Filter by company ID | |
| balance_amount | No | Balance amount to compare against | |
| balance_comparator | No | Comparison operator (e.g. "gt", "lt") | |
| columns | No | Specific columns to include |