My Oracle Support Banner

E1: 04: How To Run EnterpriseOne Accounts Payable Integrity Reports (R04701, R04702A, R04711, R04712, R047001A, R04713) (Doc ID 1407766.1)

Last updated on JUNE 07, 2021

Applies to:

JD Edwards EnterpriseOne Accounts Payable - Version XE and later
Information in this document applies to any platform.

Purpose

Overview on Accounts Payable Integrity Reports

Integrity reports identify problems and inconsistencies with your data to help ensure that your JD Edwards EnterpriseOne systems remain in balance. Use these reports to verify that your Accounts Payable data match your GL Data and that your Accounts Payable transactions are correct. Integrity reports do not have as of capabilities, therefore, they can only be run over the most up to date data. Follow these guidelines when running integrity reports:

Note: The accounts payable integrity reports include posted transactions only.

 

Scope

This document is intended for the EnterpriseOne user who is researching and cleaning up data integrity issues within the Accounts Payable module.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
 Overview on Accounts Payable Integrity Reports
Scope
Details
 Overview of AP Orig Doc to GL by Batch Report (R04701)
 Integrity Test
 Overview of AP Payments to GL by Batch Report (R04702A)
 Overview of A/P to G/L Integrity with Adjustments Report (R04711)
 Prerequisite Setup
 Overview of A/P Payments to G/L Integrity with Adjustments Report (R04712)
 Overview of AP to GL by Offset Account Report (R047001A)
 Overview of AP Payments to AP with Update Report (R04713)
 Overview of Voucher Journal Report (R04305)
 Preventing Integrity Issues
 Ten Suggestions for Preventing Integrity Issues
 Resolving an AP Integrity Issue
 1. Verify Posted and Unposted Batches
 2. AP to GL Integrity by Batch Report (R04701)
 3. AP Payments to GL by Batch Report (R04702A)
 4. Batch to Detail and Out of Balance Report (R007031)
 5. Repost Account Ledger Report (R099102)
 6. Account Balance to Transactions report (R09705)
 7. General Journal by Account Report (R09311)
 8. Global Update Programs
 9. Other Potential Causes to Consider
 10. Period Numbers
 New Integrity Reports
 New Integrity Programs and Functionality
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.