implementationtoolkit.doc

Implementation Toolkit Financial Close Management Configuring ERPI for ARM Author: Heather Lynds Creation Date: Feb 21, 2012 Last Updated: Apr 17, 2012 Document Version: 1.0 Status: DRAFT Table of Contents 1. Overview 4 1.1 Purpose of this Document 4 2. Data Integration Options 5 2.1 ERP Sources 5 2.2 Open Interface Method 5 2.3 File-Based Data Loads 5 2.3.1 File Naming Convention 5 2.3.2 File Columns 6 2.3.3 Importing Balances Associated with Different Currency Buckets 6 3. Data Load Process 8 4. Planning the ERPI Configuration 9 4.1 Planning Locations 9 4.1.1 One for each Unique Chart of Accounts within a Single Source System 9 4.1.2 Multiple Reconciliation Processes 10 4.1.3 Same Source System Account reconciled in 2 different Profiles in a Single Process 10 5. Configuring ERPI for ARM 11 5.1 Configure System Settings 11 5.2 Register Target Application 12 5.2.1 Configure the Target Application Summary 12 5.2.2 Configure the Dimension Details 12 5.3 Period Mapping 14 5.3.1 Global Mapping 15 5.3.2 Application Mapping 16 5.3.3 Source Mapping 16 5.4 Category Mapping 16 5.4.1 Review ARM Currency Configuration 16 5.4.2 Single Currency Category Mapping 17 5.4.3 Multi-Currency Category Mapping 17 5.5 Register Source Systems 18 5.6 Register Source Adapter 18 5.7 Select Source Accounting Entities 19 5.7.1 Configure Accounting Entities 20 5.7.2 Configure Entity Groups 20 5.8 Configure Import Formats 21 5.8.1 Configure Details 21 5.8.2 Configure Mappings 22 5.9 Configure Locations 26 5.10 Configure Data Load Rules 27 5.10.1 Configuring Data Load Rules for ERP Sources 27 5.10.2 Configuring Data Load Rules for File-Based Data Loads 29 5.11 Configure Data Load Mapping 30 5.11.1 Rules Assigning ARM Profile ID’s 31 5.11.2 Rules Assigning ARM Balance Source Types 33 5.11.3 Import Data Load Mappings 34 6. Appendix 1: Supported Currency Codes 39 7. Appendix 2: Troubleshooting 42 7.1 ODI Studio Error Message 42 8. Index 43 Overview Integration of account balances