Defining Journal Sources
Journal sources identify the origin of your journal entries. General Ledger supplies a number of predefined journal sources. In addition, you should define at least one journal source for each of your own, non-Oracle feeder systems to help you track imported journal entries.
For each journal source, you can specify whether to import detail reference information for summary journals you import from your feeder systems. You can also choose to freeze the journal source, preventing users from making changes to any journals that are posted to General Ledger from that source.
If you have journal approval enabled for your set of books, you can require that journals with a specific journal source be approved by higher management levels before the journal can be posted.
You can define intercompany and suspense accounts for specific sources, run the AutoPost program for specific sources, import journals by source, and report on journals by source using the Foreign Currency Journals or General Journals reports.
General Ledger provides the following predefined journal entry sources:
|
AX Inventory
| AX Inventory Entry
|
AX Payables
| AX Payables Entry
|
AX Receivables
| AX Receivables Entry
|
Assets
| Fixed Asset System
|
Average Consolidation
| Average Balance Consolidation
|
Budget Journal
| Budget Journal
|
Carryforward
| Carry Forward Journal Entry
|
Consolidation
| Consolidation System
|
Conversion
| Historical Data Conversion
|
Encumbrance
| Manual Encumbrance Entry
|
Inventory
| Inventory Control System
|
Manual
| Manual Journal Entry
|
Manufacturing
| Manufacturing
|
MassAllocation
| MassAllocation
|
Move/Merge
| Mass Maintenance Move/Merge
|
Move/Merge Reversal
| Mass Maintenance Move/Merge Reversal
|
Other
| System default
|
Payables
| Accounts Payable System
|
Payroll
| Payroll System
|
Personnel
| Personnel System
|
Project Accounting
| Project Accounting
|
Purchasing
| Purchasing System
|
Receivables
| Accounts Receivable System
|
Recurring
| Recurring Journal Entry
|
Revaluation
| Revaluation Journal Entry
|
Revenue
| Revenue Accounting System
|
Spreadsheet
| Spreadsheet
|
Statistical
| Statistical Journal Entry
|
Transfer
| Budget Transfer
|
To define a new journal entry source:
1. Navigate to the Journal Sources window.
2. Enter a unique Name and Description for your journal entry source. You cannot delete a source name after saving your work.
3. Choose whether to Import Journal References from your feeder systems to maintain a mapping of summarized transactions if you choose to create summary journals when you run Journal Import. This information is stored in the GL_IMPORT_REFERENCES table.
You can request a mapping report from your feeder systems after Journal Import completes. Or, you can write your own report referencing the GL_IMPORT_REFERENCES table which stores the mapping information.
4. Check whether to Freeze Journals for this journal entry source. If you mark this checkbox, journals from this source cannot be changed in the Enter Journals window. If you subsequently unmark this checkbox, you can make changes to journals from this source.
5. Check whether to Require Journal Approval for this journal source.
If journal approval is enabled for your set of books and you enter a journal whose journal source requires journal approval, the batch must be approved before it can be posted.
- Fail: Journal Import will reject transactions when the effective date is not a valid business day. No posting takes place.
- Leave Alone: Journal import will accept all transactions regardless of the effective date.
- Roll Date: Journal Import will accept the transaction, but roll the effective date back to the nearest valid business day within the same period. If there is no prior valid business day within the same period, the effective date is rolled forward.
Note: The Effective Date Rule field will not appear unless you have average balance processing enabled for at least one set of books.
To review or change an existing journal entry source:
1. Navigate to the Journal Sources window.
2. Query the journal entry source you want to review or change. You can change the Name, Description, Import Journal References setting, Freeze Journals setting, and Require Journal Approval setting. You can change the Effective Date Rule for any journal source except Average Consolidation.
See Also
Integrating Oracle General Ledger Using Journal Import
Importing Journals
Overview of Average Balance Processing