Versions Compared

Key

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


Image RemovedImage Added


Info
iconfalse
titleReporting CoordinatorOwner - Process Expert
Aurélie Mazerot


Info
iconfalse
titleIS Reporting Coordinator
Charlotte Rollier
Diogo Paiva
 IS OtC Reporting Coordinator


Info
iconfalse
titleD&PS Expert
Miriam Luttrin
EMEA: Stéphane Bourgeaud-lignot
NAM/LAM: Karina Tsuji
APAC: Lilian Cheong



General Description

The Overdue and DSO section gives valuable information about how customers are paying and behaving. This data comes from the FIAR perimeter and the source of the data is Business Warehouse (see below for more info).
This section is divided into two parts: Current and Historical.

Definitions of:

Outstanding = Sum of open documents in the customer's account (invoices) at the report date.
Overdue = 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 amounts with due date lower or equal to the last day of the month and not yet paid nor cleared by that date.
Percentage of Overdue = Overdue/Outstanding
DSO (Days Sales Outstanding) = Evaluation in term of days of sales of the outstanding amount at the report date. It is a measure 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. Method of calculation used is back-track DSO.
EOM Overdue = End of Month Overdue.
The sum of overdue values due within the month selected. (Estimated amount of overdue
Overdue value but ONLY for current month
)
.


Sources

Orderbook

Core query
ITC Credit Management Workbook (BW)
QV query
QVSBS_BW_QRY_MVFIAR01_0001

QVSBS_BW_QRY_MVFIAR01_0006
Refresh frequency
Daily
Filters
GL Account Subtype Products and Services Only


Scope

  • Overdue, DSO, Aged Overdue