SI.USERBOOKDESCRIPTION

Overview

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

Syntax

CODE

=SI.USERBOOKDESCRIPTION(ConnectionName, BookID)

Arguments

The SI. USERBOOKDESCRIPTION function uses the following arguments:

Argument	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

CODE

=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 arguments in this example)

Example 2

CODE

=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 arguments in this example)

Example 3

CODE

=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 arguments in this example)