Summary description

This KPI shows 3 numbers:

The open Account Receivables: the amount due by the customers.
The overdues : the amount overdue by the customers
The % of overdues: the percentages of the open account receivables which are overdue.

Detailed description

Displays

Evolution Graphic

Syensqo IS - Customer Support > Attachment Library > Documentation Detaillee - Overdues v2 - Completed_html_mdd2f38e.png

The evolution graphic shows 2 indicators:

Bar : The amount of overdues in EUR
Line: The percentage of Overdues on the total Open Account Receivables.

Overall Graphic

The overall graphic shows the percentage of Overdues on the total Open AR for the full current selection. The difference with the evolution graphic is that this overall graphic takes the full selected period into account.

Detail Table

Syensqo IS - Customer Support > Attachment Library > Documentation Detaillee - Overdues v2 - Completed_html_74371a57.png

The detail table simply shows the indicators by period.

Time dimension

The time dimension is the date of the Account Receivables snapshot. The AR and Overdues shown for each period are the values at the end of each period.

By default the display is by month, but it can be changed to Quarter or Year.

Note that the value for the quarter or year will be the value of the last month of that quarter/year (not the sum, or the average of all the months).
Ex: January AR will be the AR as of 31th January at 23h59. 2013 AR will be the AR as of 31 December 2013 at 23h59.

Other dimensions

Legal Entity	Invoicing Company
Ship to KA	The "Ship to KA" is actually based on the Customer Group
Ship to	The customer from the invoice- NOT THE ACTUAL SHIP TO
Product	Product sold
Country	Country of the invoiced customer (not the Ship to, not the legal entity)
IECRA	Market of the invoice (Catalysis etc…)
Zone	Zone of legal entity (NOT the ship to)
Mat. Ent. Grp	Classification of materials in "Material Enterprise Groups"
Mat. Ent. GrpSub	Classification of materials in "Material Enterprise Sub Groups"

Filters

Only Account Receivables for the Rare Earth GBU are shown. This is determined by the IECRA of each invoice.

GBU = ZSECT00068 Rare Earth Systems

Only non-doubtful product sales are included. This is done by filtering on the below GL accounts:

41100100	AR-TP-TRADE-RECONCILIATION ACCOUNT
41100101	ZZZZ-AR-TP-TRADE -DISPUTED/DOUBTFUL DEBTS
41100200	AR-TP-TRADE-BILLS OF EXCHANGE
41100201	AR - THIRD PARTY BOE (SPEC G/L B) - Korea
41100210	ZZZZ-AR TP TRADE UNPAID BILLS OF EXCHANGE

Intercompany is excluded. This is done by filtering on the status of the trading partner :

Status of the trading partner <> 1 (SI Entity)

Only currently active legal companies are included. This means that if a company becomes obsolete, all the history will be removed.

Calculations

The open AR at end of month M is the sum of all invoices with open at that time (so posted in M or before and which were not cleared at that time):

Open AR M = Sum Invoices where:
Posting Date <= M
Clearing Date = Empty or >M
The Overdues at the end of month M is the sum of all the Open AR invoices for which the Net Due date was in M or before.

Overdues M = Sum Open AR where:
Net Due Date <= M
The percentage of overdues is the Overdues value divided by the Open AR.

Overdues M % = Overdues M / Open AR M

Conversion

The values are first extracted in the local currency (currency of the legal entity). Then a conversion is applied to convert all values into EUR.

Target

Target for the % of overdues can be shown or hidden using the “Show Target” flag.

Target is defined by the Dashboard Owner via an excel file.

Getting the detail

Detail can be obtained via the BW FIAR query below :

BW - 12 Month Rolling Aged Balance (Core Query) BW_QRY_CUB_FIAR1_0007

To run this report you first need to get access to the BW FIAR application, with all the necessary legal entities.
Once the report is run, make sure you apply the filters listed above (on GL account and on Status of the Trading Partner).
Note that there may be a slight difference in exchange rate.