The SI.ADJCREDITS function uses the following arguments:
Parameter
Required/ Optional
Description
ConnectionName
Required
The name of the connection as configured in the Connection Manager
AccountGroup
Optional if Accountis specified
The name of the account group for which to return the aggregated adjusted credits.
Computational Account Groups are not supported.
Account
Optional if AccountGroupis specified
The code of the general ledger account, or multiple account codes defined by a Velixo range expression
FromDate
Required
The start date (inclusive) or a cell reference to a date
ToDate
Required
The end date (inclusive) or a cell reference to a date
LocationID
Optional unless the company has multiple base currencies
The ID of the entity or location
Books
Optional
The reporting book or global consolidation book to be used for retrieving the balance. One or more user-defined adjustment book IDs may be included.
Booksparameter:
If you leave the parameter blank, the default reporting book will be used (ACCRUAL or CASH depending on your company settings).
If you specify just one reporting or global consolidation ("GC") book, that's what will be used to retrieve balances.
If you specify more than one reporting / GC books (e.g. "ACCRUAL;GCBOOK") an error will be thrown - it is not allowed in Sage.
If you specify a reporting / GC book and one or more predefined/user-defined adjustment books (e.g. "ACCRUAL;TAX;GAAP") then you will retrieve balances from ACCRUAL plus any adjustments defined by each of the adjustment books.
Dimensions
Optional
Either:
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 semicolon-separated list of values for that dimension. OR
A multi-column array where the first row (or column) of the array contains the name of a predefined analytical dimension, and the remaining rows (or columns) contain the individual values for that dimension.
This feature is available in version 2023.8 and higher
For more in-depth information about filtering by Dimensions: see Using Dimensions
For user-defined dimensions, use the UserDefinedDimensionsargument.
UserDefinedDimensions
Optional
Either:
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. Or
A multi-column array where the first row (or column) of the array contains the name of a user-defined analytical dimension, and the remaining rows (or columns) contain the individual values for that dimension.
This feature is available in version 2023.8 and higher)
For predefined analytical dimensions like customer, project etc., use the Dimensions argument.
IncludeChildDimensionBalances
Optional
TRUE or FALSE (Default)
Determines if (for dimensions that have child dimensions) the balances of child dimensions are included in the calculation of the total balance.
This argument only affects balances if:
The Locationargument is defined and/or
Other dimensions are specified in the Dimensions or UserDefinedDimensions parameters.
The IncludeChildDimensionBalances parameter performs similarly to the Includesubdimensions checkbox in Sage Intacct's stock reports such as Account Balances:
