1 / 19

Oracle General Ledger

Oracle General Ledger. ‘FSG’ Financial Statement Generator Training Course Overview. FSG Training : Course Aims. FSG features and Capabilities Writing FSG components Building FSG reports ADI as a reporting Tool Advanced reporting features FSG strategy & procedures. Today’s Agenda.

teal
Download Presentation

Oracle General Ledger

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Oracle General Ledger ‘FSG’ Financial Statement Generator Training Course Overview

  2. FSG Training : Course Aims • FSG features and Capabilities • Writing FSG components • Building FSG reports • ADI as a reporting Tool • Advanced reporting features • FSG strategy & procedures

  3. Today’s Agenda • Overview of GL Set-up • Overview of FSG reports • Running reports in Oracle & ADI • Using different components • Standard examples of FSG reports • Basic Report Components • Row Sets • Column Sets

  4. Overview of GL Set-up • Some terminology • Set of Books • Functional Currency • Accounting Calendar • Chart of accounts

  5. Set of Books • Oracle terminology for the complete accounts systems of different business’s within the same system • One accounting calendar • One base currency • One chart of accounts(accounting structure)

  6. Calendar • Year runs from 1st May to 30th April • 18 Periods in a year • 12 monthly periods • 4 Quarterly adjusting periods • 2 Year end adjusting periods • Once a period has been closed, should not be re-opened. • Reports can be run for any period including Adjusting • At year end the P&L is automatically swept to Retained Earnings

  7. Management Accounting Calendar

  8. Currencies • Each set of books has one functional currency (e.g... GBP) • This is the default currency for reports & transaction entry • All foreign currency entries are automatically included in functional currency balance • You cannot get a balance just for balances in functional currency, but you can report on balances of foreign entered currencies • Report in many entered currencies one report • ‘Translation’ allows reporting of whole TB in Foreign Currency

  9. Currencies - Exchange Rates • Foreign -> functional currency • e.g... Euro - Sterling • Create a rate for each day • Standard Corporate Rates loaded automatically • Rate set on last day of previous month • Month end revaluation rates entered manually • Loaded to system via Reuters

  10. Chart of Accounts • Accounting Flexfield • Account code security • The Chart of Account Structure

  11. Accounting Flexfield • Oracle terminology for database field • Key flexfield (fundamental) • Max 30 segments • Specify a balancing segment • Specify a natural account segment • revenue, expense, etc.. • Segments independent of each other • Segments combined to form unique account codes ( CCID’s)

  12. Account code security • Cross Validation Rules • Restrict how segments are combined • Security Rules • Restrict which values a user can use

  13. Your Chart of Accounts Structure • Seg Name Default • Entity From Logon • Office From Logon • Group none • Account none • Local 000000 • Partner 0000 • Project 00000 • Year 0000 • Tax Year 0000 • Spare2 0000 Example of a full account combination 85.70.0000.16603.000000.0000.00202.0000.0000.0000

  14. Chart of accounts - standards • All segments are global apart from the ‘Local’ segment • Cannot add values to the set-up without world firm approval • New combinations of existing segment values are created automatically • Parent accounts exist on main segments for reporting ( Group & Account )

  15. FSG : Financial Statement Generator • Build your own custom reports without programming. • Define reports with complete control over the accounts, periods, calculations & submission

  16. FSG : Features • Generate financial reports, such as income statements and balance sheets • Apply security rules to control financial information • Define your reports with reusable report objects • Design custom financial reports to meet specific business needs.

  17. FSG : More Features • Print as many reports as you need, simultaneously. • Print the same report for multiple companies, cost centres etc, in a single submission. • Schedule reports to run automatically. • Produce ad hoc reports whenever you need them.

  18. Basic Report Building Principles • Re-usable report components ( objects) • Row and Column set is required minimum. • Build advanced options into simple reports • Content Sets, Display Sets, Row Order & Level of detail.

  19. Using Report Components

More Related