Contents

• Title and Copyright Information
• Preface

1 Introduction to JD Edwards EnterpriseOne Base Currency Conversion

• JD Edwards EnterpriseOne Base Currency Conversion Overview
  • Conversion Guidelines
• JD Edwards EnterpriseOne Base Currency Conversion Integrations
• JD Edwards EnterpriseOne Base Currency Conversion Implementation
  • JD Edwards EnterpriseOne Base Currency Conversion Implementation Steps

2 Understanding the Base Currency Conversion Implementation Guide

• Understanding the Base Currency Conversion Implementation Guide
• Test Versus Production Environments
• Types of Tasks
  • Preconversion Tasks
  • Conversion Tasks
  • Postconversion Tasks

3 Understanding the Base Currency Conversion

• Ledgers Affected by the Conversion
  • XA, YA, and ZA Ledgers and Detailed Restatement Records
• Accounts Receivable and Accounts Payable Affected by the Conversion
• General Accounting Affected by the Conversion
  • Domestic and Foreign Currency Ledger Amounts in the F0911 Table
    • Domestic Currency Transaction
    • Foreign Currency Transaction
    • AA Example: Domestic Currency Transaction Before and After the Conversion
    • AA and CA Examples: Foreign Currency Transactions Before and After the Conversion
    • Example: Foreign Transactions That Are Not In the Currency of the New Base Currency
    • Example: Foreign Transactions That Are In the Currency of the New Base Currency
  • Alternate Currency Ledgers in the F0911 Table
    • Domestic Currency Transaction
    • Foreign Currency Transaction
    • XA, YA, and ZA Example: Domestic Currency Transaction Before and After the Conversion
    • XA, YA, and ZA Examples: Foreign Currency Transactions Before and After the Conversion
    • Example: Foreign Transactions That Are Not In the Currency of the New Base Currency
    • Example: Foreign Transactions That Are In the Currency of the New Base Currency
• Sales Order Management Affected by the Conversion
• Procurement Affected by the Conversion
  • Example: Recalculating PRRC
• Base Currency Conversion and Non-JD Edwards EnterpriseOne Records

4 Understanding Strategies, Test Environments, Sizing Impacts, and Indexes

• Base Currency Conversion Strategies
  • Conversion Timeline
  • Conversion Project Team
  • Example of an Approach to the Conversion
• Conversion Test Environment Setup
• System Sizing Impacts and System Resources
  • Sizing Impacts on the F0911, F0902, and F0086 Tables
    • Sizing Impacts on the F0911 and F0902 Tables
    • Sizing Impacts on the F0086 Table
  • System Resources and Performance
• Creation of Indexes Before Running the Conversion
  • Creating Indexes Before Running JD Edwards EnterpriseOne Base Currency Conversion

5 Completing System-Level Prerequisites

• Understanding System-Level Prerequisites
• Completing the System-Level Prerequisite Checklist

6 Completing Preconversion Tasks

• Understanding the Preconversion Tasks
• Verifying the CRCD and CRCX Currency Code Fields
  • Example of Currency Code Values for CRCD and CRCX Fields
  • F0010 Table
  • F0901 Table
  • F0911 Table
  • F0902 Table
• Completing the Financial Management Preconversion Checklist
  • Completing the Accounts Receivable Preconversion Checklist
  • Completing the Accounts Payable Preconversion Checklist
  • Completing the General Accounting Preconversion Checklist
  • Completing the Reports Preconversion Checklist
  • Completing the Localization Preconversion Checklist
  • Completing Fixed Assets and Job Cost Preconversion Checklists
• Completing the Distribution Preconversion Checklist
• Completing the Manufacturing Preconversion Checklist
• Completing the Final Post Preconversion Checklist

7 Running Preconversion Integrity Reports

• Understanding Preconversion Integrity Reports
• Completing the Financial Management Preconversion Integrity Checklist
  • Completing the Accounts Receivable Preconversion Integrity Checklist
  • Completing the Accounts Payable Preconversion Integrity Checklist
  • Completing the General Accounting Preconversion Integrity Checklist
  • (ITA) Completing the Localizations Preconversion Integrity Checklist
  • Completing the Fixed Assets and Job Cost Preconversion Integrity Checklists
  • Completing the Change Management Preconversion Integrity Checklist
