Completing Postconversion Tasks

This chapter provides an overview of postconversion tasks and discusses how to:

Click to jump to parent topicUnderstanding Postconversion Tasks

Before or after you review and correct your postconversion integrity reports and repost the account ledger, you must complete the postconversion tasks. Most of the postconversion tasks rebuild or update workfiles. Complete only those postconversion tasks that apply to the JD Edwards EnterpriseOne programs and systems that you use. For example, if you do not use localization programs, do not complete the postconversion tasks for Localization. Similarly, if you do not use bank statement processing, do not complete the postconversion task for reconciliation listed under General Accounting.

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

Note. Complete the postconversion tasks and all remaining tasks in this 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.

Click to jump to parent topicCompleting the Financial Management Postconversion Checklist

These checklists describe the postconversion tasks that you must perform for the JD Edwards EnterpriseOne Financial Management systems.

This section discusses how to:

Click to jump to top of pageClick to jump to parent topicCompleting the General Accounting Postconversion Checklist

This checklist discusses the postconversion tasks that apply to the JD Edwards EnterpriseOne General Accounting system:

Postconversion Task

Description

Change the currency code for company 00000

Select Company Names & Numbers, menu G09411.

Change the currency code for the default company 00000 to the new base currency. The base currency conversion does not do this; you must do it manually.

 

Refresh the reconciliation file

Run Refresh Reconciliation File (R09130), menu G0921.

This program rebuilds domestic amounts in the Account Ledger Reconciliation workfile (F0911R) with the new base currency amounts.

 

Review and revise your model journal entries

The base currency conversion does not convert model journal entries. Locate the list of model journal entries that you printed before the conversion, or create a new list by running a query or UBE over the F0911 table for journal entries with a posted code M (model). Revise the model journal entries as needed.

 

Review and revise allocations

The base currency conversion does not convert amounts in the Cost Allocations / Flex Budgeting table (F0912). Locate the list of recurring journal entries that you printed before the conversion, or create a new list by running a query or UBE over the F0912 table for journal entries with a batch type D. Revise the recurring journal entries as needed.

 

Run the annual close for prior years

Run the annual close program for all prior years that have been closed and contained converted records. The annual close program creates an adjusting amount to correct prior year-end and beginning balance postings. Use the report produced by this program to verify the prior year-end and balance forward amounts with the amounts from the repost.

 

Delete indexes

Delete any indexes that you create prior to running the base currency conversion.

 

Click to jump to top of pageClick to jump to parent topicCompleting the Accounts Receivable Postconversion Checklist

This checklist discusses the postconversion tasks that apply to the JD Edwards EnterpriseOne Accounts Receivable system:

Postconversion Task

Description

Rebuild workfile

Run Credit Analysis Refresh (R03B525), menu G03B15.

This program rebuilds domestic amounts in the A/R Cash Management workfile (F03B15) with new base currency amounts.

 

Print the Recurring Invoice Report

Print the Recurring Invoice Report (R03B305), menu G03B111.

Review and revise your recurring invoices. Receive the converted recurring invoices and verify the new amounts. To revise an amount, you must delete the recurring invoice and enter a new one.

 

Click to jump to top of pageClick to jump to parent topicCompleting the Accounts Payable Postconversion Checklist

This checklist discusses the postconversion tasks that apply to the JD Edwards EnterpriseOne Accounts Payable system:

Postconversion Task

Description

Rebuild workfiles

Run Date File Generation (R04901), menu G0421.

This program rebuilds domestic amounts with new base currency amounts in the following workfiles:

  • As of A/R Ledger (F0411A)

  • As of A/P Matching Document (F0413A)

  • As of A/P Matching Document Detail (F0414A)

 

Print the Recurring Voucher Report

Print the Recurring Voucher Report (R04305), menu G0411.

Review and revise your recurring vouchers. Review the converted recurring vouchers and verify the new amounts. To revise an amount, you must delete the recurring voucher and enter a new one.

 

Click to jump to top of pageClick to jump to parent topicCompleting the Localization Postconversion Checklist

This checklist discusses the postconversion tasks that apply to the JD Edwards EnterpriseOne Localization system:

Postconversion Task

Description

Run a query over the F0018 tax table

For clients with F0018 (Sales/Use/VAT) records:

Run a query over the F0018 tax table for records that are not in the AR, AP, and GL ledger tables. The base currency conversion converts F0018 tax amounts that are stored in the F03B11, F0411, and F0911 ledger tables only.

