1 / 20

Welcome to:

Welcome to:. “Summer School” for Oracle 11i. Your Instructor: Dorothy Sheets. Independent Consultant Farmington Hills, MI. Agenda/Topics to Be Covered. Instructor Introduction Lesson 1: General Ledger Lesson 2: Accounts Receivable Lesson 3: Fixed Assets

ashley
Télécharger la présentation

Welcome to:

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. Welcome to: “Summer School” for Oracle 11i Your Instructor: Dorothy Sheets Independent Consultant Farmington Hills, MI

  2. Agenda/Topics to Be Covered • Instructor Introduction • Lesson 1: General Ledger • Lesson 2: Accounts Receivable • Lesson 3: Fixed Assets • Field Trip: What I Learned at OAUG-Toronto • Other Erudite Professors • Review • Questions and Answers • Graduation! Dorothy Sheets, Independent Consultant

  3. Instructor: Dorothy Sheets • Independent Consultant • Custom Curriculum Development • Training (Implementation Team and End Users) • Implementation Services • 9+ Years Experience in Oracle Applications • Office: 248-478-2177 • E-mail: dsheets@ameritech.net Dorothy Sheets, Independent Consultant

  4. Lesson 1: General Ledger • 11i Differences (Brief) • Training and Implementation Considerations • Lessons Learned Dorothy Sheets, Independent Consultant

  5. GL: Differences (Brief) • Enhanced Subledger Inquiries and Drilldowns • Automatic Reversal of Journals • Account Hierarchy Manager Copy Feature • Improved Multi-currency Management • Global Consolidation System (GCS) • Optional Closing Journals • RXi Reports • Global Intercompany System (GIS) • AutoAllocation Workbench Dorothy Sheets, Independent Consultant

  6. GL: Training and Implementation Considerations • Chart of Accounts • Psychology vs. physiology • What CAN you include vs. what SHOULD you include • ADI (Applications Desktop Integrator) • To use or not to use • Teach ADI and actual application (let users decide) • Proper setup of ADI is important • Hierarchy Manager (Parent/Child Relationships) • Planning, setup and use • FSG (Financial Statement Generator) • It’s still here & it still works • Teach power users how to build report components • Row sets, column sets, content sets, etc. Dorothy Sheets, Independent Consultant

  7. GL: Lessons Learned • RESIST Temptation to Make NEW System Look Exactly Like OLD System • PLAN Accounting Flexfield Carefully • Consider all modules implemented, not just GL • UTILIZE Cross-validation Rules • Look at bad data in “old” system to help build these • FSG • Setup row sets & test with existing column sets • Setup column sets (copy and modify existing sets) • See Metalink for technical details on content sets • Journal Import • User interface written for low volume Dorothy Sheets, Independent Consultant

  8. Lesson 2: Accounts Receivable • 11i Differences (Brief) • Training and Implementation Considerations • Lessons Learned Dorothy Sheets, Independent Consultant

  9. AR: Differences (Brief) • Credit Card Processing • Credit Memo Workflow • Tax Enhancements • Improved Document Sequencing • Enhanced AutoAccounting • AutoInvoice Exception Handling • Cross Currency Lockbox • Archive & Purge Performance Improvement • T-accounts • RXi Reports Handle Multiple Currencies Dorothy Sheets, Independent Consultant

  10. AR: Training and Implementation Considerations • Be Prepared to Re-engineer Business Processes • But we’ve always done it THAT way • Customer Master • Set standards and communicate them to users • Standard Reports – Test and Re-test • Review and Populate QuickCodes • Test Standard Interfaces for Accuracy • FROM Order Management • FROM Oracle Projects • TO Oracle General Ledger Dorothy Sheets, Independent Consultant

  11. AR: Lessons Learned • Be Flexible • Train on How to Use Application • Train on How Jobs Will Change • Train on Collections Call Handling • QuickCode data is important here • Test and Re-test Standard Reports for Accuracy • Test and Re-test RXi Reports for Accuracy • Test and Re-test Standard and Custom Interfaces for Accuracy Dorothy Sheets, Independent Consultant

  12. Lesson 3: Fixed Assets • 11i Differences (Brief) • Training and Implementation Considerations • Lessons Learned Dorothy Sheets, Independent Consultant

  13. FA: Differences (Brief) • Rollback and Rerun Depreciation • Depreciation Separate from Closing Period • Mass Reclassification • What-if Depreciation Analysis on Future Assets • Maintain Asset Insurance Values • Enhanced Mass Transfers • Security by Book • T-accounts • RXi Reports • Maintain CIP Assets in Tax Book(s) • Short Tax Year Support • Asset Maintenance Dorothy Sheets, Independent Consultant

  14. FA: Training and Implementation Considerations • Category, Asset Key and Location Flexfields • Psychology vs. physiology • Account Generator • Use “as-is” or modify to get results you want • Modifications done with Oracle Workflow • Teach Entire Asset Life Cycle • Additions, adjustments, transfers, depreciation, retirements & reinstatements • Teach Application Flows • Enter data in corporate books • Close corporate books • Mass copy data to tax books (from a CLOSED corp book to an OPEN tax book) • Close tax books Dorothy Sheets, Independent Consultant

  15. FA: Lessons Learned • Review and Test Account Generator Defaults Including Interface to General Ledger • Watch Out for General Ledger “Rules” • Cross-validation rule “violations” • Modify Account Generator (if necessary) • Watch Out for Initial Run of FAGDA Process • Initial (first) run can run long, but DOES complete • Can delay your first depreciation run, so be prepared • See Metalink for technical details on FAGDA process • Test Interface from Oracle Projects • Test Interface from Oracle Payables • ADI: Decide Whether or Not to Use • Ensure accuracy of spreadsheet data Dorothy Sheets, Independent Consultant

  16. Field Trip: What I Learned at OAUG-Toronto • Plan for Training • DO Training • Do MORE Training* • Next OAUG is October 27-30 in San Diego *See OAUG website (member area) for a complete listing of 11i presentations delivered in Toronto – www.oaug.org Dorothy Sheets, Independent Consultant

  17. Other Erudite Professors • Cline Consulting and Training Solutions • Cindy Cline • Web: www.ccatsolutions.com • E-mail: cindycline@earthlink.net • FMT Systems • Faun deHenry • Web: www.fmtsystems.com • E-mail: faun@fmtsystems.com • O2works • Mark Clark • Web: www.o2works.com • E-mail: mclark@o2works.com • Vlamis Software Solutions • David Fuston • Web: www.vlamis.com • E-mail: dfuston@vlamis.com Dorothy Sheets, Independent Consultant

  18. Review • 11i GL/AR/FA • Nice enhancements to already stable modules • Low incidence of TARS • They WORK! • OAUG-Toronto • All users (in sessions that I personally attended) said they would do MORE training • OAUG-San Diego • October 27-30 Dorothy Sheets, Independent Consultant

  19. Questions and Answers? • ??? • E-mail: dsheets@ameritech.net • Office phone: 248-478-2177 Dorothy Sheets, Independent Consultant

  20. Graduation! • Thanks VERY MUCH for Your Attention • Good Luck with Oracle 11i • Please Pick Up “Diploma” at Back Table • Presentation Will Be Available On-line at: • www.mi-oaug.org • Have a GREAT Summer, See You in September! Dorothy Sheets, Independent Consultant

More Related