get_receivables_activity_report
Generate a receivables activity report by specifying a date range and optional filters like tenant status or property groups. Uses numeric IDs for accurate results.
Instructions
Returns receivables activity report for the given filters. IMPORTANT: All ID parameters (owners_ids, 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
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| tenant_visibility | No | Filter tenants by status. Defaults to "active" | |
| tenant_statuses | No | Filter by specific tenant statuses (e.g., ["0", "4"] for Current and Notice) | |
| property_visibility | No | Filter properties by status. Defaults to "active" | |
| properties | No | Filter results based on properties, groups, portfolios, or owners. All ID fields must be numeric strings, not names. | |
| receipt_date_from | Yes | The start date for the reporting period based on receipt date (YYYY-MM-DD). Required. | |
| receipt_date_to | Yes | The end date for the reporting period based on receipt date (YYYY-MM-DD). Required. | |
| manually_entered_only | No | Include only manually entered receipts. Defaults to "0" (false) | |
| columns | No | Array of specific columns to include in the report |