Skip to Content
0
Jan 06, 2011 at 09:04 AM

How to calculate Receivables aging for not overdue

61 Views

Hi to all,

I have created query to calculate Receivables aging using 0FI_AR_4 and there are bucket for aging

bucket example:

1-10 11-30 >90 Not overdue

for 1-10 and 11-30 bucket i have used selection and inside selection i have resticed 0CREDIT_LC with 0NETDUEDATE, and 0NETDUEDATE resrticted with 0P_KEYDT variable and set variable range on 0P_KEYDT OFFSET -1 to -11 and -30 to -11.

for >90 bucket i have used selection and inside selection i have resticed 0CREDIT_LC with 0NETDUEDATE, and 0NETDUEDATE resrticted with 0P_KEYDT variable and set variable range GREATER THAN 0P_KEYDT and offset -90.

for Not overdue bucket i have used selection and inside selection i have resticed 0CREDIT_LC with 0NETDUEDATE, and 0NETDUEDATE resrticted with 0P_KEYDT variable and set variable range GREATER THAN 0P_KEYDT .

when i run the query i cant find any value in Not overdue bucket.

i that the right way to calculate Not overdue and 1-10 and 11-30.

Can any one provide me solution.

I shall be thankful to you for this .

Regards

Pavneet Rana

Edited by: pavneet rana on Jan 6, 2011 10:41 AM