Aurelie Mazerot
Process Expert
Miriam Luttrin
General Description
This indicator explore the aged overdue and the end of the month overdue split by PRS Customer. It provides to the credit team a real scenario of which customers has the largest overdue.
 
 Indicator details results can be analyzed by :
PRS Customer
Aged: 0-4 days
--------5-10 days
---------11-30 days
--------31-60 days
---------> 60 days
 Date Reference:
 
  Refresh Frequency:
Daily for current month's balance
Monthly for previous months' balances

 

KPI Name
Calculation
Overdue (KCURR)
Consists of total overdue for current and past months. When no selection of month is made, the list will show the current month's data up to the last update of dashboard. A choice to select a specific month to view the list of overdue customer for the selected specific month
%Overdue

 

-----Overdue
-----------------------
--Total Overdue

 

Overdue EOM
End of Month Overdue:
It's the overdue amount at the end of the last month
Source Information:
QV Query:
QVSBS_BW_QRY_MVFIAR01_0006
Core Query
 
Specific Dimensions
GL Account Sub Type
 
Mini Zone (Cust)
 
Customer Country
 
PRS Customer
 
Customer Group
 
Coll. Speci.
 
Sales Rep
 
Credit. Mgr.