Versions Compared

Old Version 4

changes.mady.by.user Li Lian Cheong

Saved on

compared with

New Version Current

changes.mady.by.user Rachdi, Donia

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Image RemovedImage Added

info
Info
titleProcess Owner
Aurelie Mazerot
Process Expert
iconfalse
titleD&PS ExpertKPI Owner
TBC
Louise Hallström



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.
      Image Removed Refresh Frequency: 
    • DSO are filtered on the GL Accounts Sub Type "Products & Services". If you use My Table, don't forget to add the filter back to have aligned figures!
    • The highlights DSO is based on the last 12 months rolling.
    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 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:

Image Removed

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 Days = Number of days in the month. (Month premise: 30 days)
  • Outstanding Outstanding = Sum of open documents in the customer's account at the report date. Receivables in doubtful state and advanced payments are excluded.
  • Turnover Turnover = Sales (VAT included) in a specific month
  • m m = Current month (Month Premise: 30 days)
Best DSO
 Number  Number of days of up to previous month (M-1)
Delay DSO
 = DSO - Best DSO
Info
iconfalse
titleAttention
On My
Report
Table, DSO KPI comes with TOTAL. Note the TOTAL calculation is made based on the formula described above.
Ex:

Image Removed

 

If Turnoverm ≥ Outstandingm then
DSO = Outstandingm / Turnoverm X daysm

Image Added

 

Source Information:
Core Query:
BW_QRY_MVFIAR01_0001
QV Query:
QVSBS_BW_QRY_MVFIAR01_0001
Flat file
Non Core ERP Credit DATA for Composite Materials and Chemlogics
BW Filters:
Image Removed Company Code <> ZUS4
 Image RemovedGL Acct Type = RECEIVABLES
Image Removed
PRS Comp.
Interco Flag = YES
Image RemovedPRS Comp. Merging Date = #
 Image Removed PRS Customer <> 2200000000 CLIENTI
 Image Removed
PRS Payer <> SPARROW SRL - 423344


Image Added
Previous obsolete exclusions:
Company Code <> ZUS4
ERP GBU <> Eco Service
PRS Comp. Interco Flag = YES
PRS Cust. Interco Flag = No
Image RemovedERP GBU <> Eco Service
Image Removed
Qlik Filters
  • GL account sub-type = Product and services
    => in the pages by default, to be added in the My report sheet
  • PRS Payers: 
    <> SIEMENS FINANCE & LEASING GMBH - 1039781
    <> 2200000000 CLIENTI - 410759
    <> Aleris rolled products - 1039381
  • Control  Credit Area = "SOLV"
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
 
Zone
PRS Customer Zone (this falls under the attribute list of 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.