Cash & Risks

General Description
This indicator explore the Overdue and Outstading through trend monthly or 12M Rolling chart and table in addition to calculate the % of Overdue and correlates them to the DSO. Indicator details results can be analyzed by : GBU Group of Activity Legal Entity Payer Geographical Zone GL Acc Sub Type Legal Entities Refresh Frequency: Monthly (after D4 closing)

KPI Name	Calculation
Outstanding (KCURR)	Sum of open documents in the customer's account 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 amounts 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 - Overdue/Outstanding: It is by default filtered by GL Account sub-type Product & Services. **Please noted that Credit Management term 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:	Company Code <> ZUS4 GL Acct Type = RECEIVABLES PRS Comp. Interco Flag = YES PRS Comp. Merging Date = # PRS Customer <> 2200000000 CLIENTI PRS Cust. Interco Flag = No ERP GBU <> Eco Service Control Credit Area = "SOLV"

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.

Page tree

Cash & Risks

Aurelie MazerotProcess Expert

Miriam Luttrin

General Description

This indicator explore the Overdue and Outstading through trend monthly or 12M Rolling chart and table in addition to calculate the % of Overdue and correlates them to the DSO.

Indicator details results can be analyzed by :

GBUGroup of ActivityLegal EntityPayer Geographical ZoneGL Acc Sub TypeLegal Entities

Refresh Frequency:

Monthly (after D4 closing)

KPI Name

Calculation

Outstanding (KCURR)

Sum of open documents in the customer's account 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 amounts 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 - Overdue/Outstanding:

It is by default filtered by GL Account sub-type Product & Services.

**Please noted that Credit Management term 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:

Company Code <> ZUS4

GL Acct Type = RECEIVABLES

PRS Comp. Interco Flag = YES

PRS Comp. Merging Date = #

PRS Customer <> 2200000000 CLIENTI

PRS Cust. Interco Flag = No

ERP GBU <> Eco Service

Control Credit Area = "SOLV"

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.

Aurelie Mazerot
Process Expert

GBU
Group of Activity
Legal Entity
Payer Geographical Zone
GL Acc Sub Type
Legal Entities