Applies to
⚠️ Velixo NX only
ERP: Sage Intacct
The SI.CUSTOMERNAME function returns the customer name corresponding to one or more given customer IDs.
Syntax
SI.CUSTOMERNAME(Connection, CUSTOMERID)
Parameters
The SI. CUSTOMERNAME function uses the following parameters:
Parameter | Required/Optional | Description |
Connection | Required | The name of the connection as configured in the Connection Manager |
CustomerID | Required | The ID number(s) of the customer(s) |
Examples
Given the following configuration in Sage Intacct...
Example #1
=SI.CUSTOMERNAME("Sage", "10001")
Description
Returns the name of the customer with the ID "10001".
Result
Example #2
=SI.CUSTOMERNAME("Sage", C2:C4)
Description
Returns the name of the customers whose ID numbers are listed in cell C2 through C4.
Result
Example #3
=SI.CUSTOMERNAME("Sage", C2#)
Description
Returns the name of all customers whose ID numbers are displayed by the function in cell C2.
Result