SI.EXPANDCONSOLIDATIONBOOKRANGE

Overview

The SI.EXPANDCONSOLIDATIONBOOKRANGE function returns a list of Book ID field values that are located on the Global Consolidation books form in Sage Intacct.

Syntax

CODE

=SI.EXPANDCONSOLIDATIONBOOKRANGE(ConnectionName, Range, IncludeInactive)

Arguments

The SI. EXPANDCONSOLIDATIONBOOKRANGE function uses the following argument:

Argument	Required/Optional	Description
`ConnectionName`	Required	The name of the connection as configured in the Connection Manager
`Range`	Optional	A filter of one or more consolidation reporting Book IDs to include/exclude from the results. See Filtering Techniques for Velixo Functions.
`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)

Example

Assuming the following configuration within Sage Intacct:

Example 1

CODE

=SI.EXPANDCONSOLIDATIONBOOKRANGE("Sage")

Description
Returns the name of all Consolidation reporting books defined in Sage Intacct:

Result

Global
NA
Non-US
Test book

Example 2

CODE

=SI.EXPANDCONSOLIDATIONBOOKRANGE("Sage","*;-Test book")

Description
Returns the name of all Consolidation reporting books defined in Sage Intacct, except the Test book

Result

Example 3

CODE

=SI.EXPANDCONSOLIDATIONBOOKRANGE("Sage","N?")

Description

Returns the name of all Consolidation reporting books defined in Sage Intacct, for which the name starts with the letter N

Result

Example 4

Assuming this configuration within Sage Intacct:

CODE

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

Description
Returns the names of all active Consolidation reporting books defined in Sage Intacct.

Result