Compute Account Balances by Dimension
compute_account_dimension_balancesBreaks an account balance down by dimension or client, returning per-group rows with totals, opening balances, and closing balances for a date range.
Instructions
Break an account's balance down per dimension (e.g. each bank sub-account of 1020 Arvelduskontod: LHV, Wise, Lightyear), including API INITIAL opening balances. Returns one row per dimension plus a total that equals compute_account_balance for the same account. group_by "client" or "dimension_client" splits by journal header client instead (e.g. the borrowers of a shared loan account; journals without a client form a clients_id null row). With date_from, each row and the account also carry opening_balance_at_date_from and closing_balance.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"account_id": "<account_id>"
},
"name": "compute_account_dimension_balances"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| fresh | No | Clear cached API/reference data first. | |
| date_to | No | End date (YYYY-MM-DD) | |
| group_by | No | Row grouping: "dimension" (default), "client" (journal header client) or "dimension_client". | |
| date_from | No | Start date (YYYY-MM-DD) | |
| account_id | Yes | Account id (e.g. 1020). Required. In the RIK chart the id is the account number. |