SI.EXPANDUSERBOOKRANGE

Overview

The SI.EXPANDUSERBOOKRANGE function returns the list of the Book ID field of all reporting books defined on the User-defined books form in Sage Intacct.

Syntax

=SI.EXPANDUSERBOOKRANGE(
    ConnectionName, 
    Range
)

Arguments

The SI. EXPANDUSERBOOKRANGE 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.

Omit the argument to return results for all compatible connections with default aggregation settings.

Range

Optional

A filter of one or more reporting Book IDs to include/exclude from the results. See Filtering Techniques for Velixo Functions.

Examples

Assuming the following configuration within Sage Intacct:

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

Example 1

=SI.EXPANDUSERBOOKRANGE(
    "Sage"
)

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

Result

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

Example 2

=SI.EXPANDUSERBOOKRANGE(
    "Sage",
    "*;-Contracts"
)

Description
Returns the name of all user-defined reporting books defined in Sage Intacct except the "Contracts" book.

Result

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

Example 3

=SI.EXPANDUSERBOOKRANGE(
    "Sage",
    "*;-Co??"
)

Description
Returns the name of all user-defined reporting books defined in Sage Intacct except those starting with "Co"

Result

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