My Oracle Support Banner

E1: 04: FAQ - Frequently Asked Questions Regarding AP As Of Reports (R04901A, R04413C, R04423C, R04423D) (Doc ID 660023.1)

Last updated on SEPTEMBER 10, 2018

Applies to:

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

Purpose

This document provides answers to frequently asked questions regarding JD Edwards EnterpriseOne Accounts Payable As Of Reports (R04901A, R04413C, R04423C, R04423D).

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
 Date File Generation (R04901A) General/Setup Questions
 Question 1: How is the workfile As Of Accounts Payable Ledger (F0411A) table refreshed?
 Question 2: Where is the Date File Generation (R04901) report?
 Question 3: Does the Create AP As Of Files (R04901A) process vouchers in the Accounts Payable Ledger (F0411) if the Pay Status is already P (Paid)?
 Question 4: Is there a recovery process if the Create A/P As Of Files (R04901A) fails during processing?
 Question 5: What are the high impact bugs for Date File Generation (R04901A)?
 Question 6: What are the high impact enhancement bugs for Date File Generation (R04901A)?
 Question 7: R04901A is not consistent when using Data Selection by F0414.Document Company(KCO). That is,the resulting F0411A file will include other KCO values than what was in the Data Selection.Why is that?
 
 Date File Generation (R04901A) Troubleshooting Questions
 Question 1: Why is the Pay Status always A (Approved) in the workfile As Of Accounts Payable Ledger (F0411A), even if the actual voucher Pay Status is H (Held) in Accounts Payable Ledger (F0411)?
 Question 2: Why does the Create AP As Of Files (R04901A) have such a long processing time?
 Question 3: Why do transactions with future dates cause issues reconciling data?
 Question 4: The Create AP As Of Files (R04901A) on the Server returns an error but works fine on a Fat Client, why?
 Question 5: A voucher is not processed by the Create A/P As Of Files (R04901A) if the Gross Amount (data dictionary item AG) is zero, why?
 As Of Open AP Summary Report (R04413C) General/Setup Questions
 Question 1: Is there a report that summarizes Accounts Payable aging by supplier number detailing one total line per supplier?
 As Of Open AP Summary Report (R04413C) Troubleshooting Questions
 Question 1: My auditors are comparing the Open Amount of R04413C and is not equal to the G/L amount for the same account (AP Trade), how can this be explained?
 Question 2: Why are the totals for the As Of Open AP Summary Report (R04413C) inconsistent with the totals of the Open AP Details of Aging (R04423B)?
 Question 3: What could cause the output in the header of As Of Open AP Summary Report (R04413C) to show 1-0 instead of the aging values set in the processing options?
 Question 4: Why does the Open A/P Summary Report (R04413) and "As-Of" Open A/P Summary Report (R04413C) produce different results for vouchers that have a Pay Status # (Work in Progress)?
 As Of AP Detail with Remarks (R04423C) Troubleshooting Questions
 Question 1: Why does the As Of AP Detail with Remarks report (R04423C) show ## N/A ## in the Report Total?
 Question 2: Why are the totals incorrect on the As Of A/P Detail with Remarks report (R04423C)?
 Question 3: Why is the As Of AP Detail with Remarks report (R04423C) returning a blank PDF?
 As Of Open AP Details with Aging (R04423D) General/Setup Questions
 Question 1: Is it possible to change the aging columns on the As Of Open AP Details with Aging (R04423D)?
 Question 2: What is the difference between the Open AP Details of Aging (R04423B) and the As Of Open A/P Details with Aging (R04423D)?
 As Of Open AP Details with Aging (R04423D) Troubleshooting Questions
 Question 1: A voucher pay item net to zero, however, the As Of Open AP Details with Aging (R04423D) is printing the amount incorrect: a negative amount in the current column and a corresponding positive amount under the aging days column, why?
 Question 2: In XE for the Report R04423D in the PO of the Aging tab there is one field DATE CALCULATION where we can select or enter the date. But in 9.0 the same DATE CALCULATION field is not there why?
References

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