Accounts Receivable

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 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: Run the F03B22 to F03B23 Integrity report. Set up 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 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: 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. 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.