• Completing the Contract/Service Billing Preconversion Integrity Checklist
• Completing the Distribution Preconversion Integrity Checklist
• Completing the Logistics Preconversion Integrity Checklist
• Completing the Manufacturing Preconversion Integrity Checklist
• Completing the Batch Header Preconversion Integrity Checklist
• Completing the Repost Account Ledger Integrity Checklist

8 Purging Outdated Data

• Purging Outdated Data
• Understanding the Purge and Outdated Data
• Prerequisites
• Running the General Purge Programs
• Running the Financial Management Purge Programs
  • Completing the Address Book Purge Checklist
  • Completing the Accounts Receivable Purge Checklist
  • Completing the Accounts Payable Purge Checklist
  • Completing the General Accounting Purge Checklist
  • Completing the Fixed Assets Purge Checklist
• Running the Distribution Purge Programs
  • Completing the Procurement Purge Checklist
  • Completing the Sales Order Management Purge Checklist
  • Completing the Electronic Commerce Purge Checklist
• Running the Logistics Purge Programs
  • Completing the Warehouse Management Purge Checklist
• Running the Manufacturing Purge Programs
  • Completing the Work Orders Purge Checklist

9 Rerunning Preconversion Integrity Reports

• Rerunning the Preconversion Integrity Reports

10 Updating the Conversion Scheduler

• List of Conversion Programs to Add to the Scheduler
  • Xe
  • 8.0
  • 8.9
  • 8.10
  • 8.11
  • 8.11 SP1
  • 8.12
  • 9.0
  • 9.1
  • 9.2
• Adding Conversion Programs to the Scheduler
  • Understanding the Scheduler
  • Forms Used To Add Conversion Programs to the Scheduler
  • Adding Conversion Programs to the Scheduler

11 Updating the Audit Record Table for Model Plan ZJDE

• Understanding the Audit Record Table for Plan ZJDE
• Updating the Audit Record Table for Plan ZJDE
  • Forms Used to Update the Audit Record Table for Plan ZJDE
  • Updating the Audit Record Table for Plan ZJDE

12 Completing Conversion Tasks

• Understanding Base Currency Conversion Plans
• Setting Up Conversion Plans
  • Understanding Conversion Plan Setup
  • Understanding Conversion Plan Constants
  • Understanding Audit Records
  • Prerequisites
  • Forms Used To Set Up Conversion Plans
  • Verifying Statuses for UDC Table H90/DS
  • Setting Up a Conversion Plan
  • Setting Up Conversion Plan Constants
  • Preventing the Creation of Audit Records
• Running the Base Currency Conversion
  • Understanding the Conversion Workbench
  • Understanding Differences Between the Workbench and Postconversion Programs
  • Prerequisites
  • Form Used To Run the Conversion Workbench
  • Reviewing Programs for a Conversion Plan
  • Running the Conversion Workbench
• Running Multiple Versions of the Accounts Receivable Conversion Programs
  • Understanding Accounts Receivable Tables
    • Example: Multiple Versions of the Accounts Receivable Conversion Programs
  • Running Multiple Versions of an Accounts Receivable Conversion Program
• Running Multiple Versions of the F0911 Conversion Program
  • Understanding the F0911 Table
  • Example: Running Multiple Versions of the F0911 Conversion Program
  • Running Multiple Versions of the Convert F0911 Base Currency Program
• Verifying the Status of the Base Currency Conversion
  • Understanding Base Currency Conversion Status
  • Forms Used to Verify the Status of the Base Currency Conversion
  • Verifying the Base Currency Conversion Status
    • Verifying Status When All Programs Have a Status of 60
    • Verifying Status When One or More Programs Have a Status of 50
• Reviewing Base Currency Conversion Reports
  • Understanding Base Currency Conversion Reports
  • Reviewing the Table Conversion/Merge Driver Report
  • Reviewing the Conversion Log
  • Reviewing the Table Conversion Report
    • Messages on the Table Conversion Report
    • Informational Message
    • Error Messages
• Reviewing the Conversion Audit Records
  • Understanding the Conversion Audit Records
  • Reviewing the F0086 Table
    • Exchange Rate Fields in the Conversion Audit Table
