My Oracle Support Banner

E1: 03B: FAQ - Frequently Asked Questions about A/R Statements (R03B500X, R03B5001, R03B5005, R03B5010) (Doc ID 625842.1)

Last updated on JUNE 20, 2023

Applies to:

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


This document provides answers to frequently asked questions about A/R Statements (R03B500X, R03B5001).

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
Questions and Answers
 General Questions
 Question 1: Why wasn't the change to the Alpha Name (ALPH) through Address Book Revisions (P01012) reflected on the statement?
 Question 2: Why is it taking so long to process statements?
 Question 3: How can paid invoices be excluded from statements?
 Question 4: Why do statements with zero dollar balances print?
 Question 5: Can statements be printed in portrait format?
 Question 6: Is it possible to view AR statements in CSV format?
 Question 7: How is the A/R Statement Print Driver (R03B5005) added to the Next Unique Number - Find/Browse program (P00022)?
 Question 8: If the next number for the field Batch Run ID (RNID) is 999 in Next Unique Number - Find/Browse program (P00022), can the user manually update the field to 1?
 Question 9: Why does R03B5005 - 'A/R Statement Print Driver' go into an infinite loop, when the value of processing option #3 'Summarize Invoices' is set 'Blank = Pay items Only' in R03B500X - 'Statement Notification Refresh'?
 Question 10: When testing Statements (R03B500X), why are we getting different results with every test? Some times it loops, some times it doesn't summarize invoices by customers, etc.
 Question 11: Prior to release 8.9: On an AS400 Platform, in the AR statements run process, R03B500X runs and creates the statement records but the subsequent UBE's (R03B5005 and R03B5001) that print the statements are never run. The process runs OK locally?
 Question 12: The system is generating a statement for each invoice. They are all for the same customer and company. Why does this occur?
 Question 13: When running Statement Notification Refresh (R03B500X), why is the Due Date not populated in F03B21 for the summary lines?
 Question 14: Is it possible to prevent statements from printing if they have only current balances?
 Question 15: Why is a statement not generated when the Customer Ledger (F03B11) record has a value in the Date Invoice Closed (RPJCL) field, that is less than or equal to the value of the Statement Date on the F03B11?
 Question 16: When using Greater Than or Less Than operators in the Grid of Work with Notifications (P03B202) for Statement Number (CTL), why are the results not as expected?
 Question 17: Why, after migrating from World A7.3 to E1 9.1, does the system not break the A/R statements properly by customer when running R03B500X-R03B5005-R03B5001?
 Question 18: To print statements in another language such as French, the language is added to the customer's Address Book records (P01012) and French language is installed on the environment, but the statement produced is only partially translated into French. Some of the column headers appear in English, what needs to be checked?
 Question 19: What Document Types are included by default on statements?
 Question 20: Is it possible to produce a consolidated parent-level statement that aggregates child-level information into a single statement?
 Question 21: Can the original invoice amount be printed on statements?
 Statement Notification Refresh (R03B500X) Questions
 Question 1: The R03B500X is showing boxes on the "remit to" address. Is there any setup that has been missed out?
 Question 2: Can the data sequencing of R03B500X be changed to print statements in a different order?
 Question 3: What does the data sequence of the Statement Notification Refresh (R03B500X) control?
 Question 4: Which tables are used by R03B500X, Statement Notification Refresh?
 Question 5: After migrating one DB to another DB, R03B500X - Statement Notification Refresh stays 'P - Processing' status from Work With Submitted Job screen. What will be the possible cause of this?
 Question 6: When running Statement Notification Refresh (R03B500X), why is the Due Date not populated in F03B21 for the summary lines?
 Question 7: How is the NAPR field populated in F03B20?
 Question 8 : A GL Receipt is entered via Standard Receipt Entry (P03B11) thru Form / General Ledger.  Why this transaction did not appear in the Statement?   
 Question 9 : If the summarize processing options on both the R03B500X and the R03B5001 are set to  1 ( = Summarize), what is shown in the Remark field in the output file of R03B5001 ?
 Question 10 : Why might the Company Consolidation processing option not consolidate all invoices for a given customer into one statement under the designated Company value?
 Question 11 : Is there a way to send/burst AR Statements as an Excel spreadsheet in .xlsx format?
 AR Statement Print Driver (R03B5005) Questions
 Question 1: The R03B5005 runs but never completes. What might cause this to occur?
 Question 2: The R03B5005 runs, generates no Work Center messages, but ends in error in Work with Submitted Jobs.  What might cause this to occur?
 Statement Print (R03B5001) Questions
 Question 1: How can the data sequence of the statement detail be changed?
 Question 2: What are the standard print programs available for generating statements (Statement Notification Refresh (R03B500X))?
 Question 3: Can I use A/R Delinquency Notices Print (R03B20) as the Print Program when running the Statement Notification Refresh program (R03B500X)?
 Question 4: How does the new Invoice Column (ZSAAP) on the AR Statement report (R03B5001) get updated?
 Question 5: Why is any additional data selection or changes to the default data selection specified on the Statement Print (R03B5001) report ignored?
 Question 6: Why does the mailing name print twice for a customer on the Statement Print (R03B5001) output, if you have multiple Who's Who records, one of which being the A/R Billing type?
 Statement Purge (R03B5010) Questions
 Question 1: Why are all records with a future date still in the A/R Notification History (F03B20) and the A/R Notification Detail (F03B21) tables after the statement purge was run?

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