You can create consolidation books that automatically convert different currencies into a single reporting currency, then run a consolidation to produce an integrated view of financial and operational results.

Setting up a new consolidation book is done in several phases:

  • Create the consolidation book, providing the book ID, reporting currency, elimination entity, dimensions, and so forth.
  • Specify the entities to consolidate.
  • Specify the elimination account for posting consolidation journal entries, including currency translation adjustments and elimination transactions for inter-entity balances.
  • Add journals for GAAP, tax, and user-defined books.
  • Override the exchange rate translation method for any GL account used in a consolidation.

You can then run the consolidation, specifying the reporting period and other choices.

In 2018 Release 2, the improved version of Global Consolidations was introduced and old functionality was deprecated. Any consolidation book now has a LEGACY parameter that indicates whether it is a new consolidation book (LEGACY=’F’) or a deprecated one. The API only supports creating and updating new consolidation books.


Get Global Consolidation Book Object Definition

lookup

List all the fields and relationships for the Global Consolidation book object:

<lookup>
    <object>GCBOOK</object>
</lookup>

Parameters

Name Required Type Description
object Required string Use GCBOOK

List Global Consolidation Books

query

List the record number and book ID for each global consolidation book:

<query>
    <object>GCBOOK</object>
    <select>
        <field>RECORDNO</field>
        <field>BOOKID</field>
    </select>
</query>

Parameters

Name Required Type Description
object Required string Use GCBOOK
select Required sequence One or more field names and an optional aggregate function such as count or sum. Returning all fields is not supported.
filter Optional object Query filter expression. Check the value of a single field using operators such as equalto/like, or multiple fields using and/or. Query fields on related objects using the dot operator (for example, VENDOR.CREDITLIMIT on APBILL).
orderby Optional object Provide an order element with a field name and choose an ascending or descending sort order, for example:
<order>
        <field>RECORDNO</field>
        <descending/>
</order>
options Optional object Set the caseinsensitive element to true for a case-insensitive query:
    <caseinsensitive>true</caseinsensitive>
In a multi-entity company, set the showprivate element to true to query data in private entities:
   <showprivate>true</showprivate>
pagesize Optional integer Custom page size between 1 and 2000 items (Default: 100)
offset Optional integer Point at which to start indexing into records (Default: 0)

List Global Consolidation Books (Legacy)

readByQuery

<readByQuery>
    <object>GCBOOK</object>
    <fields>*</fields>
    <query></query>
    <pagesize>100</pagesize>
</readByQuery>

Parameters

Name Required Type Description
object Required string Use GCBOOK
fields Optional string Comma-separated list of fields on the object to list. For best performance and predictability, limit the number of fields. To return all fields, omit the element or provide * for the value.
query Required string SQL-like query based on fields on the object. The following operators are supported: <, >, >=, <=, =, like, not like, in, not in, IS NOT NULL, IS NULL, AND, OR. Illegal XML characters must be properly encoded, and single quotes must be escaped with backslashes ('Jane\'s Deli'). Joins are not supported.
pagesize Optional integer Custom page size between 1 and 1000 items (Default: 100)

query Fields

Name Required Type Description
BSTRANMETHOD Optional string Translation method for Balance sheet accounts. Use S for Ending spot rate or A for Weighted average rate.
ISTRANMETHOD Optional string Income statement accounts. Use S for Ending spot rate or A for Weighted average rate.

Get Global Consolidation Book

read

<read>
    <object>GCBOOK</object>
    <keys>5</keys>
    <fields>*</fields>
</read>

Parameters

Name Required Type Description
object Required string Use GCBOOK
keys Required string Global consolidation book RECORDNO to get
fields Optional string Comma-separated list of fields on the object to get. For best performance and predictability, limit the number of fields. To return all fields, omit the element or provide * for the value.

Get Global Consolidation Book by Name

readByName

<readByName>
    <object>GCBOOK</object>
    <keys>gc_book</keys>
    <fields>*</fields>
</readByName>

Parameters

Name Required Type Description
object Required string Use GCBOOK
keys Required string Consolidation book BOOKID to get
fields Optional string Comma-separated list of fields on the object to get. For best performance and predictability, limit the number of fields. To return all fields, omit the element or provide * for the value.

Create Global Consolidation Book

Release Changes
2019 Release 3 Added DIMENSIONS
2019 Release 3 Added HISTORICALRATEDATETYPE

create

<create>
    <GCBOOK>
        <BOOKID>gc_book</BOOKID>
        <DESCRIPTION>Global consolidated book</DESCRIPTION>
        <CURRENCY>USD</CURRENCY>
        <CTANETASSETACCOUNTNO>1009</CTANETASSETACCOUNTNO>
        <CTANETINCOMEACCOUNTNO>1007</CTANETINCOMEACCOUNTNO>
        <BOOKSTATJOURNALSYMBOL>gc_stat</BOOKSTATJOURNALSYMBOL>
        <BOOKSTATJOURNALTITLE>Statistical journal</BOOKSTATJOURNALTITLE>
        <BSTRANMETHOD>Ending spot rate</BSTRANMETHOD>
        <ISTRANMETHOD>Weighted average rate</ISTRANMETHOD>
        <EENAME>USAE</EENAME>
        <AUTOELIMINATION>true</AUTOELIMINATION>
        <SOURCEBOOKID>ACCRUAL</SOURCEBOOKID>
        <BOOKJOURNALSYMBOL>gc_journal</BOOKJOURNALSYMBOL>
        <BOOKJOURNALTITLE>Global consolidations journal</BOOKJOURNALTITLE>
        <DIMENSIONS>location#~#department</DIMENSIONS>
    </GCBOOK>
