{toc:maxLevel=3}
This KPI shows 3 numbers:
The evolution graphic shows 2 indicators:
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.
The detail table simply shows the indicators by period.
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.
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" |
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.
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
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 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.
BW - 12 Month Rolling Aged Balance (Core Query) BW_QRY_CUB_FIAR1_0007