Process Owner
Aurelie Mazerot
Process Expert
D&PS Expert
TBC
General Description |
|---|
This indicator explore the Customer Overdue and Outstanding through monthly trend or 12M Rolling chart and table in addition to calculate the percentage of Overdue and correlates them to the DSO. |
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