Go to main content
1/27
Contents
List of Figures
Title and Copyright Information
Preface
Audience
JD Edwards EnterpriseOne Products
JD Edwards EnterpriseOne Application Fundamentals
Documentation Accessibility
Related Documents
Conventions
1
Introduction to JD Edwards EnterpriseOne Base Currency Conversion
1.1
JD Edwards EnterpriseOne Base Currency Conversion Overview
1.1.1
Conversion Guidelines
1.2
JD Edwards EnterpriseOne Base Currency Conversion Integrations
1.3
JD Edwards EnterpriseOne Base Currency Conversion Implementation
1.3.1
JD Edwards EnterpriseOne Base Currency Conversion Implementation Steps
2
Understanding This Implementation Guide
2.1
Test Versus Production Environments
2.2
Types of Tasks
2.2.1
Preconversion Tasks
2.2.2
Conversion Tasks
2.2.3
Postconversion Tasks
3
Understanding the Base Currency Conversion
3.1
Ledgers Affected by the Conversion
3.1.1
XA, YA, and ZA Ledgers and Detailed Restatement Records
3.2
Accounts Receivable and Accounts Payable Affected by the Conversion
3.3
General Accounting Affected by the Conversion
3.3.1
Domestic and Foreign Currency Ledger Amounts in the F0911 Table
3.3.1.1
Domestic Currency Transaction
3.3.1.2
Foreign Currency Transaction
3.3.1.3
AA Example: Domestic Currency Transaction Before and After the Conversion
3.3.1.4
AA and CA Examples: Foreign Currency Transactions Before and After the Conversion
3.3.1.5
Example: Foreign Transactions That Are Not In the Currency of the New Base Currency
3.3.1.6
Example: Foreign Transactions That Are In the Currency of the New Base Currency
3.3.2
Alternate Currency Ledgers in the F0911 Table
3.3.2.1
Domestic Currency Transaction
3.3.2.2
Foreign Currency Transaction
3.3.2.3
XA, YA, and ZA Example: Domestic Currency Transaction Before and After the Conversion
3.3.2.4
XA, YA, and ZA Examples: Foreign Currency Transactions Before and After the Conversion
3.3.2.5
Example: Foreign Transactions That Are Not In the Currency of the New Base Currency
3.3.2.6
Example: Foreign Transactions That Are In the Currency of the New Base Currency
3.4
Sales Order Management Affected by the Conversion
3.5
Procurement Affected by the Conversion
3.5.1
Example: Recalculating PRRC
3.6
Base Currency Conversion and Non-JD Edwards EnterpriseOne Records
4
Understanding Strategies, Test Environments, Sizing Impacts, and Indexes
4.1
Base Currency Conversion Strategies
4.1.1
Conversion Timeline
4.1.2
Conversion Project Team
4.1.3
Example of an Approach to the Conversion
4.2
Conversion Test Environment Setup
4.3
System Sizing Impacts and System Resources
4.3.1
Sizing Impacts on the F0911, F0902, and F0086 Tables
4.3.1.1
Sizing Impacts on the F0911 and F0902 Tables
4.3.1.2
Sizing Impacts on the F0086 Table
4.3.2
System Resources and Performance
4.4
Creation of Indexes Before Running the Conversion
4.4.1
Creating Indexes Before Running JD Edwards EnterpriseOne Base Currency Conversion
5
Completing System-Level Prerequisites
5.1
Understanding System-Level Prerequisites
5.2
Completing the System-Level Prerequisite Checklist
6
Completing Preconversion Tasks
6.1
Understanding the Preconversion Tasks
6.2
Verifying the CRCD and CRCX Currency Code Fields
6.2.1
Example of Currency Code Values for CRCD and CRCX Fields
6.2.2
F0010 Table
6.2.3
F0901 Table
6.2.4
F0911 Table
6.2.5
F0902 Table
6.3
Completing the Financial Management Preconversion Checklist
6.3.1
Completing the Accounts Receivable Preconversion Checklist
6.3.2
Completing the Accounts Payable Preconversion Checklist
6.3.3
Completing the General Accounting Preconversion Checklist
6.3.4
Completing the Reports Preconversion Checklist
6.3.5
Completing the Localization Preconversion Checklist
6.3.6
Completing Fixed Assets and Job Cost Preconversion Checklists
6.4
Completing the Distribution Preconversion Checklist
6.5
Completing the Manufacturing Preconversion Checklist
6.6
Completing the Final Post Preconversion Checklist
7
Running Preconversion Integrity Reports
7.1
Understanding Preconversion Integrity Reports
7.2
Completing the Financial Management Preconversion Integrity Checklist
7.2.1
Completing the Accounts Receivable Preconversion Integrity Checklist
7.2.2
Completing the Accounts Payable Preconversion Integrity Checklist
7.2.3
Completing the General Accounting Preconversion Integrity Checklist
7.2.4
(ITA) Completing the Localizations Preconversion Integrity Checklist
7.2.5
Completing the Fixed Assets and Job Cost Preconversion Integrity Checklists
7.2.6
Completing the Change Management Preconversion Integrity Checklist
7.3
Completing the Contract/Service Billing Preconversion Integrity Checklist
7.4
Completing the Distribution Preconversion Integrity Checklist
7.5
Completing the Logistics Preconversion Integrity Checklist
7.6
Completing the Manufacturing Preconversion Integrity Checklist
7.7
Completing the Batch Header Preconversion Integrity Checklist
7.8
Completing the Repost Account Ledger Integrity Checklist
8
Purging Outdated Data
8.1
Understanding the Purge and Outdated Data
8.2
Prerequisites
8.3
Running the General Purge Programs
8.4
Running the Financial Management Purge Programs
8.4.1
Completing the Address Book Purge Checklist
8.4.2
Completing the Accounts Receivable Purge Checklist
8.4.3
Completing the Accounts Payable Purge Checklist
8.4.4
Completing the General Accounting Purge Checklist
8.4.5
Completing the Fixed Assets Purge Checklist
8.5
Running the Distribution Purge Programs
8.5.1
Completing the Procurement Purge Checklist
8.5.2
Completing the Sales Order Management Purge Checklist
8.5.3
Completing the Electronic Commerce Purge Checklist
8.6
Running the Logistics Purge Programs
8.6.1
Completing the Warehouse Management Purge Checklist
8.7
Running the Manufacturing Purge Programs
8.7.1
Completing the Work Orders Purge Checklist
9
Rerunning Preconversion Integrity Reports
9.1
Rerunning the Preconversion Integrity Reports
10
Updating the Conversion Scheduler
10.1
List of Conversion Programs to Add to the Scheduler
10.1.1
Xe
10.1.2
8.0
10.1.3
8.9
10.1.4
8.10
10.1.5
8.11
10.1.6
8.11 SP1
10.1.7
8.12
10.1.8
9.0
10.1.9
9.1
10.1.10
9.2
10.2
Adding Conversion Programs to the Scheduler
10.2.1
Understanding the Scheduler
10.2.2
Forms Used To Add Conversion Programs to the Scheduler
10.2.3
Adding Conversion Programs to the Scheduler
11
Updating the Audit Record Table for Model Plan ZJDE
11.1
Understanding the Audit Record Table for Plan ZJDE
11.2
Updating the Audit Record Table for Plan ZJDE
11.2.1
Forms Used to Update the Audit Record Table for Plan ZJDE
11.2.2
Updating the Audit Record Table for Plan ZJDE
12
Completing Conversion Tasks
12.1
Understanding Base Currency Conversion Plans
12.2
Setting Up Conversion Plans
12.2.1
Understanding Conversion Plan Setup
12.2.2
Understanding Conversion Plan Constants
12.2.3
Understanding Audit Records
12.2.4
Prerequisites
12.2.5
Forms Used To Set Up Conversion Plans
12.2.6
Verifying Statuses for UDC Table H90/DS
12.2.7
Setting Up a Conversion Plan
12.2.8
Setting Up Conversion Plan Constants
12.2.9
Preventing the Creation of Audit Records
12.3
Running the Base Currency Conversion
12.3.1
Understanding the Conversion Workbench
12.3.2
Understanding Differences Between the Workbench and Postconversion Programs
12.3.3
Prerequisites
12.3.4
Form Used To Run the Conversion Workbench
12.3.5
Reviewing Programs for a Conversion Plan
12.3.6
Running the Conversion Workbench
12.4
Running Multiple Versions of the Accounts Receivable Conversion Programs
12.4.1
Understanding Accounts Receivable Tables
12.4.1.1
Example: Multiple Versions of the Accounts Receivable Conversion Programs
12.4.2
Running Multiple Versions of an Accounts Receivable Conversion Program
12.5
Running Multiple Versions of the F0911 Conversion Program
12.5.1
Understanding the F0911 Table
12.5.2
Example: Running Multiple Versions of the F0911 Conversion Program
12.5.3
Running Multiple Versions of the Convert F0911 Base Currency Program
12.6
Verifying the Status of the Base Currency Conversion
12.6.1
Understanding Base Currency Conversion Status
12.6.2
Forms Used to Verify the Status of the Base Currency Conversion
12.6.3
Verifying the Base Currency Conversion Status
12.6.3.1
Verifying Status When All Programs Have a Status of 60
12.6.3.2
Verifying Status When One or More Programs Have a Status of 50
12.7
Reviewing Base Currency Conversion Reports
12.7.1
Understanding Base Currency Conversion Reports
12.7.2
Reviewing the Table Conversion/Merge Driver Report
12.7.3
Reviewing the Conversion Log
12.7.4
Reviewing the Table Conversion Report
12.7.4.1
Messages on the Table Conversion Report
12.7.4.2
Informational Message
12.7.4.3
Error Messages
12.8
Reviewing the Conversion Audit Records
12.8.1
Understanding the Conversion Audit Records
12.8.2
Reviewing the F0086 Table
12.8.2.1
Exchange Rate Fields in the Conversion Audit Table
12.9
Rerunning a Conversion Program
12.9.1
Understanding the Rerun of a Conversion Program
12.9.2
Forms Used to Rerun a Conversion Program
12.9.3
Rerunning a Conversion Program Before Updating the F0010 Table
12.9.4
Rerunning a Conversion Program After Updating the F0010 Table
12.10
Deleting the Conversion Log for a Plan
12.10.1
Understanding Conversion Log Deletion
12.10.2
Forms Used to Delete the Conversion Log for a Plan
12.10.3
Deleting a Conversion Log
13
Running Postconversion Programs
13.1
Changing Plan Exchange Rates for Postconversion Programs
13.1.1
Understanding Plan Exchange Rate Revisions
13.1.1.1
Example of Running a Postconversion Program Multiple Times for a Plan
13.1.2
Forms Used to Change the Plan Exchange Rate
13.1.3
Changing the Exchange Rate for a Plan
13.2
Suppressing Audit Records for Postconversion Programs
13.2.1
Understanding Suppression of Audit Records
13.2.2
Forms Used to Suppress Audit Records for Postconversion Programs
13.2.3
Preventing Audit Records from Being Created for Postconversion Programs
13.3
Running Ordered Conversion Programs
13.3.1
Understanding Ordered Conversion Programs
13.3.2
Prerequisite
13.3.3
Running the Ordered Conversion Programs
13.3.3.1
Sales Order Management
13.3.3.2
General Accounting
13.3.3.3
Product Data Management
13.3.3.4
All Systems (Required)
13.4
Converting Multicurrency Intercompany Transactions
13.4.1
Understanding the Multicurrency Intercompany Conversion
13.4.2
Understanding the Multicurrency Intercompany Post
13.4.2.1
Multicurrency Intercompany Post Report
13.4.3
Converting Multicurrency Intercompany Transactions
13.5
Running Additional Conversion Programs
13.5.1
Understanding Additional Conversion Programs
13.5.2
Prerequisites
13.5.3
Running the Additional Conversion Programs
13.5.3.1
Localization
13.5.3.2
Expense Management
13.5.3.3
Real Estate Management and Advanced Real Estate
13.5.3.4
Customer Relationship Management
13.5.3.5
Sales Order Management
13.5.3.6
Advanced Pricing
13.5.3.7
Procurement
13.5.3.8
Grower Management
13.5.3.9
Operational Sourcing
13.5.3.10
Blend Management
13.5.3.11
Agreement Management
13.5.3.12
Advanced Transportation Management
13.5.3.13
Service Billing and Contract Billing
13.5.3.14
Plant and Equipment Management
13.5.3.15
Product Data Management
13.5.3.16
Contract Management
13.5.3.17
Stock Valuation
14
Running Postconversion Integrity Reports
14.1
Running Postconversion Integrity Reports
14.1.1
Understanding Postconversion Integrity Reports
14.1.1.1
Prerequisites
14.1.2
Completing the Financial Management Postconversion Integrity Checklists
14.1.2.1
Accounts Receivable
14.1.2.2
Accounts Payable
14.1.2.3
General Accounting
14.1.2.4
(ITA) Localization
14.1.2.5
Fixed Assets/Job Cost
14.1.2.6
Change Management
14.1.3
Completing the Contract/Service Billing Postconversion Integrity Checklist
14.1.4
Completing the Procurement Postconversion Integrity Checklist
14.1.5
Completing the Inventory Management Postconversion Integrity Checklist
14.1.6
Completing the Product Data Management Postconversion Integrity Checklist
14.1.7
Completing the Batch Header Postconversion Integrity Checklists
15
Running the Repost Account Ledger Program
15.1
Understanding the Repost Accounting Ledger Program
15.2
Prerequisites
15.3
Reposting the Account Ledger
16
Completing Postconversion Tasks
16.1
Understanding Postconversion Tasks
16.2
Completing the Financial Management Postconversion Checklist
16.2.1
Completing the General Accounting Postconversion Checklist
16.2.2
Completing the Accounts Receivable Postconversion Checklist
16.2.3
Completing the Accounts Payable Postconversion Checklist
16.2.4
Completing the Localization Postconversion Checklist
16.3
Completing the Plant & Equipment Management Postconversion Checklist
16.4
Completing the Homebuilder Postconversion Checklist
16.5
Completing the Distribution Postconversion Checklist
16.6
Completing the Manufacturing Postconversion Checklist
17
Converting the Production Environment
A
JD Edwards EnterpriseOne Base Currency Conversion Tables
A.1
Base Currency Conversion Tables List
B
Ordered and Additional Conversion Tables
B.1
Ordered Conversion Tables
B.2
Additional Conversion Tables
C
Composite Keys for JD Edwards EnterpriseOne Systems
C.1
Composite Keys List
D
Clauses for Conversion Program Indexes
D.1
Clauses for Indexes
Glossary
Index
Scripting on this page enhances content navigation, but does not change the content in any way.