If you enter tax amounts directly in the F0018 table (using the Tax File Revisions program), you must convert those tax amounts manually.

 

Rebuild sales tax workfile

Run Update Extra Tax File - Sales (R0018I1), menu G00211.

This program rebuilds domestic amounts in the Intrastat workfile (F0018T) with new base currency amounts.

 

Rebuild purchasing workfile

Run Update Extra Tax File - Purchasing (R0018I2), menu G00211.

This program rebuilds domestic amounts in the Intrastat workfile (F0018T) with new base currency amounts.

 

Rebuild French Legal Report workfile

For French and Italian clients only:

Run G/L by Category Code (R70470), menu G093151 or menu G093152.

This program rebuilds domestic amounts in the French Legal Report workfile (T740911) with new base currency amounts.

 

Rebuild A/P Ledger workfile

For French clients only:

Run the Ledger Report - Localized (R7404014), menu G093151.

This program rebuilds domestic amounts in the Accounts Payable Ledger workfile (T74411) with new base currency amounts.

 

Rebuild ETAFI Interface table

For French clients only:

Run ETAFI Interface (R7409FI), menu G093151.

This program rebuilds domestic amounts in the ETAFI Interface table (F7409FI) with new base currency amounts.

 

Click to jump to parent topicCompleting the Plant & Equipment Management Postconversion Checklist

This checklist discusses the postconversion tasks that apply to the JD Edwards EnterpriseOne Plant & Equipment Management system:

Postconversion Task

Description

Update PM Projections table

Run PM Projections Update (R13411), menu G1322.

This program updates domestic amounts in the PM Projections table (F13411) with new base currency amounts.

 

Update Work Order Master table

Run Update Work Order Actual Amounts (R13800), menu G1331.

This program updates actual domestic amounts in the Work Order Master table (F4801) with new base currency amounts.

 

Click to jump to parent topicCompleting the Homebuilder Postconversion Checklist

This checklist discusses the postconversion task that applies to the JD Edwards EnterpriseOne Homebuilder Management system:

Postconversion Task

Description

Update the closing worksheet

Select Closing Worksheet Accounting Instruction, menu G44H41.

Manually update the Closing Amount and Budget Amount fields in the closing worksheet template for any templates with existing amounts.

 

Click to jump to parent topicCompleting the Distribution Postconversion Checklist

This checklist discusses the postconversion tasks that apply to the JD Edwards EnterpriseOne Distribution systems:

Postconversion Task

Description

Rebuild workfile

Run Item Ledger As Of Generation (R41542), menu G4122.

This program rebuilds the Item Ledger As Of workfile (F41112), based on transactions in the Cardex table (F4111).

 

Run the container extraction and billing processes

Run the container extraction and billing processes for Container Management, menu G4118.

Run end-of-day processing for Container Extraction (R41189), Rental Billing (R41186), and Deposit/Refund Billing (R41187).

 

Delete indexes

Delete any indexes that you created prior to running the base currency conversion.

 

Click to jump to parent topicCompleting the Manufacturing Postconversion Checklist

This checklist discusses the postconversion tasks that apply to the JD Edwards EnterpriseOne Manufacturing systems:

Postconversion Task

Description

Run Simulate Rollup

Run Simulate Rollup (R30812), menu G3014.

This program creates new base currency costs using converted rates and purchase costs.

 

Run Frozen Update

Prerequisite: Simulate Rollup.

Run Frozen Update (P30835), menu G3014.

This program revalues inventory in the new base currency amounts.

 

Regenerate the lean bill of material and routing records

Run BOM & Routing Detail (RF31012), menu GF3111.

This program regenerates the lean bill of material and routing records in these tables:

  • Lean Multi Level Bill of Material Header (F300210)

  • Lean Multi Level Bill of Material Detail (F300211)

  • Lean Multi Level Routing Detail File (F300311)

Without data in these tables, Lean Manufacturing cannot function.

 

Run Create Summary Forecast

Run Create Summary Forecast (R34640), menu G3421.

This program creates the summary forecast for future sales amounts in the new base currency amounts.

 

Manually update amounts in UDC fields, if applicable

Refer to the list that you compiled before the conversion. Update the amounts in the user-defined code fields manually.

 

Delete indexes

Delete any indexes that you created prior to running the base currency conversion.