SI.EXPANDACCOUNTRANGE

Created by Damien Zwillinger, Modified on Thu, 05 Oct 2023 at 05:48 PM by Gabriel Michaud

Applies to:

This function applies to Sage Intacct connections only. For the Acumatica/MYOB/CEGID/ JAMIS Prime function with the same name, see EXPANDACCOUNTRANGE

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

SI.EXPANDACCOUNTRANGE(Connection, AccountRange, StatisticalAccounts, IncludeInactive)

The SI. EXPANDACCOUNTRANGE function uses the following parameters:

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

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

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

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

Assuming this account configuration within Sage Intacct:

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

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

(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.