Days Sales Outstanding (DSO) Shows As 0 When There Are No Sales Within The DSO Days
(Doc ID 1900782.1)
Last updated on FEBRUARY 03, 2019
Oracle Advanced Collections - Version 12.1.3 and later Information in this document applies to any platform.
On : 12.1.3 version, Collections Agent UI
Days Sales Outstanding (DSO) now shows as zero when Total Sales for DSO days is zero.
This has changed from previous functionality, in which you would substitute a 1, when the sales were 0.
DSO Formula: DSO = (total outstanding receivables/total sales for last DSO days) * (DSO Days) NOTE: If Total Sales for DSO days is null or zero, then one (1) is substituted in the calculation.
You have the following: GET_CONV_DSO_OCM : l_op_bal 40 GET_CONV_DSO_OCM : l_tot_bal 0 DSO_DAYS = 30 (40/0) * 30 = 0
Based on note, this should be (40/1) * 30 = 1200 So the code does NOT include this substitution: iexvmtib.pls latest version 120.12.12010000.7 l_conv_dso := l_op_bal/l_tot_bal*l_dso_days;
Steps to Reproduce: 1. DSO days = 30 2. Create new customer, and invoice for 01-FEB-2014, sysdate = 05-JUN-2014. 3. Run scoring engine, customer is delinquent. DSO = 0 4. Create invoice for 01-JUN-2014, rerun scoring. 5. DSO now shows as 45.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!