SI.LOCATIONNAME
Created by Damien Zwillinger, Modified on Fri, 3 Nov, 2023 at 12:34 PM by Harry Lewis
Applies to:
- Velixo NX
- Sage Intacct
The SI.LOCATIONNAME function returns the Name field of the location entities from Sage Intacct.
TABLE OF CONTENTS
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
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article