SI.EXPANDACCOUNTRANGE

Created by Harry Lewis, Modified on Thu, 04 Apr 2024 at 06:16 PM by Harry Lewis

Applies to:

  • Velixo NX
  • Sage Intacct


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

 


TABLE OF CONTENTS


Syntax


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

 

Parameters


The SI.EXPANDACCOUNTRANGE function uses the following parameters:


Parameter

Required/Optional

Description

Connection

Required

The name of the connection as configured in the Connection Manager


AccountRangeOptional

The range of accounts to include in the results.*


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


InclueInactiveOptional

True (default) or False

Determines whether or not the results include entries with a Status field set to Inactive.


QuickStartCategoryOptionalFilters the result set. Only those accounts belonging to the specified Quick Start account category will be displayed.


* see Filtering Techniques for Velixo Functions

 

  

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

 

=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

(note that inactive account 10011 is not included)


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