SI.EXPANDSTANDARDCOSTTYPERANGE

Overview

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

Syntax

CODE

=SI.EXPANDSTANDARDCOSTTYPERANGE(Connection, Range, IncludeInactive)

Arguments

The SI. EXPANDSTANDARDCOSTTYPERANGE function uses the following arguments:

Argument	Required/ Optional	Description
`ConnectionName`	Required	The name of the connection as configured in the Connection Manager
`Range`	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. (available in version 2023.8 and higher)

Examples

Assuming the following configuration within Sage Intacct:

Example 1

CODE

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

Description
Returns all cost types configured within Sage Intacct

Result

Example 2

Assuming the following configuration within Sage Intacct:

CODE

=SI.EXPANDSTANDARDCOSTTYPERANGE("Sage",,FALSE)

Description
Returns all active cost types configured within Sage Intacct

Result

The inactive cost type BUR is not included

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: