{toc:maxLevel=3}
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
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
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.
The best way to get IT support is to use the new
Service One Platform.