Aurelie Mazerot
Process Expert


TBC



General Description
This indicator explore the Customer Overdue and Outstanding through monthly trend or 12M Rolling chart and table in addition to calculate the percentage of Overdue and correlates them to the DSO.



KPI Name
Calculation
Outstanding (KCURR)
Sum of open documents in the customer's account as 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 amount 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 calculation:
Percentage of Overduem = Overduem / Outstandingm
Only GL Account sub-type = Product & Services is taken when calculating outstanding and overdue.
**Please noted that Credit Management team 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:
GL Acct Type = RECEIVABLES
PRS Comp. Interco Flag = YES

PRS Comp. Merging Date = #

PRS Cust. Interco Flag = No
Control  Credit Area = "SOLV"
To be excluded
Company Code <> ZUS4
PRS Customer <> 2200000000 CLIENTI
ERP GBU <> Eco Service
Refresh Frequency:
Monthly (after D4 closing)


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.