SI.EXPANDACCOUNTRANGE

Overview

The SI.EXPANDACCOUNTRANGE function returns all general ledger account numbers within the specified range.

=SI.EXPANDACCOUNTRANGE(
    ConnectionName, 
    Account, 
    StatisticalAccounts, 
    IncludeInactive, 
    QuickStartCategory
)

The SI.EXPANDACCOUNTRANGE function uses the following arguments:

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.
`Account`	Optional	The range of accounts to include in the results. see Filtering Techniques for Velixo Functions
`StatisticalAccounts`	Optional	Determines whether or not statistical accounts are included in the results. Possible values: 1 - Include statistical accounts (default) 2 - Exclude statistical accounts 3 - Include Only statistical account
`InclueInactive`	Optional	`TRUE` (default) or `FALSE` Determines whether or not the results include entries with a Status field set to Inactive.
`QuickStartCategory`	Optional	Filters the result set. Only those accounts belonging to the specified Quick Start account category will be displayed.

=SI.EXPANDACCOUNTRANGE(
    "Sage", 
    "10000:11000",
    "1"
)

Description

Returns all active general ledger account numbers (including statistical accounts) between account 10000 and account 11000 (inclusive).

Result

=SI.EXPANDACCOUNTRANGE(
    "Sage", 
    "10010:12600;-10400", 
    "2"
)

Description

Returns all active general ledger account numbers (between 10010 and 12600) except account 10400 and statistical accounts.

Results

=SI.EXPANDACCOUNTRANGE(
    "Sage",
    ,
    ,
    FALSE
)

Assuming this account configuration within Sage Intacct:

Description

Returns all active general ledger account numbers defined within Sage Intacct (inactive account 10011 will be excluded).

Results

Inactive account 10011 is not included