Slide1 l.jpg
This presentation is the property of its rightful owner.
Sponsored Links
1 / 50

Oracle General Ledger & GL Desktop Integrator PowerPoint PPT Presentation


  • 164 Views
  • Uploaded on
  • Presentation posted in: General

Oracle General Ledger & GL Desktop Integrator. Post. Subledger. Spreadsheet. Journal. Multi-Currency. Intercompany Transaction. Post-to-Analysis. CENTRA. CEN tralized TR ansaction A pproval. Close Your Books Faster.

Download Presentation

Oracle General Ledger & GL Desktop Integrator

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Slide1 l.jpg

Oracle General Ledger & GL Desktop Integrator


Post to analysis l.jpg

Post

Subledger

Spreadsheet

Journal

Multi-Currency

Intercompany Transaction

Post-to-Analysis


Cen tralized tr ansaction a pproval l.jpg

CENTRA

CENtralized TRansaction Approval

Close Your Books Faster

An Intercompany Control System which allows you to centrally enter, approve, and identify manual inter- company transactions in a controlled manner across the enterprise.


Cen tralized tr ansaction a pproval4 l.jpg

CENtralized TRansaction Approval

Close Your Books Faster

  • Record Transactions Across Sets of Books

    • Even if use different calendars, charts of accounts and currencies

  • Online Audit Trail

  • Streamlines I/C Reconciliation


Post to analysis5 l.jpg

Post

Subledger

Spreadsheet

Journal

Multi-Currency

Intercompany Transaction

Post-to-Analysis


Journal approval system l.jpg

Journal Approval System

Lower Administrative Costs

  • Based on Workflow Technology

    • Tailor rules to address unique business needs

  • Additional Level of Control

    • Hierarchy based upon HR employee / manager relationship

    • Specify authorization limits for each user


Journal enhancements l.jpg

Journal Enhancements

Lower Administrative Costs

  • AutoPost Criteria Sets

    • Group journals by source, category, and effective date

    • AutoPost at different frequenciesfor different criteria sets

  • AutoCopy MassAllocations/ MassBudgets

    • Ease creation of similar allocations/budgets


Mass maintenance l.jpg

Mass Maintenance

Lower Administrative Costs

  • Move / Merge Existing Accounts & Balances

  • Create New Accounts Based on Existing Accounts

From Depts 100 and 200

To Dept 500

01.100.000.1000100

01.200.000.1000 75

01.200.010.2000100

01.500.000.1000175

01.500.010.2000100


Mass maintenance9 l.jpg

Mass Maintenance

Lower Administrative Costs

  • Effect High Volume Modifications

    • Chart of Account Reorganizations

    • Corporate Restructuring

    • Reclassifications

  • Reversible Function

  • Drill to Source Balances

  • Provides Audit Trail


Post to analysis10 l.jpg

Post

Subledger

Spreadsheet

Journal

Multi-Currency

Intercompany Transaction

Post-to-Analysis


Multiple reporting currencies l.jpg

Multiple Reporting Currencies

Make Better Decisions

  • Provides Multi-Currency Representations of Transactions

  • Link Multiple Sets of Books with Different Reporting Currencies

  • Automatically Replicate Transactions upon Posting


Euro support l.jpg

Euro Support

  • Supports Fixed EURO NCU Conversion Factors

  • Compliant withEURO TriangulationRules

  • Use with MRC to Smooth Transition to EURO Accounting Requirements


Multi currency enhancements l.jpg

Multi-Currency Enhancements

Lower Administrative Costs

  • Cross-Currency Rates

    • Enter conversion rates between any two currencies

  • Single Daily Rates For Entire Install

    • Simplifies maintenance

  • Daily Rates Interface Table

    • Standard API for importing daily currency rates


Post to analysis14 l.jpg

Report

Consolidate

Analyze

Budget Writeback

Post-to-Analysis


Slide15 l.jpg

Announcing . . .

The

Global

Consolidation

System


Slide16 l.jpg

The Consolidation Process

There are actually SEVEN tasks involved

in the consolidation process. Most

consolidation systems, however, only address a subset of these tasks.

Analyze

Report

Eliminate

Transfer Data

Prepare Data

Map Data

Define Consolidation COA


Slide17 l.jpg

Central Point of Control

Close Your Books Faster

  • Consolidation Sets

  • Comprehensive View of All Subsidiaries

  • Latest Status for Each Subsidiary

  • Color-Coded Workflow

    • Blue = Recommended

    • Gray = Not recommended

    • Red = Warning

Consolidation Workbench & State Controller


Slide18 l.jpg

Central Point of Control

Close Your Books Faster

Consolidation Hierarchy Viewer

  • A Graphical View of the Entire Consolidation Structure


Targeted business intelligence l.jpg

Targeted Business Intelligence

Close Your Books Faster

  • Flexible Mapping Rules

    • Define General Subsidiary to Parent Relationship

    • Specify Exception Cases

  • Leverage Summary Account Efficiencies

  • Automatically Derive Business Dimensions

  • Consolidation Audit Reports


Post to analysis20 l.jpg

Report

Consolidate

Analyze

Budget Writeback

Post-to-Analysis


Enhanced drilldown l.jpg

Enhanced Drilldown

Make Better Decisions

New Drill Paths . . .

  • From Account Balances To Complete Journal Entries

  • From Translated Balances to Functional Balances

  • Between Consolidated Entities


Cross enterprise visibility l.jpg

Cross-Enterprise Visibility

Make Better Decisions

Drill From the Consolidated Parent to . . .

  • Any Subsidiary

  • Any Account

  • Any Journal

  • Any Subledger Transaction


We interrupt this program to l.jpg

We Interrupt This Program To...

Product Update

Explain What ADI Is!!!

Applications Desktop Integration (ADI) is a family of products which include:

  • GL Desktop Integrator

  • Request Center

  • Future Desktop Integration Functionality

    • Fixed Assets


After the close l.jpg

After the Close

Make Better Decisions and Lower Administrative Costs

Here is the News!

Please Explain!

What Should I Do?

Request Center

Analysis Wizard

Financial Analyzer


Reporting l.jpg

Reporting

  • FSG Report Title

    • Moved from Row Set to Report Definition Level

    • Easier Report Identification for Separate Reports using same Row Set


After the close report l.jpg

After the Close - Report

Lower Administrative Costs

After the close, you need to distribute results in a timely and cost effective manner.

With Centralized Report Management, you can publish reports anywhere -- more quickly and at a lower cost than ever before!

Request Center !

Here is the News!


After the close report27 l.jpg

After the Close - Report

Lower Administrative Costs

  • Submit, Monitor, Publish from the Desktop

  • Publish Financial (FSG) Reports AND Standard Reports From ANY Application

  • Apply Themes for Automatic Formatting

  • Replace Reports to Update Management Reporting Packages

  • Fast Server-Based Reporting Engine

  • And…


After the close report28 l.jpg

After the Close - Report

Lower Administrative Costs

  • Web Publishing

    • Publish, Subscribe, and Pull On Demand

    • Eliminates Manual Report Distribution

    • Publish Once, Read Often

    • No Lost Email or Missing Printouts

    • Offload Report Viewing from Production Environment

  • Lowers the Cost of Month End Reporting!


After the close analyze l.jpg

After the Close - Analyze

Make Better Decisions

  • Optionally Include a Spreadsheet in Web Page for Download

  • Drill Down via Analysis Wizard

  • Information Filtered Using Security Rules

  • Expand Analysis by Changing Drill Context

    • Effectively creating NEW REPORTS on the fly!


Financial analyzer integration l.jpg

Financial Analyzer Integration

Make Better Decisions

  • Share Data and Structures

    • Reduces Maintenance

    • Reduces Reconciliation Issues

  • Multiple Balance Transfers

    • Any Balance Type

      • Functional, Statistical, Average,

      • Encumbrance

    • Any Currency

    • Detail Balances or SummaryBalances

  • Automatically Load Balances from GL to OFA


Financial analyzer integration31 l.jpg

Financial Analyzer Integration

Make Better Decisions

  • Automation Means Tighter Integration!

AutoLoad

BudgetWriteback


Slide32 l.jpg

Oracle Receivables


Oracle receivables r11 checklist l.jpg

Transaction Interface

Tax Inclusive

User-Definable Tax Hierarchy

Account Method VAT

Flexible Invoice Print

Multi-Organization Enhancements

User-Definable Dunning

Dunning History

Desktop Documents

Customer Query

Cross Currency Receipts

AutoLockbox Enhancements

Payment Application Rule Sets

Notes Receivable

Multiple Reporting Currencies

Inquiry Only Menu

Oracle Receivables - R11 Checklist


Order to cash l.jpg

Order Processing

PROJECT

PROJECT

PROJECT

Assets

Cash

Account Receivable

Land

Total Assets

Liability

Account Payable

Notes Payable

Total Liability

Stockholder’s Equity

Contributed Capital

Retained Earnings

Total Stockholder’s Equity

$4,456

$5,714

$ 981

---------

$11,151

======

$3,830

$ 416

---------

$4,246

======

$2,365

$ 367

---------

$2,732

======

Assets

Cash

Account Receivable

Land

Total Assets

Liability

Account Payable

Notes Payable

Total Liability

Stockholder’s Equity

Contributed Capital

Retained Earnings

Total Stockholder’s Equity

$4,456

$5,714

$ 981

---------

$11,151

======

$3,830

$ 416

---------

$4,246

======

$2,365

$ 367

---------

$2,732

======

Assets

Cash

Account Receivable

Land

Total Assets

Liability

Account Payable

Notes Payable

Total Liability

Stockholder’s Equity

Contributed Capital

Retained Earnings

Total Stockholder’s Equity

$4,456

$5,714

$ 981

---------

$11,151

======

$3,830

$ 416

---------

$4,246

======

$2,365

$ 367

---------

$2,732

======

Projects

Order-to-Cash

Collections

Legacy System

Payment Receipt

and Application

Invoice Generation


Automatic transaction processing l.jpg

Automatic Transaction Processing

Lower Administrative Costs

  • AutoInvoice

    • Significant performance improvements since 10.7

  • Transaction Interface

    • Create, modify and delete transactions

    • Real-time


Tax inclusive l.jpg

Tax Inclusive

Lower Administrative Costs

  • Provide invoices to your customers with tax included in individual unit amounts


Tax inclusive37 l.jpg

Unit

Price

Extended

Amount

Item no.

Description

Quantity

World Atlas

2

$50.00

$100.00

15138

Multimedia Monitor

$300.00

$300.00

1

P66238

$400.00

Subtotal

40.00

Tax

$440.00

Total

Unit

Price

Extended

Amount

Includes

Tax

Item no.

Description

Quantity

World Atlas

2

$50.00

$110.00

X

15138

1

Multimedia Monitor

$300.00

$300.00

P66238

Subtotal

$410.00

30.00

Tax

$440.00

Total

Tax Inclusive

Lower Administrative Costs


Cross product tax l.jpg

Cross-Product Tax

Lower Administrative Costs

Close Your Books Faster

  • User-Definable Tax Hierarchy

  • Account Method VAT

  • New Variable Format Report

    • U.S. Sales Tax Report


Flexible invoice print l.jpg

Flexible Invoice Print

Lower Administrative Costs

  • Custom format your invoices

    • New views to make invoice customizations simple

    • Use any reporting tool


Multi organization enhancements l.jpg

Multi-Organization Enhancements

Lower Administrative Costs

  • Assign a default salesperson at the customer site level

  • Create centralized statement and dunning sites for customers


Order to cash41 l.jpg

Order Processing

PROJECT

PROJECT

PROJECT

Assets

Cash

Account Receivable

Land

Total Assets

Liability

Account Payable

Notes Payable

Total Liability

Stockholder’s Equity

Contributed Capital

Retained Earnings

Total Stockholder’s Equity

$4,456

$5,714

$ 981

---------

$11,151

======

$3,830

$ 416

---------

$4,246

======

$2,365

$ 367

---------

$2,732

======

Assets

Cash

Account Receivable

Land

Total Assets

Liability

Account Payable

Notes Payable

Total Liability

Stockholder’s Equity

Contributed Capital

Retained Earnings

Total Stockholder’s Equity

$4,456

$5,714

$ 981

---------

$11,151

======

$3,830

$ 416

---------

$4,246

======

$2,365

$ 367

---------

$2,732

======

Assets

Cash

Account Receivable

Land

Total Assets

Liability

Account Payable

Notes Payable

Total Liability

Stockholder’s Equity

Contributed Capital

Retained Earnings

Total Stockholder’s Equity

$4,456

$5,714

$ 981

---------

$11,151

======

$3,830

$ 416

---------

$4,246

======

$2,365

$ 367

---------

$2,732

======

Projects

Order-to-Cash

Collections

Legacy System

Payment Receipt

and Application

Invoice Generation


Dunning enhancement l.jpg

Dunning Enhancement

Improve Cash Management

Make Better Decisions

  • Create custom dunning letters

    • Develop an unlimited number of dunning letters

    • Create and modify letters on-line

  • View dunning history in new window


Customer query l.jpg

Customer Query

Lower Administrative Costs

  • Look up a customer based on a phone number

  • View all customers within a given city, state, county, province, country, postal code or area code


Inquiry only menu l.jpg

Inquiry Only Menu

Lower Administrative Costs

  • Allow employees to view information in the Receivables system without the ability to make any changes


Order to cash45 l.jpg

Order Processing

PROJECT

PROJECT

PROJECT

Assets

Cash

Account Receivable

Land

Total Assets

Liability

Account Payable

Notes Payable

Total Liability

Stockholder’s Equity

Contributed Capital

Retained Earnings

Total Stockholder’s Equity

$4,456

$5,714

$ 981

---------

$11,151

======

$3,830

$ 416

---------

$4,246

======

$2,365

$ 367

---------

$2,732

======

Assets

Cash

Account Receivable

Land

Total Assets

Liability

Account Payable

Notes Payable

Total Liability

Stockholder’s Equity

Contributed Capital

Retained Earnings

Total Stockholder’s Equity

$4,456

$5,714

$ 981

---------

$11,151

======

$3,830

$ 416

---------

$4,246

======

$2,365

$ 367

---------

$2,732

======

Assets

Cash

Account Receivable

Land

Total Assets

Liability

Account Payable

Notes Payable

Total Liability

Stockholder’s Equity

Contributed Capital

Retained Earnings

Total Stockholder’s Equity

$4,456

$5,714

$ 981

---------

$11,151

======

$3,830

$ 416

---------

$4,246

======

$2,365

$ 367

---------

$2,732

======

Projects

Order-to-Cash

Collections

Legacy System

Payment Receipt

and Application

Invoice Generation


Cross currency receipts l.jpg

Cross Currency Receipts

  • Issue an invoice in one currency and receive payment in another currency

    • Offers flexible billing and receiving

    • Aids in transition to the euro

    • Supports floating and fixed rate currencies


Autolockbox l.jpg

AutoLockbox

Lower Administrative Costs

  • Increase “hit” rate of matching receipts to transactions

    • Match using transaction, sales order, purchase order, consolidated bill or custom number

    • Develop custom matching through open PL/SQL interface

    • Allow receipts to be partially applied when there is an invalid transaction number

  • Determine treatments of unapplied amounts

    • Use Autocash rules for partial unapplied amounts


Payment application rule sets l.jpg

Payment Application Rule Sets

Lower Administrative Costs

  • Control how payments are applied to your transaction balances by defining application rule sets

    • Determine order of line, tax, freight and charges

    • Define how the payment will be prorated among line types

    • Assign application rule sets to transaction types and/or at system level


Notes receivable l.jpg

Notes Receivable

Improve Cash Management

  • Process future dated checks and promissory notes as notes receivable

    • Create note

    • Note reaches maturity

    • Clear note by running the Automatic Clearing program


Multiple reporting currencies50 l.jpg

Vision Enterprises

Financial Statement

at December 31, 1997

JOURNAL

Vision Enterprises

Financial Statement

at December 31, 1997

Assets

Cash

Account Receivable

Land

Total Assets

Liability

Account Payable

Notes Payable

Total Liability

Stockholder’s Equity

Contributed Capital

Retained Earnings

Total Stockholder’s Equity

$4,456

$5,714

$ 981

---------

$11,151

======

$3,830

$ 416

---------

$4,246

======

$2,365

$ 367

---------

$2,732

======

Vision Enterprises

Financial Statement

at December 31, 1997

Assets

Cash

Account Receivable

Land

Total Assets

Liability

Account Payable

Notes Payable

Total Liability

Stockholder’s Equity

Contributed Capital

Retained Earnings

Total Stockholder’s Equity

$4,456

$5,714

$ 981

---------

$11,151

======

$3,830

$ 416

---------

$4,246

======

$2,365

$ 367

---------

$2,732

======

Assets

Cash

Account Receivable

Land

Total Assets

Liability

Account Payable

Notes Payable

Total Liability

Stockholder’s Equity

Contributed Capital

Retained Earnings

Total Stockholder’s Equity

$4,456

$5,714

$ 981

---------

$11,151

======

$3,830

$ 416

---------

$4,246

======

$2,365

$ 367

---------

$2,732

======

PAYMENT

?

Multiple Reporting Currencies

Make Better Decisions

  • Report and Account Your Business in Multiple Currencies at Transaction Level

    • Account in multiple functional currencies... …automatically!

    • Inquire and report in multiple functional currencies


  • Login