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 laterInformation in this document applies to any platform.
Purpose
This document is consumable version of the EnterpriseOne AR Statistical History Refresh Advisor Webcast Presentation.
Scope
NA
Details
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 |
Scope |
Details |
Overview |
Setup |
Setup - Credit/Collection Date Pattern (P03B08) |
Setup - Minor Write-off and Bad Debt Amounts |
Setup - AR Statistical History Refresh (R03B16A) |
Process |
Account Statistical Summary (P03B16) |
Periodic Statistics (P03B16) |
Statistics Annual Close (R03B161) |
Statistical Purge Repost (R03B163) |
Definitions |
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) |
Reports |
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))? |
References |