Aurelie Mazerot
Process Expert


Miriam Luttrin



General Description
This KPI is a summary table that includes Product and Service (Turnover, Outstanding, Overdue, Percentage of Overdue, DSO, Best DSO, Delay DSO, Cash Value 1 day DSO (KCURR)), Doubtful (Bad Debt), Write Down (Negative amounts displayed in positive), Advanced Payments (Negative amounts displayed in positive), Accruals and Revaluation.

 Indicator details results can be analyzed by :
Month Year


  Refresh Frequency:
Monthly (during closure on 1st to 6th 3 times per day)



KPI Name
Calculation
Turnover (KCURR)
Total Sales of the month
Outstanding (KCURR)
Sum of open documents in the customer's account at the report date
Overdue (KCURR)
Amount of outstanding due and not yet paid at the date of report. In a monthly report, the overdue amount at the end of the month is the sum of amounts with due date lower or equal to the last day of the month and not yet paid nor cleared by that date.
% Overdue
Percentage of Overdue - Overdue/Outstanding:
 It is by default filtered by GL Account sub-type Product & Services.
**Please noted that Credit Management term will still communicate official percentage overdue statistics for Solvay Group with the old calculation method. 
DSO
Evaluation in teams of days of sales of the outstanding amount at the report date. It is a measure 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

  • 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
Cash Value 1 day DSO (KCURR)
Amount to the each day of the DSO
= Outstanding / DSO
Bad Debts Outstanding (KCURR)
Amount consider 100% lost
%Bad Debts Outstanding
-------Bad Debts Outstanding (KCURR)
= ---------------------------------------------------
-------------Outstanding (KCURR)
Advanced Payment Outstanding (KCURR)
Payment received before due date. Where GL Acct Sub-type = ADVANCE PAYMENT transformed to absolute value.
%Advanced Payment Outstanding
-------Advanced Payment Outstanding (KCURR)
= -------------------------------------------------------------------
---------------Outstanding (KCURR)
Write Downs Outstanding (KCURR)
Bad Debits adjustment
%Write Downs Outstanding
-----------Write Downs Outstanding (KCURR)
= -------------------------------------------------------------------
------------------Outstanding (KCURR)


Source Information:
QV Query:
QVSBS_BW_QRY_MVFIAR01_0001
Core Query:
BW_QRY_MVFIAR01_0001
BW Filter
 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.