Aurelie Mazerot
Process Expert
Miriam Luttrin
General Description
This KPI explore the Outstanding, Overdue and number of credit accounts vs. the risk class:
# - Unassigned
1 - Low Risk
2 - Medium Low Risk
3 - Medium Risk
4 - High Risk
5 - Credit Against Security
On the top a chart display the Outstanding split by risk percentage by zone and below a table with 2 possibility of views: General View that display the overdue, outstanding and #credit accounts by Risk and BFC Activity and Details for High Risk (4 & 5) that display the overdue, outstanding and #credit accounts only from customer under risk 4 and 5 .

 Indicator details results can be analyzed by :
General View:
  • BFC Activity
High Risk (4 & 5)
  • BFC Activity
  • Customer
  Refresh Frequency:
Monthly (during closure on 1st to 6th 3 times per day)

 

KPI Name
Calculation
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.
#of credit accounts
#of credit accounts
Risk Class:
# - Unassigned
1 - Low Risk
2 - Medium Low Risk
3 - Medium Risk
4 - High Risk
5 - Credit Against Security
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
Sales Rep
 
Credit. Mgr.