NEW!

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, 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.


List Global Consolidation Books

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. Illegal XML characters must be properly encoded. The following SQL operators are supported: <, >, >=, <=, =, like, not like, in, not in. When doing NULL comparisons: IS NOT NULL, IS NULL. Multiple fields may be matched using the AND and OR operators. Joins are not supported. Single quotes in any operands must be escaped with a backslash - For example, the value Erik's Deli would become 'Erik\'s Deli'.
pagesize Optional integer Custom page size between 1 and 1000 items (Default: 100)

query

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

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>
    </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)

Update Global Consolidation Book

Note that after running a consolidation, the ability to change book setup is limited to adding new data, such as a completely new account.

<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.

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