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) | 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. |
Source Information: | ||||||||||
Core Query | BW_QRY_MVFIAR01_0001 | |||||||||
QV Query: | QVSBS_BW_QRY_MVFIAR01_0001 | |||||||||
BW Filters: | PRS Comp. Merging Date = # Excluded:PRS Customer <> 2200000000 CLIENTI
| |||||||||
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)
| |||||||||
| Specific Dimensions | |
|---|---|
GL Account Sub Type | By default filtered on Product and Services. Please remind it when using My Table |
Payer Geo Zone | PRS Customer Zone |
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. | |
**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. |
Not able to find the solution? Contact SBS Support.
Page
viewed times