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

CODE

=SI.EXPANDUSERBOOKRANGE(ConnectionName, Range)

Arguments

The SI. EXPANDUSERBOOKRANGE 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 reporting Book IDs to include/exclude from the results. See Filtering Techniques for Velixo Functions.

Examples

Assuming the following configuration within Sage Intacct:

Example 1

CODE

=SI.EXPANDUSERBOOKRANGE("Sage")

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

Result

Example 2

CODE

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

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

Result

Example 3

CODE

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

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

Result