get_aged_receivables_detail_report
Retrieve aged receivables detail report filtered by property, tenant, or balance criteria. Input numeric IDs and date range to get aging buckets like 0-30, 30-60 days.
Instructions
Returns aged receivables detail for the given filters. IMPORTANT: All ID parameters (properties_ids, etc.) must be numeric strings (e.g. '123'), NOT names. Use respective directory reports first to lookup IDs by name if needed.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| property_visibility | No | Filter properties by status. Defaults to "active". | active |
| properties | No | Optional. Filter by specific property-related IDs. | |
| tags | No | Optional. Filter by property tags. | |
| balance_operator | No | Optional. Filter by balance amount with comparison operator. | |
| tenant_statuses | No | Optional. Filter by tenant status. | |
| occurred_on_to | Yes | End date for transaction occurrence filter (YYYY-MM-DD format). | |
| gl_account_map_id | No | Optional. General ledger account map ID. | |
| columns | No | Array of specific columns to include in the report. Valid columns: payer_name, property, property_name, property_id, property_address, property_street, property_street2, property_city, property_state, property_zip, invoice_occurred_on, account_number, account_name, account_id, total_amount, amount_receivable, future_charges, 0_to30, 30_to60, 60_to90, 90_plus, 30_plus, 60_plus, occupancy_name, account, unit_address, unit_street, unit_street2, unit_city, unit_state, unit_zip, unit_name, unit_type, unit_tags, tenant_status, payment_plan, txn_id, occupancy_id, unit_id | |
| as_of | Yes | As-of date for the aged receivables report (YYYY-MM-DD format). |