1. Base Currency Conversion Implementation Guide
  2. Completing the Accounts Payable Preconversion Integrity Checklist

Completing the Accounts Payable Preconversion Integrity Checklist

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

Report Name (Program Number)

Description

√

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:

  • ADP, which tracks differences between the F0411 and F0911 distribution amounts (expense account).

  • AEP, which tracks differences between the F0411 and F0911 automatic entry amounts (trade account).

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.