SI.EXPANDACCOUNTRANGE
Created by Damien Zwillinger, Modified on Thu, 05 Oct 2023 at 05:48 PM by Gabriel Michaud
Applies to:
- Velixo NX
- Sage Intacct
This function applies to Sage Intacct connections only. For the Acumatica/MYOB/CEGID/ JAMIS Prime function with the same name, see EXPANDACCOUNTRANGE
Description
The SI.EXPANDACCOUNTRANGE function returns all general ledger account numbers within the specified range.
Syntax
SI.EXPANDACCOUNTRANGE(Connection, AccountRange, StatisticalAccounts, IncludeInactive)
The SI. EXPANDACCOUNTRANGE function uses the following parameters:
Examples
Example #1
=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

Example #2
=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

Example #3
Assuming this account configuration within Sage Intacct:

=SI.EXPANDACCOUNTRANGE("Sage",,,FALSE)
Description
Returns all active general ledger account numbers defined within Sage Intacct (inactive account 10011 will be excluded).
Results

(note that account 10011 is not included)
Parameter | Required/Optional | Description |
Connection | Required | The name of the connection as configured in the Connection Manager |
AccountRange | Optional | The range of accounts to include in the results. See our article on including multiple parameter values |
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 |
IncludeInactive | Optional** | True (default) or False Determines whether or not to include entries with a Status field set to Inactive in the results. |
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