Defining Elimination Sets
The elimination set defines a related group of intercompany accounts. When eliminated, the balances of this group of accounts should normally net to zero. To maintain a balanced journal entry, the system posts any amounts that remain after the elimination to a user-defined out-of-balance ChartField. When you run the consolidation, the system processes each elimination set specified in your consolidation definition.
To define elimination sets, use the Elimination Sets component (ELIMINATION_SET).
|
Page Name |
Definition Name |
Usage |
|---|---|---|
|
ELIMINATION_SET1 |
Define parameters for the elimination. |
|
|
ELIMINATION_SET2 |
Define which accounts you want to eliminate. When you define these accounts, the level of detail required depends on whether you are using the Affiliate ChartField. |
|
|
RUN_GLS2005 |
Set up criteria to run the GLS2005 SQR for auditing elimination sets. Determines if any duplicate lines exist in consolidation definitions. The system uses the criteria that you enter to generate the Audit Elimination Sets report. |
Use the Elimination Set page (ELIMINATION_SET1) to define parameters for the elimination.
Navigation:
This example illustrates the fields and controls on the Elimination Set page. You can find definitions for the fields and controls later on this page.
Field or Control |
Description |
|---|---|
Ledger Template |
Select the ledger template that is used by the ledgers in your consolidation. If you specify a Summary Ledger template as the ledger template, the system displays the Ledger field, where you enter the summary ledger name. The system also displays a detail link; click it to access the Summary Ledger Definition page. |
Description |
Identifies the elimination for prompt lists. |
Comments |
Describe what the elimination set does. This field is particularly useful for documenting each set in a complex consolidation. |
Field or Control |
Description |
|---|---|
Entity Field |
Select the field on which you are consolidating. This is the field on which you have previously structured your consolidation and on which you have built your consolidation tree. It is usually the business unit. However, if you have setup your system to use other fields, such as Operating Unit or Department for the business entity and are tracking interunit transactions among these entities, you use Operating Unit or Department as the Entity Field. |
Out of Balance Debit and Out of Balance Credit
If the activity within a given elimination set does not net to zero, PeopleSoft General Ledger directs the out-of-balance amount to the Out of Balance field values that you specify on this page.
Field or Control |
Description |
|---|---|
Field Name |
Specify special ChartFields for the out-of-balance amounts. For example, you can enter a department for both the debit and credit field name in addition to an account Value. For summary ledger templates, the Field Name prompt lists all the ChartFields for the summary ledger template, and the Value prompt is based on how the summary ledger is defined. |
Use the Elimination Lines page (ELIMINATION_SET2) to define which accounts you want to eliminate.
When you define these accounts, the level of detail required depends on whether you are using the Affiliate ChartField.
Navigation:
This example illustrates the fields and controls on the Elimination Lines page. You can find definitions for the fields and controls later on this page.
Field or Control |
Description |
|---|---|
Match Affiliate Value |
Select the check box if you use the Affiliate approach for elimination. For a summary ledger that does not have an Affiliate ChartField, the Match Affiliate Value check box is deselected and display-only. |
Values to Eliminate
Field or Control |
Description |
|---|---|
Field and Value |
When each intercompany transaction is recorded in a unique account, the Business Unit and the Account or ALTACCT ChartField and their respective values are required. If you use the Affiliate ChartField, and its respective value is already a business unit, do not enter the Business Unit ChartField. The system evaluates business unit and affiliate relationships when you perform the consolidation based on data in the ledger. In addition to the Account or ALTACCT ChartField, you can specify other ChartFields to further narrow the scope of the transaction being eliminated. This applies regardless of which method you use for tracking intercompany activity. To prevent duplication, the system does not allow you to enter the same ChartFields and ChartField values within the same elimination line. |
Use the Audit Elimination Sets page (RUN_GLS2005) to set up criteria to run the GLS2005 SQR for auditing elimination sets.
Determines if any duplicate lines exist in consolidation definitions. The system uses the criteria that you enter to generate the Audit Elimination Sets report.
Navigation:
This example illustrates the fields and controls on the Audit Elimination Sets page. You can find definitions for the fields and controls later on this page.
Report Request Parameters
Field or Control |
Description |
|---|---|
SetID |
SetID for the consolidation set. |
Consolidation Set |
Select the Consolidation Set for which you want to run the elimination set audit. |
As of Date |
Enter the point of reference date for the effective-dated setup information. |