get_cashflow_12_month_report
Generates a 12-month cash flow report for properties, filtering by dates, property status, owners, and portfolios to analyze income and expenses.
Instructions
Generates a 12-month cash flow report.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| property_visibility | No | Filter properties by status. Defaults to "active" | 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 | |
| posted_on_from | Yes | Required. The start month for the reporting period (YYYY-MM). | |
| posted_on_to | Yes | Required. The end month for the reporting period (YYYY-MM). | |
| gl_account_map_id | No | Optional. Filter by a specific GL Account Map ID. | |
| level_of_detail | No | Level of detail. Defaults to "detail_view" | detail_view |
| include_zero_balance_gl_accounts | No | Include GL accounts with zero balance. Defaults to "0" | 0 |
| exclude_suppressed_fees | No | Exclude suppressed fees. Defaults to "0" | 0 |
| columns | No | Array of specific columns to include |