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