My Oracle Support Banner

E1: 04: FAQ - Frequently Asked Questions Regarding AP Integrity Reports (R04701, R04702A, R047001A, R04713) (Doc ID 663128.1)

Last updated on JANUARY 30, 2018

Applies to:

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

Purpose

This document has answers to frequently asked questions regarding JD Edwards EnterpriseOne Accounts Payable integrity Reports (R04701, R04702A, R047001A, R04713).

Questions and Answers

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
Questions and Answers
 AP Orig Doc to GL by Batch Report (R04701) Questions
 Question 1: Is it possible to run the AP to GL Integrity Report by Batch (R04701) data selecting on Company?
 Question 2: Why are W (Payments without Voucher Match) batches excluded from the AP to GL Integrity Report by Batch (R04701)?
 Question 3: What causes the AP to GL Integrity Report by Batch (R04701) to include V batches without a Gross Amount and Distribute Amount in the Accounts Payable Ledger (F0411)?
 Question 4: Other than the Pay Status, what fields are checked by the AP to GL Integrity Report by Batch (R04701)?
 Question 5: Is there any application available in JD Edwards EnterpriseOne that corrects data corruption that appear on the AP to GL Integrity Report by Batch (R04701)?
 Question 6: When was the Amount to Distribute field introduced?
 Question 7: What enhancement bugs have been entered for the AP to GL Integrity Report by Batch (R04701)?
 Question 8: Why does the AP to GL Integrity Report by Batch (R04701) show an integrity issue for records entered with a Tax Explanation Code of C?
 Question 9: How can integrity issues when running the AP to GL Integrity Report by Batch where the Amount to Distribute is blank when upgrading from Xe or ERP8 to release 8.9 or higher be avoided?
 Question 10: Why is a copy of the standard version (ZJDE0001) of the AP to GL Integrity by Batch (R04701) showing totals when the standard version is clean?
 Question 11: The AP to GL Integrity Report by Batch (R04701) is returning an error message about an invalid journal entry being posted, why?
 Question 12: The AP to GL Integrity Report by Batch report (R04701) is reporting that general transactions are out of balance, why?
 Question 13: Why does the AP to GL Integrity Report by Batch (R04701) show that the Gross Amount (AG) and Amount to Distribute (ATAD) as the same amount but opposite signs?
 Question 14: AP to GL Integrity Report by Batch (R04701) is picking up batches that have been marked to be excluded from integrity reports, why?
 Question 15: Why is the AP to GL Integrity Report by Batch (R04701) showing different batches each time it is ran?
 Question 16: Will the AP to GL Integrity Report by Batch (R04701) use data selection?
 AP Payments to GL by Batch Report (R04702A) Questions
 Question 1: Why is the AP Payments To GL By Batch (R04702A) PDF displaying the same document several times?
 Question 2: Why does the AP Payments to GL by Batch (R04702A) include batches that have a value of 'N' in the Include Batch on Integrity?
 Question 3: Why does the AP Payments to GL By Batch (R04702A) return error message 'F0911 Amounts do not net to 0' on a foreign transaction?
 Question 4: Is it possible to run the AP Payments to GL by Batch (R04702A) by Company?
 Question 5: Why is the AP Payment to GL By Batch (R04702A) returning a blank Gross Amount in the Accounts Payable Matching Document Detail (F0414) when the records in the General Ledger (F0911) are correct?
 AP to GL by Offset Account Report (R047001A) Questions
 Question 1: Why is the AP to GL Integrity by Offset Account (R047001A) showing an exception for one AP Trade Account when all batches are posted and in balance?
 Question 2: Why does the AP to GL by Offset Account (R047001A) result in a blank PDF?
 Question 3: Why is the AP to GL by Offset Account (R047001A) not in sync with the As Of Open AP Details with Aging (R04423D) or the Open A/P Summary Report (R04413)?
 Question 4: What is the Integrity Report Work Table (F04UI004)?
 Question 5: Is it possible to run the AP to GL by Offset Account (R047001A) by fiscal year?
 Question 6: Why is the AP to GL by Offset Account (R047001A) output different than the amounts in the Account Balances for the A/P Trade Account?
 Question 7: Is it possible to exclude a batch from the AP to GL by Offset Account report?
 Question 8: Why is the AP to GL by Offset Account showing a discrepancy caused by paid vouchers that have not been posted?
 Question 9: What type of issue could cause integrity problems on the AP To GL by Offset Integrity Report (R047001A)?
 Question 10: The AP to GL by Offset Account (R047001A) is showing a discrepancy caused by paid vouchers that have not been posted, why?
 Question 11: The AP to GL by Offset Account (R047001A) is reporting an out of balance condition due to a JX document, why?
 Question 12: Why does the AP to GL by Offset Account (R047001A) print an AAI missing error on the report?
 Question 13: Why is the AP to GL by Offset Account not reporting the balances for AAIs by gl offset (i.e. PCFROG) in the F0902 but the F0411 balance does include them?  Hence reporting an out of balance on the report?
 Question 14: How can an integrity issue be avoided when the GL Offset code is modified in the Supplier Master (P04012)?
 Question 15: Why does the AP to GL by Offset Account (R047001A) show a discrepancy related to RETN GL Offsets when there is un-released retainage?
 AP Payments to AP w/Update report questions (R04713)
 Question 1: Why is a payment record appearing on this report when the gross, Open and Paid Amount columns for the Accounts Payable Ledger (F0411) are blank?
 AP Integrity Troubleshooting Questions
 Question 1: After upgrading to a new E1 release, why are the AP integrity reports showing a few batches that weren't reported in the previous release?
 Question 2: Is it possible to restore missing General Ledger (F0911) records?
 Question 3: Is there an Accounts Payable report that shows all associated voucher and payment records?
 AP Integrity General Questions
 Question 1: Do A/P Integrity reports reconcile only AA ledger type transactions?
References

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