My Oracle Support Banner

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

Last updated on AUGUST 23, 2017

Applies to:

JD Edwards EnterpriseOne Accounts Receivable - Version XE and later
Information 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))
 Resources
 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

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