SI.EXPANDCONSOLIDATIONBOOKRANGE

Created by Damien Zwillinger, Modified on Thu, 5 Oct, 2023 at 9:26 PM by Damien Zwillinger

Applies to:

Velixo NX
Sage Intacct

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

TABLE OF CONTENTS

Syntax
Example

Syntax

SI.EXPANDCONSOLIDATIONBOOKRANGE(ConnectionName, Range, IncludeInactive)

The SI. EXPANDCONSOLIDATIONBOOKRANGE function uses the following parameter:

Parameter	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

=SI.EXPANDCONSOLIDATIONBOOKRANGE("Sage")

Description

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

Result

Global

Non-US

Test book

Example 2

=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

=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:

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

Description

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

Result