SI.EXPANDACCOUNTRANGE

Modified on Wed, 13 Sep 2023 at 10:08 PM

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

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article