My Oracle Support Banner

E1: 03B: How To Calculate Statistical History Update Fields (P03B16, R03B16, R03B16A) (Doc ID 656325.1)

Last updated on JULY 26, 2024

Applies to:

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

Goal

This document describes how key fields in the AR Statistical History (F03B16) and AR Statistical History Summary (F03B16S) tables are calculated and looks in detail at the Weighted Average Days late (AVDL) calculation.

Solution

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
Goal
Solution
 Overview of Field Calculations
 Credits Entered (CREE)
 First Invoice Date (DFIJ)
 Last Invoice Date (DLIJ)
 Deduction Amount (DDCA)
 Last Paid Amount (ALP)
 Paid Late Amount (AIPL) 
 Invoices Paid Late (NIPL) 
 Average Days Late (Non-Weighted) (AVDN)
 Weighted Average Days Late (AVDL)
 Days Sales Outstanding (DSO)
 Bad Debt 
 Bad Debt Ratio 
 Total Write-off 
 Percent (%) of Invoices Paid Late 
 Weighted Average Days (AVDL) Calculation
 1. AVDL in AR Statistical History (F03B16)
 2. AVDL in AR Statistical History Summary (F03B16S)

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