E1: 03B: FAQ - Frequently Asked Question Regarding AR Open Detail Reports and 'As Of' Reports (R03B413A, R03B413B, R03B4201A, R03B4201B, R03B429B)
(Doc ID 837840.1)
Last updated on MARCH 06, 2023
Applies to:
JD Edwards EnterpriseOne Accounts Receivable - Version XE and laterInformation in this document applies to any platform.
Purpose
This document provides answers to frequently asked questions on Open A/R Reports.
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 |
| General Questions |
| Question 1: Can Open AR Aging Reports Be Sorted By Collection Manager? |
| Question 2: Is it possible to have distinct column headings for the AP aging reports and for the AR aging reports? |
| Question 3: Is there any standard JDE report giving output of customer open AR Balances "As of" specific date along with aging information? |
| Question 4: For any of the A/R reports, is it possible to display the negative amounts with parenthesis rather than a negative sign? For example (123.45) instead of 123.45- |
| As Of Processing Questions |
| Question 1: Why do the G/L account balances not reconcile with the A/R balances on As-of aging report (R03B4201A or R03B4201B)? |
| Question 2: Can R03B4201A or R03B4201B be used to Summarize and use "As Of"? |
| Question 3: Why do we have performance issues when running R03B4201A or R03B4201B for "As Of" reporting? |
| Question 4: What is the equivalent report for the AS of Reporting - Date file generation (P03900) on World for E1? |
| Question 5: In the report A/R Details with Aging (R03B4201B), there is a new processing option under the Date tab - [Pre-Activity As Of]. How to use this option? |
| Question 7: At what date does the Open A/R Detail with Aging report (R03B4201B) look to use for comparison with the As Of date? |
| Question 8: Does a standard A/R 'As Of' report exist that reports in both the reporting company currency and the transactional currency of the customer? |
| Question 10: How can Master Business Function B03B0136 be accessed? |
| Open A/R Summary report (R03B413A) Questions |
| Question 1: Why are we getting multiple lines for the same customer on the R03B413A report? |
| Question 2: Why do the open AR balances from the R03B413A report not seem to match with those of Customer Ledger Inquiry (P03B2002)? |
| Question 3: What type of AR transaction would be included under the "Future" Column of the R03B413A report? |
| Open A/R Summary with Currency report (R03B413B) Questions |
| A/R Invoice Details With Aging report (R03B4201B) Questions |
| Question 1: Why does the customer's phone number not show up at all on report R03B4201B, after implementing the fix for <Bug:10961422>? |
| Question 2: R03B4201B is not aging Unapplied Cash (doc type RU) as expected (by invoice date in company constants). Shouldn't the report use the Receipt Date value for this aging? |
| Question 3: Why does the output of R03B4201B not always tie back to the General Ledger (F0911)? |
| Question 5: Why is R03B4201B not printing the telephone number for customers, although it does print the brackets? |
| Question 7: Why is the Open A/R Detail with Aging report (R03B4201B) taking hours to run? |
| Question 8: When the R03B4201B report is submitted with the CSV Output option active, why are some columns missing (e.g. invoice number) in the CSV Output when compared to a PDF Output? |
| Question 9: Why does the R03B4201B show an invoice as fully open, when the the F03B11 record indicates the invoice is not fully open or closed? |
| A/R Invoice Details with Remarks report (R03B4201A) Questions |
| Question 1: Why are the page numbers on the Open A/R Detail with Remarks Report (R03B4201A) not printing in release 9.1? |
| Question 2: The R03B4201A shows an Open Amount of $523.67 where the G/L shows an Open Amount of $506.95, how to fix this? |
| Question 3: When the R03B4201A report is submitted with the CSV Output option active, why are some columns missing (e.g. Invoice Date) in the CSV Output when compared to a PDF Output? |
| Currency Detail - Aging report (R03B429B) Questions |
| Question 1: What does the processing option 'Age Credit Amounts' on R03B429B do? |
| A/R Currency Foreign/Domestic with Aging (R03B429C) Questions |
| Question 1: Why do the foreign totals on the A/R Currency Foreign/Domestic with Aging (R03B429C) report show as "N/A"? |
| References |