Midwest User Group Meeting

1. Midwest User Group Meeting Jeff Kohagen, Manager Financial Services Lance LaCross ,CPA, Senior Solutions Consultant Monday, September 24, 2012 EE Upgrade

2. Agenda • Enterprise Edition Review • What is Enterprise Edition (EE)? • Demystify Some Key Concepts • Daybooks • Business Relationships • Upgrade Process Considerations • Tools / Techniques • Questions & Answers

3. Why EE? • Reap the Benefits • Take advantage of new functionality • Reduce customizations • Reduce operational costs • Respond to globalization and consolidation needs • Increase user productivity • Ensure compliance • Optimize application and system performance • Drive lean principles throughout the organization

4. EE Review • Daybooks • Business Relationships • Layers • Status Codes (Customer Invoice, Supplier Invoice, Cash Applications, etc.) • SAF – Supplemental Analysis Fields • Intercompany vs. Cross Company • Trial Balance View - Drill Down • Financial Report Writer

5. Enterprise Edition GL Analytical Coding Segments Entity Yr/Pd Daybook = JE-ID Layer/Book header level Primary Acct - 8 Sub-Account-8 Cost Center-4 Project- 8 SAF’s SAF’s SAF’s SAF’s SAF’s Up to five ‘supplementary analysis fields’on a posting line line level Intercompany key • can automatically retrieve SAF data from Operational transactions • Site • Product Line • Region (Customer) • Customer Type • Supplier Type • Item Type • Item Group • Allows - actuals in value (in tc, bc, sc) • actuals in quantities • budgets Open item key Other GAAP Account

6. Review the QAD System… 6

7. Financial GL Report Writer Components

8. Review the QAD System… 8

9. Demystify - Two Key Concepts • Daybooks • Business Relationship

10. Daybooks – What Are They? • General ledger transaction type! • IC • RCT-UNP • ISS-SO

11. Daybooks • With no daybooks defined • Journal entries • Account – sub – cc – source - amt • 5000 100 4000 IC 75.00 • 5000 100 4000 IC -65.00

12. Daybooks • With daybooks defined • Journal entries • Account – sub – cc – source –daybook amt • 5000 100 4000 IC rct-unp -75.00 • 5000 100 4000 IC iss-so 65.00

13. Journal Entry View with Daybooks

14. Easy Set up

15. Daybooks - EE • Now Required • Integral to document numbering • Invoices • Can be set by site

16. Business Relations • Explicit entry of the Address Record • Coding can be distinct from customer, supplier • Associated multiple addresses • Contacts • Bill-to • Ship-to • System wide • Can be restricted to a domain

17. Business Relations

18. Business Relations - Contacts

19. Customer

20. Upgrade Process Considerations? • The Plan • Objective • Template • Conversion vs. Data Loading • Why one vs. the other? • Data Conversion Guide • Pre Conversion Tools • Validates Current • Data Entry (for new features i.e. daybooks) • Easy On Boarding Process • Investment / Cost – How Much???

21. Conversion Process

22. Tools • Standard Conversion Tool • Domain Merge Tool • Custom Code Conversion Tool • Program Tracer Tool • Non-intrusive Customization Framework 22

23. Migrate Risk & Investment • Convert with no new features • Convert with new features

24. Convert with No New Features • Convert With No New Features • Daybooks • Business Relationship • Invoice Status Codes • Security

25. Convert with New Features • Convert With New Features • Daybooks • Business Relationship • Invoice Status Codes • Security • Shared Sets • SAF • Shared Services • GL Allocations • Banking (Electronic, Lock Box, etc.) • Financial Reporting • Statutory Currency

26. Summary • You Can Upgrade • Time • Resource • Expense • Reap the Benefits • Maximize: • QAD Investment • Efficiencies • Benefits

27. Thank You! Questions?