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

=SI.EXPANDCONSOLIDATIONBOOKRANGE(
    ConnectionName, 
    Range, 
    IncludeInactive
)

Arguments

The SI. EXPANDCONSOLIDATIONBOOKRANGE function uses the following argument:

Argument	Required/Optional	Description
`ConnectionName`	Optional	Provide one of the following values: Connection name as defined in Connection Manager. Velixo range expression defining a set of connection names. An array of settings as described in the Multiple connections per formula article. We recommend using the VX.SETTINGS function to construct the array. OR Omit the argument to return results for all compatible connections with default aggregation settings.
`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:

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/v2uiNzOuEQvlXqvlHJcPuzS2cZWwUXsuLQ.png

Example 1

=SI.EXPANDCONSOLIDATIONBOOKRANGE(
    "Sage"
)

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

Result

Global
NA
Non-US
Test book

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/APRO5iESTanP55pDlMnIIUx4MyD_MIfAqw.png

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

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/L4pAq3OR3tFUPz9P-ki0-kUJnfYsbwonug.png

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

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/JMpfl_Czh8xjeIPp1-KOddS5B8oBcseg9A.png

Example 4

Assuming this configuration within Sage Intacct:

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/8ZUyYbd-ss0fwz2qxRqnjvEGwZfgVSO8hA.png

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

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

Result

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/qxIQsdW3yPM4qP3HaN7mio4inlyl6oWU2g.png