R12 – General Ledger – GL
Back to R12 – Upgrade Overview
Overview
In GL there has been a number of changes:
- Terminology Changes
- Set of Books (SOB) is now Ledgers
- Multiple Reporting Currencies (MRC) is now Reporting Currencies
- Global Intercompany System (GIS) is now Advanced Global Intercompany System (AGIS)
- Obsolete
- Global Accounting Engine (AX) replaced by Subledger Accounting
- MRC as a workaround – now fully integrated as Reporting Currencies
- Accounting Setup manager – New central management of legal entities and legers
- Legal Entities – now really used
- Ledgers – new name and setup for SOBs
- Ledger sets – ledger grouping and security feature
- Reporting Currencies – MRC has now been cleaned up and is better integrated
- Period rates – now all daily rates and managed in same way
- Revaluation and Translation – changed functionality
- Journal Reconciliation
- Advanced Global Intercompany System (AGIS) – changed functionality
Accounting Setup Manager
The new Accounting Setup Manager simplifies and centralizes accounting-related setup for common financial components that are shared across financial applications. From a central location, you can define your legal entities and their accounting context, such as the ledgers and reporting currencies that perform the accounting for your legal entities.
The setup steps are:
- Legal Entity
- Primary Ledger
- Reporting Currencies
- Balancing Segment Value Assignments
- Subledger Accounting Options
- Operating Units
- Intercompany Accounts
- Intercompany Balancing Rules
- Sequencing
- Secondary Ledgers
Each of the setup steps is a number of sub screens where some are described later.
Legal Entities
Legal Entities part of Accounting Setup Manager now holds important information for both tax and VAT reporting.
General
Registrations
This is where you would put in information for the Corporations Office
Establishments
List of all locations
Balancing Segments
This is a new important feature that the balancing segment now relates to the legal entity.
Primary Ledger
Ledgers are mostly the same as the old Set Of Books however the setup screens has changed a bit.
Definition
Nothing really new here except for the OFA screen.
Options
Similar to the old screens in a new wrapping.
Advanced Options
Again similar to old days except for the new Journal Reconciliation option.
Ledger Sets and Data Access Sets
The Ledger Set is a great new feature which lets you manage multiple ledgers as one – a especially useful feature for faster closing. However the ledgers must share the following information:
- Chart of accounts
- Calendar/period type combination
You can open/close periods for multiple ledgers at once, run recurring journals that update balances for multiple ledgers. So it goes way beyond report sets or cross COA FSG reports.
Ledger Set
Strange though – this is a non-OFA screen…having thought that all new features was pushed to OFA.
Similar to the Ledger Set the Data Access Set provides security at same level so ledgers must still share the following information:
- Chart of accounts
- Calendar/period type combination
The security can be at the following levels:
- Full Ledger – access to the whole COA
- Balancing Segment Value – access to specific balancing segment values
- Management Segment Value – access to specific management segment values
Note the Management Segment is a new segment qualifier. If you what your cost centre to be secured and used in Data Access sets enable the Cost Centre segment as a Management Segment. Remember if your COA has been used there is a specific procedure for doing this to avoid corruption.
Data Access Set
The system always generate a Data Access Set with same name and full access for each:
- Primary Ledger
- Secondary ledger
- Ledger Set
- Reporting Currency (also creates a Reporting Currency + Source Ledger Data Access Set)
Data Access Set security can be combined with Segment Value Security Rules and will work as a logical AND so only where the two overlaps access will be allowed.
Reporting Currencies
The reporting currency definition is now comprised from the R11i options for reporting sets of books and the MRC profile options.
Period Rates
Period Rates Replaced by Daily Rates and all new OAF screens.
Currency Rates Manager:
Revaluation and Translation
Revaluation sets are now usable across ledgers that share a common chart of accounts. In some cases, you may need to enter the secondary tracking segment for revaluation sets involving a secondary tracking segment before running revaluations with upgraded templates.
General Ledger modifies revaluation templates to use corresponding daily rates for those that used period rates prior to the upgrade.
Journal Reconciliation
Journals can now be reconciled if an account has been marked as such.
The is a useful feature for clearing accounts or tax accounts which should balance to zero.
Account Setup
Note this is a cash clearing account which is a good candidate for journal reconciliation.
So in this case you would enable the segment qualifier “Reconcile” to “Yes”.
Journal Entry
Note the new “Reconciliation Reference” field. This is used both for automatic and manual reconciliation.
Unreconciled Lines
Search for unreconciled journal lines using the parameters above.
Reconcile Journal
No journals to reconcile here – but you see the point?