Breadcrumbs

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 

=SI.USERBOOKDESCRIPTION(
    ConnectionName, 
    BookID
)

Arguments

The SI. USERBOOKDESCRIPTION function uses the following arguments:

Argument

Required/Optional

Description

ConnectionName

Optional

Provide one of the following values:

OR

Omit the argument to return results for all compatible connections with default aggregation settings.

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:

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/Q-C5AfEfuLVpVtbXuOGIXR0KCvb5JLiZgA.png

Example 1 

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


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

Result

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/AHAzBJ3juf3lnIfMuCwHnwsBxNhzmJh0_Q.png

(cell references have been used for the arguments 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

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/2QJJ1E1cyNlJVFSjsoHbhK41zbrqUHau9g.png

(cell references have been used for the arguments 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

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/AWYw8XvF2SunCEU3qiBgB2GZUwULArSICA.png

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