Versions Compared

Old Version 30

changes.mady.by.user Rachdi, Donia

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.


Info
iconfalse
titleKPI Owner
Aurelie Mazerot
Info
iconfalse
titleSBS Decision & Piloting Solutions Team
WW Solutions:
  • Donia Rachdi
Regional Animators:
  • Emma Glasson (EMEA)
  • Karina Tsuji (LATAM & NAM)
    • Lilian Cheong (APAC)
    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.
    • 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.
    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
    Info
    iconfalse
    titleAttention
    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
    Flat file
    Non Core ERP Credit DATA for Composite Materials and Chemlogics
    BW Filters:
    GL Acct Type = RECEIVABLES
    PRS Comp. Merging Date = #
    PRS Payer <> SPARROW SRL - 423344


    Previous obsolete exclusions:
    Company Code <> ZUS4
    ERP GBU <> Eco Service
    PRS Comp. Interco Flag = YES
    PRS Cust. Interco Flag = No
    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.