E1: 03B: FAQ- Frequently Asked Questions about AR Statistical History (R03B16, R03B16A, R03B161, R03B163)
(Doc ID 664021.1)
Last updated on MAY 02, 2024
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 AR Statistical History (R03B16(A)).
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 are there only two records in the F03B16 table for Address Number 00000000, after the Statistics History Update (R03B16(A)) is run? |
| Question 2: Why is the Statistics History Update not updating information for specific customers? |
| Question 3. Why does the Statistics History Update take so long to run? |
| Question 4. Can data selection be used for the Statistics History Update (R03B16(A))? |
| Question 5. How does the 'Number of Days to Balance' processing option work, and what happens when the number is exceeded? |
| Question 6. Why is the Days Sales Outstanding (DSO) field not updated correctly, when Stats History Refresh (R03B16(A)) is run? |
| Question 7: How can the F03B16 and F03B16S statistical tables be rebuilt/refreshed; for an example going back 5 years of data with current year = 2013? |
| Question 8. Why have the stats in the Account Balance Inquiry (P03B218), on form 'Periodic Statistics' not been updated since we did our year end? |
| Question 10: Is it possible to run Statistical History report R03B16A by company CO or KCO? |
| Question 11: Is it possible to change the processing options of Stats History Refresh (R03B16A)? I have heard that it is recommended not to change them. Would you please clarify why? |
| Question 12: In which currency are values shown in the A/R History (F03B16) and A/R History Summary (F03B16S) tables? |
| Question 14: Why is it not recommended to use data selection when running Stats History Refresh (R03B16A)? Does the UBE not read it? |
| Question 17: Does Stats History Refresh (R03B16A) include nonstandard invoice document types in its calculations? |
| Question 18: Why is the R03B16A running for extended time without giving any errors? |
| Question 19: What might cause the R03B16A to run for a much longer time than it has in the past, ultimately erroring out with memory allocation failure errors shown in the jde.log? |
| Calculations |
| Question 1. How and when is the Ending Balance (ENBL) field calculated? |
| Question 3. How is the Customer Master by Line of Business (F03012) ''Average Days Late' (AVD) calculated? |
| Question 4. How are the fields 'Weighted Average Days Late' and 'Percent of Amt Paid Late' calculated? |
| Question 5. What is the difference between Average Days Late (AVD) and Weighted Average Days Late (AVDL), and how do these get calculated? |
| Question 6: How is the High Balance (AHB) calculated? |
| Question 7: Why isn't the R03B16A calculating any fields for any of the customers on a new install with newly created data? |
| Question 8: Why does the calculated High Balance appear to only be for each particular period and not for all open records from previous periods? |
| Question 9: How is the value for the Days Sales Outstanding (DSO) field calculated in the A/R Statistical History Table (F03B16) using the Average Balance Method? |
| Question 10: How is the value for the Best DSO (BDSO) field calculated in the A/R Statistical History Table (F03B16) using the Average Balance Method? |
| Question 11: How is the value for the Delinquent DSO (DDSO) field calculated in the A/R Statistical History Table (F03B16)? |
| Question 12: How is the Delinquent Balance (DLBL) field calculated in the A/R Statistical History Table (F03B16) / displayed in the Periodic Statistics application (P03B16)? |
| Purge |
| Question 1. How can I manually purge statistical history data? |
| References |