SI.CONSOLIDATIONBOOKDESCRIPTION
Created by Damien Zwillinger, Modified on Thu, 5 Oct, 2023 at 9:27 PM by Damien Zwillinger
Applies to:
- Velixo NX
- Sage Intacct
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
SI.CONSOLIDATIONBOOKDESCRIPTION(ConnectionName, BookID)
Parameters
The SI. CONSOLIDATIONBOOKDESCRIPTION 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 consolidation book for which a description is to be displayed. |
Examples
Example 1
=SI.CONSOLIATIONBOOKDESCRIPTION("Sage", A2)Description
Returns the description of the Consolidation Book whose ID is displayed in cell A2.
Result
Example 2
=SI.CONSOLIATIONBOOKDESCRIPTION("Sage", A2#)Description
Returns the description of the Consolidation Books whose IDs are displayed by the array function in cell A2.
Result
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article