Creating and editing fsg reports with oracle adi
Download
1 / 33

creating and editing fsg reports with oracle adi - PowerPoint PPT Presentation


  • 513 Views
  • Uploaded on

Creating and Editing FSG Reports with Oracle ADI. Jerry Reller Sr. Financial Analyst ZiLOG, Inc. [email protected] ZiLOG is using Oracle 11i (11.5.7). Multi-Org Multiple books Multiple Currencies Global Accounts Global Calendar. Oracle ADI.

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 'creating and editing fsg reports with oracle adi' - johana


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
Creating and editing fsg reports with oracle adi l.jpg

Creating and Editing FSG Reports with Oracle ADI

Jerry Reller

Sr. Financial Analyst

ZiLOG, Inc.

[email protected]


Slide2 l.jpg


Oracle adi l.jpg
Oracle ADI

  • Overview of ADI (Application Desktop Integrator)

    • Excel/Text interface with Oracle Applications

      • ZiLOG uses for General Ledger

        • Upload journal vouchers and budgets

      • Fixed assets

        • Upload assets

      • Use to publish Standard and FSG Reports


Fsg financial statement generator l.jpg

FSG (Financial Statement Generator)

FSG’s– Used for financial statements ie Balance Sheet, P&L, Cost Center Statements Spend Reports, Cash Flow , etc.

GAAP and Management Reports


Components of an fsg report l.jpg
Components of an FSG Report

Column Set (required)

Content

Set

(Optional)

Row Set (required)


Fsg advantages l.jpg
FSG Advantages

  • Use components with multiple reports

  • Auto copy components and modify the copy

  • Combine components in Ad Hoc report

  • Able to combine several books into a single report prior to consolidation


Creating and modifying fsg s using oracle adi l.jpg
Creating and Modifying FSG’s using Oracle ADI

  • Use Oracle Excel to create and edit reports

    • Copy and paste values

    • Row and column grouping

    • Spelling check

  • Able to visualize the report layout

  • Have access to Oracle list of values


Adi menu bar l.jpg
ADI Menu Bar

Ledger Icon


Report wizard step 1 l.jpg
Report Wizard Step 1

Define Report

Click “Next>”






Slide14 l.jpg

Duplicate values can be copied and pasted

Rows and Columns are grouped





ad