Ageing from any specified date

[former_member344586]

Hi Guys,

we delivered ageing with current date , 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 !

[karthik_vasudevan · Accepted solution]

Hi Raju

It is simple in query designer than in transformation level. Just create a manual input variable for your document date and let the user input the date in this.

Create an RKF with your keyfigure and document date. Offset the document date with the variable - 30, variable - 60 and so on.

Hope this helps. Revert if you have any issues.

Regards

Karthik

[former_member344586 · Accepted solution]

Thanks Karthik for reply , I am applying logic will let you know if I face any problem.

[former_member186399 · Accepted solution]

Hello Raju,

Please go through the below link to have an idea on ageing for any given date.

http://scn.sap.com/community/data-warehousing/bw/blog/2014/02/01/accounts-receivables--a-walk-throug...

http://scn.sap.com/community/data-warehousing/bw/blog/2014/03/16/accounts-receivables-a-walk-through...

Regards

Gajesh

[former_member344586 · Accepted solution]

Hi Guys ,

I am able to apply the ageing logic and it calculates well.

This is for the "To Date" entered by user.

I also need to apply another filter on clearing date as follow :

Clearing date > to date

could you please suggest where should I apply this.

As the to date is variable I dont see this in the conditions. so unable to apply on the date entered by user.

Kindly suggest if possible.

Thanks !