Skip to Content
0
Jan 04, 2011 at 04:55 AM

How to do aging in Receivables 0FI_AR_4

36 Views

Hi to all,

Can any one tell me the logic to calculate aging in Receivables?

Requirement is like that I have to create a query which has 7 buckets.

1 u2013 10 11 u2013 30 31 - 60 61 u2013 90 > 90 NotOverdue Overdue

And to calculate aging based on condition:

(SY-DATUM u2013 VBRK- FKDAT = number of days,

If number of days > 0NETDUEDATE (Due date for net payment) = Overdue

If number of days < 0NETDUEDATE (Due date for net payment) = notOverdue

I have created 2 DSO, from one DSO VBRK- FKDAT is coming and from other DSO for AR from where 0NETDUEDATE is coming.

Do I need to do logic in transformation from DSO TO CUBE via routine or formula?

Or do I need to do logic at Query level.

Also For rest bucket how i will find Receivables according to date range

or any thing else i need to do.

Please can any one suggest me the solution?

i will be great thankful to you.

Regards

Pavneet Rana

Edited by: pavneet rana on Jan 4, 2011 6:11 AM

Edited by: pavneet rana on Jan 4, 2011 8:42 AM