Completing Conversion Tasks

This chapter provides overviews of base currency conversion plans and discusses how to:

• Set up a conversion plan.

• Update the Table Conversion - Scheduler table (F9843).

• Run the conversion workbench.

• Run multiple versions of the accounts receivable conversion programs.

• Run multiple versions of the Convert F0911 Base Currency program.

• Verify the status of the base currency conversion.

• Review the base currency conversion reports.

• Review the conversion audit records.

• Rerun a conversion program.

• Delete the conversion log for a plan.

• Change the plan exchange rate.

• Suppress audit records for ordered and additional conversion programs.

• Run ordered conversion programs.

• Run additional conversion programs.

Understanding Base Currency Conversion Plans

Before you begin the tasks for setting up and running the base currency conversion, make sure that you understand what a conversion plan is and why you might want to set up more than one conversion plan in an environment.

A conversion plan contains a list of companies that you plan to convert to a new base currency. When you run the base currency conversion to convert to the new base currency, you run the conversion by plan and environment. The system converts the data for a plan in the same environment that you run the conversion.

This graphic illustrates that some clients set up a single conversion plan for all companies and base currencies and run the base currency conversion one time:

Example of a Single Conversion Plan

Clients with only a few companies to convert to the new base currency might set up one conversion plan for each company.

This graphic indicates that other clients might set up multiple plans to convert multiple currencies:

Example of Three Conversion Plans

This graphic illustrates that other clients set up multiple plans and convert each currency in a separate plan:

Example of Six Conversion Plans

Clients find that it is easier to manage the conversion and review the results for a single currency, instead of multiple currencies in a plan.

Clients who set up multiple plans must run the base currency conversion one plan at a time, and upon successful completion, delete the conversion log before running the next plan.

To set up a conversion plan, you enter conversion constant information and assign companies to the plan on the Conversion Plan Revisions form of the Conversion Constants program (P0087). When you run the base currency conversion, the system retrieves the exchange rate for each company in the plan from the F0015 table.

As you prepare to set up the conversion plans, ask:

• How many companies do I need to convert?

• How many different base currencies do I need to convert?

• In which environments are the companies I need to convert?

Based on the answers to these questions and any special considerations at the site, such as schedules and resources, carefully evaluate how you want to convert the company base currencies and set up the conversion plans accordingly.

Note. You do not have to convert companies that have multicurrency intercompany transactions in the same conversion plan or at the same time. However, you must convert all companies in all plans before you run the Multicurr Interco Conversion program (R890911EB) and the Multicurr Interco Conversion Post program (R8909801EB), which make the necessary adjustments and keep the multicurrency intercompany transactions in balance.

See JD Edwards EnterpriseOne Base Currency Conversion Implementation Steps.

Setting Up Conversion Plans

This section provides an overview of conversion plan constants and audit records, lists a prerequisite, and discusses how to:

• Verify statuses for UDC H90/DS.

• Set up a conversion plan.

• Set up conversion plan constants.

• Prevent the creation of audit records.

Note. Set up the base currency conversion plan and complete all remaining tasks in the JD Edwards EnterpriseOne Base Currency Conversion 8.12 Implementation Guide in the test environment first, and then correct any data issues in both the test and production environments. Later, when you are satisfied with the results of the conversion in the test environment, complete all of the tasks again in the production environment and go live.

Understanding Conversion Plans

When you set a conversion plan, you enter a description and status, and the system loads the conversion programs into the plan. To set up a conversion plan, you use a front-end program called the Euro Conversion Planner/Workbench (P9840E). This program was originally created for companies in the Economic and Monetary Union (EMU) that converted to the euro, but any company can use it to convert to a new base currency.

The Euro Conversion Planner/Workbench program interfaces with the existing Installation Planner (P9840) and Control Table Workbench (P98413) programs and provides access to these forms:

• Table Conversion Planner, which contains the conversion programs for a plan.

• Euro Conversion Workbench, which you use to run the conversion programs.

Understanding Conversion Plan Constants

When you set up constants for a conversion plan, you assign companies and currency information to the plan. The base currency conversion uses the constants for a plan to determine which company base currencies to convert, which currency to convert to, and the effective date to use to retrieve conversion rates from the F0015 table. When you set up the constants, you also enter a plan exchange rate and currency conversion method. The rate and method are used only by the ordered and additional conversion jobs.

Understanding Audit Records

Audit records provide transaction amounts before and after the base currency conversion and the conversion rate used to calculate the new base currency amount. All programs for the base currency conversion automatically create audit records for each table and write the records to the F0086 table, although the conversion programs do not require that you create audit records.

If you want the system to create audit records for all tables in a plan, skip this task. When the Audit Record Y/N File - Euro table (F0085) contains no record for a plan, the conversion programs automatically create audit records.

If you do not want the system to create audit records for all tables, you must complete this task and create a record for the plan. When the F0085 table contains a record for a plan, the conversion programs search the table and determine whether to create audit records. You can create audit records for some tables and not others.

Important! Creating audit records during the base currency conversion can require a substantial amount of disk space.

See Sizing Impacts on the F0911, F0902, and F0086 Tables.

Carefully consider whether you need to create audit records for a table. Consult the auditors to find out which audit records the company requires, if applicable, and the country in which you conduct business.

To produce a report, you can create and run a query or batch program over the F0086 table. To do this, you need the composite key for each table converted. If you decide to run a batch program, create the report based on the F0086 Audit Report Model program (R0086) that appears on the Setup and Conversion menu (G97UE9A) in the Windows environment.

See Composite Keys.

Prerequisites

Before you complete the tasks in this section:

• Locate the list of systems that you use.

  See Completing the System-Level Prerequisite Checklist.

• Set up currency relationships and exchange rates for the existing base currency and the new base currency.

See Setting Up Exchange Rates for the Inverse Method.

See Setting Up Exchange Rates for the No Inverse Method.

Forms Used To Set Up Conversion Plans

Verifying Statuses for User Defined Code (UDC) H90/DS

The UDC table H90/DS lists the various statuses that a program can have throughout an installation or conversion. The statuses that apply specifically to the base currency conversion are 10, 45, 50, 60, and 70.

Setting Up a Conversion Plan

Access the Work with Euro Conversion Plans form.

Use the Maintain Euro Conversion Plans form to provide a plan name, description, and status for a euro conversion plan.

To define a conversion plan:

1. Select the Add on Work with Euro Conversion Plans form.

2. Complete these fields on the Maintain Euro Conversion Plans form:

   • Plan Name

     Enter the plan name for the conversion. Use the same plan name that you entered when you set up constants for the conversion plan. Do not leave this field blank. If you do, the system enters the default plan name (ZJDE), which appears when you return to the Work with Euro Conversion Plans form.

   • Description

     Type a meaningful description in this field, especially if you set up more than one conversion plan. This is a 30-character field.

   • Plan Status

     Enter 10 (In Planning) in this field. This field identifies the stage of a plan; 10 is the first stage.

3. Select OK, and the system:

   • Creates a plan master in the Installation Plan Master Table (F9840).

   • Creates an environment record in the Environment Plan Detail Table (F98403).

   • Loads all type 8 programs from the F9843 table to the Table Conversion Scheduler table (F98405).

     This loads all programs for the base currency conversion into the plan.

4. Select the plan and then select Conversion Planner from the Row menu On the Work with Euro Conversion Plans form, to review the conversion programs in the plan:

