on 09-16-2014 9:01 PM
hi
I have a report of accounts receivable, which has portfolio ranges days past due, but now I want to calculate the days that are about to expire or has expired days, based on the expiration date, but have as input parameter in the report variable reference date is for infobjeto posting date, on that date the date reference income query query, and I think I have to take it into account for the calculation.
Someone who can help me with this calculation.
greetings
Nando.
Hi Nando,
In your accounts receivable, you have Posting date and expiration date and the user input is Posting date. So based on posting date, you need to calculate past due date.
About to expire date( fast due days)= Expiration date - Posting date.
Regards,
Bhas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
I applied the formula, placing the due date and the posting date , but put the input parameter as the reference date 31/07/2014 , it is assumed that the Posting Date field should put the date that I entered is 31/07/2014 and the calculation would subtract the due date - date reference for example I show in the first line would be 17/06/2014 - 31/07/2014 and that would give 45 days.
attachment
Best regards
Hello,
To get the delay days , you have to find the difference between the due date and the input date .
Create a formula variable with customer exit which will pick up the date from the posting date entered in the input parameter.
Find the difference between this formula variable and net due date to provide you the delay days.
Hi Herdando,
if I understand correctly:-
you have 2 dates.Posting date and expiration date and the user input is Posting date. So based on posting date, you need to calculate expired in days.
Is the days expired formula = Expiration date - Posting date ?
Regards,
Sakthi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Nando,
Do you want to calculate the ageing buckets of the overdue receivables line item in a predefined buckets (for 1 to 30 days, 30 to 60 days ) or you want no of delayed days against each of the AR line item ).
Regards
GN
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.