SI.LOCATIONNAME

Overview

The SI.LOCATIONNAME function returns the Name field of the location entities from Sage Intacct.

=SI.LOCATIONNAME(
    ConnectionName, 
    LocationID
)

The SI.LOCATIONNAME function uses the following arguments:

Argument

Required/Optional

Description

ConnectionName

Optional

Provide one of the following values:

Connection name as defined in Connection Manager.
Velixo range expression defining a set of connection names.
An array of settings as described in the Multiple connections per formula article. We recommend using the VX.SETTINGS function to construct the array.

Omit the argument to return results for all compatible connections with default aggregation settings.

LocationID

Optional

A filter of Location IDs for determining which Location names to include in the results.

Valid entries are:

Assuming the following configuration with Sage Intacct:

=SI.LOCATIONNAME(
    "Sage", 
    J5#
)

Description

Returns the name of each location for which the location ID is returned by the function in cell J5.

Result

=SI.LOCATIONNAME(
    "Sage", 
    "100"
)

Description

Returns the name of the location entity with ID 100

Result

(cell references have been used for some parameters in this example)

=SI.LOCATIONNAME(
    "Sage", 
    J5:J7
)

Description

Returns the name of each location for which the location ID listed in cell J5 through J7

Result