• Rerunning a Conversion Program
  • Understanding the Rerun of a Conversion Program
  • Forms Used to Rerun a Conversion Program
  • Rerunning a Conversion Program Before Updating the F0010 Table
  • Rerunning a Conversion Program After Updating the F0010 Table
• Deleting the Conversion Log for a Plan
  • Understanding Conversion Log Deletion
  • Forms Used to Delete the Conversion Log for a Plan
  • Deleting a Conversion Log

13 Running Postconversion Programs

• Running Postconversion Programs
• Changing Plan Exchange Rates for Postconversion Programs
  • Understanding Plan Exchange Rate Revisions
    • Example of Running a Postconversion Program Multiple Times for a Plan
  • Forms Used to Change the Plan Exchange Rate
  • Changing the Exchange Rate for a Plan
• Suppressing Audit Records for Postconversion Programs
  • Understanding Suppression of Audit Records
  • Forms Used to Suppress Audit Records for Postconversion Programs
  • Preventing Audit Records from Being Created for Postconversion Programs
• Running Ordered Conversion Programs
  • Understanding Ordered Conversion Programs
  • Prerequisite
  • Running the Ordered Conversion Programs
    • Sales Order Management
    • General Accounting
    • Product Data Management
    • All Systems (Required)
• Converting Multicurrency Intercompany Transactions
  • Understanding the Multicurrency Intercompany Conversion
  • Understanding the Multicurrency Intercompany Post
    • Multicurrency Intercompany Post Report
  • Converting Multicurrency Intercompany Transactions
• Running Additional Conversion Programs
  • Understanding Additional Conversion Programs
  • Prerequisites
  • Running the Additional Conversion Programs
    • Localization
    • Expense Management
    • Real Estate Management and Advanced Real Estate
    • Customer Relationship Management
    • Sales Order Management
    • Advanced Pricing
    • Procurement
    • Grower Management
    • Operational Sourcing
    • Blend Management
    • Agreement Management
    • Advanced Transportation Management
    • Service Billing and Contract Billing
    • Plant and Equipment Management
    • Product Data Management
    • Contract Management
    • Stock Valuation

14 Running Postconversion Integrity Reports

• Running Postconversion Integrity Reports
  • Understanding Postconversion Integrity Reports
    • Prerequisites
  • Completing the Financial Management Postconversion Integrity Checklists
    • Accounts Receivable
    • Accounts Payable
    • General Accounting
    • (ITA) Localization
    • Fixed Assets/Job Cost
    • Change Management
  • Completing the Contract/Service Billing Postconversion Integrity Checklist
  • Completing the Procurement Postconversion Integrity Checklist
  • Completing the Inventory Management Postconversion Integrity Checklist
  • Completing the Product Data Management Postconversion Integrity Checklist
  • Completing the Batch Header Postconversion Integrity Checklists

15 Running the Repost Account Ledger Program

• Understanding the Repost Accounting Ledger Program
• Prerequisites
• Reposting the Account Ledger

16 Completing Postconversion Tasks

• Understanding Postconversion Tasks
• Completing the Financial Management Postconversion Checklist
  • Completing the General Accounting Postconversion Checklist
  • Completing the Accounts Receivable Postconversion Checklist
  • Completing the Accounts Payable Postconversion Checklist
  • Completing the Localization Postconversion Checklist
• Completing the Plant & Equipment Management Postconversion Checklist
• Completing the Homebuilder Postconversion Checklist
• Completing the Distribution Postconversion Checklist
• Completing the Manufacturing Postconversion Checklist

17 Converting the Production Environment

• Converting the Production Environment

18 Appendix A - JD Edwards EnterpriseOne Base Currency Conversion Tables

• Base Currency Conversion Tables List

19 Appendix B - Ordered and Additional Conversion Tables

• Ordered Conversion Tables
• Additional Conversion Tables

20 Appendix C - Composite Keys for JD Edwards EnterpriseOne Systems

• Composite Keys List

21 Appendix D - Clauses for Conversion Program Indexes

• Clauses for Indexes

22 Glossary

• Plan Name
• Plan Status