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. |
KPI Name | Calculation |
Outstanding (KCURR) | Sum of open documents in the customer's account as at the report date |
Overdue (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 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. |
%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 = # To be excludedPRS Customer <> 2200000000 CLIENTI |
Refresh Frequency: | Monthly (after D4 closing) |
| 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. | |
Not able to find the solution? Contact SBS Support.
Page
viewed times