5. On the Euro Conversion Planner form:

   The New Environment and Previous Environment fields contain the same name. This is because you run the conversion and convert the data in the same environment.

   The Conversion Sequence field begins at 101 for the first conversion program and is numbered sequentially through the last conversion program.

   The Dependency Sequence field contains 0 (zero) for all conversion programs except:

   • R8951911E, which contains 119. (119 is the conversion sequence for R890911E.) R8951911E depends on the successful completion of R890911E; that is, R890911E must run before R8951911E.

   • R8941181E, which contains 157. (157 is the conversion sequence for R894201E.) R8941181E depends on the successful completion of R894201E; that is, R894201E must run before R8941181E.

   • R894118E, which contains 215. (215 is the conversion sequence for R8941181E.) R894118E depends on the successful completion of R8941181E; that is, R8941181E must run before R894118E.

6. Refer to the list of systems that you use.

   Based on the list, determine which systems you do not use. To improve processing time, you should remove conversion programs for any systems that do not apply to the plan, as described in the next step.

7. Select the record that corresponds to a program that you do not use and select Delete on the Table Conversion Planner form:

8. Select Auto Load from the Form menu if you inadvertently deleted a program.

   The system reloads all type 8 (conversion) programs into the plan and resets the plan status to 10 (In Planning).

9. Select Save if you added a conversion program.

10. Select Cancel when you are satisfied with the contents of the plan.

Setting Up Conversion Plan Constants

Access the Conversion Plan Revisions form.

To set up constants for a conversion plan:

1. Complete the Plan Name field located on the Conversion Plan Revisions form.

   Use these guidelines for the name of the conversion plan:

   • Give the plan a meaningful name to help you and others identify it throughout the conversion process.

   • Use alphanumeric characters. Do not use special characters, except underscore (_), in the plan name.

   • Name the plan something other than ZJDE. (ZJDE is reserved as a model plan).

2. Complete these fields:

   • Effective Date

     Enter the date that you want the conversion programs to use to retrieve the conversion rate from the F0015 table. The system uses this date to retrieve the rate, regardless of the transaction date.

     If no matching date exists in the F0015 table, the conversion programs search backwards and use the exchange rate associated with the most recent prior date. For example, if a currency relationship has a conversion rate and effective date of 2005/01/01, and you enter 2005/06/30 in this field, the program uses the exchange rate for 2005/01/01.

   • To Currency Code

     Enter the code of the currency to which you are converting the base currency.

   • Exchange Rate

     Enter a default exchange rate to be used by the ordered and additional conversion programs.

     All ordered and additional conversion programs, except the Multicurr Interco Conversion (R890911EB) and Price Variable Conversion (R894075EB) programs, use the exchange rate in this field along with the currency conversion method in this field to convert records without a currency code, company, or business unit. The Multicurr Interco Conversion and Price Variable Conversion programs use the exchange rate in the F0015 table.

   • Currency Conversion Method (Y/Z)

     Enter Y (multiplier) or Z (divisor).

   • Begin Company

     To convert one company, enter the number of the specific company.

     To convert a range of companies, enter the first number in the range.

     To convert several companies that are not in a range, enter each company number.

     Note. If you convert the F03B16 and F03B16S tables, make sure you enter company 00000 in the Begin Company and End Company fields. Company 00000 has records in the F03B16 and F03B16S tables that must be converted.

   • End Company

     To convert one company, leave this field blank. The system uses the value that you entered in the Begin Company field.

     To convert a range of companies, enter the last number in the range of companies.

     To convert several companies that are not in a range, leave this field blank. The system uses the value that you entered in the Begin Company field.

     The company in the Begin Company and End Company fields must exist in the F0010 table.

3. Select OK.

Preventing the Creation of Audit Records

Access the Work with Audit Definitions form.

The system provides a model plan (ZJDE) that contains a list of tables that the base currency conversion and the postconversion programs convert. Copy the tables from the model plan into the conversion plan, and then change the value in the Audit Record Flag field for each table in which you do notwant the system to create audit records. The default value 0 (blank) creates an audit record for a table.

Here is the Audit Definition Revisions form, which you use to revise an audit definition in this procedure:

To prevent audit records from being created:

1. Select ZJDE (model plan) on the Work with Audit Definitions form.

2. Click Select.

   The system displays the tables for model plan ZJDE.

3. Locate any tables that are highlighted and delete them (if an error message appears) on the Audit Definition Revision form.

4. Verify that the F0018 table exists in the ZJDE plan and add it, if necessary.

5. SelectOK.

6. Select the model plan ZJDE, and then select the Copy on the Work with Audit Definitions form.

7. Enter the plan name on the Audit Definition Revisions form.

8. Change the value in the Audit Record Flag field, where applicable.

   Change this value to 1 for any tables that do not require an audit record or are not used at the site. The Audit Record Flag field controls whether the creation of an audit record is suppressed during the conversion. Values are:

   Blank: Do not suppress the creation of an audit record.

   0: Do not suppress the creation of an audit record.

   That is, create an audit record. Audit records are written to the F0086 table.

   1: Suppress the creation of an audit record

   That is, do not create an audit record.

   Note. The F0911, F03B11, and F0411 tables write tax records to the F0018 table. If you prevent the system from creating audit records for the F0911, F03B11 or F0411 table, remember to do the same for the F0018 table.

9. Select OK.

10. Verify that the new plan appears on the Work with Audit Definitions form.

11. Read the caution and continue to the next step to remove a plan that was entered in error.

    Important! The Delete option on this form does not check the status of a plan before removing it. Make sure that you have not run the base currency conversion for the plan that you want to delete.

12. Select the plan, and then select Delete on the Work with Audit Definitions form.

13. Select OK on Confirm Delete.

Updating the F9843 Table

This section provides an overview of the F9843 table and discusses how to update the F9843 table.

Understanding the F9843 Table

The F9843 table, which contains the base currency conversion programs, is not completely accurate. To update the F9843 table, you must remove two conversion programs.

The system loads records from the F9843 table into the Control Table Workbench program (P98413) when you define a conversion plan. For this reason, update the F9843 table to ensure that it is accurate before you define any conversion plans.

Form Used To Update the F9843 Table

Updating the F9843 Table

Access the Work with Table Conversion Scheduler form.

To update the F9843 table:

1. Enter 8 (base currency conversion records) in the Conversion Type field and select Find on the Work with Table Conversion Scheduler form.

2. Select the records that contain these values in the Conversion Program field and select Delete to remove these conversion programs from the scheduler:

   • R891206EB

   • R891301EB

3. Select OK to confirm the deletion on Confirm Delete.

See Also

JD Edwards EnterpriseOne Base Currency Conversion Tables

Running the Conversion Workbench

This section provides overviews of the conversion workbench and the differences between the workbench and postconversion programs, lists prerequisites, and discusses how to:

• Review programs for a conversion plan.

• Run the conversion workbench.

Understanding the Conversion Workbench

When you run the conversion workbench, you run it by conversion plan, and the system converts the records for the companies that are defined in that plan. Some clients set up only one conversion plan, whereas others set up multiple plans. Clients with multiple plans must run the conversion workbench one plan at a time and, upon successful completion, delete the conversion log before running the next plan.

Review this list for information about what you can expect while the base currency conversion is being processed:

• An hourglass button appears on the Euro Conversion Workbench form (WP98413D) and remains there while the conversion programs are being processed.

• You cannot perform any functions on the Euro Conversion Workbench form while the conversion programs are being processed.

• You cannot run any other application programs while the conversion programs are being processed.

• You can track the progress of the conversion programs by completing one of these tasks:

  • Review the conversion status in the Table Conversion/Merge Log program (P984052).

    To access this program from the Windows environment, select Table Conversion/Merge Log from the Advanced Operations menu (GH9611). Alternatively, type P984052 in the Fast Path field.

  • Work with the Submitted Reports program (P986116).

    To access this tool, select Submitted Reports from the System Administration Tools menu (GH9011). Alternatively, typeP986116 in the Fast Path field.

  • Upon completion of each conversion program, the system displays an online report that indicates exceptions (errors).

    If no exceptions exist, the online report indicates header report information only and is blank.

