Completing the Accounts Receivable Preconversion Integrity Checklist

These integrity reports apply to the JD Edwards EnterpriseOne Accounts Receivable system:

Report Name (Program Number)	Description	√
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: Run the F03B22 to F03B23 Integrity report. Set up Automatic Accounting Instruction (AAI) items ADR and AER for company 00000. If you do not set up ADR and AER, you receive an AAI missing/invalid error message when you run this report in proof and final - update F0911 only modes. You can set up ADR and AER for companies other than company 00000; however, in final mode, this integrity report creates an adjustment for the last company in a document or batch, which might not be the correct company. 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: ADR, which tracks differences between the F03B11 and F0911 distribution amounts at the document level. The distribution amounts typically appear in revenue accounts. AER, which tracks differences between the F03B11 and F0911 automatic entry amounts at the batch level. The automatic entry amounts appear in accounts such as trade and tax payable accounts. 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.