Running Prepare Intercompany Eliminations

Open the Prepare Intercompany Eliminations page.

Select the period range for the intercompany data to be processed.

Select one version for the intercompany data to be processed.

Select the Intercompany Eliminations journals to process. The journal definitions define the accounts to be adjusted. To show in the list, a journal’s periodicity, effective life, and version must correspond with the selected period range and version. If you change the default settings for period/year and version, click Update Journal List to show the journals applicable to the new selection. If necessary, a scroll bar is available for the journal list, which shows five journals at a time.

After selecting a journal, you can select a tolerance or combination of tolerances to define what transaction sets are within (a match) or outside (a mismatch) of the specified tolerance. Base tolerance on (1) a percent tolerance, (2) a fixed amount tolerance, (3) a percent AND a fixed amount tolerance, or (4) a percent OR a fixed amount tolerance.

Select the Select All Journals check box to select all journals. To select journals individually, select the check box in the Include column.
In the Tolerance % box, specify a value between 0 and 100.
Leave the operator field blank (default) or select AND or OR from the list. If you specify only one tolerance, leave the operator field blank. If you specify both types of tolerances, you must select either AND or OR.
In the Amount box, specify a positive, whole number if you want to define a fixed amount tolerance. The amount specified is associated with the selected currency.

Click the underlined dimension names to select the desired dimension members.

Select one consolidation unit. When the journal data is created, it includes the transactions (if any) for the leaf units that belong to the selected consolidation unit.
Select one or more custom dimension members. We recommend selecting only the leaf members where intercompany data has been specified or loaded.
Selecting a parent member as Self automatically includes the implied descendants in the journal data generation. The report only displays the parent member. To avoid duplicate members being included in the journal data generation, do not select a parent member and any of its descendants.

Select the currencies that are used during consolidation.

Select the rate set to use during consolidation. This rate set is used when translating local currency to the currencies selected in step 6.

In the Journal Options, select one of these options to create and/or approve journals:

Option	Description
Create Work-In-Process Journals	Creates data for the selected journals with a work-in-process status. These journals are not posted during a consolidation.
Create and Approve Journals	Creates data for the selected journals with an approved status. These journals are posted during a consolidation.
Approve Existing Journals	Does not create new journals but approves existing work-in-process journals previously created. Use this option when you are certain the intercompany data did not change since you last reviewed the Intercompany Elimination Journal Analysis report.
Report Only	Regenerates a previous report without rerunning the Prepare Intercompany Eliminations process. This re-generated report uses previous tolerance settings, not the settings currently displayed on the page. In addition, the report does not display the journal status (Working or Approved) in the report header. This is for previously created journals and tolerance settings.

Click Options.

Option	Description
Create Eliminations Report	Creates the Intercompany Elimination Journal Analysis report after creating the journals. The report can only be prepared at the time journal data is created, not when approving existing journals. If creating a report, select at least one of these options: Display Category/Other Dimensions displays custom dimension members associated with the intercompany transactions. If this option is not selected and data exists for more than one custom dimension member, adjustments to different custom dimension members can appear to be duplicate adjustments on the report. Display Within Tolerance separately displays intercompany transactions that will be eliminated with no remainder because they fall within the specified tolerance. Display Outside Tolerance separately displays intercompany transactions that will be eliminated with a remainder because they fall outside the specified tolerance. Display With Equity or Investment Units separately displays transactions for a specifying unit when the affiliated unit is considered an investment or equity company for the selected period and version. Display Not Eliminated separately displays transactions that will not be eliminated because the affiliated unit is not within the scope of the journal. Round to number Decimal Places displays database amounts on the report that are rounded to the specified number of decimal places.
Create Local IC Adjustments	Creates local Intercompany Eliminations journal data for elimination units. Seconds Between Progress Updates causes the status on the progress meter to update at regular intervals, according to the specified number of seconds, while the journal data is being prepared. The default is 2 seconds.

Option

Description

Create Eliminations Report

Creates the Intercompany Elimination Journal Analysis report after creating the journals. The report can only be prepared at the time journal data is created, not when approving existing journals. If creating a report, select at least one of these options:

Display Category/Other Dimensions displays custom dimension members associated with the intercompany transactions. If this option is not selected and data exists for more than one custom dimension member, adjustments to different custom dimension members can appear to be duplicate adjustments on the report.

Display Within Tolerance separately displays intercompany transactions that will be eliminated with no remainder because they fall within the specified tolerance.

Display Outside Tolerance separately displays intercompany transactions that will be eliminated with a remainder because they fall outside the specified tolerance.

Display With Equity or Investment Units separately displays transactions for a specifying unit when the affiliated unit is considered an investment or equity company for the selected period and version.

Display Not Eliminated separately displays transactions that will not be eliminated because the affiliated unit is not within the scope of the journal.

Round to number Decimal Places displays database amounts on the report that are rounded to the specified number of decimal places.

Create Local IC Adjustments

Creates local Intercompany Eliminations journal data for elimination units.

Seconds Between Progress Updates causes the status on the progress meter to update at regular intervals, according to the specified number of seconds, while the journal data is being prepared. The default is 2 seconds.

Click Prepare Eliminations. If the Create Eliminations Report option is selected on the Prepare Intercompany Eliminations page, the Intercompany Elimination Journal Analysis report automatically opens after the process completes. The report displays the new journal data. This report is described in detail in the "Reports" chapter.

For approved journals, run a consolidation to post and roll up the Intercompany Eliminations journal data to eliminate the intercompany data. Ensura that the consolidation scope encompasses all the intercompany data for your organization.