Trusted Business Advisor Lessons Learned for Financial Implementations
"Discover valuable insights and lessons learned from a Trusted Business Advisor on EE Financials Implementation. Gain knowledge on key activities, organization profiles, and more to enhance your financial systems effectively."
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.
E N D
Presentation Transcript
Trusted Business Advisor Trusted Business Advisor EE Financials Implementation - Fall 2014 Lessons Learned March 24th, 2015 Presented By: Andy Vitullo, C.P.A. Principal, Logan Consulting
Trusted Business Advisor 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. Fall 2014 Upgrade/Implementation Cutover Check List /Master Data Check List Wrap Up and Questions.
Trusted Business Advisor Target Audience for this Presentation Companies still running SE or Earlier Versions. Project Sponsors Controllers IT Management Project Managers
Trusted Business Advisor 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.
Trusted Business Advisor Who is Logan Consulting? Operating throughout North America, our clients are equally diverse...from global Fortune 100 companies manufacturers...in both process and discrete industries. to regional We don t sell QAD Software, We Implement the software tools to support your business requirements and processes.
Trusted Business Advisor 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 20 Years of Experience.
Trusted Business Advisor Master Data Concepts
Trusted Business Advisor Master Data Concepts
Trusted Business Advisor EE Functionality General Ledger Master Data Controls Universal Charts of Accounts Standard Accounting Transactions across domain with Profiles
Trusted Business Advisor EE Functionality Extended GL Account String for Analysis of Operation Results SAFs. Can Eliminate SAM, IAM, PAM and WAM
Trusted Business Advisor EE Functionality GL Layers Official There can be only one. Management Multiple. Transient Multiple. Financial Reporting Across Layers or by Individual Layer.
Trusted Business Advisor 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.
Trusted Business Advisor 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).
Trusted Business Advisor 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.
Trusted Business Advisor EE Functionality Inter-domain-GL / AP / AR Enables Financial Shared Services Regional SS Offices
Trusted Business Advisor 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.
Trusted Business Advisor Key Activities for Your Upgrade (EE Financial Implementation) Planning and Scoping COA Enhancement Required Consolidation? Financial Interface Requirements? Financial Reporting Requirements? Financial Business Process Changes Common Customer Master Across the Enterprise? Common Supplier Master Across the Enterprise?
Trusted Business Advisor 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?
Trusted Business Advisor Manufacturing & Distribution Same Core Package as MFG/PRO. Character Interfaces still available. CIM Still available.
Trusted Business Advisor 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.
Trusted Business Advisor QXtend Qxtend Interface Excel Integrator. Data Conversion tools from Legacy environment to EE. Leverages Qdocs for Financials and Ops Modules. Excel Integration. Embedded Transactions within EE financials.
Trusted Business Advisor 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.
Trusted Business Advisor 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
Trusted Business Advisor Client Back Ground - Fall 2014 Canadian Based Business Metal Molding Single Site Tier 2 & 3, auto and industrial customers. CAD Base Currency Alternate Currency Transactions 3.5 Resources per Accounting Department
Trusted Business Advisor Goals of Project Upgrade from Version 8.5 MFG/PRO Upgrade to Enterprise Edition version 2014 Cleanse and Refresh Master Data Customers Suppliers Items Maintain COA - Add Control Accounts Stand Up SAF Codes
Trusted Business Advisor Statistics Single Domain Single site Single Entity 6 month Implementation / Part Time Logan Services New database.
Trusted Business Advisor Approach Seed a new EE database with updated/different master data. Augmented chart of accounts (control Accounts) From Multi-Site to Single Site. From Multi-Entity to Single Entity. Perform Process Design/Review to insure Efficient Use of EE financials. Loaded All Master Data Tables, Converted GL History at the Trial Balance Level. Deployed Financial Report Writer.
Trusted Business Advisor Process Objectives Financials Stand Up Financial Modules to Support Accounts Payable Processing Accounts Receivable Processing General Ledger Processing Multi-Currency Processing to include month- end Foreign Exchange Revaluation of Transactions.
Trusted Business Advisor Key Master Data Loads Review Master Data Load Workbook. Time to test and load all master data for Financials and Operations 1st Data Load Test 3 Weeks 2nd Data Load Test 1 Week Production Master Data Load effort 4 Days. Internal Team owned assembling and cleansing data.
Trusted Business Advisor Integration Work Accounts Payable Banking Integration Payment files to Bank ACH Payment files to Bank Checks Positive Pay
Trusted Business Advisor Process Work Accounts Receivable Customer Invoices Create (DR/CR Memo s) Deduction Management Payment Creation (Application)
Trusted Business Advisor General Ledger GL Close Processing Journal Entries Excel Integration Entity Cutoff Calendar Management FX revaluation
Trusted Business Advisor Lessons Learned Excel Integration is challenging. Large < 400 to 500 records are problematic. Requires breaking load data into multiple load files. FX Revaluation Settings are numerous. Account Level Currency Settings Revaluation is at the transaction level. Added additional GL accounts for alternate currency transactions for Receivables and Payables. COA Mapping Required for All implementations /upgrades. Additions accounts required in EE (Control Accounts)
Trusted Business Advisor Lessons Learned Tax Environment Should be Reviewed Make sure you map out all tax conditions required. GTM May Need updating. Taxable Supplier Invoices Process requires voucher level changes for use tax accrual, if PO s are calculated differently. Load your Trial Balances via Excel Integration to Primary Layer. Cannot load tax accounts to the transient layer. Daemons must be running!! Replication daemon ensure that your trial balance is complete from posted transactions. Cube Daemon refreshes FRW Cube in real time.
Trusted Business Advisor Lessons Learned Don t punt on dynamic data conversion. For Financials convert Open Receivers. Open Payables Open Receivables Impact FX Revaluations will need to be completed in new and legacy environments. Convert Outstanding Checks for Bank Recon. Use Open Item Adjustment for alternate currency transactions settled on Bank Account that does not support that currency.
Trusted Business Advisor Cutover Process Show Cutover Checklist
Trusted Business Advisor Thank You Andy Vitullo Logan Consulting www.logan-consulting.com avitullo@logan-consulting.com Go Zips
