SI.CONSOLIDATIONBOOKDESCRIPTION

Overview

The SI.CONSOLIDATIONBOOKDESCRIPTION function (formerly SI.GLOBALCONSOLIDATIONBOOKDESCRIPTION) returns the Description field of a specified global reporting book as defined on the Consolidation books form within Sage Intacct.

Syntax

CODE

=SI.CONSOLIDATIONBOOKDESCRIPTION(
    ConnectionName, 
    BookID
)

Arguments

The SI. CONSOLIDATIONBOOKDESCRIPTION function uses the following arguments:

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 consolidation book for which a description is to be displayed.

Examples

Example 1

CODE

=SI.CONSOLIATIONBOOKDESCRIPTION(
    "Sage", 
    A2
)

Description
Returns the description of the Consolidation Book whose ID is displayed in cell A2.

Result

Example 2

CODE

=SI.CONSOLIATIONBOOKDESCRIPTION(
    "Sage", 
    A2#
)

Description
Returns the description of the Consolidation Books whose IDs are displayed by the array function in cell A2.

Result