My Oracle Support Banner

E1: 03B: EnterpriseOne AR Statistical History Refresh Advisor Webcast Presentation (Doc ID 1602723.1)

Last updated on MAY 26, 2023

Applies to:

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


This document is consumable version of the EnterpriseOne AR Statistical History Refresh Advisor Webcast Presentation.




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
 Setup - Credit/Collection Date Pattern (P03B08)
 Setup - Minor Write-off and Bad Debt Amounts
 Setup - AR Statistical History Refresh (R03B16A)
 Account Statistical Summary (P03B16)
 Periodic Statistics (P03B16)
 Statistics Annual Close (R03B161)
 Statistical Purge Repost (R03B163)
 AR Statistical History table (F03B16)
 Ending Balance (ENBL)
 Delinquent Balance Amount (DLBL)
 High Balance Amount (AHB)
 Days Sales Outstanding (DSO)
 Days Credit Granted (BDSO)
 Delinquent DSO (DDSO)
 Average Days Late, Non-Weighted (AVDN)
 Weighted Average Days Late (AVDL)
 Paid Late Amount (AIPL)
 Bad Debt (BDBT)
 Total Write-Off (TAWO)
 AR Statistical Summary Table (F03B16S)
 Ending Balance Amount (ENBL)
 High Balance Amount (AHB)
 High Credit Limit (ACLH)
 Average Days Late, Non-Weighted (AVDN)
 Weighted Average Days Late (AVDL)
 Gross Amount (AG)
 Sales Amount (SAG)
 Amount Invoiced Current Year (ASTY)
 Amount Invoiced Prior Year (SPYE)
 Minor Write-Off Amount (MWO)
 Statistical Trend Analysis Report (R03B165)
 Aging Trend Analysis Report (R03B166)
 Receipt Trend Analysis (R03B167)
 Invoice Trend Analysis (R03B168)
 Statistical Definitions by Company (R03B1691)
 Statistical Definitions by Credit Manager (R03B1692)
 Statistical Definitions by Collection Manager (R03B1693)
 Best Practices
 Statistics History Update (R03B16(A))
 Frequently Asked Questions
 Question 1: When changing the DSO calculation method from Average Balance to Count Back, will the DSO statistics for previous periods automatically be recalculated using the new method?  
 Question 2: Why have the stats on the Account Balance Inquiry – form Periodic Statistics (P03B218) not been updated since year end?
 Question 3: Why does the Statistics History Update (R03B16(A)) take a long time to run?
 Question 4: Can data selection be used for the Statistics History Update (R03B16(A))?

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