1 / 30

Enterprise Edition Financials A Core Model Design

Enterprise Edition Financials A Core Model Design. Presented by: Andy Vitullo Logan Consulting. Introduction. Andy Vitullo Principal, Logan Consulting 17 years of QAD ERP Implementation Experience Certified Public Accountant (CPA) - State of Ohio University of Akron . Agenda.

abdalla
Download Presentation

Enterprise Edition Financials A Core Model Design

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. Enterprise Edition FinancialsA Core Model Design Presented by: Andy Vitullo Logan Consulting

  2. Introduction • Andy Vitullo • Principal, Logan Consulting • 17 years of QAD ERP Implementation Experience • Certified Public Accountant (CPA) - State of Ohio • University of Akron

  3. Agenda • Company Profile • Key Business / Reporting Data • Management Objectives • Design Challenges • EE System Accounts and their Impact on Accounting • The Design • Open Forum

  4. Company Profile • Operations in North America, EMEA, APAC • 40 sites globally • 40 databases/ Version eb2.1 • Central Order Processing Model in US • Common Customer and Suppliers • Lacks master data organization • EMEA - single site single entity databases • APAC - multi-site, multi-entity databases with entity separation at the business unit level

  5. Company Profile (Continued) • Business Units are generally aligned by ‘Sites’ and ‘Product Family’ • IT Application Support Staff ~ 20 resources globally (B/A’s, EDI, DBA’s) • Analytical Tools • Oracle DSS (Financial And Sales Analysis Cubes). • Data Warehouse (Refreshed Daily) • Cyber query • .NET Browses & Collections

  6. Company Profile (Continued) • Accounting Department Profile • VP of Finance - Business CFO • Business Group Controllers • Business Unit Controllers • Site Controllers & Cost Accountants. • Shared Services Accountants • SGA, Treasury & Tax Accounting

  7. Company Profile (Continued) • Shared Services - USA • Accounts Payable • Accounts Receivable • Credit and Collections • Fixed Assets

  8. Key Business / Reporting Data • ‘Product Family’ Profit and Loss to EBITA • ‘Product Lines’ Roll Up to ‘Product Family’ • Product Family = Cost Center • Allocations of Expenses to Product Family from other COGS through EBITA

  9. Management Strategic Objectives • Retirement of Unsupported Software • Support IFRS Requirements • Increased Level of Controls at General Ledger Level • Internal Audit issue with Standard Edition (SE) GL • Journal Entry Approval Control does not exist in the SE GL • Stand Up Shared Services Accounting by Country

  10. Implementation Goals • Upgrade to a current version of QAD Enterprise Software • Combine 40databases to 3 regional databases • Deploy, Manage, and Control Global Chart of Accounts across all QAD Facilities to include Accounts, Sub Accounts, Cost Centers and Projects • Deploy standard currency exchange rates across databases to support alternate currency transactions • Implement new accounts payable and receivable modules • Implement integrated QAD fixed asset module in North America • Minimize Impact on operations • Elimination of custom code for central order processing model • Sustainable ERP environment to last 10 - 15 years

  11. Design Challenges • Statutory Reporting and Statutory Accounts in certain countries • COP AR and AP in single US database • Disparate Charts of accounts across databases • Region Database (3) in future state • EE System Account Requirements • GAAP, NON GAAP and IFRS reporting • Accounts used differently by jurisdiction

  12. Shared Sets of Data

  13. Control Accounts

  14. Control Accounts

  15. List of Control Accounts • Show excel workbook

  16. System Account Sub Categories Show System Account Worksheet.

  17. System Account Sub Categories

  18. EE Financial Configuration Concepts

  19. The Design • Layers • COA • Masking • Alternate COA

  20. Databases – Domains - Entity • 3 Databases • Europe – 11 Domains - 15 Entities • APAC – 12 Domains – 15 Entities • NA - 17 Domains – 20 Entities

  21. Layers

  22. Accounts • Shared Set of Accounts Across all Domains in Each Database • Manual Replication of Accounts from Database to Database • Qxtend Phase 2 Note to self: Show Shared Set Logic in Excel

  23. SAFs – Extended Account String • Item Type – (Item Master Attribute) • Item Group – (Item Master Attribute) • Product Line - (Item Master Attribute) • Customer Type – (Customer Master Attribute) • Customer Region - (Customer Master Attribute) • Supplier Type - (Supplier Master Attribute) • Site - (Order Attribute)

  24. SAFs – Account Analysis

  25. Cash Account Approach • Cash Accounts Are Currency Specific. • Cash Accounts Are bank Specific. • Enables consolidation view of all cash accounts.

  26. Account Analysis Rules • Define BEFORE you load your accounts

  27. Shared Set Design • See worksheet.

  28. Statutory Reporting and Accounting • Alternate Chart of Accounts • Transaction level detail with Global and Alternate Chart Example: French Stat GL Accounts

  29. Open Forum

More Related