Topic Options
#60986 - 06/03/19 09:13 AM Open Payables List
Hugh Offline
Adagio Maven

Registered: 09/25/13
Posts: 182
Loc: Victoria, BC Canada
Hey, I'm running an Open Payable List and it creates a work file before presenting the report. I have a relatively powerful computer and a relatively small vendor list but it's currently taking in excess of 10 minutes to generate the report. Is anyone else having this issue?
Thanks!

Top
#60987 - 06/03/19 09:23 AM Re: Open Payables List [Re: Hugh]
Hugh Offline
Adagio Maven

Registered: 09/25/13
Posts: 182
Loc: Victoria, BC Canada
*update* over 20 minutes now... it's a 5 page report

Top
#60989 - 06/03/19 09:55 AM Re: Open Payables List [Re: Hugh]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10493
Loc: Canada
Are you running it for a date in the past? If so, it has to scan all your Payables history.

Does Task Manager show any activity in the application?
_________________________
Andrew Bates

Top
#60993 - 06/03/19 11:51 AM Re: Open Payables List [Re: Retired_Guy]
Hugh Offline
Adagio Maven

Registered: 09/25/13
Posts: 182
Loc: Victoria, BC Canada
Yes, a date in the past... this makes a wee bit of sense as I had checked some other time frames and it calculated quite quickly but as you mention this I think it slowed down when I started looking at prior dates.... but still, it's a struggle when it takes 20 minutes to get a historical report...

The application is using betwen 1.5 and 2% of the CPU and 29.5MB of memory... so nothing there... data is coming from the server at 2.2Mbps but I don't know if that's good or bad.

Top
#60994 - 06/03/19 12:37 PM Re: Open Payables List [Re: Hugh]
Douglas Dickie Offline
Adagio God

Registered: 06/02/99
Posts: 4322
Loc: Vancouver, BC
Hugh:

How much history do you have? The report should not be taking that much time.
_________________________
Douglas Dickie
AccSys Solutions Inc
Phone: 1.888.534.4344
ddickie@accsyssolutions.com

Top
#60996 - 06/03/19 01:29 PM Re: Open Payables List [Re: Douglas Dickie]
Hugh Offline
Adagio Maven

Registered: 09/25/13
Posts: 182
Loc: Victoria, BC Canada
all the history... why would I not want to keep history? I guess because it makes reports super slow?

Top
#61014 - 06/04/19 07:58 AM Re: Open Payables List [Re: Hugh]
Douglas Dickie Offline
Adagio God

Registered: 06/02/99
Posts: 4322
Loc: Vancouver, BC
Hugh

You have been using Adagio and ACCPAC Plus before that for what, 20 to 30 years now? AP history that old can’t possibly be that meaningful.
_________________________
Douglas Dickie
AccSys Solutions Inc
Phone: 1.888.534.4344
ddickie@accsyssolutions.com

Top
#61072 - 06/06/19 08:35 AM Re: Open Payables List [Re: Douglas Dickie]
Hugh Offline
Adagio Maven

Registered: 09/25/13
Posts: 182
Loc: Victoria, BC Canada
true... maybe I'll try and get rid of a few years, although you'd be surprised how often someone comes to me and says what did we pay for those widgets? I think we bought the last batch about 5 years ago...

Top
#61074 - 06/06/19 10:51 AM Re: Open Payables List [Re: Hugh]
Douglas Dickie Offline
Adagio God

Registered: 06/02/99
Posts: 4322
Loc: Vancouver, BC
Hugh

That’s why you keep copies of your database at the end of every year, so that you can check the odd question about an old ( purged from history) transaction.
_________________________
Douglas Dickie
AccSys Solutions Inc
Phone: 1.888.534.4344
ddickie@accsyssolutions.com

Top
#61157 - 06/13/19 04:04 PM Re: Open Payables List [Re: Douglas Dickie]
Hugh Offline
Adagio Maven

Registered: 09/25/13
Posts: 182
Loc: Victoria, BC Canada
Douglas,
This totally makes sense. Thank you!

Top


Moderator:  Softrak Support 
Who's Online
2 registered (Softrak Support, Patricia B.), 36 Guests and 1 Spider online.
Key: Admin, Global Mod, Mod
Forum Stats
1847 Members
5 Forums
14235 Topics
69703 Posts

Max Online: 359 @ 11/18/19 09:08 PM
April
Su M Tu W Th F Sa
1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30