Accounts Receivables-Part 2

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.

1. 0FI_AR_3/4 data source works based on AIM delta process, which means it only brings the After Image. 
   Therefore the data has to first flow to a staging DSO and then to a Cube for the delta mechanism to work out.
2. It is always better to map the entire characteristic available in AR data source to data targets.

        The key characteristics (other than the org structure characters)  that should  be available in your data target for AR reporting are

1. Accounting Document (BELNR)
2. Item (BUZEI)
3. Document type
   (BLART)
4. Document status (BSTAT)
5. Clearing Date (AUGDT)
6. Posting Key (BSCHL)
7. Posting date (BUDAT)
8. Customer (KUNNR)
9. Net due date (NETDT)
10. Base Line date (ZFBDT)
1. 0FI_AR_3/4  data source doesn’t bring the statistical AR document (noted items) and you have to implement SAP Note 411758 – “Extracting noted item“ to bring in the same.
2. It is also better that you link the AR document to the sales document (VBELN) so that you can analyze the AR’s based on various sales attributes.
3. The AR Field REBZG (Number of the Invoice) is also an important field which keeps a track of the flow of the AR’s for a particular invoice.

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.

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