Skip to Content
avatar image
Former Member

A/R Aging or Overdue Analysis in Calendar Months

Hi,

Considering the standard SAP Delivered 0FIAR_C03_Q0005 Query which is the Overdue analysis query based on Accounts Receivable cube, I have a custom requirement where the aging has to be done in calendar months compared to days as delivered in the business content.

I have been trying to do that but this where am stuck, the way SAP is calculating Aging buckets is by hard coding the columns (1 - 30 days, 31 - 60 days and so on) and my requirement requires to be Dynamic. Here is how the report should look like assuming we are in September -

Comp Code Acc Doc # Invoice # Sep'2010 Aug'2010 Jul'2010 Jun'2010..................

For my requirement I don't want to change the way SAP has proposed to calculate because that's the true way of calculating Aging but am not sure how I can achieve the months one.

Please provide your suggestions.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Sep 04, 2010 at 04:00 PM

    Assuming you have fixed number of Aging buckets you can use text variables of type customer exit(hence making it dynamic) to populate the description of these aging buckets.

    Hope this helps.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      I don't understand your requirement clearly.

      Whether an amount is overdue or not is decided based on dates. Due date and the open items at key date. Difference of these 2 dates gives us the no. of days by which the amount is overdue.In the standard SAP report if the difference is 25 days , the amount will appear under 0-30days bucket.

      What I mean to say is, the report shows the situation as on the key date entered by the user. Monthly report as such is not possible because in that case you don't define a date for which you can calculate the overdue period. However, if you can make different key figures based on month end date. and use the end date for each month to calculate whether an amount is overdue or not untill that date of the month.

      Best Wishes,

      Mayank

  • avatar image
    Former Member
    Sep 08, 2010 at 02:10 PM

    Hi

    As Manyak said, SAP standard report calculates over due based on Net Due date, Posting date ,clearing date and user entered key due date. So please find out your requirements on what basis you need to calculate monthly.

    Thanks

    Raghu

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      Due date i s Net due date , based on the posting date of that document and based on credit period it will be calculted at ECC it self

      key date is nothing but which date we are enetering in varaible screen.

      . it may be based on your postin date or may be clearing date.

      , But for your requiemnt it is just idea only , but i do not know how it fits with your requirement.

      really it is based on purely posting date

      posting can be assigned to calmomth.

      in calmonth . there is a cstomer exit varaiable Cmonth (current month )

      amount can be resticted with that -


      current month

      offse-1 -- previus month

      offset-2 -


      pre previoues month

      like that

      that same varaible you can use in text varaible also , it gives the month also

      if the users do not want to enter the data in varaible screen, by default it wil come.

      but the users wants to eneter write the customer exit code by i_step= 2 , take the use entry varibale value based on that calculation to be done.

      but mainely my conceren is the , the over due not based on psoting date it must be mainely with net due date .

      Thansk & regards,

      sathish