Days Sales Outstanding (DSO) Shows As 0 When There Are No Sales Within The DSO Days
Last updated on MAY 11, 2017
Applies to: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 = (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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms