Skip to main content
Skip table of contents

SI.EXPANDCONTRACTSINGROUP

Overview

The SI.EXPANDCONTRACTSINGROUP function returns contracts belonging to the specified group, defined within Sage Intacct.

Syntax

CODE
=SI.EXPANDCONTRACTSINGROUP(
    ConnectionName, 
    GroupName,
    WithChildren
)

Arguments

Argument

Required/Optional

Description

ConnectionName

Required

The name of the connection, as specified in the Connection Manager

GroupName

Required

Dimension group name, as visible in the Sage Intacct interface.

WithChildren

Optional

When set to TRUE, return contracts in group along with their children.

FALSE by default.

Examples

Return all objects

CODE
=SI.EXPANDCONTRACTSINGROUP(
    "Sage"
    "CONTRACTS1"
)

Description: Returns a list of contracts belonging to the CONTRACTS1 group available for the Sage connection.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.