Velixo NX 2023.6 Release Notes - Sage Intacct

SI.EXPANDCOSTTYPERANGE

Modified on Wed, 20 Sep 2023 at 12:22 PM

Applies to:

Velixo NX
Sage Intacct

The SI.EXPANDCOSTTYPERANGE returns an array containing one or more cost types configured within Sage Intacct.

TABLE OF CONTENTS

Syntax
Examples

Syntax

SI.EXPANDCOSTTYPERANGE(Connection, ProjectRange, TaskRange, CostTypeID, IncludeInactive, IncludeProjects, IncludeTasks)

The SI. EXPANDCOSTTYPERANGE function uses the following parameters:

Parameter	Required/ Optional	Description
ConnectionName	Required	The name of the connection as configured in the Connection Manager
Project Range	Required	The ID of the project (or multiple projects) for which Cost Types are to be shown (available in version 2023.10 and higher)
TaskRange	Required	The ID of the task (or multiple tasks) for which Cost Types are to be shown (available in version 2023.10 and higher)
CostTypeID	Optional	The range of cost types to include in the results. See our article on including multiple parameter values
IncludeInactive	Optional	True (default) or False Determines whether or not to include entries with a Status field set to Inactive in the results.
IncludeProjects	Optional	True or False (default) Determines whether a separate column with project ID is included in the results (available in version 2023.10 and higher)
IncludeTasks	Optional	True or False (default) Determines whether a separate column with task ID is included in the results (available in version 2023.10 and higher)

Examples

Example 1

=SI.EXPANDCOSTTYPERANGE("Sage", "*", "*")

Description

Returns all cost types configured within Sage Intacct

Result

Example 2

Assuming the following configuration within Sage Intacct:

=SI.EXPANDCOSTTYPERANGE("Sage", "*", "*",,FALSE)

Description

Returns all ACTIVE cost types configured within Sage Intacct

Result

(note that the inactive cost type BUR is not included)

Example 3

=SI.EXPANDCOSTTYPERANGE("Sage", "20-001", "G01-040")

Description

Returns all cost types associated with task G01-040 in project 20-001

Result

(cell references have been used for some parameters in this example)

Note: If cost types have not been set up with Sage Intacct (or your user account does not have access to the cost type configuration), the function will return a #N/A error: