Aurelie Mazerot


WW Solutions:
  • Donia Rachdi
Regional Animator:
  • Stephane Bourgeaud-Lignot/Emma Glasson (EMEA)
  • Karina Tsuji (LATAM & NAM)
  • Lilian Cheong (APAC)



General Description
A monthly trend on DSO (Days of Sales Outstanding), Best DSO, comparing with Target in terms of number of days. It also provides the differences on number of days between DSO and best DSO which is known as late/delayed DSO. The calculation of DSO is using back-track method. In the DSO calculation, Solvay Energy Services is being excluded, but it is included in both Overdue and Outstanding (if any).There is also results of DSO, Best DSO between GBUs and also the Group of Activity within individual GBU.
  • DSO are filtered on the GL Accounts Sub Type "Products & Services"
  • The highlights DSO is based on the last 12 months rolling.



KPI Name
Calculation
DSO
Evaluation in terms of Days of Sales Outstanding at the report date. It is a measurement of efficiency on how quickly receivables are collected. It shows the age in term of days of an organization's accounts receivable and the average time it takes to turn receivables into cash.
The calculations are as follow:
If Turnoverm ≥ Outstandingm then
DSO = Outstandingm / Turnoverm X daysm
If (Turnoverm + Turnoverm-1) ≥ Outstandingm then
DSO = (Outstandingm - Turnoverm) / Turnoverm-1 X daysm-1 + daysm
If (Turnoverm + Turnoverm-1 + Turnoverm-2) ≥ Outstandingm then
DSO = (Outstandingm - Turnoverm - Turnoverm-1) / Turnoverm-2 X daysm-2 + daysm-1 + daysm
  • Days = Number of days in the month. (Month premise: 30 days)
  • Outstanding = Sum of open documents in the customer's account at the report date. Receivables in doubtful state and advanced payments are excluded.
  • Turnover = Sales (VAT included) in a specific month
  • m = Current month (Month Premise: 30 days)
Best DSO
 Number of days of up to previous month (M-1)
Delay DSO
 = DSO - Best DSO


On My Table, DSO KPI comes with TOTAL. Note the TOTAL calculation is made based on the formula described above.
Ex:
If Turnoverm ≥ Outstandingm then
DSO = Outstandingm / Turnoverm X daysm

 

Source Information:
Core Query:
BW_QRY_MVFIAR01_0001
QV Query:
QVSBS_BW_QRY_MVFIAR01_0001
BW Filters:
GL Acct Type = RECEIVABLES
PRS Comp. Interco Flag = YES
PRS Comp. Merging Date = #
PRS Cust. Interco Flag = No
Control  Credit Area = "SOLV"
Have been Excluded
Company Code <> ZUS4
PRS Customer <> 2200000000 CLIENTI
ERP GBU <> Eco Service
Refresh Frequency
Monthly (during closure on 1st to 6th 3 times per day)


Specific Dimensions
GL Account Sub Type
By default filtered on Product and Services. Other values may be selected; Accruals&Revaluation, Advance Payment, Doubtful, Write Down
Mini Zone (Cust)
Mini Zone of the PRS Customer
Customer Country
Country of the PRS Customer
PRS Customer
 
Customer Group
Customer Group of the PRS Customer
Coll. Speci.
 
Sales Rep
 
Credit. Mgr.
 
**Missing Dimensions from SBS_OtC
If you do not find the same dimensions you used to see in SBS_OtC, please refer here for details.