Ageing analysis in ISU

[former_member344586]

Hi ,

  I need to display the report in the below format in report :

  Customer

  180 Days

  180 Days

  150 Days

   120 Days

  90 Days

  60 Days

30 Days

Current

  Balance

  I have got the document date in the extract.

could you please let me know how to design this logic.

[Former Member · Accepted solution]

Hi Raju,

you can create a Restricted key figure / Selection to achieve the buckets (days)

Restricted key figure -- drag and drop key figure (ex: total) ->then document date, now restrict the document date with variable range using offset values . you can use the standard variable 0DAT (current date) when applying offsets.

ex: 0Dat-30 to 0dat . this give the the value of last 30 days. similarly you can apply it for other days.

[former_member344586]

Hi Guys,

I was able to deliver this , but customer changed requirement.

Now customer want to see the report on the date , which they enter and not on current date.

For current date I implemented the logic in DSO for each record and displayed in query by using restricted key figures.

Current scenario : user enter the date value and we should calculate ageing from there.

  for eg. user inputs end of august and report should show ageing based o that date.

so logic is document date - to date.  This has changed the logic , now I cant calculate the ageing at DSO leve l as I dont know what date user will input.

Can somebody help with the new logic.

I am just worried all abap code will go away and all will be handled in query.

Kindly suggest some logic if possible.

Thanks !

[KodandaPani_KV]

Hi,

it was easy to do at BEx designer.

you can create the calcualated key figure below like this.

> 30 days, 30 =<60 days,

use the document date as the objet.