This chapter contains the following topics:
Section 7.1, "Understanding Preconversion Integrity Reports"
Section 7.2, "Completing the Financial Management Preconversion Integrity Checklist"
Section 7.3, "Completing the Contract/Service Billing Preconversion Integrity Checklist"
Section 7.4, "Completing the Distribution Preconversion Integrity Checklist"
Section 7.5, "Completing the Logistics Preconversion Integrity Checklist"
Section 7.6, "Completing the Manufacturing Preconversion Integrity Checklist"
Section 7.7, "Completing the Batch Header Preconversion Integrity Checklist"
Section 7.8, "Completing the Repost Account Ledger Integrity Checklist"
To ensure the accuracy of the data that you are going to convert to a new base currency, you must run and review the preconversion integrity reports and, if necessary, research and correct any data issues. Typically, clients who review and correct their integrity reports and clean up their tables before they run the base currency conversion have fewer errors to review and correct after the conversion.
Run the preconversion integrity reports in proof mode to review and manually correct any errors. You can run preconversion integrity reports in final (update) mode, which:
Tests the integrity of data between tables that have dependent relationships.
Locates the differences between the tables.
Creates adjusting entries for batches that are out of balance. You can use the data selection to exclude records in which you do not want to create adjusting entries.
|
Important: Consider placing security on integrity reports that can be run in final mode to ensure that others do not inadvertently update tables. |
If a time lapse occurs between when you run the preconversion integrity reports and the base currency conversion, run the integrity reports again to correct any errors that might have occurred during that time.
Run integrity reports for only those systems that the company uses. After the conversion, compare the preconversion integrity reports to the postconversion integrity reports to verify that the conversion results are accurate. Verify that all transactions for all systems have been posted and updated in the F0911 and F0902 tables.
|
Note: The preconversion integrity reports are described in a checklist. The checklist has one check-off (√) column to indicate that the task is complete. Review and correct the preconversion integrity reports and complete 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. |
Select Financials Integrities (G97UE91), and then select an integrity report.
Before you run the preconversion integrity reports in proof mode for JD Edwards EnterpriseOne Financial Management, verify that the Exclude Batch From Integrity Report option is not selected on batches that do not appear on integrity reports. When this option is turned off, the system creates audit records of out-of-balance batches before it performs the base currency conversion.
To locate and change this option on batches:
Create and run a query or batch program over the Batch Control Records table (F0011) for IBOI (Include Batch on Integrity) equal to N.
Access the Batch Header Revisions program (R0011) and select the batch. From the Row menu, select Revise. On Create/Revise Batch Header, select Overrides from the Form menu. On Batch Overrides, clear the Exclude Batch From Integrity Report option.
These checklists describe the integrity reports that you must run before 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 A/R Fee Journal History table (F03B22) 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 to the A/R Deduction Management table (F03B40) 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 to 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 to the A/R Deduction Activity table (F03B41) 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 to 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 to the A/R Fee Journal History Detail table (F03B23) 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 with the F0911 table and prints differences on a report. 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 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 one of these AAIs:
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 ATAD field 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 to 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 to 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 summarizes open amounts in each general ledger account in the F03B11 table and compares the total to 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 to the balance amount in each offsetting accounts payable trade account in the F0902 table. |
These 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 CA records to 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 CA records from the F0902 table that do not have a corresponding AA record. |
|
| Cash Basis Integrity Test (R11C750) | This report identifies cash accounts that have different balances in the AA and cash basis ledger (AZ) after posting.
This integrity report can be accessed only from the Cash Basis Accounting menu (G09314). |
These 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 G/L Registration Balance table (F70404).
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 to the Withholding Tax Detail - Italy table (F74411).
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 Trans 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 (R129107) | In proof mode, this report compares posted transactions with [(batch rear end) = Ã] in the F0911 table to 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 the F1202 records to not have 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 to 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 to records in the Profit Recognition (F5144) and Profit Recognition Account Balance (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 Change Order Master Table (F5315) with the attached planned change orders in the Planned Change Order Master table (F5314) 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 to the attached change requests in the Change Request Details Table (F5311) 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). |
Select Distribution Integrities (G97UE92), 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 with the F4311 table and records in the F43199 table with the F0902 table, and then prints the differences.
In final mode, this program creates an adjusting amount in the F43199 table if a difference exists between the amounts in the F4311 and F43199 tables. Create 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 with records in the F4111 table and prints differences on a report. | |
| Item Balance/Ledger Integrity (R41544) | This report compares records in the Item Location File table (F41021) with records in the F4111 table and prints differences on a report. |
Select Manufacturing Integrity Jobs (G97UE94), Cost Component/Ledger Integrity.
This integrity report applies to the JD Edwards EnterpriseOne 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), and then select an integrity report.
These integrity reports apply to batch headers:
| Report Name (Program Number) | Description | Complete |
|---|---|---|
| Unposted Batches (R007011) | This report prints all unposted batches sequentially by batch type and batch number. | |
| Transactions to Batch Headers (R007021) | This report locates inconsistencies in the F0011 table. The system locates F03B11, F0411, and F0911 transactions without a batch header record and locates unposted F03B11, F0411, and F0911 transactions with a posted batch header record. | |
| Company by Batch/Out of Balance (R09706) | This report locates batches by company that were posted out of balance and prints a report. | |
| 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 preconversion integrity reports for all other systems and before you run the Repost Account Ledger program (R099102). |
Select Post Integrity Jobs (G97UE99), Repost Account Ledger.
This integrity report applies to the repost:
| Report Name (Program Number) | Description | Complete |
|---|---|---|
| Repost Account Ledger (R099102) | Prerequisite: Run the preconversion integrity reports for all other systems.
In proof mode, this report identifies accounts with different amounts in the F0911 and F0902 tables. In final mode, this report updates the F0902 table with the posted amounts from the F0911 table. |