Aurelie Mazerot
Process Expert
Miriam Luttrin
General Description
This indicator measured payment behaviors of customers of Solvay's GBUs rating for M-1 (previous month) based on rolling 6 months' data. The first chart display the number of customer vs. payment behaviors, then another chart that relates GBU vs. payment behaviors and last a table with two possibility of view: Rating on payment behavior, where it's possible to see the score of each zone and GBU and Value by payment period where it's possible to see the amount paid classified as Early Payment,
At the due date, Late 1 - 4, Late 5 - 10, Late 11 - 30 and Late > 30

 Indicator details results can be analyzed by :
Rating on Payment Behaviors
  • GBU
  • Legal Entity Zone
Value vs. Payment Period: Early Payment/ At the due date/ Late 1 - 4/ Late 5 - 10/ Late 11 - 30/ Late > 30
  • GBU
  • Payer Geographical Zone
  Refresh Frequency:
Monthly (1st Sunday of the month)

 

KPI Name
Calculation
Rating
Payment Period
Early Payment
At the due date
Late 1 - 4
Late 5 - 10
Late 11 - 30
Late > 30
Source Information:
Core Query:
BW_QRY_MVFIAR01_0010
QV Query
QVSBS_BW_QRY_MVFIAR01_0010
BW Filters:
 Company Code <> ZUS4
GL Acct Sub Type = PRODUCT AND SERVICE
GL Acct Type = RECEIVABLES
PRS Comp. Interco Flag = YES
PRS Comp. Merging Date = # 
PRS Cust. Interco Flag = No
ERP GBU <> Eco Service
Control  Credit Area = "SOLV"
Specific Dimensions
Customer Country
Country of the PRS Customer
Customer Group
Customer Group of the PRS Customer
Credit. Mgr.