Thanks for all for you comments and feedback for my first post Accounts Receivables-A Walk Through Part1.
Now having explained the functional aspect of AR in my last blog, I would like to detail on the FI-AR Data source and some of the important fields in the AR data source.
The key characteristics (other than the org structure characters) that should be available in your data target for AR reporting are
AR Reporting
AR is always reported as on date. Let us go through the some of the cases which can make your understanding clear.
Case 1. For a customer C1 an AR document was created on 01.01.2013 for 1000 Currency.
So if you run the report.
As on 31.01.2013 the AR value for C1 should be 1000
Case2 . On 25.02.2013 another AR document was created for an amount of 500 Currency for C1.
So if you run
As on 31.01.2013 the AR value for C1 should be 1000
As on 28.02.2013 the AR value for C1 should be 1500 (1000+500)
Case 3 . On 15.03.2013 an amount 1000 was cleared against the receivables of Customer C1
So if you run
As on 31.01.2013 the AR value for C1 should be 1000
As on 28.02.2013 the AR value for C1 should be 1500
As on 30.03.2013 the AR value for C1 should be 500 (1500 -1000)
Now below will be sample of the data that will be available in the cube after the above 3 transactions.
Accounting Document | Item | Customer | Posting Date | Invoice Reference | Clearing Date | Status | Amount |
A1 | 1 | C1 | 01.01.2013 | O (open) | 1000 | ||
A2 | 1 | C1 | 25.02.2013 | O (open) | 500 | ||
A1 | 1 | C1 | 01.01.2013 | O (open) | -1000 | ||
B1 | 1 | C1 | 01.01.2013 | A1 | 15.03.2013 | C (Cleared ) | 1000 |
Now the question would be how to do this in the bex to get the report as stated in Case 3.
In Bex you will have to define two selections and add them to get the balances as of any given date.
1. Selection1 ( To get the Open Receivable ) = Amount key figure + <= Posting Date (variable which is input ready ) + Open status (Status with ‘O’ only)
+
2. Selection 2 ( To get the cleared Receivables) = Amount Key figure + <= Posting date (Same variables used in selection 1) + > Clearing Date (Customer Exit variable to read from Posting Date variable )
So in the Case 1 .
As on 31.01.2013 the AR value for C1 should be 1000
Selection 1 = 0
Selection 2 = 1000
Total Balance = 1000
Case 2
As on 28.02.2013 the AR value for C1 should be 1500 (1000+500)
Selection 1 = 500
Selection 2 = 1000
Total Balance = 1500
Case 3 .
As on 30.03.2013 the AR value for C1 should be 500 (1500 -1000)
Selection 1 = 500
Selection 2 = 0
Total Balance = 500
In the next blog I would to try to highlight on AR Ageing bucket Analysis and some of the Dashboard Analysis that can be done on AR.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
37 | |
10 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 | |
3 | |
3 |