Creating Eliminating Entries
Use General Ledger's standard journal entry functions to create eliminating entries in your parent set of books. You can also use GL Desktop Integrator's Journal Wizard to create eliminating entries (See: Oracle General Ledger Desktop Integrator User's Guide).
Optionally, you can use the Global Consolidation System to create elimination sets, which are a variation of General Ledger's recurring journals. With elimination sets, you can define eliminating entries that repeat every accounting period.
Creating Elimination Sets
Define an eliminating entry by first creating an elimination set. Your set can contain a single elimination entry, or you can group related entries into the same elimination set.
To create an elimination set:
1. Navigate to the Consolidation Workbench window.
2. Choose the Eliminate button from the State Controller. The Generate Eliminations window appears, showing all of the elimination sets you have defined for your parent.
3. Choose the Elimination Set button. The Elimination Sets window appears
4. Enter a Name and optional Description for the elimination set.
5. If you want to copy entries from an existing elimination set to your new set, choose the AutoCopy button.
6. Create eliminating journal entries for the set. If you copied entries, modify them, if necessary.
8. Generate your eliminating journals.
9. Review and post your eliminating journals.
Creating Eliminating Journal Entries
Elimination entries are comprised of individual lines that use recurring journal formulas. These formulas can be simple or complex. Each formula can use fixed amounts and/or account balances, including standard, end-of-day, or average balances, actual or budget amounts, statistics, and period-to-date or year-to-date balances from the current period, prior period, or same period last year. You can quickly create new recurring formulas by copying and modifying existing formulas.
To create an eliminating journal entry for an elimination set:
1. From the Elimination Sets window, enter a Name for the Elimination Entry.
2. Enter the Category and Currency for the entry.
3. Enter a range of Effective Dates that includes only those periods for which you want the eliminating entry to be used.
Attention: Eliminating journal entries will only be created when you choose to generate them for a date that falls within the Effective Dates range.
4. Choose the Lines button to enter the account you want General Ledger to update when you generate your eliminating journals, as well as the formula to use.
Entering Eliminating Journal Entry Lines
You can define an unlimited number of journal entry lines for each eliminating journal entry. The journal entry lines specify the accounts to update with the eliminating journals. Each line also contains the amount to post to the designated account, or a formula to calculate the journal amounts.
To enter an eliminating journal entry line:
1. From the Elimination Sets window, enter or query the elimination set name and the journal entry name.
2. Choose the Lines button. The Elimination Lines window appears.
3. Enter a Line number to set the order of your eliminating journal entry lines. You can indicate an automatic offsetting line for your eliminating journal entry by entering the line number 9999.
4. Enter the Account you want General Ledger to update when you generate and post your eliminating journals.
5. Enter an optional Line Description.
6. Enter a Formula for the line.
7. Enter the remaining lines for the eliminating journal entry. Remember that you can use line number 9999 as the automatic offsetting line for each eliminating journal entry.
You can enter an eliminating journal entry line and have General Ledger calculate and insert the balancing amount for the eliminating journal entry automatically. This is useful for allocation-type entries.
1. Enter one or more lines for the eliminating journal entry.
2. Enter 9999 as the line number for the automatic offsetting line.
3. Enter an Account for the line, but do not enter a formula. General Ledger will automatically calculate the amount for this journal entry line when you generate your eliminating journal.
Generating Eliminating Journals
You must generate eliminating journals to create unposted journal batches from the eliminating journal formulas you defined. After generating the formulas, you can review or edit the eliminating journal batches before posting them.
Prerequisite
Define your eliminating journal entry formulas.
To generate unposted batches from eliminating journal formulas:
1. Navigate to the Generate Eliminations window.
2. (Optional) If you have average balance processing enabled and your set of books is a consolidation set of books, select a Usage. Select Standard Balances to create eliminating journals that update standard balances only. Select Average Balances to create eliminating journals that update average balances only.
3. (Optional) If you have average balance processing enabled, choose Submission Details from the poplist to enter values for the eliminating journals you want to generate. Choose Last Run Details to see the values that you used the last time you generated the eliminating journals.
4. Select the Elimination Sets you want to generate by marking the checkbox to the left of each set name.
5. Enter the accounting Period for which you want to create an unposted journal batch. The default is the first open accounting period following the one for which you last generated eliminating journals.
6. (Optional) If you have average balance processing enabled, enter a Journal Effective Date. You can enter any valid business day, unless your set of books is a consolidation set of books or if your current elimination set uses actual balances. In these cases, General Ledger automatically enters the first day of the period and you cannot change the value.
Note: You can also enter non-business days if you have set the profile option Journals: Allow Non-Business Day Transactions to Yes.
7. (Optional) If you have average balance processing enabled, enter a Calculation Effective Date. General Ledger will automatically enter the nearest day of the period. You can change this to any day in any open, closed, future enterable, or permanently closed period.
8. If you have an eliminating journal entry formula that uses budget balances to calculate journal amounts, enter the Budget name.
9. Choose the Generate button. General Ledger submits a concurrent process to create unposted journal batches based on the selected elimination sets. Note the Request ID assigned to the concurrent process.
General Ledger names the resulting journal batch as follows: <Eliminating Batch Name>: <Date> <Time>. For example, Project Expense: 15-JAN-95 16:36.
10. Post the generated eliminating journal batches to update your parent account balances.
See Also
About Recurring Journals
Overview of Average Balance Processing
Global Consolidation System
Consolidation Workbench
Mapping Subsidiaries to Your Parent
Preparing Subsidiary Data
Transferring Subsidiary Data to Your Parent
Transferring Consolidation Sets
Posting Subsidiary Data