KYRIBA.GETCASHFLOWS
Overview
Returns cash flow details.
Syntax
KYRIBA.GETCASHFLOWS(uuids; [fields])
Note❗ The list separator (e.g., comma or semicolon) may differ depending on your Region settings.
Parameter | Required/Optional | Description | Details |
---|---|---|---|
Uuids | ✅ Required | One or a range of cash flows’ unique identifiers (uuid) that can be retrieved with KYRIBA.GETCASHFLOWSLIST. | |
Fields | 🟨 Optional | Specify fields to return. If omitted or equal to empty space, default fields are returned. |
Default fields: Account code; Cash flow code; Budget Code; Transaction date; Flow amount; Flow currency; Status; Reference; Description; Origin. Enter “EXCEL” or “EXCELH” to return all the existing fields horizontally. Enter “EXCELV” to return all the existing fields vertically. Enter “JSON” to return the API response body. |
Examples
1. Return all the details of the selected cash flow. All fields are requested to be returned horizontally.
Formula:
=KYRIBA.GETCASHFLOWS("fa700f41-1455-4ed4-85aa-e54509beb7f7";"EXCELH")
Result: