Versions Compared

Old Version 4

changes.mady.by.user Miriam Luttrin

Saved on

compared with

New Version Current

changes.mady.by.user Karina Keiko Tsuji

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Info
titleProcess Owner
Aurelie Mazerot
Process Expert
Info
titleD&PS 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.

This page contains a chart: Aging balance that display current and past month's aging overdue in K€ (according to user's preference) and a table : that list overdue customers and consists of current and past months data. 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.
 
 Indicator details results can be analyzed by :
PRS Customer
Aged: 0-4 days
---------5-10 days
---------11-30 days
---------31-60 days
---------> 60 days
Image Removed 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
Overdue value but only for current month.
Source Information:
Core Query:
BW_QRY_MVFIAR01_0006
QV Query:
QVSBS_BW_QRY_MVFIAR01_0006
Core Query
BW Filters:
Image Added Company Code <> ZUS4
 Image AddedGL Acct Type = RECEIVABLES
Image AddedPRS Comp. Interco Flag = YES
Image AddedPRS Comp. Merging Date = #
 Image Added PRS Customer <> 2200000000 CLIENTI
 Image AddedPRS Cust. Interco Flag = No
Image AddedERP GBU <> Eco Service
Image AddedControl  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.