SI.EXPANDCOSTTYPERANGE

Overview

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

Syntax

CODE

=SI.EXPANDCOSTTYPERANGE(ConnectionName, Project, Task, CostType, IncludeInactive, IncludeProjects, IncludeTasks)

Arguments

The SI.EXPANDCOSTTYPERANGE function uses the following arguments:

Argument	Required/ Optional	Description
`ConnectionName`	Required	The name of the connection as configured in the Connection Manager
`Project`	Required	The ID of the project (or multiple projects) for which Cost Types are to be shown (available in version 2023.10 and higher)
`Task`	Required	The ID of the task (or multiple tasks) for which Cost Types are to be shown (available in version 2023.10 and higher)
`CostType`	Optional	The range of cost types to include in the results. See our article on including multiple argument 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 - all cost codes

CODE

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

Description
Returns all cost types configured within Sage Intacct

Result

Example 2 - active cost codes

Assuming the following configuration within Sage Intacct:

CODE

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

Description
Returns all ACTIVE cost types configured within Sage Intacct

Result

The inactive cost type BUR is not included

Example 3 - specific project and task

CODE

=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 arguments in this example)

Example 4 - including project IDs

CODE

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

Description
Returns all Project IDs and their corresponding active Cost Types

Result

Example 5 - including task codes

CODE

=SI.EXPANDCOSTTYPERANGE("Sage", "TEST-2205", "*", FALSE, FALSE, TRUE)

Description
Returns all Task Codes and corresponding active Cost Types for project TEST-2205.

Result

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: