SI.ADJDEBITS
Created by Harry Lewis, Modified on Thu, 8 Aug at 12:24 PM by Harry Lewis
Applies to:
- Velixo NX
- Sage Intacct
The SI.ADJDEBITS function returns the total of the adjusted debits applied to a GL account (between two dates).
The function returns the same value as can be found in the Adjusting Debit column of the Sage Intacct Account balanceS report:
Syntax
SI.ADJDEBITS(
Connection,
AccountGroup,
AccountCode,
StartDate,
EndDate,
LocationId,
Books,
Dimensions,
UserDefinedDimensions, IncludeChildDimensionBalances)
Parameters
The SI.ADJDEBITS function uses the following parameters:
Parameter | Required/ Optional | Description |
ConnectionName | 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 adjusted debits. Note: Computational Account Groups are not supported. |
AccountCode | Optional if AccountGroup is specified | The code of the general ledger account, or multiple account codes defined by a Velixo range expression |
StartDate | Required | The start date (inclusive) or a cell reference to a date |
EndDate | 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* |
Optional | Either:
For more in-depth information about filtering by Dimensions: see Using Dimensions
For user-defined dimensions, use the UserDefinedDimensions argument. | |
UserDefined Dimensions | Optional | Either:
For predefined analytical dimensions like customer, project etc., use the Dimensions argument. |
IncludeChild Dimension Balances* | Optional | True or False (Default) Determines if (for dimensions which have child dimensions) the balances of child dimensions are included in the calculation of the total balance. This parameter only affects balances if:
|
*The IncludeChildDimensionBalances parameter performs similarly to the Include subdimensions checkbox in Sage Intacct's stock reports such as Account Balances:
Books parameter:
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.
Example
=SI.ADJDEBITS(
"Sage",
,
"10100",
"12/1/2024",
"12/31/2024",
"100",
"ACCRUAL")
Description
Returns the total of the adjusted debits applied to account "10100" during December 2024 for entity "100" in the ACCRUAL reporting book.
Result
100.00
(this example uses cell references for the parameters)
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article