Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

General Journal Screen taking too long to open

Status
Not open for further replies.
dgillz

dgillz

Instructor
Mar 2, 2001
10,043
US
ES 9.5 SQL Server 2000 sp4.

If we go to GL\Entries\General Journal, this screen takes 9-15 minutes just to open. This is with limited display options with the dates restricted to 08/01/08 thru 08/31/08 and unprocessed transactions only.

This has been going on a while and this is our first attempt to address this issue.

Has anyone seen this before and if so what did you do to increase the performance?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

"What version of URGENT!!! are you using?
 
Sort by date Sort by votes
These are known bugs in 9.5. Anytime you run any sort of GL report or process it takes forever to open. In the meantime your other users will notice a freeze or pauses when they are trying to do their own work in Macola.

I had to generate my own Aging Analysis report through access, since the one in Macola is useless due to the speed issue.

What's funny is they are doing a 'webinar' that is going to address the speed issues and what WE can do to make it faster.

They need to fix their GL problem already.
 
Upvote 0 Downvote
We actually fixed this by adding indexes to the tables that are used to open this screen. I am looking forward to this webinar.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

"What version of URGENT!!! are you using?
 
Upvote 0 Downvote
Is it possible that the check box to show "processed" was checked at one time? Then when the user goes back into the GL\Entries\General Journal screen it is loading ALL transaction in the general ledger (gbkmut). If you uncheck the box to show "processed", press the "refresh" button, close and then go back in see if that speeds up the screen load time.
 
Upvote 0 Downvote
ibeg,

Yes we looked at that, but good thinking.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

"What version of URGENT!!! are you using?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

prog_0927
  • Locked
  • Question
Journal Source SQL Table
Replies
9
Views
472
dgillz
dgillz
prog_0927
  • Locked
  • Question
Macola inventory Tag count Process How Many Days Open?? 2
Replies
2
Views
905
dgillz
dgillz
X
  • Locked
  • Question
Qty_to_ship default to 0
Replies
3
Views
2K
Xannidax
X
mjbasecamp
  • Locked
  • Question
Upgrade Progression 7.9.3 to SQL Server 2019?
Replies
0
Views
205
mjbasecamp
mjbasecamp
KOKRSIT
  • Locked
  • Question
Macola Progression 7.8.200 | Unable to open anything under AR > Trx > Cash Receipts 1
Replies
5
Views
198
KOKRSIT
KOKRSIT

Part and Inventory Search

Sponsor

Back
Top