creating and editing fsg reports with oracle adi l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Creating and Editing FSG Reports with Oracle ADI PowerPoint Presentation
Download Presentation
Creating and Editing FSG Reports with Oracle ADI

Loading in 2 Seconds...

play fullscreen
1 / 33

Creating and Editing FSG Reports with Oracle ADI - PowerPoint PPT Presentation


  • 536 Views
  • Uploaded on

Creating and Editing FSG Reports with Oracle ADI. Jerry Reller Sr. Financial Analyst ZiLOG, Inc. jreller@zilog.com. 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

Creating and Editing FSG Reports with Oracle ADI

Jerry Reller

Sr. Financial Analyst

ZiLOG, Inc.

jreller@zilog.com

slide2
ZiLOG is using Oracle 11i (11.5.7).
  • Multi-Org
  • Multiple books
    • Multiple Currencies
    • Global Accounts
    • Global Calendar
oracle adi
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

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
Components of an FSG Report

Column Set (required)

Content

Set

(Optional)

Row Set (required)

fsg advantages
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
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
ADI Menu Bar

Ledger Icon

report wizard step 1
Report Wizard Step 1

Define Report

Click “Next>”

slide14

Duplicate values can be copied and pasted

Rows and Columns are grouped