• No results found

Oracle R12 General Ledger

N/A
N/A
Protected

Academic year: 2021

Share "Oracle R12 General Ledger"

Copied!
40
0
0

Loading.... (view fulltext now)

Full text

(1)
(2)

Agenda

• Process Overview

• Integration with Modules

• Key Functionality

 Accounting Set Up Manager  Journals

 Consolidation, Translation, Revaluation

• Security

• Open Interface

• Reports

(3)

PROCESS OVERVIEW

(4)

General Ledger Process

Open /Close periods Journal Entries Review & Correct JE’s Consolidate / Translate/ Revalue Account Analysis & Reports General Ledger Process Originating in GL Sub Modules

(5)

INTEGRATION WITH MODULES

(6)

Integration

Sub Ledger Accounting General Ledger Payables Receivables Assets Cash Management Treasury Inventory Payroll Projects Purchasing Manufacturing

(7)

KEY FUNCTIONALITY

:ACCOUNTING SET UP MANAGER

(ASM)

(8)

Accounting Setup Manager

Legal Entities Ledgers Operating Units

Inter & Intra Company Accounting Subledger Accounting Reporting Currencies Accounting & Reporting Sequences Accounting Setup Manager

(9)

Accounting Setup Manager Concepts

Main, record-keeping ledger Defined by 4Cs:

Chart of accounts

Accounting calendar

Primary currency

Sub ledger Accounting Method

Optional, additional accounting

representations of your primary ledger

Can differ in one or more of the following from the primary ledger:

Chart of accounts

Accounting calendar

Primary currency

Subledger Accounting Method

(10)

Accounting Setup Manager Concepts

SLA Transaction Accounting Subledger Transactions SLA Corporate Ledger (Primary Ledger)

Local Statutory Ledger (Secondary Ledger)

AP AR FA Other

Subledgers

Legal Entity

(11)

Accounting Setup Manager Concepts

SLA Transaction Accounting Subledger Transactions SLA Corporate Ledger (Primary Ledger)

Local Statutory Ledger (Secondary Ledger)

AP AR FA Other

Subledgers

Legal Entity

(12)

If difference is only currency, If one or more of the following are different,

Accounting Setup Manager Concepts –

Reporting Currency

Use a Secondary Ledger

Currency Corporate Chart of accounts Monthly Calendar Accounting Method US GAAP Accrual

Use Reporting

Currencies

(13)
(14)
(15)
(16)
(17)
(18)
(19)
(20)

Ledger Set

Grouping of ledgers with the same chart of accounts and

calendar/period type combination

(21)

KEY FUNCTIONALITY

:JOURNAL

(22)

Types of Journals

• Manual Journals

• Imported Journals

• Recurring Journals

• Mass Allocation

(23)
(24)
(25)
(26)

Mass Allocation Journals

Dept1 Dept2 Dept3 1/3 1/3 1/3

(27)
(28)

KEY FUNCTIONALITY

:CONSOLIDATION, TRANSLATION &

EVALUATION

(29)

Consolidation

C O N S O L I D A T E Subsidiary 1 Set of Books Subsidiary 2 Set of Books Subsidiary 3 Set of Books Parent Set of Books

(30)

Translation

Translation and re-measurement methods

Period average and end rates

historical rates

Period to date and year to date modes

Translation method KWD KWD T R A N S L A T E USD USD KWD USD Functional Currency

(31)

Revaluation

USD Foreign currency KWD Functional currency converts to R E V A L U E USD Foreign currency KWD Functional currency converts to

(32)

SECURITY

(33)

Security

Cross validation rules prevent the

combination of certain segment values in the chart of accounts.

CROSS VALIDATION RULE

Security gives you the capability to restrict the set of values a user can use during data entry

(34)

Security

• Accounting Calendars • Auto Allocations • AutoPost Criteria Sets • Auto Reversal Criteria Sets • Budget Formulas

• Budget Organizations • Chart of Accounts Mappings • Consolidation Definitions • Consolidation Sets • Elimination Sets • FSG Reports and components • Mass Allocation • Mass Budgets • Rate Types • Recurring Journals • Revaluations • Transaction Calendars

• Control access to setup/reference independently of data security

• Enable setup sharing across ledgers and ledger sets

• Enable setup autonomy within multi-legal entity ledgers

• Set up view, modify, and usage privileges

DEFINITION ACCESS SET

Access multiple legal entities and ledgers from a single GL responsibility

DATA ACCESS SET

Restrict the usage of Control Accounts in manual Journal Entry

(35)

OPEN INTERFACE

(36)

Open Interface

To Import Journal lines from

peripheral systems and Oracle Sub ledgers

GL_INTERFACE

To Import Budget Journals from external sources

GL_BUDGET_INTERFACE

To Import Currency Exchange Rates from external sources

(37)

REPORTS

(38)

Reports

Financial Statement Generator

Account Analysis

Accounting Set Up Manager Post-Update

Diagnosis Report

Consolidation Journals Report

Journals Day Book

Trail Balance

Import Journals

(39)

Financial Statement Generator

Rows FSG Reports columns Sales Returns Net Sales Row Set A Row Set B Income Company statement PTD YTD 3000 6200 1000 1200 2000 5000 Cash Investments Balance Sheet YTD Last Y 3000 4200 1000 2200 column set column set

(40)

References

Related documents

Normals: Comparison of retinal and choroidal vasculature imaged by FA and PC-OCT Figure 1 shows a comparison between FA and PC-OCT imaging of the retinal vasculature along

Compared to other methods, chemotaxonomic analysis based on High Pressure Liquid Chromatography (HPLC) presents many advantages (e.g., rapidity, reproducibility, and capacity to

The machine may be foot powered (or less commonly hand powered), or mechanically powered. It works by first clamping the material with a ram. A moving blade then comes

The IRC algorithm excels when a strong co-channel interferer is present, meaning that the noise (which consists of both Gaussian white noise and the interfering signal) will

If you continue to receive income arising in France following your departure abroad, declare this income on form 2042 NR and enclose this form with your usual tax return.. If

conduct and/or the types of services the customer expects to utilize (particularly higher risk products such as international wire transfers).  Review of customer’s

Of interest as well, is an examination of factors that contribute to early attrition from treatment programs, or dropout within the first few days or first week of substance

The objective of this assessment was to learn about the Sahuwa kitchen activities, sensitize the group on biogas technology, analyze their energy needs and issues and assess