Versions Compared

Old Version 22

changes.mady.by.user Rachdi, Donia

Saved on

compared with

New Version Current

changes.mady.by.user Rachdi, Donia

Saved on

Key

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



Info
iconfalse
titleKPI Owner
Aurelie Mazerot


Info
iconfalse
titleSBS Decision & Piloting Solutions Team
WW Solutions:
  • Donia Rachdi
Regional Animator:
  • Emma Glasson (EMEA)
  • Karina Tsuji (LATAM & NAM)
  • Lilian Cheong (APAC)



General Description
These indicators explore the Customer Overdue and Outstanding through monthly trend and 12M Rolling chart. There is a bar displaying the overdue aging and accrued overdue by customers. As for the overdue risks, it is now showing the risks classes according to GBU's customers as defined.
Overdues are filtered on the GL Accounts Sub Type "Products & Services"



KPI Name
Calculation
Outstanding (KCURR)
Sum of open documents in the customer's account as at the report date
Overdue (KCURR)
Overdue EOM (KCURR) => in My Table
Amount of outstanding due and not yet paid at the date of report.
In a monthly report, the overdue amount at the end of the month (Overdue EOM) is the sum of amount with due date lower or equal to the last day of the month and not yet paid nor cleared by that date.
The Overdue EOM is available in the My Table sheet
%Overdue
Percentage of Overdue calculation:
Percentage of Overduem = Overduem / Outstandingm
Only GL Account sub-type = Product & Services is taken when calculating outstanding and overdue.
**Please noted that Credit Management team will still communicate official percentage overdue statistics for Solvay Group with the old calculation method. 


Interco Flag = YES Merging Date = #
Control  Credit Area = "SOLV"
Zone = PRS Customer Zone (this falls under the attribute list of PRS Customer)
Excluded:
Company Code <> ZUS4
PRS Customer <> 2200000000 CLIENTI
ERP GBU <> Eco Service
Image Removed
Source Information:
Core Query
BW_QRY_MVFIAR01_0001
QV Query:
QVSBS_BW_QRY_MVFIAR01_0001
Flat file
Non Core ERP Credit DATA for Composite Materials and Chemlogics
BW Filters:
GL Acct Type = RECEIVABLES
PRS Comp.
Merging Date = #
PRS Payer <> SPARROW SRL - 423344


Image Added
Previous obsolete exclusions:
Company Code <> ZUS4
ERP GBU <> Eco Service
PRS Comp.
Interco Flag = YES
PRS Cust. Interco Flag = No
Qlik Filters
  • GL account sub-type = Product and services
    => in the pages by default, to be added in the My report sheet
  • PRS Payers: 
    <> SIEMENS FINANCE & LEASING GMBH - 1039781
    <> 2200000000 CLIENTI - 410759
    <> Aleris rolled products - 1039381
  • Control  Credit Area = "SOLV"
Refresh Frequency:
The sheet is now refreshed several times a day.
Considering the refresh frequency of the BW queries and the CCT dashboard, it is pretty hard for them to be aligned.
See reload times below (Paris time)

BW
CCT dashboard
During Closing period
:
2 am
8 am
1:
30am,
30 pm
6 pm
10 pm
5:30 am
,
11:30 am
,
5 pm
,
9:30 pm
(Paris time):30am,
1:30 am
Out of Closing period
:
8 am
2 pm
10 pm
11:30 am
,
5:30 pm
(Paris time)
1: 30 am



Specific Dimensions
GL Account Sub Type
By default filtered on Product and Services. Please remind it when using My Table
Other values may be selected; Accruals & Revaluation, Advance Payment, Doubtful, Write Down
Payer Geo Zone
PRS Customer Zone
Mini Zone (Cust)
Mini Zone of the PRS Customer
Customer Country
Country of the PRS Customer
PRS Customer
 
 PRS Payer
Customer Group
Customer Group of the PRS Customer
Coll. Speci.
 
Sales Rep
 
Credit. Mgr.
 
**Missing Dimensions from SBS_OtC
If you do not find the same dimensions you used to see in SBS_OtC, please refer here for details.