Tina Gavalier Financial Analyst Washtenaw County, Michigan

1. Washtenaw County Improves Access to ERP Information:A Case Study Using the Really Real Time Inquiry Suite Tina Gavalier Financial Analyst Washtenaw County, Michigan Julie Holmes Account Manager The GL Company

2. Environment and Background • J D Edwards EnterpriseOne Xe (SP 23 L1) • Using a HP/UX Operating System (V 11.1) with an Oracle Database (V 9.2) • Both FAT Client & terminal server users • Financials (AP/AR, Budget, Capital Assets, GL & Procurement) since 1-1-99 • HR/Payroll since 1-1-00 • JDE EnterpriseOne Report Writer • An internal support structure using business area leaders work on JDE initiatives

3. Product Selection • About two years ago started investigating 3rd party reporting solutions • Business area leaders attended the Midwest User Group, Oracle Open World and Quest Collaborate • Reporting tool vendors were identified • Demos were observed and evaluated • Much discussion took place and the focus of the search was divided among business area leaders

4. Product Selection (Continued) • Functional power users focused on: • The ad-hoc inquiry capabilities • Ease of use • Flexibility • Intuitiveness • Consistent look and feel that compliments JDE • The GL Company’s Really Real Time Inquiry Suite software was singled out to be the most viable solution to enhance reporting

5. Product Evaluation • Completed a two week trial of the Inquiry Suite: Accounts Payable, General Ledger and Procurement modules • On site with our own JDE data • Analyzed aged integrity issues from 1999 & 2000 and were resolved in a matter of a few hours during the trial • Prepared reports listing outstanding items for year-end review (journal entries, open commitments, payments, etc.)

6. Product Evaluation (Continued) • Developed auditor reports that wereprovided by IT prior to using the Inquiry Suite • Numerous inquiries and reports were created as useful financial decision making tools • Summarized information with condensed data for high level overviews for departments, divisions & programs • Provided detailed information for managers & supervisors to assist in identifying issues and celebrating successes

7. Decision and Implementation • Unanimous recommendation to purchase • Accounts Payable, General Ledger & Procurement • Retained all reports created during the trial • Continued to use the Inquiry Suite for year-end & the audit • Trained power users over 3 days and on day four held an interactive workshop with the trainer

8. Decision and Implementation (Continued) • Human Resources & Payroll powerusers completed a two week trial • Another unanimous recommendationto purchase • Executive Console, Human Resources & Payroll • Retained all inquiries/reports created during the trial • Continued to use the Inquiry Suite after the trial • Trained power users over 3 days and had another day for workshop

9. Inquiry Suite Benefits • Accelerates account reconciliation, data extractions & analysis for integrity issue troubleshooting • Drill down to transactions allows immediate access to details • Eliminates dependency on IT support for reporting solutions • Provides timely access to useful data and information to make decisions and conduct County business • Reporting packs save valuable time when multiple inquiries are needed on a regular basis

10. Inquiry Suite Benefits (Continued) • Reusable inquiry objects, another time saver, requires setup only once and the ability to use defined calculations, formats and hierarchies in any report within the suite • Power users are able to create simple ad-hoc inquiries as well as complex custom reports • Selector functionality simplifies data options for users that have little or no knowledge of JDE • Time series functionality has provided a reporting solution for County grant & multi-year programs

11. Inquiry Suite Benefits (Continued) • Developed numerous HR and Payroll reports that has saved time and resources in accessing, running and analyzing employee data and information • Arrearage report with pay period to pay period payment data and grand totals per employee • Employee information report to validate accuracy of data in JDE • Leave of absence report by type with beginning and ending dates • Longevity report that has eliminated a ten month manual process of monitoring eligibility requirements and calculating payment amounts • Overtime report with subtotals by business unit and a grand total • Various reports to assist in filing EEO/AA requirements with the Federal and State governments

12. The Inquiry Suite for JDEdwards • Product Overview • Purpose Built for JDEdwards World and EnterpriseOne (Plug & Play). • Allows end-users to create and use ad hoc inquiries and reports. • Accesses data real time (no staging or delay). • Easy to learn, easy to use (3 days of training). • Easy to install/configure (1 hour install). • Exceptional performance. • Users can share reports immediately. • Leverages JDE security. Modules Sales@TheGLCompany.com

13. Inquiry Suite Product Demonstration Sales@TheGLCompany.com

14. Questions & Answers Sales@TheGLCompany.com

15. WORLDWIDE NORTH AMERICA Europe: +44 (0)1494 582 039 • Australasia: +61 (0)2 8216 0810 Main Office: 303 872 6959 • East Coast: 646 673 8644 • West Coast: 714 371 4077 • South: 281 328 3222