Hi,

I'm trying to build a GridView that will show me the average days to pay for our customers.

The field I'm looking for is in the Statistics Tab of the customer record in Receivables. I found the Last Year Average days to pay field but I cannot find the one for the current data.

I was looking in the customer Master table, should I be looking else where?

Thanks
Yann

Hi Yann,

This field is actually a calculated value - from the 'Total Days to Pay' and the 'Total Invs Paid' fields - which is why you cannot see a particalar field called 'Avg days to pay'. This number is not directly stored in the data.

You will need to create a calculated column that does the same calculation:
IF( {Total Invs Paid}<>0 , {Total Days to Pay}/{Total Invs Paid} , 0 )

Hi Yann

Please look at this thread for my opinion about the average days to pay calculation in Adagio -

http://www.softrak.com/ubbthreads/ubbthreads.php?ubb=showflat&Number=23277#Post23277

Steve

Thanks to both of you.

I had read Steve's thread before posting this new one.

Thanks
Yann

Could anyone explain why I would have some average days to pay of 65,535, 32,766, 16,383 ???
These numbers are found in my Calculated Columns as well as the the one that is stored in the database for the last year.

Thanks
Yann

What values do you have for Total Days to Pay and also Total Invoices Paid for your customers? Put these fields onto your View (at least temporarily) to explain why your calculated Average is what it is.

The numbers you posted make it seem to me that a number has maxed out at 65,535 - this is often a maximum integer. The Total Days to Pay is an accumulating field, and every time an invoice is paid, the difference in days between the invoice date and the payment date is added to this value. I suppose if there is a maximum number, it could be reached for very high volume customers.

In general, I agree with Steve's comment that this field is not really of good use. Statistically, there are definitely better ways of dealing with this information, especially for the Last Year value.

If you want more accurate numbers and are using the latest GridView version 9.0C, you could potentially calculate the Days to Pay directly and in the way you require by creating an Inquiry on the Transaction Matching file. This stores the invoices and the dates that they were paid. Then use the new formulas to GetLinkedValue and bring those values into the Customer view. This will likely be very complicated (as the Invoice date is not stored in the Matching file, just the Payment date), so if you choose to attempt this, be aware that you will need to combine the 'Customer + Transactions' composite table along with the Matching file, and this is not a simple workspace to create and requires more sophisticated GridView knowledge.

I pulled my TOTAL INVS PAID and my TOTAL DAYS TO PAY onto the grid view and discovered that the total invoices paid for the customers that were in the 65000, 32000 or 16000 days, were either 1 or 2 invoices.

Their respective Total Days to Pay were 65,535 or 16,766 or 32,767.
not sure where these values are coming from...