You need to refer to this list throughout the base currency conversion.

Note. Run the conversion workbench and complete all remaining tasks in the Base Currency Conversion Guide in the test environment first, and then correct any data issues in both the test and production environments. Later, when you are satisfied with the results of the conversion in the test environment, complete all of the tasks again in the production environment and go live.

Understanding Differences Between the Workbench and Postconversion Programs

The conversion workbench and the postconversion (ordered and additional conversion) programs are similar in that they convert transaction amounts to the new base currency; however, they are different in many other ways.

The differences are described in this table:

Prerequisites

Before you complete the tasks in this section:

• Set up a base currency conversion plan.

• Consider running multiple versions of the accounts receivable and F0911 conversion program to reduce processing time.

• Back up all data before running the base currency conversion.

• Make sure that a system user with full authority runs the base currency conversion and that UBE row security is not activated for that user.

  This is necessary for performance reasons and to ensure that the conversion does not halt because of row security.

• Sign on to a client workstation that has a full install.

  Although you submit the base currency conversion and review the results from a workstation, you should process the conversion on the enterprise server for performance purposes.

• Verify that you are signed on to the environment that contains the companies that you want to convert to a new base currency.

  Ensure that no one else is signed on to the environment.

Form Used To Run the Conversion Workbench

Reviewing Programs for a Conversion Plan

To review the programs for a specific conversion plan and the sequences in which the programs must run, print a list:

On Work with Euro Conversion Plans, select a conversion plan and then select Conversion Workbench from the Row menu. On Euro Conversion Workbench, select Grid -> Print from the Preferences menu. Alternatively, you can export the data to a spreadsheet and print the spreadsheet.

1. On Work with Euro Conversion Plans, select a conversion plan.

2. Select Conversion Workbench from the Row menu.

3. On Euro Conversion Workbench, select Grid -> Print from the Preferences menu.

   Alternatively, you can export the data to a spreadsheet and print the spreadsheet.

You need to refer to this list throughout the base currency conversion.

Running the Conversion Workbench

Access the Euro Conversion Workbench form.

Note. The New Status field on the Euro Conversion Workbench form always contains the default value 60, which you should not change. This default value reflects the detail status that each conversion program should have upon successful completion.

To run the conversion workbench:

1. Select the Synch option on the Euro Conversion Workbench form.

   Each conversion program runs to completion before another one is launched, regardless of whether you have a single job queue or multiple job queues. The system creates one or multiple Table Conversion/Merge Driver reports (R98405), based on this information:

   • If you convert all tables and run the conversion synchronously from a server, the system creates a separate report for each conversion program, which indicates whether the program finished normally.

   • If you convert selected tables and run the conversion synchronously, the system creates a separate report for each conversion program.

     Important! When you complete the next step, the system immediately begins the base currency conversion. Make sure you have selected the correct plan and that you are ready to proceed with the actual conversion before you continue to the next step.

2. Select the Convert All from the Form menu.

   It is recommended that you convert all tables when you run the conversion workbench for a plan; however, you can convert selected tables by choosing Convert Selected from the Form menu.

Running Multiple Versions of the Accounts Receivable Conversion Programs

This section provides an overview of accounts receivable tables and discusses how to run multiple versions of an accounts receivable conversion program.

Understanding Accounts Receivable Tables

The volume of records stored in the JD Edwards EnterpriseOne Accounts Receivable tables can affect processing time when you run the conversion workbench. To reduce the processing time, you can create and run multiple versions of the accounts receivable conversion programs from different workstations.

Before you create and run multiple versions, analyze the data in the accounts receivable tables and look for a logical way in which to group the records into equal parts (or versions). You might decide to group the records by company only, by batch type, batch, or general ledger date; or by an internal tracking number called the unique key ID. You can group the records into different versions using any of the fields that are available in the data selection for a particular conversion program.

Note. The unique key IDs for the JD Edwards EnterpriseOne Accounts Receivable tables are:

To view the unique key IDs for these tables, use the Universal Table Browser (UTB).

After you carefully analyze the data, review this information to understand how the accounts receivable conversion programs work, and to help ensure that you set up the versions correctly:

• The Euro Conversion Workbench form in the Control Table Workbench program (P98413) contains 10 accounts receivable conversion programs.

  Each conversion program converts one of these tables:

  • F03B11

    The conversion program that converts the F03B11 table also converts corresponding records in the F0018 table.

  • F03B112

  • F03B13

  • F03B14

  • F03B22

  • F03B23

  • F03B40

  • F03B41

• You can create multiple versions for each accounts receivable conversion program, or create multiple versions for some programs and not for others.

  You should base the decision on the volume of records in each JD Edwards EnterpriseOne Accounts Receivable table. If the volume in a table is not significant, do not create multiple versions. Instead, run the accounts receivable conversion program for that table along with the other conversion programs that appear on the Euro Conversion Workbench form.

• You should convert a record only one time.

  When you create the versions, ensure that each accounts receivable record is selected by only one version of an accounts receivable conversion program and that no overlapping of records occurs among the versions.

  For example, if you create versions by batch type, do not convert the same batch type in two different versions. Conversely, do not omit any batch types.

• You must set up unique conversion plans to run multiple versions of an accounts receivable conversion program.

  Remember that conversion plans can contain one or more companies. You can run one or more accounts receivable conversion programs in a plan; however, you cannot run a version for a specific conversion program more than one time.

  You are essentially running multiple plans for that conversion program when you run multiple versions of an accounts receivable conversion program.

• You cannot inadvertently convert records that have already been converted by the accounts receivable conversion programs.

  For each accounts receivable conversion program, the system either ignores a transaction or issues an error message if the currency in the F0087 table or a processing option is the same as the domestic currency of the transaction in the table being converted.

Example: Multiple Versions of the Accounts Receivable Conversion Programs

After careful analysis, you decide to create multiple versions of these accounts receivable conversion programs:

To run multiple versions, you create these conversion plans:

Running Multiple Versions of an Accounts Receivable Conversion Program

Access the Work with Batch Versions form.

1. Copy version XJDE0001 of an accounts receivable conversion program for each version.

2. Select records that are equal to a certain value in the data selection.

   The conversion program processes records faster when the data selection is positive (is equal to) instead of negative (is not equal to).

3. Create a conversion plan for each version.

   You do not have to run all accounts receivable conversion programs in the same plan; you can run some programs in one plan and others in another plan. Be careful to convert all accounts receivable records for all companies and do not inadvertently skip some records when you run multiple plans and versions.

4. Remove from the Euro Conversion Workbench form all conversion programs except the accounts receivable conversion programs for which you want to run multiple versions for each plan.

5. Assign a version to each conversion program in the plan; you can run only one version of a particular conversion program for a plan.

6. Run the accounts receivable conversion program for the plan.

Running Multiple Versions of the F0911 Conversion Program

This section provides an overview of the F0911 table and discusses how to run multiple versions of the Convert F0911 Base Currency program.

Understanding the F0911 Table

The volume of records stored in the F0911 table can affect processing time when you run the conversion workbench. To reduce the processing time, you can create and run multiple versions of the Convert F0911 Base Currency program (R890911E) from different workstations.

Before you create and run multiple versions of the Convert F0911 Base Currency program, analyze the batch types and batch numbers of the records in the F0911 table, and look for a logical way in which to group the records into equal parts (or versions).

After you carefully analyze the data, review this information to understand how the Convert F0911 Base Currency program works and to help ensure that you set up the versions correctly:

• Create versions of the Convert F0911 Base Currency program by either batch type (ICUT) or batch number (ICU), or by a range of batch types or batch numbers.

  Although you can create versions of the conversion program by both batch type and batch number, be aware that you might convert the same record twice or not convert a record at all.

