September 26 rd , 2011

1. Trusted Business Advisor September 26rd, 2011 EE Financials Implementation Lessons Learned Presented By: Andy Vitullo, C.P.A. Principal, Logan Consulting

2. Agenda • Master Data Concepts • Significant EE Financial Functionality. • Key Activities for your Upgrade. • Profile of Organization. • What about Manufacturing and Distribution? • QAD Support. • CIM vs. Qxtend. • Character vs. .NetUI. • Wrap Up and Questions.

3. Target Audience for this Presentation • Project Sponsors • Controllers • IT Manangment • Project Managers

4. Who is Logan Consulting? • Logan Consulting is a professional services firm committed to helping businesses get the most from their information technology investments. Since 1992, we have been helping companies develop and execute business management and information systems strategies...from ERP selections and implementations to e-business planning to strategic IT applications.

5. Who is Logan Consulting? • Operating throughout North America, our clients are equally diverse...from global Fortune 100 companies to regional manufacturers...in both process and discrete industries. • We don’t sell QAD Software, We Implement the software tools to support your business requirements and processes.

6. BIO: Andy Vitullo • Principal (Owner) @ Logan • Consultant, Controller, Accounting Manager, Tax Preparer, Auditor. • CPA, State of Ohio • BS, Accounting – • An Implementer of ERP with over 15 Years of Experience.

7. Master Data Concepts

8. Master Data Concepts

9. EE Functionality • General Ledger Master Data Controls • Universal Charts of Accounts • Standard Accounting Transactions across domain with “Profiles”

10. EE Functionality • Extended GL Account String for Analysis of Operation Results – SAFs. • Operation Transactions provide the SAF to the Transaction.

11. EE Functionality • GL Layers • Official – There can be only one. • Management – Multiple. • Transient – Multiple. • Financial Reporting Across Layers or by Individual Layer.

12. EE Functionality • GL Layers • Official • System Transaction Set pointed to this layer • Operational and Financial Transaction Set. • Management • A GAAP or IFRS Layer. • Transient • Temporary GL Adjustment Entries requirement Approval into the Management layer. • GL Level Controls.

13. EE Functionality • Alternate COA • Business COA for used for Consolidation. • Alternate COA for Legal Statutory Reporting • COA provide to you by Legal Authority (China, Russia, France).

14. EE Functionality • Dual Base Currency GL Currency. • Example USA Company with Mexican Maquila. • Single Domain, Multi-entity Configuration. • Arms Length transaction set not required. • USA functional Currency with Mexico Statutory Currency. • User Friendly.

15. EE Functionality • Inter-domain-GL / AP / AR • Enables Financial Shared Services • Regional SS Offices

16. EE Functionality • Key Transactions in Financials • Procure to Pay • Quote to Cash • GL Closing Cycle. • Daybooks permeate all financial transactions. • Include in your planning effort.

17. Key Activities for Your Upgrade(EE Financial Implementation) • Planning and Scoping • Universal COA? • Consolidation? • Financial Interface Requirements? • Financial Reporting Requirements? • Financial Business Process Changes • Common Customer Master Across the Enterprise? • Common Supplier Master Across the Enterprise?

18. Key Activities for Your Upgrade • Insure Steering Committee is Assembled • Has vested Interest in Business Requirements. • Agrees to Scope of Effort. • Supports the Project with requisite Resources.

19. Profile of Organization EE is a Global Financial Accounting Package. Does Your Business Have these Requirements? • Multi-Country? • Multi-Currency? • Regional Shared Service Offices? • Global Procurement Organization? • Global Customer Service Organization?

20. Manufacturing & Distribution • Same Core Package as MFG/PRO. • Character Interfaces still available. • CIM Still available.

21. QAD Support • Full SE Support & Investment through 2015. • Sunset of SE in 2020. • Certain Extended Software Tools may only work with SE vs EE • Manufacturing and Scheduling Workbenches - EE • PRM – SE. • Do Your Due Diligence.

22. CIM vs. QXtend • Qxtend (XML) works across the entire platform. • QDocs available for EE financials and Operation modules. • CIM – Operation Modules. • Qxtend –Financial Modules and Operation Modules. • Technical Resources required with Qxtend. • Functional Business Analysts • Typically can use CIM. • May not have the skill set for Qxtend.

23. QXtend • Qxtend Interface • Excel Integrator. • Data Conversion tools from Legacy environment to EE. • Leverages Qdocs for Financials and Ops Modules. • Excel Intergration. • Embedded Transactions within EE financials. • Like JE Upload. • ~ 20 programs.

24. Interface • .Net – Exclusive to Financial EE Modules. • Apache Tomcat Skills required to Run .Net. • Character - Still works with Operation Modules. • Client Machines - Minimum Specs. • Fast processors, RAM.

25. Reporting Framework Forms Production • RF – Exclusive to EE Financials • AP Check • Customer Invoice From AR • Customer Statements • Jetforms / Optio • Operations Module forms • Shipper, Work Order, etc…

26. Wrap Up / Keys to Success • Strong Steering Committee • Well Defined Scope • Strong Project Management • View this as a new implementation • Not an upgrade.

27. Key Observations • EE financials is an Implementation • Significant change. • Tight Scope Important to Spend. • New Skills Required • Tomcat • Qxtend • Extend Your Scoping and Planning Effort. • Ensure Good Leadership.

28. Thank You • Andy Vitullo • Logan Consulting • www.logan-consulting.com • avitullo@logan-consulting.com • Go Zips