SI.LOCATIONNAME
Overview
The SI.LOCATIONNAME function returns the Name field of the location entities from Sage Intacct.
Syntax
=SI.LOCATIONNAME(
ConnectionName,
LocationID
)Arguments
The SI.LOCATIONNAME function uses the following arguments:
Argument | Required/Optional | Description |
| Required | The name of the connection as configured in the Connection Manager |
| Optional | A filter of Location IDs for determining which Location names to include in the results.
|
Example
Assuming the following configuration with Sage Intacct:
Example 1 - Excel array of Location IDs
=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
Example 2 - single Location ID
=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)
Example 3 - Excel cell range of Location IDs
=SI.LOCATIONNAME(
"Sage",
J5:J7
)
Description
Returns the name of each location for which the location ID listed in cell J5 through J7
Result
