I am trying to create a report in Gridview 9.0C and would like to include the Average Days to Pay - I found LY Avg Days to pay but not the current Avg Days to Pay on the AR Customer Master w TB - Could you tell me where to find the current Avg Days to Pay

Sorry, that figure is calculated by Receivables before it is displayed (and there have been several discussions about it's accuracy over the years). SalesAnalysis records the date of the invoice and the date of the payment in one place. You can find the number of days by subtracting the two dates.

Otherwise, the computation is going to get complex and messy (in fact I'm not sure it can be done in GridView and Receivables).

Here is a link to a prior discussion - http://www.softrak.com/ubbthreads/ubbthreads.php?ubb=showflat&Number=23277#Post23277

Steve

Not to hijack the thread, but I'd be interested in all suggestions about how "average days to pay" should be calculated. Should the amount of the invoice play a role? should all invoices be included? What about partially paid invoices?

Hi Andrew

I think the amount should be calculated on the fly, based on a date range selected by the user - the date represents the date an invoice was fully paid, not the invoice date. It should also be weighted, based on the invoice amount.

Here's how I do it - I multiple the number of days it takes to pay an invoice (date paid minus invoice date) times the dollar amount of the invoice, for each invoice whose paid date falls within the range. Then I add up the results for each invoice into one grand total. Then I divide the grand total by the total dollar amount of all of the invoices paid. That's the weighted average days-to-pay.

An example - a $100 invoice was paid in 10 days, and a $1,000 invoice was paid in 20 days. $100 * 10 = 1,000 plus $1,000 * 20 = 20,000 - the grand total is 21,000. Divided by $1,100, the days-to-pay is 19.1 (not 15 days which would be the answer ignoring the invoice value)

Steve