Enterprise Edition Financials A Core Model Design

Publish in

Documents

7 views

Please download to get full document.

View again

of 29
All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
Share
Description
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.
Transcript
Enterprise Edition FinancialsA Core Model DesignPresented by: Andy VitulloLogan ConsultingIntroduction
  • Andy Vitullo
  • Principal, Logan Consulting
  • 17 years of QAD ERP Implementation Experience
  • Certified Public Accountant (CPA) - State of Ohio
  • University of Akron
  • Agenda
  • Company Profile
  • Key Business / Reporting Data
  • Management Objectives
  • Design Challenges
  • EE System Accounts and their Impact on Accounting
  • The Design
  • Open Forum
  • 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
  • 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
  • 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
  • Company Profile (Continued)
  • Shared Services - USA
  • Accounts Payable
  • Accounts Receivable
  • Credit and Collections
  • Fixed Assets
  • 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
  • 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
  • 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
  • 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
  • Shared Sets of DataControl AccountsControl AccountsList of Control Accounts
  • Show excel workbook
  • System Account Sub CategoriesShow System Account Worksheet. System Account Sub CategoriesEE Financial Configuration ConceptsThe Design
  • Layers
  • COA
  • Masking
  • Alternate COA
  • Databases – Domains - Entity
  • 3 Databases
  • Europe – 11 Domains - 15 Entities
  • APAC – 12 Domains – 15 Entities
  • NA - 17 Domains – 20 Entities
  • LayersAccounts
  • 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 ExcelSAFs – 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)
  • SAFs – Account AnalysisCash Account Approach
  • Cash Accounts Are Currency Specific.
  • Cash Accounts Are bank Specific.
  • Enables consolidation view of all cash accounts.
  • Account Analysis Rules
  • Define BEFORE you load your accounts
  • Shared Set Design
  • See worksheet.
  • Statutory Reporting and Accounting
  • Alternate Chart of Accounts
  • Transaction level detail with Global and Alternate Chart
  • Example: French Stat GL AccountsOpen Forum
    Related Search

    Previous Document

    Be Winners

    Next Document

    Angel

    We Need Your Support
    Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

    Thanks to everyone for your continued support.

    No, Thanks