• Set up unique conversion plans to run multiple versions of the Convert F0911 Base Currency program.

  Remember that conversion plans can contain one or more companies. Within a conversion plan, you can run only one version of the Convert F0911 Base Currency program. When you run multiple versions of the Convert F0911 Base Currency program, you are actually running multiple plans for that conversion program.

• Verify that each record is selected by only one version and that there is no overlapping of records among the version if you create versions of the conversion program using a range.

  If you decide to run the Convert F0911 Base Currency program by range of batch types, verify that you do not convert the same batch type twice.

  For example, if you convert batch types A through F in one version, do not convert batch types E through J in the other. This also applies to a range of batch numbers. Verify that each F0911 record is included in one of the versions and that you do not omit any batch types or batch numbers.

Example: Running Multiple Versions of the F0911 Conversion Program

the company has 12 million records in the F0911 table. Based on an analysis of the data, you conclude that about one-third are accounts receivable and accounts payable batch types (for invoices, vouchers, and so on), one-third are general ledger batch types (for journal entries), and the remaining one-third are a mix of other batch types from other systems.

You create three versions (CNV0001, CNV0002, and CNV0003) of the Convert F0911 Base Currency program, using data selection to specify:

• Batch types equal to I, DB, R, V, K, W, and so on (accounts receivable and accounts payable batch types) for version CNV0001.

• Batch type equal to G (general ledger batch types) for version CNV0002.

• Batch types equal to H, N, and O (miscellaneous batch types) for version CNV0003.

Next, you define three conversion plans called CNVF0911ARAP, CNVF0911GL, and CNVF0911MISC. For each plan, you remove all conversion programs except the Convert F0911 Base Currency program. You assign these versions to the Convert F0911 Base Currency program for each plan:

• CNV0001 to plan CNVF0911ARAP

• CNV0002 to plan CNVF0911GL

• CNV0003 to plan CNVF0911MISC

Running Multiple Versions of the Convert F0911 Base Currency Program

Access the Work with Batch Versions form.

To run multiple versions of the Convert F0911 Base Currency program (R890911E):

1. Copy version XJDE0001 of the Convert F0911 Base Currency program for each version.

2. Select records that are equal to specific batch types (ICUT) or batch numbers (ICU) in the data selection.

   The conversion program processes records faster if the data selection is positive (is equal to) instead of negative (is not equal to).

3. Create a conversion plan for each version of the Convert F0911 Base Currency program.

4. Remove from the Euro Conversion Workbench form (W98413D) all conversion programs except the Convert F0911 Base Currency program for each plan.

5. Assign a version to the Convert F0911 Base Currency program for each plan; you can run only one version of this program for a plan.

6. Run the Convert F0911 Base Currency program for the plan.

   Note. This applies to clients who are using JD Edwards EnterpriseOne Job Cost and who run multiple versions of the Convert F0911 Base Currency program.
   
   You must run the F51911 Euro Conversion program (R8951911E) after you run the Convert F0911 Base Currency program. Therefore, verify that you do not run the F51911 Euro Conversion program when you run the conversion workbench. Instead, remove the F51911 Euro Conversion program from the Euro Conversion Workbench form and create a separate version for it. This ensures that you convert the records in the Draw Reporting Master table (F51911) after you convert the records in the F0911 table.

Verifying the Status of Base Currency Conversion

This section provides an overview of base currency conversion status and discusses how to verify the base currency conversion status.

Understanding Base Currency Conversion Status

After you run the base currency conversion for a plan, you must verify its status. Each conversion program within a plan must have a status of 60 (Installed) for the conversion to have finished successfully. When all conversion programs within a plan have a status of 60, the base currency conversion is complete.

Note. Verify the status of the base currency conversion and complete all remaining tasks in the JD Edwards EnterpriseOne Base Currency Conversion 8.12 Implementation Guide in the test environment first, and then correct any data issues in both the test and production environments. Later, when you are satisfied with the results of the conversion in the test environment, complete all of the tasks again in the production environment and go live.

Forms Used to Verify the Status of Base Currency Conversion

Verifying Base Currency Conversion Status

Access the Work with Euro Conversion Plans form.

To verify the status of the base currency conversion:

1. Select Find to view a list of plan names on the Work with Euro Conversion Plans form.

2. Select the conversion plan that you ran and then select Conversion Workbench (Conversion Workbench) from the Row menu.

3. Review the Dtl Sts field in the detail area on Euro Conversion Workbench.

   This field indicates the status of each conversion program.

4. Scroll down several times to review the status of each program in the plan.

5. Depending on the status of the programs, proceed to:

   • Verifying Status When All Programs Have a Status of 60 (Installed).

   • Verifying Status When One or More Programs Have a Status of 50 (Failed).

Verifying Status When All Programs Have a Status of 60

To verify if all programs in the plan have a status of 60 (Installed):

1. Click the Next button on the tool bar on the Euro Conversion Workbench form.

   This button is activated only if all conversion programs have a status of 60. The system displays the Congratulations! form.

2. Select Finish to complete the base currency conversion.

   The system updates the plan status to 60 (Installed).

3. Verify the plan status on the Work with Euro Conversion Plans.

   Note. After reviewing the conversion reports and audit tables, clients with multiple conversion plans must delete the conversion log for a plan before running another plan.

   See Deleting the Conversion Log for a Plan.

Verifying Status When One or More Programs Have a Status of 50

To verify if one or more programs in the plan have a status of 50 (Failed):

1. Determine what caused the conversion programs to fail and correct the errors.

2. Restore the necessary tables and rerun the conversion programs after correcting the errors identified in the previous step.

See Also

Reviewing the Conversion Log

Rerunning a Conversion Program

Reviewing Base Currency Conversion Reports

This section provides an overview of the base currency conversion reports and discusses how to:

• Review the Table Conversion/Merge Driver report.

• Review the conversion log.

• Review the Table Conversion report.

Understanding Base Currency Conversion Reports

After you verify the status of the base currency conversion, review the reports generated by the conversion before you continue with the conversion process. If a conversion program failed, you must review the reports, correct the errors, and rerun the conversion program.

When you run the Control Table Workbench program (P98413), the system generates:

Note. Review the base currency conversion reports and complete all remaining tasks in the JD Edwards EnterpriseOne Base Currency Conversion 8.12 Implementation Guide in the test environment first, and then correct any data issues in both the test and production environments. Later, when you are satisfied with the results of the conversion in the test environment, complete all of the tasks again in the production environment and go live.

Reviewing the Table Conversion/Merge Driver Report

System Administration Tools (GH9011), Submitted Reports.

The Table Conversion/Merge Driver report (R98405) lists each conversion program that ran and its status.

Each conversion program on this report has one of these statuses:

• Completed Normally

• Completed with Errors

The system creates one or multiple Table Conversion/Merge Driver reports, based on:

• If you convert all tables and run the conversion synchronously from a server, the system creates a separate report for each conversion program and indicates whether it finished normally.

• If you convert selected tables and run the conversion synchronously, the system creates a separate report for each conversion program.

Reviewing the Conversion Log

Access the Work with Euro Conversion Plans form.

The system creates conversion log records and stores them in the Table Conversion - History Log table (F984052). You can review the status of the conversion log records online by plan name, by object (table) name, and so on.

Records in the log have one of these statuses:

• Conversion finished normally

• Conversion finished abnormally

The system creates one log record for each conversion program in a plan, along with the date and time of the conversion. If a conversion program finishes abnormally, another log record is created when you rerun the conversion program. This means that more than one log record might exist for a conversion program.

Reviewing the Table Conversion Report

System Administration Tools (GH9011), Submitted Reports.

