My Oracle Support Banner

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 AUGUST 19, 2019

Applies to:

JD Edwards EnterpriseOne Accounts Receivable - Version XE and later
Information 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-
 Question 5: Is it possible to increase the number of the aging columns for report R03B4201B A/R Details with Aging?
For example - the aging to be 1-30, 31-60, 61-90, and so on in 30 days buckets till 365 days.
 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 6: The report created by Open A/R Detail with Aging (R03B4201B) shows the right "As Of" open amount and with the individual buckets ties up to the open amount. However this one do not have Foreign Currency Aging bucket. Any solution to this? We need the detail A/R Aging but with both Foreign and Domestic Aging information.
 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?
 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
 Question 1: The report produced by Open A/R Detail - Summarised with Currency (R03B413B) has the format we want. But the issue is the same as R03B413A where the processing option #2 for "As Of" doesn't work. It only shows the Current Open Amount which is Wrong.
 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 4: There are two issues when exporting AR Aging Report (R03B4201B) to Excel. The first is that the invoice# disappears, however, it does show on the PDF file. The second is that my client would like to do some sorting in the excel, but it only shows like a pdf report, no sorting or filter can be done in excel.
Is there anything that can be done regarding this?
 Question 5: Why is R03B4201B not printing the telephone number for customers, although it does print the brackets?
 Question 6: The Open A/R Amount report as of 8/31/03 (generated by R03B4201B) does NOT match the amount for the same period in G/L (displayed on P0902P1). The open A/R amount is less than the G/L amount, and the difference seems to be unapplied cash receipts that are used to apply RMs against RIs. This difference has been growing for the last 2/3 months. Which figure should I trust - G/L or A/R? If G/L is correct, is there anything wrong with the open A/R as-of report?
 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?
 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

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