Create Consolidation Entries

Use this screen to create the consolidation entry. This creates the transfer entry in the performing consolidation company.

Note: For Multicurrency users, this process converts the sending company's functional currency to the receiving company's functional currency.

Beginning in FS_ SUM (a Costpoint General Ledger table), Costpoint summarizes costs by account/organization for the fiscal year selected up to and including the period you select.

If you select Inception-To-Date as the Consolidation Calculation Method on the Configure Consolidation Settings screen, the process includes the beginning balances from prior years, which are located in the BEG_AMT column in the FS_SUM table. This process happens regardless of the S_ACCT_TYPE_CD in the ACCT table (the beginning balance for income statement accounts is zero).

Next, Costpoint verifies that the entry is balanced and complete. All accounts must be transferred. This includes both balance sheet and income statement accounts. If you mapped all accounts to consolidation account/organizations, this entry always balances or nets to zero.

You cannot transfer unbalanced entries. If the entry does not balance, Costpoint compares the account/organizations from the FS_ SUM table with the subset of account/organizations from the entry you tried to create. The difference between the two represents account/organizations that are not mapped to consolidation account/organizations. Costpoint prints these account/organizations and their respective balances on an exception report.

If the entry is out of balance, you must map the missing account/organizations to the consolidation account/organizations and start the process over.

Costpoint generates the consolidation entry in the form of a journal entry. The entry contains header information such as the location performing the transfer, the entry number, user ID, and date of creation and description. The lines contain the consolidation account/organizations and amounts for transfer. Depending on whether the transfer is internal or external, Costpoint either creates the consolidation entry directly in the receiving company or in a file that you can upload and post.

Use this screen after completing the Link Consolidation Locations screen and before completing the Manage Consolidation Transfer History screen.