cancel
Showing results for 
Search instead for 
Did you mean: 

calculation of days of delay in query

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

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

Former Member
0 Kudos

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

former_member186399
Active Contributor
0 Kudos

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.


Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Sakthi

But as I do if the reference date is a variable and not a date as such, what happens is that the variable reference date is applied to the posting date, then  i don't know theat to put how Posting date.

Best regards.

Nando.

former_member186399
Active Contributor
0 Kudos

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


Former Member
0 Kudos

Hi Gajesh

So is, i want no of delayed days against each of the AR line item, 

Best regards.

Nando.