CREATE CONSOLIDATION ENTRIES

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

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.

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.

Options

Receiving Location

Code

Enter, or click  to select, a receiving location code. Only active location codes are available for selection. The home location of your login company is not available.

For Multicurrency users, Costpoint uses the currency code linked to the receiving locations to convert the sending location's functional currency.

Ending Fiscal Year and Period

Fiscal Year

Enter, or click  to select, the fiscal year for which you want this consolidation entry to be created.

Period

Enter, or click  to select, the period for which you want this consolidation entry to be created. Costpoint uses the last subperiod of this period to create the consolidation entry.

Output

This group box is enabled only if the receiving location is external.

File Name

Enter a file name for the output file.

File Location

Enter, or click  to select, the alternate file location where you want the file stored. Alternate file locations are set up on the Manage Alternate File Locations screen.

Create/update mapping explosion

Select this check box to create the individual account/organizations from the wildcards entered on the Manage Consolidation Acct/Org Mappings screen. Select this check box any time you:

Currency Conversion

From

This non-editable field displays the sending company's functional currency.

To

This non-editable field displays the receiving company's functional currency.

Subtask

Description

Exchange Rates

Click this link to open the Exchange Rates subtask, on which you can review the currency and rates Costpoint uses to convert the sending company's functional currency to the receiving company's functional currency. 

This link is enabled only if the From and To currencies are different.

Historical or weighted average historical rates from the RT_BY_PD table do not display in this screen. By default, stockholders' equity accounts are translated using historical exchange rates; you can enter equity account overrides on the Manage Consolidation Equity Accounts Override screen.