This chapter contains the following topics:
This section provides an overview of postconversion integrity reports and discusses how to:
Complete the Financial Management postconversion integrity checklists.
Complete the Procurement postconversion integrity checklist.
Complete the Inventory Management postconversion integrity checklist.
Complete the Product Data Management postconversion integrity checklist.
Complete the batch header postconversion integrity checklist.
Most of the integrity issues that appear on the postconversion integrity reports are minor rounding differences that occur when you convert from the base currency to the new base currency. Compare the postconversion integrity reports to the preconversion integrity reports to ensure that the conversion results are accurate.
Run the postconversion integrity reports in proof mode first, and then run them in final (update) mode. Final mode was created especially for the base currency conversion and is used to update any minor rounding differences that occur during the actual conversion.
Final mode:
Tests the integrity of data between tables with dependent relationships.
Locates the difference between the tables.
Creates adjusting entries for batches that are out of balance and corrects any integrity issues caused by the conversion. (You can use the data selection to exclude records in which you do not want to create adjusting entries.)
Run integrity reports only for those systems that the company uses.
|
Note: The postconversion integrity reports are described in a checklist. The checklist has one check-off (√) column to indicate that the task is complete. Run the postconversion integrity reports and complete all remaining tasks in this 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. |
Before you complete the tasks in this section:
Run the Company Currency Codes Conversion program (R890010E), which updates the currency codes for the companies in a plan to the new base currency.
You can verify currency codes on the Company Names & Numbers form (P0010).
Run all other postconversion programs.
From the Financials Integrities menu (G97UE91), select an integrity report.
These checklists describe the integrity reports that you need to run after you run the base currency conversion.
These integrity reports apply to the JD Edwards EnterpriseOne Accounts Receivable system:
| Report Name (Program Number) | Description | Complete |
|---|---|---|
| F03B11 to F03B22 Integrity (R8903B22I) | In proof mode, this report compares records in the F03B11 table with the F03B22 table and prints the differences on a report.
In final mode, this report creates an adjusting amount in the F03B22 table to balance to the F03B11 table. |
|
| F03B11 to F03B40 Integrity (R8903B40I) | Prerequisite: Run the F03B11 to F03B22 Integrity report.
In proof mode, this report compares records in the F03B11 table with the F03B40 table and prints differences on a report. In final mode, this report creates an adjusting amount in the F03B40 table to balance to the F03B11 table. |
|
| F03B11 to F03B14 Integrity (R8903B14I) | Prerequisite: Run the F03B11 to F03B40 Integrity report.
In proof mode, this report compares records in the F03B11 with the F03B14 table and prints differences on a report. In final mode, this report creates an adjusting amount in the F03B14 table to balance to the F03B11 table. |
|
| F03B14 to F03B41 Integrity (R8903B41I) | Prerequisite: Run the F03B11 to F03B14 Integrity report.
In proof mode, this report compares records in the F03B14 with the F03B41 table and prints differences on a report. In final mode, this report creates an adjusting amount in the F03B41 table to balance to the F03B14 table |
|
| F03B14 to F03B13 Integrity (R8903B13I) | Prerequisite: Run the F03B14 to F03B41 Integrity report.
In proof mode, this report compares records in the F03B14 table with the F03B13 table and prints differences on a report. In final mode, this report creates an adjusting amount in the F03B13 table to balance to the F03B14 table. |
|
| F03B22 to F03B23 Integrity (R8903B23I) | Prerequisite: Run the F03B14 to F03B13 Integrity report.
In proof mode, this report compares records in the F03B22 table with the F03B23 table and prints differences on a report. In final mode, this report creates an adjusting amount in the F03B23 table to balance to the F03B22 table. |
|
| F03B11 to F0911 Integrity (R890911AI) | Prerequisites:
This report has four modes, one proof and three final: In proof mode, this report compares records in the F03B11 table to the F0911 table and prints differences on a report. In final mode, update F0911 only, this report creates an adjusting amount in the F0911 table to balance to the F03B11 table. In final mode for this report, the adjusting amounts are directed to:
Note: Before you run this report in final mode, determine whether you want to automatically create adjusting entries for batches that are out of balance. If you do not want to create adjusting entries, modify the data selection to exclude the batches from appearing on the integrity reports. Otherwise, adjusting entries are created for out-of-balance batches. In final mode, update F03B11 only, this report creates an adjusting amount in the Amount to Distribute field (ATAD) of the F03B11 table to balance to the F0911 table. This report ensures that the distribution amounts in the F0911 equal the total of the ATAD amounts for a document. To balance the amounts at the document level, this report creates an adjusting amount for the last pay item in a document. In final mode, update F0911 and F03B11, this report creates an adjusting amount first in the F0911 table to balance to the F03B11 table, and then an adjusting amount in the ATADfield of the F03B11 table to balance to the F0911 table. The results of this report are the same as running the final - update F0911 only and final - update F03B11 only reports in succession. Note: If, at a later time after the conversion, you adjust an existing pay item for a document in which the ATAD field was adjusted by this integrity report, the document might be out of balance. To avoid this, you should create a new pay item to adjust the amount instead of adjusting the converted pay item. |
|
| F03B13 to F0911 Integrity (R890911CI) | Prerequisite: Run the F03B11 to F0911 Integrity report.
In proof mode, this report compares records in the F03B13 table with the F0911 table and prints differences on a report. In final mode, this report creates an adjusting amount in the F0911 table to balance to the F03B13 table. |
|
| F03B14 to F0911 Integrity (R890911BI) | Prerequisite: Run the F03B13 to F0911 Integrity report.
In proof mode, this report compares records in the F03B14 table with the F0911 table and prints differences on a report. In proof mode, this report is equivalent to the A/R to G/L Receipts by Batch report (R03B702). In final mode, this report creates an adjusting amount in the F0911 table to balance to the F03B14 table. |
|
| A/R to Account Balance by Account ID (R03B707) | Prerequisite: Run the F03B14 to F0911 Integrity report.
This report replaces the A/R to G/L by Offset Account integrity report (R03B7001A). It summarizes open amounts in each general ledger account in the F03B11 table and compares the total with the balance amount in each offsetting accounts receivable trade account in the F0902 table. |
These integrity reports apply to the JD Edwards EnterpriseOne Accounts Payable system:
| Report Name (Program Number) | Description | Complete |
|---|---|---|
| F0411 to F0911 Integrity (R04711) | In proof mode, this report compares records in the F0411 table with the F0911 table and prints differences on a report.
In final mode, this report creates an adjusting amount in the F0911 table to balance to the F0411 table. The adjusting amount is directed to one of these AAIs:
Note: Before you run this report in final mode, determine whether you want to automatically create adjusting entries for batches that are out of balance. If you do not want to create adjusting entries, modify the data selection to exclude the batches from appearing on the integrity reports. Otherwise, adjusting entries are created for out-of-balance batches. |
|
| F0414 to F0411 Integrity (R04713) | In proof mode, this report compares records in the F0414 table with the F0411 table and prints differences on a report.
In final mode, this report creates an adjusting amount in the F0414 table to balance to the F0411 table. |
|
| F0414 to F0911 Integrity (R04712) | Prerequisites: Run the F0414 to F0411 Integrity and F0411 to F0911 Integrity reports.
In proof mode, this report compares records in the F0414 table with the F0911 table and prints differences on a report. In final mode, this report creates an adjusting amount in the F0911 table to balance to the F0414 table. Note: Before you run this report in final mode, determine whether you want to automatically create adjusting entries for batches that are out of balance. If you do not want to create adjusting entries, modify the data selection to exclude the batches from appearing on the integrity reports. Otherwise, adjusting entries are created for out-of-balance batches. |
|
| A/P to G/L Integrity by Offset Account (R047001A) | This report summarizes open amounts in each general ledger account in the F0411 table and compares the total with the balance amount in each offsetting accounts payable trade account in the F0902 table. |
This integrity reports apply to the JD Edwards EnterpriseOne General Accounting system:
| Report Name (Program Number) | Description | Complete |
|---|---|---|
| Unposted General Journal (R09301) | This report prints a general journal of unposted transactions in the F0911 table. | |
| Accounts without Business Units (R097041) | In proof mode, this report locates account master records with an invalid company number and without a business unit record in the F0901 table.
In final mode, this report updates the F0901 table with the company number from the business unit master record. |
|
| Account Balance without Account Master (R097031) | In proof mode, this report locates account balance records with an invalid company number and without an account master record in the F0901 table.
In final mode, this report updates the F0902 table with the company number from the account master record in the F0901 table. |
|
| Transactions without Account Master (R097021) | In proof mode, this report locates transaction records with an invalid company number and without an account master record in the F0901 table.
In final mode, this report updates the F0911 table with the company number from the account master record in the F0901 table. |
|
| Companies in Balance (R097001) | This report indicates the net balance for each company. When a company is in balance, the columns on the report are blank. | |
| Intercompany Accounts in Balance (R097011) | This report lists imbalances between corresponding intercompany accounts.
If you have multiple companies with different base currencies, do not run this integrity report. This integrity report does not accommodate different base currencies. |
|
| Account Balance to Transactions (R09705) | This report lists imbalances between the F0902 and F0911 tables by fiscal period.
If imbalances exist between these tables, and you change an account from monetary to nonmonetary or vice versa, contact the Global Support Services consultant for a resolution plan. |
|
| Foreign Account Balances (R09707) | In proof mode, this report compares foreign currency ledger (CA) records with domestic ledger (AA) records in the F0902 table and prints a report that indicates CA records that do not have corresponding AA records.
In final mode, this report removes from the F0902 table CA records that do not have a corresponding AA record. |
|
| Cash Basis Integrity Test (R11C750) | This report identifies cash accounts that have different balances in the domestic ledger (AA) and cash basis ledger (AZ) after posting.
This integrity report can be accessed only from the Cash Basis Accounting menu (G09314). |
This integrity reports apply to Italian clients only:
| Report Name (Program Number) | Description | Complete |
|---|---|---|
| F70404 to F0911 Integrity (R74701) | In proof mode, this report compares records in the F0911 table with the F70404 table.
In final mode, this report creates an adjusting amount in the F70404 table to balance to the F0911 table. |
|
| F74411 to F0411 Integrity (R74703) | In proof mode, this report compares records in the F0411 table with the F74411 table.
In final mode, this report creates an adjusting amount in the F74411 table to balance to the F0411 table. |
These integrity reports apply to the JD Edwards EnterpriseOne Fixed Assets and JD Edwards EnterpriseOne Job Cost systems:
| Report Name (Program Number) | Description | Complete |
|---|---|---|
| F0911 Transaction Report (R127012) | This report prints transactions from the F0911 table for accounts within the AAI item FX range. | |
| Unposted F0911 Transactions to F1202 (R12301) | This report compares unposted transactions in the F0911 table to unposted balances in the F1202 table for accounts within the AAI item FX range and prints differences on a report. | |
| F0911 to F1202 Integrity (R12910) | In proof mode, this report compares posted transactions with (batch rear end = *) in the F0911 table with posted balances in the F1202 table.
In final mode, this report creates an adjusting amount in the F1202 table to balance to the F0911 table. This integrity report is the same program as the Fixed Asset Repost. Note: If you summarize the depreciation transactions, do not run this integrity report. Running this integrity report serves no purpose because Summarized transactions have F1202 records without supporting F0911 transactions. After you summarize transactions, you cannot re-create detail transactions. |
|
| F1202 to F0902 Integrity (R127011) | This report compares posted balances in the F1202 table with posted balances in the F0902 table and prints differences on a report. | |
| F5144/F5145 to F0902 (R51800) | In proof mode, this report compares records in the F0902 table with records in the F5144 and F5145 tables.
In final mode, this report creates adjusting amounts in the F5144 and F5145 tables to balance to the F0902 table. |
These integrity reports apply to the JD Edwards EnterpriseOne Change Management system:
| Report Name (Program Number) | Description | Complete |
|---|---|---|
| CO/PCO (F5315/F5314) Integrity (R53701) | This report compares final and quoted amounts for cost, revenue, and subcontract records in the F5315 table with the attached planned change orders in the F5314 table and prints the differences. | |
| PCO/CR (F5314/F5311) Integrity (R53702) | This report compares final and quoted amounts for cost, revenue, and subcontract records in the F5314 table with the attached change requests in the F5311 table and prints the differences. |
Access these integrity reports from the Billing Control Reports menu (G48S33).
These integrity reports apply to the JD Edwards EnterpriseOne Contract/Service Billing system:
| Report Name (Program Number) | Description | Complete |
|---|---|---|
| Workfile Control Report (R48S710) | This report identifies records in the Billing Detail Workfile table (F4812) that are not correct based on other information within table F4812. | |
| Workfile History Control Report (R48S711) | This report identifies records in the Billing Workfile History table (F4812H) that are not correct based on other information within table F4812H. | |
| G/L Link to Account Ledger Control Report (R48S720) | This report verifies that the information contained in the G/L Link table (F48S912) accurately represents the information that has been written to the Account Ledger table (F0911). | |
| Account Ledger to G/L Link Control Report (R48S721) | This report verifies that each record in the Account Ledger table (F0911) that was created by the revenue process in the Service Billing or JD Edwards EnterpriseOne Contract Billing system has at least one corresponding record in the G/L Link table (F48S912). | |
| Billing Workfile to G/L Link Control Report (R48S730) | This report identifies integrity issues between the Billing Detail Workfile and Billing Workfile History tables (F4812 and F4812H) and the G/L Link table (F48S912). | |
| G/L Link to Billing Workfile Control Report (R48S731) | Prerequisite: Create G/L (R48198).
This report identifies records that are missing from the Billing Detail Workfile table (F4812) and the Billing Workfile History table (F4812H), based on data contained within the G/L Link table (F48S912). |
|
| Invoice Summary to Workfile Control Report (R48S751) | This report verifies that the amounts in the Billing Detail Workfile and Billing Workfile History tables (F4812 and F4812H) match the amounts in the Invoice Summary Work File table (F4822). | |
| Invoice Summary to Customer Ledger Control Report (R48S761) | Release 8.10 and above.
This report verifies that the amounts in the Invoice Summary Work File table (F4822) match the amounts in the Customer Ledger table (F03B11). |
|
| Customer Ledger to Invoice Summary Control Report (R48S771) | Release 8.10 and above.
This report verifies that each invoice transaction in the Customer Ledger table (F03B11) that originated in the Contract Billing or Service Billing system has at least one corresponding source transaction in the Invoice Summary Work File table (F4822). |
From the Distribution Integrities menu (G97UE92), select Commitment Integrity Report.
This integrity report applies to the JD Edwards EnterpriseOne Procurement system:
| Report Name (Program Number) | Description | Complete |
|---|---|---|
| Commitment Integrity Report (R40910) | In proof mode, this report compares records in the F43199 table to the F4311 table and records in the F43199 table to the F0902 table, and then prints the differences.
In final mode, this report creates an adjusting amount in the F43199 table if a difference exists between the amounts in the F4311 and F43199 tables. Creates an adjusting amount in the F0902 table if a difference exists between the amounts in the F43199 and F0902 tables. |
Select Logistics Integrities (G97UE93), and then select an integrity report.
These integrity reports apply to the JD Edwards EnterpriseOne Inventory Management system:
| Report Name (Program Number) | Description | Complete |
|---|---|---|
| Item Ledger/Account Integrity (R41543) | This report compares records in the F0911 table to the F4111 table and prints differences on a report. | |
| Item Balance/Ledger Integrity (R41544) | This report compares records in the F41021 table to the F4111 table and prints differences on a report. |
Select Manufacturing Integrities Jobs (G97UE94), Cost Component/Ledger Integrity.
This integrity report applies to the Product Data Management system:
| Report Name (Program Number) | Description | Complete |
|---|---|---|
| Cost Component/Ledger Integrity (R30543) | This report compares the sum of the frozen standard cost components to the unit cost in the F4105 table and prints a report that indicates the variances. |
Select Batch Header Integrities (G97UE95), Batch to Detail/Out of Balance Report.
There are four batch header reports on menu G97UE95. Run only this one:
| Report Name (Program Number) | Description | Complete |
|---|---|---|
| Batch to Detail/Out of Balance (R007031) | This report locates batches that were posted out of balance and prints a detailed report. Compile a list of any batches that were intentionally posted out of balance and use the list to compare the results after the conversion.
Note: Run this report after you run the postconversion integrity reports for all other systems and before you run the Repost Account Ledger program (R099102). |