To review detailed information about a conversion program that finished with errors, use a table conversion report. A table conversion report prints for each table converted. For example, R8974412E is the table conversion report for the Customer / Supplier Balance Worktable (A/P and A/R) table (F74412). The table conversion report lists warnings and errors that occurred during the table conversion. Review the warnings and research and correct any errors that appear on the report.

Typically, clients who correct their integrity reports and clean up their tables before the conversion have fewer messages to review and correct on the table conversion reports.

Messages on the Table Conversion Report

Some messages on a table conversion report can be readily explained and might not need to be researched, such as messages that are associated with records that originated from an external source.

Other messages, such as minor rounding exceptions, begin with the word WARNING and are informational messages that might not require any corrections. The message WARNING - Amounts Round to Zero prints on the table conversion report when the conversion rounds a converted amount for a record to zero. For example, if the conversion rounds the converted amount of 1 Portuguese escudo to zero, it prints a warning message on the report. Another message, which is similar in wording but different in meaning is WARNING - Amounts Converted to Zero. This message prints on the report when the conversion calculates the new base currency amount and the result is zero.

Informational Message

This informational message commonly appears during the conversion of the F0911 table and is caused by slight rounding differences, which are inherent when converting to another base currency:

Error Messages

This table contains examples of error messages that might appear on a table conversion report.

You must correct the errors that are associated with these messages before you rerun the base currency conversion:

Reviewing the Conversion Audit Records

This section provides an overview of the conversion audit records and discusses how to review the F0086 table).

Understanding the Conversion Audit Records

After you verify the status of the base currency conversion, review the conversion audit records that the conversion generates before you continue with the conversion process.

For internal purposes, verify that the MIS or IT department writes and prints the necessary reports for the company auditors. For external purposes, verify that any legal audit reports contain the information required by the local or national government.

Audit records provide transaction amounts before and after the base currency conversion and the exchange rate used to calculate the new base currency amount. All conversion programs automatically create audit records for each table and write the records to the F0086 table, unless you prevent the system from creating audit records.

The records in the audit table contain the original currency amount, exchange rate, and new base currency amount. This table is the only audit trail for the base currency conversion. Examine the audit table carefully.

Reviewing the F0086 Table

You can review the F0086 table using the Universal Table Browser (UTB). To do this, sort the contents of the audit table by plan name and converted table or other criteria using the QBE row.

To run a query or batch program over the F0086 table, you need the composite key for each table converted. If you decide to run a batch program, create the report based on the F0086 Audit Report Model program (R0086), which is located on the Setup and Conversion menu (G97UE9A) in the Windows environment.

Note. Review the conversion audit records and complete all remaining tasks in the JD Edwards EnterpriseOne Base Currency Conversion 8.12 Implementation Guide in the test environment first, and then correct any data issues in both the test and production environments. Later, when you are satisfied with the results of the conversion in the test environment, complete all of the tasks again in the production environment and go live.

Exchange Rate Fields in the Conversion Audit Table

This table indicates how exchange rate fields appear in the F0086 table:

See Also

Composite Keys

Rerunning a Conversion Program

This section provides an overview of repeated runs of a conversion program and discusses how to:

• Rerun a conversion program before updating the F0010 table.

• Rerun a conversion program after updating the F0010 table.

Understanding the Rerun of a Conversion Program

You might need to rerun a conversion program during or after the base currency conversion for several reasons:

• A conversion program fails when you run the Control Table Workbench (P98413).

  If this happens, make sure you review the conversion reports and correct the errors before you rerun the conversion program.

• Data problems occur when you review the post-conversion integrity reports.

  Make sure you research and correct the data problems before you rerun the conversion program.

Before you rerun a conversion program, determine where you are in the conversion process and whether you have run the last ordered conversion program called Company Currency Codes Conversion (R890010E). This program changes the base currency code for companies in a plan to the new base currency in the F0010 table. If you ran the Company Currency Codes Conversion program, you need to change the new base currency back to the original base currency of the company before you rerun a conversion program.

Note. Rerun conversion programs, if necessary, and complete all remaining tasks in the JD Edwards EnterpriseOne Base Currency Conversion 8.12 Implementation Guide in the test environment first, and then correct any data issues in both the test and production environments. Later, when you are satisfied with the results of the conversion in the test environment, complete all of the tasks again in the production environment and go live.

Forms Used to Rerun a Conversion Program

Rerunning a Conversion Program Before Updating the F0010 Table

Access the Work with Euro Conversion Plans form.

Note. Do not reset the status of the failed conversion program on the Euro Conversion Workbench form; leave it as is.

To rerun a conversion program before updating the F0010 table:

1. Select Find to see a list of conversion plans on the Work with Euro Conversion Plans form.

2. Select the plan that contains the conversion program that failed, and then select Conversion Workbench (Conversion Workbench) from the Row menu.

3. Complete one of these options to selectively rerun one or more failed conversion on the Euro Conversion Workbench forms:

   • Select the record that corresponds to the table and select Convert Selected from the Form menu to convert one table.

   • Press the Control key, select the records that correspond to the tables, and then select Convert Selected from the Form menu to convert several tables

     Important! Do not select Convert All from the Form menu to rerun one or more failed conversions. Although the workbench reruns only those programs with a status that is not 60 (Installed), the processing time required is prohibitive.

Rerunning a Conversion Program After Updating the F0010 Table

Access the Work With Companies form.

Important! If you do not complete steps 1-4 in this procedure, be aware that a conversion program might change amounts to zero in a table for all companies in the plan. The currency code in the F0010 table would already be the new base currency, so you would be converting from and to the same currency.

To rerun a conversion program after updating the F0010 table:

1. Select Find to view all companies on the Work With Companies form.

2. Select the company that is associated with the plan and click Select.

3. Select the Currency tab on the Company Setup form.

4. Change the currency code in the Domestic Currency field back to the base currency code before the conversion.

   For example, if you converted the base currency of a Canadian company to U.S. dollars, you would change the currency code from USD back to CAD.

To rerun a conversion program, complete the remaining steps:

1. Select Setup and Conversion (G97UE9A), Euro Conversion Planner/Workbench in the Windows environment.

2. Select Find to view a list of conversion plans on the Work with Euro Conversions Plans form.

3. Select the plan that contains the conversion program that you need to rerun, and then select Conversion Workbench (conversion workbench) from the Row menu.

4. Complete one of these options to selectively rerun one or more conversions on the Euro Conversion Workbench form:

   • Select the record that corresponds to the table and then select Convert Selected from the Form menu to convert one table.

   • Press the Control key, select the records that correspond to the tables, and then select Convert Selected from the Form menu to convert several tables.

     Important! Do not select Convert All from the Form menu to rerun one or more failed conversions. Although the workbench reruns only those programs with a status that is not 60 (Installed), the processing time required is prohibitive.

5. Rerun the Company Currency Codes Conversion program (R890010E) to convert the company currency code to the new base currency when you are satisfied with the results.

Deleting the Conversion Log for a Plan

This section provides an overview of conversion log deletion and discusses how to delete a conversion log.

Understanding Conversion Log Deletion

Deleting the conversion log for a plan clears out the log and all associated log records in the F984052 table so that you can run another plan in the same environment or rerun the same plan without getting warning messages.

You must delete a conversion log for a plan if either of these reasons apply:

• You have multiple plans to convert in the same environment.

  After you run the Control Table Workbench program (P98413) for a plan and verify that it finished successfully, you must delete the conversion log before running the workbench for another plan.

• You decide to start over and run the Control Table Workbench again for the same plan.

  If you have an excessive number of programs that failed during the conversion and you decide to run the workbench again, you must delete the conversion log before running the workbench for the plan.

If you do not delete the conversion log and you run the Control Table Workbench again (whether over the same plan or another plan), the Conversion Verification form appears with this warning message for each conversion program in the plan.

