Getting Started with JD Edwards EnterpriseOne Base Currency Conversion

This chapter discusses:

JD Edwards EnterpriseOne Base Currency Conversion overview.
JD Edwards EnterpriseOne Base Currency Conversion integrations.
JD Edwards EnterpriseOne Base Currency Conversion implementation.

JD Edwards EnterpriseOne Base Currency Conversion Overview

The base currency conversion consists of programs that convert the base currency of a company to a different base currency. Specifically, these programs:

Convert all monetary amounts in all data tables from the existing base currency to the new base currency, regardless of the batch status of the records in the tables.
Ensure data integrity within a table, when necessary.
Based on user preference, create an audit trail that indicates the original amounts and converted amounts for each converted table.

The programs for the base currency conversion convert monetary amounts and currency codes. As a result, the conversion affects all JD Edwards EnterpriseOne data tables that contain currency codes, monetary amounts, or both.

Depending on the table being converted, the programs for the base currency conversion multiply or divide the domestic or foreign amount by the exchange rate in the Currency Exchange Rates table (F0015) to calculate the new base currency amount.

The programs for the base currency conversion handle rounding the same way as the application programs. For example, if you use soft rounding for transactions in accounts receivable, the accounts receivable conversion programs use soft rounding. If an application program is not set up for rounding, the conversion programs round down amounts less than 0.5 and round up amounts greater than or equal to 0.5.

The results of all conversion programs are final. You cannot run them in proof mode. As with all conversions, you cannot add, change, or delete data while the conversion programs are processing.

Important! The base currency conversion, specifically the programs for the Euro Conversion Planner/Workbench (P9840E) and the Table Conversion Scheduler (P98430), must be run in a Windows environment. All other tasks, including preconversion and postconversion tasks, can be performed in either a Windows or a Web environment.

Conversion Guidelines

To ensure the success of the base currency conversion:

Test the conversion in a test or Conference Room Pilot (CRP) environment that contains a copy of the production data.
Correct any data issues that occur during the testing in both the test and production environments.
Update the production environment when you are satisfied with the results of the conversion in the test environment and are ready to go live.

For optimum results, plan to start and finish the conversion process without interruption. The steps are:

Complete the preconversion tasks.
Update the conversion scheduler and Audit Record table.
Run the conversion and verify its success
Run the ordered and additional conversion programs.
Complete the postconversion tasks and go live, thereby resuming your daily business operations.

JD Edwards EnterpriseOne Base Currency Conversion Integrations

JD Edwards EnterpriseOne Base Currency Conversion integrates with every JD Edwards EnterpriseOne system that has data tables with currency codes, monetary amounts, or both.

JD Edwards EnterpriseOne Base Currency Conversion Implementation

This section provides an overview of the steps that are required to implement the JD Edwards EnterpriseOne Base Currency Conversion.

In the planning phase of the implementation, take advantage of all JD Edwards EnterpriseOne sources of information, including the installation guides and troubleshooting information. A complete list of these resources appears in the preface in About This Documentation with information about where to find the most current version of each.

When determining which electronic software updates (ESUs) to install for JD Edwards EnterpriseOne Base Currency Conversion, use the EnterpriseOne and World Change Assistant. EnterpriseOne and World Change Assistant, a Java-based tool, reduces the time required to search and download ESUs by 75 percent or more and enables you to install multiple ESUs at one time.

See JD Edwards EnterpriseOne Tools 8.98 Software Update Guide

JD Edwards EnterpriseOne Base Currency Conversion Implementation Steps

This table lists the implementation steps for the JD Edwards EnterpriseOne Base Currency Conversion:

Step	Reference
1. Set up the conversion test environment.	See Conversion Test Environment Setup.
2. Update programs in the scheduler.	See Updating the Conversion Scheduler.
3. Update the Audit Record table	See Updating the Audit Record Table for Model Plan ZJDE.
4. Set up a conversion plan.	See Setting Up a Conversion Plan.
5. Set up constants for a conversion plan.	See Setting Up Conversion Plan Constants.
6. Prevent the creation of audit records for a conversion plan.	See Preventing the Creation of Audit Records.