Welcome, Guest. Please Login.
11/01/24 at 17:27:23
News:
Home Help Search Login


Pages: 1
Send Topic Print
AR Summary Reports - Feedback please! (Read 549 times)
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
AR Summary Reports - Feedback please!
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?   ???
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Dick
Member
**




Posts: 71
Gender: male
Re: AR Summary Reports - Feedback please!
Reply #1 - 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.
 
Back to top
 
 

Dick Gardner
TECO Corp
dba Classic 2004.1 C/S + EVO
IS Tech Upgrade 3/28/08
  IP Logged
Karen Mason
Active Member
*****


Ain't life grand!?!

Posts: 728
Gender: female
Re: AR Summary Reports - Feedback please!
Reply #2 - 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.
Back to top
 
 

Karen Mason, Vice President
Bula Forge & Machine, Inc.
1-60# forgings, machining, & assembly
Cleveland, OH
Tel:216-252-7600 Fax:216-252-7601 www.bulaforge.com
EVO-ERP 09/16/09 SP2
Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: AR Summary Reports - Feedback please!
Reply #3 - 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)
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Karen Mason
Active Member
*****


Ain't life grand!?!

Posts: 728
Gender: female
Re: AR Summary Reports - Feedback please!
Reply #4 - 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.
Back to top
 
 

Karen Mason, Vice President
Bula Forge & Machine, Inc.
1-60# forgings, machining, & assembly
Cleveland, OH
Tel:216-252-7600 Fax:216-252-7601 www.bulaforge.com
EVO-ERP 09/16/09 SP2
Email WWW   IP Logged
Pages: 1
Send Topic Print