UPDATE CONSOLIDATION BEGINNING BALANCES
Use this screen to update the inception-to-date beginning balances for the balance sheet accounts and compress income statement accounts into current year retained earnings. This screen creates a new record in Manage Consolidation Transfer History.
You need to complete this process for each new fiscal year in a receiving location as per the selection criteria. For balance sheet accounts, this process brings forward the balances from the selected fiscal year to the new fiscal year. In the new fiscal year, income statement account balances from the selected fiscal year are compressed in the current year retained-earnings account/org. Set the Current Year Retained Earnings account/org setting on the Manage Consolidation Account/Org Mappings screen.
This screen is accessible only if you set the Consolidation Calculation Method option to Inception-To-Date on the Configure Consolidation Settings screen. You should execute this process after you run the Update General Ledger Beginning Balances screen and before you run the Create Consolidation Entries screen in the new fiscal year.
You must manually enter initial balances for the first fiscal year.
Following the accounting rule that income statement accounts are mapped to consolidated income statement accounts and balance sheet accounts are mapped to consolidated balance sheet accounts, Costpoint performs the following steps during this process:
-
Inserts a new row/record in the Consolidation Transfer History (CONS_XFR_HS) table for each receiving location selected on the screen. The fiscal year for the new record is the next sequential year after the year selected on the screen. This year displays automatically in the Fiscal Year To Be Updated field and is non-editable. The new record period is 0.
-
Costpoint brings forth the balance sheet accounts by selecting the latest consolidation period for the fiscal year. This amount is the period "zero" amount for the Fiscal Year To Be Updated.
The application, similar in functionality to the Update General Ledger Beginning Balances screen, updates the consolidation beginning balances, which are considered to be the very first period in the new fiscal year. In the Consolidation Transfer History (CONS_XFR_HIS) table, the amount of the balance is recorded as the period "zero." The current period activity is the last consolidation entry created.
-
Sums up income statement accounts into the Current Year Retained Earnings Account entered on the Manage Consolidation Account/Org Mappings screen.
-
Sums the amounts from the latest consolidation period across all income statement accounts. This amount is the period "zero" amount for the retained earnings account for the Fiscal Year To Be Uploaded.
The application, similar in functionality to the Update General Ledger Beginning Balances screen, updates the consolidation beginning balances, which are considered to be the very first period in the new fiscal year. In the Consolidation Transfer History (CONS_XFR_HIS) table, the amount of the balance is recorded as the period "zero." The current period activity is the last consolidation entry created.
The retained earnings account/org is the consolidation/org from the mapping line for the Current Year Retained Earnings row in the mapping screen.
This screen is the final step in the consolidations process. After the process is complete, you can manually transfer the Current Year Retained Earnings amount to the appropriate Prior Year Retained Earnings row in the new fiscal year record of the Manage Consolidation Transfer History screen. The Prior Year Retained Earnings row in the history should match the row in the mapping. You must perform this step before you create new consolidation entries in the new fiscal year.
Because Consolidation Transfer History has a separate record for each sending location/receiving location/fiscal year, you can rerun the Update Consolidation Beginning Balances screen as often as needed.
Location
Identification
Use the fields in this block to create a new parameter ID or to retrieve
a previously saved parameter ID. A parameter ID represents a set of screen
selection parameters. After you have saved a parameter ID and its related
parameters, you can retrieve them using Query.
You can use the retrieved parameters to produce reports and run processes
more efficiently and with greater consistency. The saved parameters are
also useful and necessary when you want to run the process as part of
a batch job. Many users save a unique set of parameters for each different
way they run a report or process. When you select a previously saved parameter
ID or parameter description, the associated saved screen selection parameters
automatically display as selection defaults. The page setup and print
options are also included in the saved parameter ID if there are any.
You can change any of the associated selection defaults as necessary.
Parameter ID
Enter, or click 
to select, a parameter
ID of up to 15 alphanumeric characters. Choose characters for your parameter
ID that help identify the type of selections you made in the screen, such
as PERIOD or QUARTERLY.
When you save your record, all the selections made in the screen are
stored with the parameter ID. Later, you can retrieve the parameter using
Query.
You can use the parameter to run the process more efficiently because
you can select the parameter ID with its previously defined screen selections.
After the default selections display in the screen, you can override the
defaults.
Description
Enter, or click to select, a parameter
description of up to 30 alphanumeric characters.
Selection Ranges
Range Option
Select a range option for the receiving locations.
-
All — When you select this option, the Start and End fields are disabled.
-
One — When you select this option, the Start field is disabled.
-
Range — Enter a range using the Start and End fields.
-
From Beginning — When you select this setting, the Start field is disabled. You must enter an ending sending location in the End field.
-
To End — When you select this setting, the End field is disabled. You must enter a beginning sending location in the Start field.
Start
Enter, or click
to select, the starting receiving location. When you select All or From Beginning in the Range Option field, this field is inactive.
End
Enter, or click to select, the ending receiving location. When you select All, One, or To End in the Range Option field, this field is inactive.
Fiscal Year Option
Fiscal Year
Enter, or click to select, the fiscal year for which you want to run this utility.
Fiscal Year to be Updated
Costpoint automatically displays the next sequential year in this non-editable field.