ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Suggestions for Updates >> Average Days To Pay Query
http://www.istechforum.com/YaBB.pl?num=1121785203

Message started by JNAPIER on 07/19/05 at 07:00:03

Title: Average Days To Pay Query
Post by JNAPIER on 07/19/05 at 07:00:03

It would be cool to have the option to look at a specific period to determine ADP for a customer. I have some Cust that have 1000's of paid inv. I would like to see if their is a trend in payment.

John

Title: Re: Average Days To Pay Query
Post by David Waldmann on 07/19/05 at 08:15:30

Not only that, but it would be great if it worked better. I once was told how it's figured out (something like 25% weight on the most recent paid, and diminishing by half on each previous invoice) but I have some customers where I know it's way off.

For instance, I have one customer who almost always takes the 10 day discount, and aways pays within 20 days (at least for the last couple of years), and it shows 54 days. Another has been paying in 45-60 for the last several months and it shows 26 days.