You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

Process Owner

Aurelie Mazerot
Process Expert

D&PS Expert

Miriam Luttrin
General Description
This indicator explore the top customers with accrued overdue for past 2 years. 
 Indicator details results can be analyzed by :
PRS Customer
Month Year
 Date Reference:
 
  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:
Source Information:
QV Query:
QVSBS_BW_QRY_MVFIAR01_0001
Core Query
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
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.
 

 

 

Core Query:
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

Not able to find the solution? Contact SBS Support.

Page viewed times
#trackbackRdf ($trackbackUtils.getContentIdentifier($page) $page.title $trackbackUtils.getPingUrl($page))
  • No labels