E1: 04: FAQ - Frequently Asked Questions Regarding AP As Of Reports (R04901A, R04413C, R04423C, R04423D)
(Doc ID 660023.1)
Last updated on APRIL 04, 2024
Applies to:
JD Edwards EnterpriseOne Accounts Payable - Version XE and laterInformation 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)? |
| 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? |
| Question 6: Create A/P As Of Files (R04901A) ends with 'PRIMARY KEY restraint in F0411A_PK and cannot insert duplicate key in F0411A', 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? |
| Question 4: Why is the As Of AP Detail with Remarks report (R04423C) missing some columns in CVS file? |
| 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 |
| References |