ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Suggestions for Updates >> AR Summary Reports - Feedback please!
http://www.istechforum.com/YaBB.pl?num=1066696104

Message started by Lynn_Pantic on 10/20/03 at 16:28:24

Title: AR Summary Reports - Feedback please!
Post by Lynn_Pantic on 10/20/03 at 16:28:24

I have had a couple of requests for some AR reports including things like average open invoice amount, average days to pay, open amount as of 30/60/90 days ago, etc. Data exists to generate all this information, my question is, what is the most universally useful for cash flow projections, establishing customer credit limits and terms, etc. Feedback requested! What do you (as users) want? ???

Title: Re: AR Summary Reports - Feedback please!
Post by Dick on 11/05/03 at 09:52:27

Key for me is a history of days-past-date paid (date of check, days-past-date of invoice(s) paid, and $ amount).

What I do now is to put the days-past-date in the AR-C Check No. field (I can always get that from the paper stub if I need it -- never have), like "32"; if it's a range over several invoices, I put in the low and the high, like
"3246". I come up with that before, by reference to the Aging, so I have it for AR-C.
Then I scan the "check No." AR-R to see how someone's paying.
Average would be good, but only if you can set the date range and show $'s.

The other datum I need to do some poking around for to come up with is a Credit Reference Request for a customer's "Recent High Credit", but that's lower priority and doesn't look too easy to do.

Thanks for asking.

Title: Re: AR Summary Reports - Feedback please!
Post by Karen Mason on 11/15/03 at 05:55:49

Avg. days to pay would be very helpful. Be nice if it came up on the AR listing AR-F. Currently I look at AR-R, estimate the average and hand write it each time I generate the list for planning cash for a specific period.

The rest would be helpful as an overall tool.

Title: Re: AR Summary Reports - Feedback please!
Post by Lynn_Pantic on 11/15/03 at 08:19:32

Which prompts the next question - define "Average days to pay" - Average since the beginning of time or only the past X months to reflect current conditions? And should it be somehow weighted by $ amount so big invoices carry more weight?

Current calculation for the AR-A value takes the current value averaged with the payment entered regardless of the $ amount so 50% weight goes to the most recent payment, 25% next prior, 12.5% next prior, etc so it is extremely skewed to the most revent payment(s)

Title: Re: AR Summary Reports - Feedback please!
Post by Karen Mason on 11/17/03 at 05:32:41

Well, since you asked, how about both? One could be based on generally accepted financial reporting, the other "current" as it is currently figured in AR-A.