Warning! The conversion/merge program for this table has already been processed or is already scheduled to run in this plan. Running it again could produce undesired results.

The system displays this warning message each time the Control Table Workbench or the Table Conversion Planner program (P9840) loads conversion records for a program.

Note. Delete the conversion log for a plan, if applicable, and complete all remaining tasks in the JD Edwards EnterpriseOne Base Currency Conversion 8.12 Implementation Guide in the test environment first, and then correct any data issues in both the test and production environments. Later, when you are satisfied with the results of the conversion in the test environment, complete all of the tasks again in the production environment and go live.

Forms Used to Delete the Conversion Log for a Plan

Deleting a Conversion Log

Access the Work with Euro Conversion Plans form.

To delete the conversion log for a plan:

1. Select Find to view a list of conversion plans on the Work with Euro Conversion Plans form.

2. Select the conversion plan that finished successfully, and then select Conversion Workbench (Conversion Workbench) from the Row menu.

   The plan status must be 60 (Installed).

3. Select View Log Table from the Form menu on the Euro Conversion Workbench Form.

4. Verify that the plan appears in the Plan Name field in the QBE row and select Find on Table Conversion/Merge Log.

   The system displays the conversion log records for the plan, which are stored in the F984052 table. These log records are not the same records that appear on the Euro Conversion Workbench form.

5. Select the first record in the detail area to select all conversion log records.

6. Press Shift, scroll to the bottom, select the last record, and then select Delete.

7. Select OK on Confirm Delete.

Changing Plan Exchange Rates for Ordered and Additional Conversion Programs

This section provides an overview of plan exchange rate revisions and discusses how to change the exchange rate for a plan.

Understanding Plan Exchange Rate Revisions

Before you run an ordered or additional conversion program, you must decide which records you want to convert to the new base currency and what exchange rate to use. Based on that decision, you enter a plan name in the processing option and specify certain criteria in the data selection for the program. Additionally, you must decide whether you want to create audit records for the table that the ordered or additional conversion program converts.

These programs use the plan name to determine:

• The currency to which to convert the records.

• The conversion rate to use when converting the records.

  This applies to all ordered and additional conversion programs except the Multicurr Interco Conversion (R890911EB) and Price Variable Conversion (R894075EB) programs, which use the exchange rate in the F0015 table.

Depending on the ordered or additional conversion program that you run and the records that you want to convert, you might need to run a program multiple times for a plan and change the plan exchange rate each time.

To change the plan exchange rate and prevent audit records from being created, you use the Conversion Constants (P0087) and Audit Record Maintenance (P0085E) programs.

Example of Running a Program Multiple Times for a Plan

The Price by Item Conversion program (R894207EB) is an additional conversion program that converts two amounts in the F4207 table. At the company, certain price rules correspond to certain currencies, which means that you set up standard price adjustments by currency. To convert records for the different currencies, you run the Price by Item Conversion program for a plan multiple times, entering the plan name in the processing option once and changing the exchange rate for the plan each time that you run the program to coincide with the currency on the records that you convert.

If you set up the conversion plans by currency, simply change the plan name in the processing option each time that you run an ordered or additional conversion program; you do not have to manually change the plan exchange rate.

Note. Change the plan exchange rate, if applicable, and complete all remaining tasks in the JD Edwards EnterpriseOne Base Currency Conversion 8.12 Implementation Guide in the test environment first, and then correct any data issues in both the test and production environments. Later, when you are satisfied with the results of the conversion in the test environment, complete all of the tasks again in the production environment and go live.

Forms Used to Change the Plan Exchange Rate

Changing the Exchange Rate for a Plan

Access the Work with Conversion Plans form.

To change the plan exchange rate:

1. Select Find to view a list of conversion plans on the Work with Conversion Plans form.

   The rate in the Exchange Rate field is used by all of the ordered and additional conversion programs, except the Multicurr Interco Conversion (R890911EB) and Price by Item Conversion (R894207EB) programs, to convert amounts to the new base currency. The Multicurr Interco Conversion and Price by Item Conversion programs use the exchange rate in the F0015 table, based on the companies being converted.

2. Select the plan and click Select to change the exchange rate for specific a conversion program.

3. Change the amount in the Exchange Rate field and select OK on the Conversion Plan Revisions form.

4. Verify the new exchange rate on the Work with Conversion Plans.

Suppressing Audit Records for Ordered and Additional Conversion Programs

This section provides an overview of suppression of audit records and discusses how to prevent audit records from begin created for ordered or additional conversion programs.

Understanding Suppression of Audit Records

All ordered and additional conversion programs automatically create audit records for a table and write the records to the F0086 table. If you want the system to create audit records for all tables that the ordered and additional conversion programs convert for a plan, bypass this task. If you do not want the system to create audit records, you must complete the steps for this task.

Depending on the size of the tables to be converted, creating audit records can require a substantial amount of disk space.

Note. Prevent audit records from being created for an ordered or additional conversion program, if applicable, and complete all remaining tasks in the JD Edwards EnterpriseOne Base Currency Conversion 8.12 Implementation Guide in the test environment first, and then correct any data issues in both the test and production environments. Later, when you are satisfied with the results of the conversion in the test environment, complete all of the tasks again in the production environment and go live.

See Also

Sizing Impacts on the F0911, F0902, and F0086 Tables

Ordered and Additional Conversion Tables

Forms Used to Suppress Audit Records for Ordered and Additional Conversion Programs

Preventing Audit Records from Being Created for Ordered or Additional Conversion Programs

Access the Work with Audit Definitions form.

You can prevent audit records from being created for an ordered or additional conversion program.

If the plan appears on the Work with Audit Definitions form:

1. Select the plan and click Select.

2. Change the value in the Audit Record Flag field to 1 for each table in which you do not want the system to create audit record on the Audit Definition Revisions form.

If the plan does not appear on the Work with Audit Definitions:

1. Select Add.

2. Complete the Plan Name and File Name fields on the Audit Definition Revisions form.

   Enter the table that corresponds to each ordered and additional conversion program that you plan to run.

3. Complete the Audit Record Flag field for each table.

   Enter 0 to create an audit record and 1 if you do not want to create an audit record.

4. Select OK.

Running Ordered Conversion Programs

This section provides overviews of ordered conversion programs, ordered conversion program checklists, multicurrency intercompany conversion, and multicurrency intercompany post; lists a prerequisite; and discusses how to:

• Run the ordered conversion programs.

• Convert multicurrency intercompany transactions.

Understanding Ordered Conversion Programs

After you run the Control Table Workbench program (P98413) and verify that the conversion has successfully finished, you must run the ordered conversion programs. The ordered conversion programs are designed to run separately from the workbench programs so that you can control the exchange rate and which records to convert.

For example, the workbench programs do not convert amounts on records without a currency code, company, or business unit. To convert these amounts, you must run several ordered conversion programs. Alternatively, you can manually modify the records.

Each time you run an ordered conversion program, you specify a plan name in the processing option. The system uses the exchange rate that is assigned to that plan to convert amounts for all ordered conversion programs except the Multicurr Interco Conversion program (R890911EB), which uses the exchange rate in the F0015 table. You also specify which records to convert in the data selection.

Important! Do not run an ordered conversion program more than one time over the same data. Ordered conversion programs convert amounts every time you run them, regardless of whether the amounts have already been converted.

Each ordered conversion program is dependent on the successful completion of one or more other ordered conversion programs, so you must run the programs in the sequence in which they appear on the Ordered Conversion Jobs menu (G97UE90).

The ordered conversion programs are:

• Configuration Management.

• Multicurrency Intercompany.

• Distribution and Product Data Management.

• Company Currency Codes (required).

• Multicurrency Intercompany Post.

