SI.EXPANDLOCATIONERANGE

Created by Damien Zwillinger, Modified on Mon, 6 Nov, 2023 at 6:16 PM by Harry Lewis

Applies to:

  • Velixo NX
  • Sage Intacct


The SI.EXPANDLOCATIONERANGE function returns an array containing one or more Sage Intacct Location IDs (based on the specified range).

 

TABLE OF CONTENTS

 

Syntax

SI.EXPANDLOCATIONRANGE(ConnectionName, Range, Status)

 

The SI. EXPANDLOCATIONRANGE function uses the following parameters:


Parameter

Required/ Optional

Description

ConnectionName

Required

The name of the connection as configured in the Connection Manager

Range

Optional

A range filtering specifying the Location IDs to be displayed. See Filtering Velixo Functions.

Status

Optional

Determines which entities are included in the results.


Available values:

  • A - records with a Status field set to Active
  • N - records with a Status field set to Active non-posting
  • I - records with a Status field set to Inactive


A combination of values can be used (e.g., "ANI"). 

By default, all records with any status are included in the results.


(available in version 2023.10 and higher)

 

Examples

 

Assuming the following configuration within Sage Intacct:

 

 

Example 1

=SI.EXPANDLOCATIONRANGE("Sage")
or
=SI.EXPANDLOCATIONRANGE("Sage","*")

Description

Returns all Location IDs.

 

Results


Example 2

=SI.EXPANDLOCATIONRANGE("Sage","9??")

Description

Returns all of the three-digit Location IDs with start with the digit 9.

 

Results

 

Example 3

=SI.EXPANDLOCATIONRANGE("Sage","100:300;900:999")

Description

Returns all Location IDs between 100 and 300 (inclusive) and between 900 and 999 (inclusive).

 

Results

 

Example 4

Assuming the following configuration within Sage Intacct:

 

=SI.EXPANDLOCATIONRANGE("Sage",,"A")

 

Description

Returns all active Location IDs defined within Sage Intacct.

 

Results


(note that inactive location 900 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 at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article