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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Slowness Printing Customer Statements

Status
Not open for further replies.
NEmacGuy

NEmacGuy

Instructor
Sep 1, 2004
421
US
At one site, since updating from microfocus to the Fujitsu cobol versions of Macola, the AR Statement printing slowed down dramatically. Wondering if anyone else has experienced the same issue ? We did check indexs, and run SQL traces, and did notice the same issue running Statements in Macola Electronics, but there are not enought customers to notice the issue in Electronis, but it does exhibit the same issue. We have 76,000 customer records. If you print customer AAA, it takes 5-10 minutes before it will print, but if you print ZZZ it prints right away. The SQL trace revealed that after AAA prints, the program continues to read thru every single customer to the end of the file. When you print ZZZ there are no more customer, and bang you have your Statement.
Just looking for Feedback.
Thanks
 
Sort by date Sort by votes
Wow thats a lot of statements. What version are they on now? What options are they selecting on the criteria to run the statements?

I have a customer database on my laptop with 11,000+ customers in the aropnfil_sql, and I am experiencing the same thing on 7.7.600.

You could use a crystal statement, which will be much faster.

Macola statements also update the aging buckets in the arcusfil_sql table, which is likely eating up a lot of time. How much data is in the aropnfil_sql in terms of purging AR open item records? I'll bet if you were aggressive with the purge it would help too.

None of this explains why it is taking longer with the new version. What has Exact said on this issue?

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:
 
Upvote 0 Downvote
I am actually seeing something very similar on my ES 9.5.300. Printing statements takes hours. I believe that there are other issues impacting the indexes on customer tables. I have not yet spent time doing traces etc.
Don, do your comments (arcusfil & aropnfil) apply to ES as well?
 
Upvote 0 Downvote
ES tables would be GBKMUT and BankTransaction. Which version and service pack of SQL are you on?
 
Upvote 0 Downvote
Last spring we upgraded to SQL 2005 (Version 9.00.5057.00) that is SP 4 with a few updates.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sans2174
  • Locked
  • Question
Setting up customers and vendors on a new company in Macola progression 7.8.200
Replies
2
Views
376
dgillz
dgillz
clnfIT
  • Locked
  • Question
Printing Issues in Macola - Page size keeps resetting
Replies
1
Views
187
clnfIT
clnfIT
SDPerkins
  • Locked
  • Question
EM10 - How to customize AR/Maintain Customers
Replies
4
Views
259
SDPerkins
SDPerkins
DrRich10
  • Locked
  • Question
Emailing customer statements 2
Replies
3
Views
270
DrRich10
DrRich10
kevvlol
  • Locked
  • Question
Which fields are updated during invoice printing?
Replies
2
Views
215
kevvlol
kevvlol

Part and Inventory Search

Sponsor

Back
Top