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/OutstandingDSO (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. Overdue value but ONLY for current month. |
Sources | Orderbook |
|---|---|
Core query | ITC Credit Management Workbook (BW) |
QV query | QVSBS_BW_QRY_MVFIAR01_0001QVSBS_BW_QRY_MVFIAR01_0006 |
Refresh frequency | Daily |
Filters | GL Account Subtype Products and Services Only |
Scope |
|---|
|
Not able to find the solution? Contact SBS Support.
Page
viewed times