SI.ITEMNAME
Harry Lewis avatar
Written by Harry Lewis
Updated over a week ago

Applies to

  • ⚠️ Velixo NX only

  • ERP: Sage Intacct

The SI.ITEMNAME function returns the item name corresponding to one or more given item IDs.

Syntax

SI.ITEMNAME(Connection,ItemID)

Parameters

The SI. ITEMNAME function uses the following parameters:

Parameter

Required/Optional

Description

Connection

Required

The name of the connection as configured in the Connection Manager

ItemID

Required

The ID number(s) of the item(s)

Examples

Assuming the following configuration within Sage Intacct:

Example #1

=SI.ITEMNAME("Sage", "1001")

Description

Returns the name of the item with the ID "1001".

Result

Example #2

=SI.ITEMNAME("Sage", C2:C4)

Description

Returns the name of the items whose ID numbers are listed in cell C2 through C4.

Result

Example #3

=SI.ITEMNAME("Sage", C2#)

Description

Returns the name of all item names whose ID numbers are displayed by the function in cell C2.

Result

Did this answer your question?