Versions Compared

Key

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

 Image Added

Info
titleProcess Owner
Claudrik Darnet
Aurelie Mazerot 

Process Expert
Info
titleD&PS Expert
Miriam Luttrin
General Description
This indicator explores the the amount of overdue by customers considered as "doubtful", through a chart that relate doubtful debit outstanding amount by PRS Payer Zone and another chart that relates doubtful debit outstanding amount by GBU. A table display doubtful debit outstanding amount by each PRS customer.
 Indicator details results can be analyzed by :
PRS Payer Zone
PRS Customer
GBU

 Date Reference:
 
  Refresh Frequency: 

 

KPI Name
Calculation
Doubtful
 
  
debt outstanding
The amount of debt not overdue by customers considered as "doubtful"
Doubtful debt overdue
The amount of debt overdue by customers considered as "doubtful"
Source Information:
Core Query:
BW_QRY_MVFIGL01_0001
Source Information:
QV Query:
QVSBS_BW_QRY_
MVFIGL01
MVFIAR01_0001
Core Query
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