SI.EXPANDUSERBOOKRANGE

Created by Damien Zwillinger, Modified on Thu, 5 Oct, 2023 at 5:49 PM by Gabriel Michaud

Applies to:

Velixo NX
Sage Intacct

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.

TABLE OF CONTENTS

Syntax
Example

Syntax

SI.EXPANDUSERBOOKRANGE(ConnectionName, Range)

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

Example

Assuming the following configuration within Sage Intacct:

Example 1

=SI.EXPANDUSERBOOKRANGE("Sage")

Description

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

Result

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

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