You must run only the ordered conversion programs that apply to the systems that you use. All clients must run the Company Currency Codes Conversion program (R890010E).

The ordered conversion programs are described in a checklist. The checklist has one check-off (√) column to indicate that the task is complete.

Note. Run the ordered conversion programs and complete all remaining tasks in the JD Edwards EnterpriseOne Base Currency Conversion 8.12 Implementation Guide in the test environment first, and then correct any data issues in both the test and production environments. Later, when you are satisfied with the results of the conversion in the test environment, complete all of the tasks again in the production environment and go live.

Checklists for Ordered Conversion Programs

You must run the ordered conversion programs in the sequence in which they appear on the Ordered Conversion Jobs menu. Each ordered conversion program depends on the successful completion of one or more of the previous ordered conversion programs.

Sales Order Management

This checklist discusses ordered conversion programs for the Sales Order Management system:

General Accounting

This checklist discusses the ordered conversion programs for the JD Edwards EnterpriseOne General Accounting system:

Product Data Management

This checklist discusses the ordered conversion programs for the JD Edwards EnterpriseOne Product Data Management system:

All Systems (Required)

This checklist discusses the ordered conversion programs that apply to all JD Edwards EnterpriseOne systems:

Understanding Multicurrency Intercompany Conversion

If the Allow Multicurrency Intercompany Trans option is set to Y in the General Ledger Constants program (P0000), you must run the Multicurr Interco Conversion program (R890911EB).

The base currency conversion does not convert multicurrency intercompany transactions that are automatically generated by the system. To convert these transactions, you run the Multicurr Interco Conversion program one time only after you have converted all companies and all plans. Unlike other ordered conversion programs, the Multicurr Interco Conversion program can convert multiple currencies at the same time because the program retrieves conversion rates from the F0015 table, based on the companies in the plan that you are converting.

The Multicurr Interco Conversion program converts amounts in the F0911 table for all intercompany transactions in which the base currency of the company associated with the transaction is being converted. To convert these intercompany transactions, the program first locates all AA transactions with 1 in the GLALT1 field (the value 1indicates that a multicurrency intercompany transaction was automatically generated). It then:

• Converts all transaction amounts on a journal entry if the company on the first line (which determines the base currency of the transaction) is the company that you are converting.

• Deletes the corresponding AE (offset) and AM (adjusting) entries for companies that you are not converting.

  Note. The Convert F911 Base Currency conversion program (R890911E), which runs during the base currency conversion, deletes corresponding AE and AM entries for all companies converted. The Multicurr Interco Conversion program, which you run after the base currency conversion and is described in this document, deletes corresponding AE and AM entries only for those companies that are not converted. (The AE and AM entries are recreated later during the post.) Review this example for further clarification.
  
  If the first line of a journal entry is for a CAD company and the second line is for a USD company, this applies: The Convert F911 Base Currency conversion program deletes the corresponding AE and AM entries for the CAD company (which is being converted).
  
  The Multicurr Interco Conversion program deletes the corresponding AE and AM entries for the USD company (which is not being converted), and:

• Clears the posted code and theGLALT1 field on the original transactions and resets the batch to an approved (unposted) status so that you can post the batch again.

• Prints a report that lists the batches that were reset to an approved (unposted) status.

After you convert all companies and plans, run the Multicurr Interco Conversion program one time only for all plans. If you run this conversion program more than one time, it converts all records on a transaction each time, which results in inaccurate amounts.

The Multicurr Interco Conversion program, along with the Multicurrency Interco Conversion Post program (R8909801EB), makes the necessary adjustments to keep the multicurrency intercompany transactions in balance.

Understanding Multicurrency Intercompany Post

The Multicurr Interco Conversion Post program (R8909801EB) is a version of the General Ledger Post program (R09801) that creates all entries in the F0911 table, including AE offset and AM adjusting entries, based on the new base currency in the F0010 table. However, unlike the General Ledger Post program, the Multicurr Interco Conversion Post program does not:

• Post to the F0902 table, which saves valuable processing time.

  Instead, it marks the entries as posted so that when you run the Repost Account Ledger program (R099102) later in the base currency conversion process, the system selects entries and posts them to the F0902 table.

• Create reversing entries

To determine the exchange rate, the Multicurr Interco Conversion Post program uses the historical date (HDGJ), if applicable, or the general ledger date (DGJ). The program marks all entries as posted, even though they are not actually posted, so that when you run the Repost Account Ledger program later in the conversion process, the system selects the entries and updates them in the F0902 table.

Note. The Multicurr Interco Conversion Post program does not convert a transaction if the account or business unit was changed from a blank to a nonblank posting edit code after the original transaction was posted. This applies only to posting edit codes that were originally blank and have since changed to a nonblank value such as I (inactive), M (machine-generated), or N (nonposting).

Multicurrency Intercompany Post Report

The report produced by the Multicurr Interco Conversion Post program:

• Prints batches that posted successfully.

• Prints batches that are in error, along with a description of the error message at the end of the report.

  You can also review the workflow messages to see information about batches that are in error.

• Inserts a page break before each new batch. The page heading for each batch clearly indicates whether the batch is in error.

• Prints batches that are out of balance and the entries and multicurrency intercompany adjustments that the system automatically created for the out-of-balance batches.

  Out-of-balance batches appear consecutively on the report.

  Before the Multicurr Interco Conversion Post program finishes processing, it deletes any entries that the system automatically creates so that only the original transactions remain.

• Mixes posted and unposted batches on the report.

Prerequisite

Ensure that the exchange rate that is assigned to the plan is correct in the Conversion Constants program (P0087).

Running the Ordered Conversion Programs

Select Ordered Conversion Jobs (G97UE90), and then select an ordered conversion program.

Converting Multicurrency Intercompany Transactions

If the company that you are converting to a new base currency has intercompany transactions, you must complete these steps to successfully convert the multicurrency intercompany transactions.

To convert multicurrency intercompany transactions:

1. Verify that all companies and all plans have been converted successfully.

2. Select and run the Multicurr Interco Conversion program (R890911EB) from the Ordered Conversion Jobs menu (G97UE90). Do not run this program more than one time.

3. Select and run the Company Currency Codes Conversion program (R890010E), one time for each plan, from the Ordered Conversion Jobs menu (G97UE90).

   This program updates the base currency code in the F0010 table for all companies in a plan.

4. Review the intercompany accounts for any manual multicurrency transactions.

   These transactions are converted when you run the Convert F0911 Base Currency conversion program (R890911E), which is part of the base currency conversion; however, you must verify and, if necessary, correct any amounts.

5. Select Company Names & Numbers from the Organization & Account Setup menu (G09411).

   In the Company Names & Numbers program (P0010), reset the fiscal period and year for accounts receivable, accounts payable, and general ledger so that you can post to prior years.

6. Use the report generated by the Multicurr Interco Conversion program (step 2) to identify the different batch types that you need to post.

7. Select Multicurr Interco Conversion Post (R8909801EB) from the Ordered Conversion Jobs menu (G97UE90).

   Designate the batch type in the processing option and run this post separately for each batch type that you identified in the previous step.

8. Review the report created by the Multicurr Interco Conversion Post program.

   If all batches posted, continue to step 11. If some batches did not post, review these options to determine the cause:

   • Batch is out of balance.

     Slight rounding differences occur when the Multicurr Intercompany Conversion program converts transactions such as invoices and vouchers that do not have an associated F0911 transaction to balance to. The rounding differences, which are typically less than a cent, cause a batch to be out of balance and, as a result, the batch does not post. Continue to step 9.

   • Posting edit code on an account or business unit changed after the original transaction was posted.

     If you changed the original posting edit code on an account or business unit from a blank to a non-blank value after you posted the original transaction, the Multicurrency Intercompany Post does not post the batch. Continue to step 10.

