Process Owner
Aurelie Mazerot
Process Expert
D&PS Expert
TBC
General Description |
|---|
A monthly trend on DSO (Days of Sales Outstanding), Best DSO, comparing with Target in terms of number of days. It also provides the differences on number of days between DSO and best DSO which is known as late/delayed DSO. The calculation of DSO is using back-track method. In the DSO calculation, Solvay Energy Services is being excluded, but it is included in both Overdue and Outstanding (if any).There is also results of DSO, Best DSO between GBUs and also the Group of Activity within individual GBU. Monthly (during closure on 1st to 6th 3 times per day) |
KPI Name | Calculation |
DSO | Evaluation in terms of Days of Sales Outstanding at the report date. It is a measurement of efficiency on how quickly receivables are collected. It shows the age in term of days of an organization's accounts receivable and the average time it takes to turn receivables into cash. The calculations are as follow:
|
Best DSO | Number of days of up to previous month (M-1) |
Delay DSO | = DSO - Best DSO |
Attention
On My Report, DSO KPI comes with TOTAL. Note the TOTAL calculation is made based on the formula described above.
Ex:
Source Information: | |
Core Query: | BW_QRY_MVFIAR01_0001 |
QV Query: | QVSBS_BW_QRY_MVFIAR01_0001 |
BW Filters: |
|
| 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