</create>

Parameters

Name Required Type Description
GCBOOK Required object Object to create

GCBOOK

Name Required Type Description
BOOKID Required string Consolidation book ID
DESCRIPTION Required string Description
DEPARTMENTID Optional string Default department
BOOKJOURNALSYMBOL Required string Book journal symbol. Use 16 characters or fewer.
BOOKJOURNALTITLE Required string Book journal title. Use 40 characters or fewer.
BOOKSTATJOURNALSYMBOL Required string Default statistical journal symbol. Use 16 characters or fewer.
BOOKSTATJOURNALTITLE Optional string Statistical journal title. Use 40 characters or fewer.
BUDGETID Optional string Budget ID
BSTRANMETHOD Required string Translation method for balance sheet accounts, typically Ending spot rate.
ISTRANMETHOD Required string Translation method for income statement accounts, typically weighted average.
SOURCEBOOKID Optional string Accounting method to use. Use ACCRUAL or CASH. CASH is available only if you selected both Accrual and cash as your accounting method in your General Ledger Setup.
CURRENCY Required string Currency code to use in reporting
EXCHRATETYPE Optional string Exchange rate type. Use Intacct Daily Rate.
CTANETASSETACCOUNTNO Required string Net income account number for currency exchange gain/loss
CTANETINCOMEACCOUNTNO Required string Net assets account number for currency exchange gain/loss
EENAME Required string Elimination entity name
AUTOELIMINATION Optional boolean Inter-entity auto-elimination, which automatically posts inter-entity eliminations to the elimination accounts. Use true to use auto elimination, false otherwise. (Default: false)
HISTORICALRATEDATETYPE Optional string Selects the historical rate date option. Use LINELEVELDATE for line level exchange rate date or TRANSACTIONDATE for the transaction date. (Default: LINELEVELDATE)
DIMENSIONS Optional string Dimensions to include in the consolidation. Implode multiple ID’s with #~# (Default: location).

Update Global Consolidation Book

Release Changes
2019 Release 3 Added DIMENSIONS
2019 Release 3 Added HISTORICALRATEDATETYPE

Note that after running a consolidation, the ability to change book setup is largely limited to adding new data, such as a completely new account. You can also modify which dimensions are included.

<update>
    <GCBOOK>
        <BOOKID>gc_book</BOOKID>
        <DESCRIPTION>gc consolidated book with more stuff, etc.</DESCRIPTION>
        <BUDGETID>Std_Budget</BUDGETID>
    </GCBOOK>
</update>

Parameters

Name Required Type Description
GCBOOK Required object Object to update

GCBOOK

Name Required Type Description
BOOKID Required string Consolidation book ID
DESCRIPTION Optional string Description
DEPARTMENTID Optional string Default department
BOOKJOURNALSYMBOL Optional string Book journal symbol. Use 16 characters or fewer.
BOOKJOURNALTITLE Optional string Book journal title. Use 40 characters or fewer.
BOOKSTATJOURNALSYMBOL Optional string Default statistical journal symbol. Use 16 characters or fewer.
BOOKSTATJOURNALTITLE Optional string Statistical journal title. Use 40 characters or fewer.
BUDGETID Optional string Budget ID
BSTRANMETHOD Optional string Translation method for balance sheet accounts, typically Ending spot rate.
ISTRANMETHOD Optional string Translation method for income statement accounts, typically weighted average.
SOURCEBOOKID Optional string Accounting method to use. Use ACCRUAL or CASH. CASH is available only if you selected both Accrual and cash as your accounting method in your General Ledger Setup.
CURRENCY Optional string Currency code to use in reporting
EXCHRATETYPE Optional string Exchange rate type. Use Intacct Daily Rate.
CTANETASSETACCOUNTNO Optional string Net income account number for currency exchange gain/loss
CTANETINCOMEACCOUNTNO Optional string Net assets account number for currency exchange gain/loss
EENAME Optional string Elimination entity name
AUTOELIMINATION Optional boolean Inter-entity auto-elimination, which automatically posts inter-entity eliminations to the elimination accounts. Use true to use auto elimination, false otherwise.
HISTORICALRATEDATETYPE Optional string Selects the historical rate date option. Use LINELEVELDATE for line level exchange rate date or TRANSACTIONDATE for the transaction date.
DIMENSIONS Optional string Dimensions to include in the consolidation. Implode multiple ID’s with #~#. The set of dimensions you provide replace the previous set of dimensions.

Delete Global Consolidation Book

delete

<delete>
    <object>GCBOOK</object>
    <keys>112</keys>
</delete>

Parameters

Name Required Type Description
object Required string Use GCBOOK
keys Required string GCBOOK RECORDNO to delete

Provide feedback