SI.DEBITS

Argument

Required/ Optional

Description

ConnectionName

Optional

Provide one of the following values:

• Connection name as defined in Connection Manager.

• Velixo range expression defining a set of connection names.

• An array of settings as described in the Multiple connections per formula article. We recommend using the VX.SETTINGS function to construct the array.

OR

Omit the argument to return results for all compatible connections with default aggregation settings.

AccountGroup

Optional if Account is specified

The name of the account group for which to return the aggregated debits.

Account

Optional if AccountGroup is specified

The code of the general ledger account, or multiple account codes defined by a Velixo range expression

FromDate

Required

The inclusive start date in YYYY-MM-DD format (or a cell reference to a date)

ToDate

Required

The inclusive end date in YYYY-MM-DD format (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

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. (note: this feature is available in version 2023.8 and higher)

When filtering by a dimension group, you can either use a dedicated group dimension name (e.g. Location Group, Customer Group) as the dimension name, or use the standard dimension name (e.g. Location, Customer) and prefix the group name with #. The # syntax also lets you reference multiple groups, for example #West Coast;#Midwest.

For more in-depth information about using Sage Intacct dimensions in Velixo NX, see Using Dimensions.

For user-defined dimensions, use the UserDefinedDimensions argument.

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. (note: this feature is available in version 2023.8 and higher)

You can specify dimension values using ranges, wildcards, and other techniques.

For more in-depth information about using Sage Intacct dimensions in Velixo NX, see Using Dimensions.

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:

1. The Location argument is defined and/or

2. Other dimensions are specified in the Dimensions or UserDefinedDimensions arguments.
   

The IncludeChildDimensionBalances argument performs similarly to the Includesubdimensions checkbox in Sage Intacct's stock reports such as Account Balances: