slide1
Download
Skip this Video
Download Presentation
Oracle General Ledger & GL Desktop Integrator

Loading in 2 Seconds...

play fullscreen
1 / 50

Oracle General Ledger GL Desktop Integrator - PowerPoint PPT Presentation


  • 219 Views
  • Uploaded on

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.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Oracle General Ledger GL Desktop Integrator' - kaycee


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
post to analysis

Post

Subledger

Spreadsheet

Journal

Multi-Currency

Intercompany Transaction

Post-to-Analysis
cen tralized tr ansaction a pproval

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
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

Post

Subledger

Spreadsheet

Journal

Multi-Currency

Intercompany Transaction

Post-to-Analysis
journal approval system
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
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
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.1000 100

01.200.000.1000 75

01.200.010.2000 100

01.500.000.1000 175

01.500.010.2000 100

mass maintenance9
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

Post

Subledger

Spreadsheet

Journal

Multi-Currency

Intercompany Transaction

Post-to-Analysis
multiple reporting currencies
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
Euro Support
  • Supports Fixed EURO NCU Conversion Factors
  • Compliant withEURO TriangulationRules
  • Use with MRC to Smooth Transition to EURO Accounting Requirements
multi currency enhancements
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

Report

Consolidate

Analyze

Budget Writeback

Post-to-Analysis
slide15
Announcing . . .

The

Global

Consolidation

System

slide16

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

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

Central Point of Control

Close Your Books Faster

Consolidation Hierarchy Viewer

  • A Graphical View of the Entire Consolidation Structure
targeted business intelligence
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

Report

Consolidate

Analyze

Budget Writeback

Post-to-Analysis
enhanced drilldown
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
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
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
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
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
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
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
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
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
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
Financial Analyzer Integration

Make Better Decisions

  • Automation Means Tighter Integration!

AutoLoad

BudgetWriteback

oracle receivables r11 checklist
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

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
Automatic Transaction Processing

Lower Administrative Costs

  • AutoInvoice
    • Significant performance improvements since 10.7
  • Transaction Interface
    • Create, modify and delete transactions
    • Real-time
tax inclusive
Tax Inclusive

Lower Administrative Costs

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

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
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
Flexible Invoice Print

Lower Administrative Costs

  • Custom format your invoices
    • New views to make invoice customizations simple
    • Use any reporting tool
multi organization enhancements
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

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
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
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
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

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
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
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
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
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

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
ad