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