SI.COSTTYPENAME

Created by Harry Lewis, Modified on Wed, 30 Apr at 9:29 AM by Wojtek Rajtar

Applies to:

Velixo NX
Sage Intacct

The SI.COSTTYPENAME function returns the Cost type name that matches the specified Project, Task and Cost type ID.

TABLE OF CONTENTS

Syntax
Parameters
Examples
- Example 1
- Example 2

Syntax

SI.COSTTYPENAME(ConnectionName, ProjectID, TaskID, CostTypeID)

Parameters

The SI.COSTTYPENAME function uses the following parameters:

Parameter	Required/ Optional	Description
ConnectionName	Required	The name of the connection as configured in the Connection Manager
ProjectID	Optional (Required only when the TaskID parameter is specified) (Required before version 2024.4)	The ID of the project for which Cost type names are to be shown. (available in version 2023.12 and higher)
TaskID	Optional (Required only when the ProjectID parameter is specified) (Required before version 2024.4)	The ID of the task for which Cost type names are to be shown. (available in version 2023.12 and higher)
CostTypeID	Required	A single cost type ID or an array containing multiple cost type IDs

Note: Starting with version 2024.4, when the TaskID and ProjectID parameters are not defined, the function returns the name of the Standard Cost type defined in Sage Intacct.

Examples

Example 1

=SI.COSTTYPENAME("Sage", , , "OH")

Description

ProjectID and TaskID are not specified; the function will return the name of the Standard Cost type defined in Sage Intacct.

Result

Example 2

=SI.COSTTYPENAME("Sage", "ED Test Project", "01 21 00", "OH")

Description

ProjectID and TaskID are specified; the function will return the Cost type name defined in Sage Intacct for the “OH” Cost type ID from the Cost type line associated with the “ED Test Project” project and the “01 21 00” Cost Code ID (TaskID).

Result