R12 – General Ledger – GL

Back to R12 – Upgrade 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.





This is where you would put in information for the Corporations Office



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.



Nothing really new here except for the OFA screen.



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?

This entry was written by Kent Willumsen , posted on Wednesday October 21 2009at 02:10 pm , filed under Functional Knowledge, General Ledger and tagged , , . Bookmark the permalink . Post a comment below or leave a trackback: Trackback URL.

Comments are closed.