Aurelie Mazerot
Process Expert
Miriam Luttrin
General Description
 A monthly trend on DSO (Days Sales Outstanding), Best DSO in terms of number of days of up to previous month (M-1). It also provides the differences on number of days between DSO and best DSO which is known as late/delayed DSO. The new calculation of DSO is now 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).
 Indicator details results can be analyzed by :
GBU
Group of Activity

 

  Refresh Frequency: 
Monthly (during closure on 1st to 6th 3 times per day)
KPI Name
Calculation
DSO
Evaluation in terms of Days of Sales Outstanding at the report date. It is a measure of efficiency of 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

  • 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 Report, DSO KPI comes with TOTAL. Note the TOTAL calculation is made based on the formula described above.
Ex:

 

 

Source Information:
Core Query:
BW_QRY_MVFIAR01_0001
QV Query:
QVSBS_BW_QRY_MVFIAR01_0001
BW Filters:
Company Code <> ZUS4
 GL Acct Type = RECEIVABLES
PRS Comp. Interco Flag = YES
PRS Comp. Merging Date = #
  PRS Customer <> 2200000000 CLIENTI
 PRS Cust. Interco Flag = No
ERP GBU <> Eco Service
Control  Credit Area = "SOLV"
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.