SI.LOCATIONNAME
Applies to:
- Velixo NX
- Sage Intacct
The SI.LOCATIONNAME function returns the Name field of the location entities from Sage Intacct.
Syntax
=SI.LOCATIONNAME(ConnectionName, LocationID)
Parameters
The SI.LOCATIONNAME function uses the following parameters:
Parameter | Required/Optional | Description |
ConnectionName | Required | The name of the connection as configured in the Connection Manager |
| LocationID | Optional | A filter of Location IDs for determining which Location names to include in the results. Valid entries are:
|
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