Aurelie Mazerot
Process Expert
Miriam Luttrin
General Description
This indicator explore the Overdue and Outstading through trend monthly or 12M Rolling chart and table in addition to calculate the % of Overdue and correlates them to the DSO.
 Indicator details results can be analyzed by :
GBU
Group of Activity
Legal Entity
Payer Geographical Zone
GL Acc Sub Type
Legal Entities

 

  Refresh Frequency:
 Monthly (after D4 closing)

 

KPI Name
Calculation
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)
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. 

 

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.