9. Complete one of these options for out-of-balance batches:

   • To correct an out-of-balance batch, review the batch and revise the amount of the entry for each document that is out of balance.

     Approve the batch and rerun the Multicurr Interco Conversion Post program.

   • To correct an out-of-balance batch, create a one-sided adjustment at the document level or at the batch level.

     For each batch, remember to set the option on the Batch Overrides form of the General Journal Review program (P0011) that enables you to post an out-of-balance batch. Approve the batch and rerun the Multicurr Interco Conversion Post program.

   • To post out-of-balance batches, set the option on the Batch Overrides form that enables you to post an out-of-balance batch.

     Approve the batch and rerun the Multicurr Interco Conversion Post program. After you rerun the post, create a final adjustment to balance all batches or, if applicable, run an integrity report that creates the final adjustment. Remember to set the post out-of-balance option for each batch and post the final adjustments.

10. Change the posting edit code back to blank on the account or business unit.

    Approve the batch and rerun the Multicurr Interco Conversion Post program. After you rerun this program, change the posting edit code back to the previous value.

11. Select Company Names & Numbers from the Organization & Account Setup menu (G09411).

    In the Company Names & Numbers program, reset the fiscal period and year back to their original values.

Running Additional Conversion Programs

This section provides overviews of additional conversion programs and additional conversion program checklists, lists prerequisites, and discusses how to run additional conversion programs.

Understanding Additional Conversion Programs

After you run and successfully complete the Euro Conversion Workbench (P98413) and the ordered conversion programs, you must run the additional conversion programs. The additional conversion programs are designed to run separately from the base currency conversion so that you can control the exchange rate and which records to convert.

The conversion workbench, for example, does not convert amounts on records if certain fields are not in a table or if certain values on a record are invalid or blank. To convert these amounts, you must run several additional conversion programs. If records do not include a company or business unit, the additional conversion programs assume that the associated amounts are in the domestic currency of the company.

Each time you run an additional conversion program, you specify a plan name in the processing option. The additional conversion program uses the exchange rate assigned to that plan to convert amounts for all additional conversion programs except the Price Variable Conversion program (R894075EB), which uses the exchange rate from the F0015 table. You also specify which records to convert in the data selection.

Important! Do not run an additional conversion program more than one time over the same data. The additional conversion programs convert amounts every time you run them, regardless of whether the amounts have already been converted.

The additional conversion programs are for these Oracle systems:

• JD Edwards EnterpriseOne Sales Order Management

• JD Edwards EnterpriseOne Procurement

• JD Edwards EnterpriseOne Agreement Management

• JD Edwards EnterpriseOne Advanced Transportation Management

• JD Edwards EnterpriseOne Equipment Management

• JD Edwards EnterpriseOne Service Billing

• JD Edwards EnterpriseOne Product Data Management

• JD Edwards EnterpriseOne Stock Valuation

Run only the additional conversion programs that apply to the systems that you use.

The additional conversion programs are described in a checklist. The checklist has one check-off (√) column to indicate that the task is complete.

Note. Run the additional conversion programs and complete all remaining tasks in the JD Edwards EnterpriseOne Base Currency Conversion 8.12 Implementation Guide in the test environment first, correcting any data issues in both the test and production environments. Later, when you are satisfied with the results of the conversion in the test environment, complete all of the tasks again in the production environment and go live.

Prerequisites

Before you complete the tasks in this section:

• Make sure that you successfully ran the Company Currency Codes Conversion program (R890010E), which updates the currency code for the companies in a plan to the new base currency.

  You can verify the new currency codes on the Company Names & Numbers form (P0010).

• Ensure that the exchange rate assigned to the conversion plan is correct.

  If necessary, change it on the Conversion Plan Revisions form (P0087).

Checklists for Additional Conversion Programs

You must run additional conversion programs for the systems that you use.

Sales Order Management

This information applies to the additional conversion programs for the JD Edwards EnterpriseOne Sales Order Management system:

• If the domestic amounts for the records are in the same currency, enter the plan name that corresponds to that particular currency in the processing option, specify all records in the data selection, and run the additional conversion program one time only.

• If the domestic amounts for the records are in multiple currencies, determine which orders represent a particular currency.

  Then:

• Enter the plan name that corresponds to a particular currency in the processing option, specify the records to convert in the data selection, and run this program separately for each currency.

• Modify selected records manually

This checklist discusses the additional conversion programs for the JD Edwards EnterpriseOne Sales Order Management system:

Advanced Pricing

This checklist discusses the additional conversion programs for the JD Edwards EnterpriseOne Advanced Pricing system:

Procurement

The additional conversion programs for the JD Edwards EnterpriseOne Procurement system have two versions:

• Version 1 (XJDE0001) runs during the base currency conversion and converts records with a branch/plant and company.

  Do not run this version.

• Version 2 (XJDE0002) is the additional conversion program that you must run to convert records without a branch/plant or company.

  Alternatively, you can create a new version and run it to convert these records.

This information applies to the additional conversion programs for JD Edwards EnterpriseOne Procurement:

• If the domestic amounts for the unprocessed orders are in the same currency, enter the plan name that corresponds to that particular currency in the processing option, specify all records in the data selection, and run the additional conversion program one time only.

• If the domestic amounts for the unprocessed orders are in multiple currencies, determine which orders represent a particular currency.

  Then:

• Enter the plan name that corresponds to a particular currency in the processing option, specify the records to convert in the data selection, and run this program separately for each currency.

• Modify selected records manually

This checklist discusses the additional conversion programs for the JD Edwards EnterpriseOne Procurement system:

Agreement Management

The additional conversion program for the JD Edwards EnterpriseOne Agreement Management system converts the currency code for records in the Agreement Quantities table (F38011). This program does not run during the base currency conversion because most clients do not want to convert the currency code on all agreement records.

You can manually modify agreement records; however, the advantage of running the additional conversion program is that it automatically updates records that are associated with the F38011 record in five other Agreement Management tables.

This checklist discusses the additional conversion programs for the Agreement Management system:

Advanced Transportation Management

The additional conversion programs for the JD Edwards EnterpriseOne Advanced Transportation Management system have an additional processing option that enables you to either convert the records or bypass converting them.

This checklist discusses the additional conversion programs for the JD Edwards EnterpriseOne Advanced Transportation Management system:

Service Billing and Contract Billing

This checklist discusses the additional conversion programs for the JD Edwards EnterpriseOne Service Billing and JD Edwards EnterpriseOne Contract Billing systems:

Plant and Equipment Management

This checklist discusses the additional conversion programs for the JD Edwards EnterpriseOne Plant and Equipment Management system:

Product Data Management

This checklist discusses the additional conversion programs for the JD Edwards EnterpriseOne Product Data Management system:

Stock Valuation

The additional conversion programs for the JD Edwards EnterpriseOne Stock Valuation system convert dual currency records only.

Do not run these conversion programs if these situations apply to you:

• You do not process dual currency records.

• You do not want to convert the dual currency records.

To convert dual currency records to a currency that is different from the currency to which you converted the domestic records (that is, the new base currency), you must set up a new conversion plan. Review this example for further clarification:

Before the conversion, a Canadian company has dual currency records in the Japanese yen (JPY). The company converts their base currency to U.S. dollars (USD), so their dual currency records are in USD and JPY. Now the company wants their dual currency records to be in the euro (EUR) instead of JPY. To convert the JPY records to EUR, the company must first set up a conversion plan with a JPY to EUR exchange rate and then run the additional conversion programs for that conversion plan.

This checklist discusses the additional conversion programs for JD Edwards EnterpriseOne Stock Valuation:

Running Additional Conversion Programs

Select Additional Conversion Jobs (G97UE901), and then select an additional conversion program.