SI.EXPANDLOCATIONSINGROUP

Overview

The SI.EXPANDLOCATIONSINGROUP function returns locations belonging to the specified group, defined within Sage Intacct.

CODE

=SI.EXPANDLOCATIONSINGROUP(
    ConnectionName, 
    GroupName,
    WithChildren
)

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 locations in group along with their children. `FALSE` by default.

CODE

=SI.EXPANDLOCATIONSINGROUP(
    "Sage"
    "LOCATIONS1"
)

Description: Returns a list of locations belonging to the LOCATIONS1 group available for the Sage connection.