Aurelie Mazerot
Process Expert


TBC



General Description
These indicators explore the Customer Overdue and Outstanding through monthly trend and 12M Rolling chart. There is a bar displaying the overdue aging and accrued overdue by customers. As for the overdue risks, it is now showing the risks classes according to GBU's customers as defined.



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.