Hi Dawn

Do not trust the statistic. It is misleading for a number of reasons.

* It doesn't use weighted averages. So if a customer bought twice, paying a $10 invoice right away, and a $10,000 invoice in 90 days, the average days-to-pay will be 45 days.

* When you perform year end processing, it takes the existing days-to-pay statistic, and counts it as one sale. So there might have been 100 sales in 2005 averaging 60 days-to-pay, and one sale in 2006 which was paid in 20 days. If year end processing was done at the end of 2005, the average days-to-pay will be 40.

* An invoice which is NEVER paid is not factored into the statistic - now isn't that misleading!

If you want a more accurate calculation, it needs to be done using Crystal Reports and historical transactions.

Steve Schwartz