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 laterInformation in this document applies to any platform.
Purpose
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
| Purpose |
| 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 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 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 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 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? |
| References |