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.

image

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

image

Registrations

image

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

Establishments

image

List of all locations

Balancing Segments

This is a new important feature that the balancing segment now relates to the legal entity.

image

Primary Ledger

Ledgers are mostly the same as the old Set Of Books however the setup screens has changed a bit.

Definition

image

Nothing really new here except for the OFA screen.

Options

image

Similar to the old screens in a new wrapping.

Advanced Options

image

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

image

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

image

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:

image

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

image

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

image

Note the new “Reconciliation Reference” field. This is used both for automatic and manual reconciliation.

Unreconciled Lines

image

Search for unreconciled journal lines using the parameters above.

Reconcile Journal

image

No journals to reconcile here – but you see the point?