Versions Compared

Old Version 1

changes.mady.by.user Karina Keiko Tsuji

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.

 Image Added

Info
titleProcess Owner
Aurelie Mazerot
Process Expert
Info
titleD&PS Expert
Miriam Luttrin
General Description
This indicator explore the top customers with accrued overdue for past 2 years. 
The first customer displays in the table will be the customer who has the highest accrued overdue amount. The period for the accrued amount is based on the period selected in the filter dimensions.
*You can change the numbers of customer you want to display:
Image Added
 
 Indicator details results can be analyzed by :
PRS Customer
Month Year
Image Removed Date Reference:
 
 Image Modified Refresh Frequency:

Monthly (during closure on 1st to 6th 3 times per day)

 

KPI Name
Calculation
Overdue (KCURR) by PRS Customers - Top 20
The first customer displays in the table will be the customer who has the highest accrued overdue amount. The period for the accrued amount is based on the period selected in the filter dimensions.
*You can change the numbers of customer you want to display:
Image Modified
Source Information:
Core Query
BW_QRY_MVFIAR01_0001
QV Query:
QVSBS_BW_QRY_MVFIAR01_0001
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.