SI.USERBOOKDESCRIPTION

Created by Damien Zwillinger, Modified on Wed, 30 Aug, 2023 at 2:43 AM by Damien Zwillinger

Applies to:

Velixo NX
Sage Intacct

The SI.USERBOOKDESCRIPTION function returns the Description field of a specified reporting book as defined on the User-defined books page within Sage Intacct.

TABLE OF CONTENTS

Syntax
Parameters
Examples

Syntax

SI.USERBOOKDESCRIPTION(ConnectionName, BookID)

Parameters

The SI. USERBOOKDESCRIPTION function uses the following parameters:

Parameter	Required/Optional	Description
ConnectionName	Required	The name of the connection as configured in the Connection Manager
BookID	Required	The Book ID value of the reporting book for which a description is to be displayed.

Examples

Assuming the following configuration within Sage Intacct:

Example 1

=SI.USERBOOKDESCRIPTION("Sage","Cmtmt Rev")

Description

Returns the description of the user-defined reporting book whose Book ID is "Cmtmt Rev".

Result

(cell references have been used for the parameters in this example)

Example 2

=SI.USERBOOKDESCRIPTION("Sage",B2:B3)

Description

Returns the description fields for the user-defined reporting books whose Book ID fields are shown in cells B2 through B3.

Result

(cell references have been used for the parameters in this example)

Example 3

=SI.USERBOOKDESCRIPTION("Sage",B2#)

Description

Returns the description fields for the user-defined reporting books whose Book ID fields are displayed by the array function in cell B2.

Result

(cell references have been used for the parameters in this example)