The SI.OPENINGBALANCE function returns the opening balance of a GL account (at the beginning of the specified reporting period or date).
Syntax
SI.OPENINGBALANCE(
Connection,
AccountGroup,
AccountCode,
ReportingPeriodName,
StartDate,
EndDate,
LocationId,
ReportingBook,
Dimensions,
UserDefinedDimensions)
Parameters
The SI.OPENINGBALANCE function uses the following parameters:
Parameter | Required/Optional | Description |
Connection | Required | The name of the connection as configured in the Connection Manager |
AccountGroup | Optional if AccountCode is specified | The name of the account group for which to return the aggregated opening balance |
AccountCode | Optional if AccountGroup is specified | The code of the general ledger account, or multiple account codes defined by a Velixo range expression |
ReportingPeriodName | Optional if both StartDate and EndDate are specified | The reporting period name. ⚠️ Attention: the "dynamic" reporting period names like "Today" or "Last Month" are not supported due to limitations in Sage Intacct's API. |
StartDate | Optional if ReportingPeriodName is specified | The start date (inclusive) |
EndDate | Optional if ReportingPeriodName is specified | The end date (inclusive) |
LocationId | Optional unless the company has multiple base currencies | The ID of the entity or location |
ReportingBook | Required | The reporting book ID ("ACCRUAL", "CASH", or a user-defined book) |
Dimensions | Optional | A two-column Excel range, where the first column contains the name of a predefined analytical dimension (e.g. department, customer, project etc.), and the second column contains the respective value / Velixo range expression for that dimension. For user-defined dimensions, use the UserDefinedDimensions argument. |
UserDefinedDimensions | Optional | A two-column Excel range, where the first column contains the name of a user-defined analytical dimension, and the second column contains the respective value (or a semicolon-separated list of values) for that dimension. For predefined analytical dimensions like customer, project etc., use the Dimensions argument. |
Example
=SI.OPENINGBALANCE(
"Demo",
,
"40000",
"Month Ended May 2022",
"300",
,
,
"ACCRUAL",
$C$6:$D$8)
Description
Returns the opening balance of the account "40000 - Revenue" at the beginning of May 2022, for entity "300", filtered down by dimensions specified in the C6:D8 range (for example, by Department and Employee).
Result
$129 019 555.08
Applies to
⚠️ Velixo NX only
ERP: Sage Intacct