16 Completing Postconversion Tasks

This chapter contains the following topics:

16.1 Understanding 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.

16.2 Completing 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:

  • Complete the General Accounting postconversion checklist.

  • Complete the Accounts Receivable postconversion checklist.

  • Complete the Accounts Payable postconversion checklist.

  • Complete the Localization postconversion checklist.

16.2.1 Completing the General Accounting Postconversion Checklist

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

Postconversion Task Description Complete
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.  

16.2.2 Completing the Accounts Receivable Postconversion Checklist

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

Postconversion Task Description Complete
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.

  

16.2.3 Completing the Accounts Payable Postconversion Checklist

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

Postconversion Task Description Complete
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.

  

16.2.4 Completing the Localization Postconversion Checklist

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

Postconversion Task Description Complete
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.

  

16.3 Completing 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 Complete
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.

  

16.4 Completing the Homebuilder Postconversion Checklist

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

Postconversion Task Description Complete
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.

  

16.5 Completing the Distribution Postconversion Checklist

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

Postconversion Task Description Complete
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.  

16.6 Completing the Manufacturing Postconversion Checklist

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

Postconversion Task Description Complete
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.