SI.EXPANDSTANDARDTASKRANGE function

Created by Damien Zwillinger, Modified on Mon, 10 Jun, 2024 at 6:45 PM by Harry Lewis

Applies to:

Velixo NX
Sage Intacct

TABLE OF CONTENTS

Syntax
Parameters
Examples

The SI.EXPANDSTANDARDTASKRANGE function returns an array of all Standard (as opposed to project-scoped) tasks available in the Standard task catalog within the Sage Intacct Project area:

Syntax

SI.EXPANDSTANDARDTASKRANGE(Connection, Range, IncludeInactive)

Parameters

The SI.EXPANDSTANDARDTASKRANGE function uses the following parameters:

Parameter	Required/Optional	Description
Connection	Required	The name of the connection as configured in the Connection Manager
Range	Optional	The range of standard tasks to include in the results. See our article on including multiple parameter values
IncludeInactive	Optional	Boolean (True/False) value determining whether or not Standard Tasks marked as Inactive are included in the results. Available values: TRUE (Default) FALSE

Examples

Example 1

=SI.EXPANDSTANDARDTASKRANGE("Sage")

Description

Returns a list of all standard (as opposed to project-scoped) tasks (cost codes).

Result

Example 2

=SI.EXPANDSTANDARDTASKRANGE("Sage","100:300")

Description

Returns all Standard Tasks within the range of 100 through 300 (inclusive).

Result

Example 3

=SI.EXPANDSTANDARDTASKRANGE("Sage","*;-200")

Description

Returns all Standard Tasks except code #200

Result

Example 4

=SI.EXPANDSTANDARDTASKRANGE("Sage")

Description

Returns all ACTIVE Standard Tasks:

Result

(Inactive task #200 is not included)