Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Sage Line 50 version 16 speed issues

Posted on 2011-03-17
6
1,377 Views
Last Modified: 2012-06-21
We have a number of speed issues with our sage installation. We are running version 16.0.4.113
On the server machine (windows 7 pro) we have the following issue
Producing the e-mail statement amongst others is taking a painful length of time. This is true if we choose to e-mail the statement or select File which saves as PDF.

I have tried disabling the anti-virus but that had minimal effect. (Avast Free)
As an additional, is it possible to make sage e-mail a pdf copy of a statement rather produce an html file?

For the network computers (7 pro), we have the same issue, although the process of producing statements and invoices takes a long time where as on the server machine there is no delay doing this. Also the network computers can not print a report directly, they must first Preview and then print, the server however can choose to print directly.

Thanks
0
Comment
Question by:pcc_tech
  • 5
6 Comments
 
LVL 10

Accepted Solution

by:
Bruce Denney earned 500 total points
ID: 35166485
V2010 introduced a lot of extra speed issues.

One of the biggest is the additional of multiple addresses for each customer,  This make a lot of reports (including layouts for emails) even more slow.

You can make these go faster by deleting the links to the un-needed tables, I would need to see your layout to see if this is the case.  

The report can be sent as a PDF attached to an email, it is all in email settings.
see http://www.makingithappen.co.uk/guides/emailreports.htm for more details

How many customer records have you got?

Can you post the email layout?

0
 
LVL 10

Expert Comment

by:Bruce Denney
ID: 35166545
You should install all the update for your version  
http://www.sage.co.uk/accountsupdates/

The current build is 16.0.17.0158

What happens on the work station to prevent them from printing directly to the printer, is the option missing, does it crash.

I think that this really should have been posed as 3 questions not 1.

1/ Slow report generation
2/ How to do an email PDF
3/ Missing Print option on workstations

0
 
LVL 10

Expert Comment

by:Bruce Denney
ID: 35166576
Are these 32 bit or 64 bit versions of windows 7?
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 10

Expert Comment

by:Bruce Denney
ID: 35166592
Have you configured the exclusions for Avast ?

This guide also cover the report designer tweak that keeps it from having it's temporay files scanned by the AV/

http://www.makingithappen.co.uk/guides/sage_anti.htm
0
 

Author Closing Comment

by:pcc_tech
ID: 35930607
Sorry for delay on reply, we eventually reverted the reports back to an older version which did not ask for additional addresses. This sorted the problem.

Thanks very much.
0
 
LVL 10

Expert Comment

by:Bruce Denney
ID: 35932543
Note that some reports for earlier version no longer give the correct numbers!  

I found this with the Transactional TB/BalanceSheet/P&L  so be careful.

I would just move the reports I needed rather than the whole lot.
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A frequent question here in the MAS90 Zone is, How do you get data out of MAS90 for analysis, reporting or using the data on your web pages?   This is an introductory level tutorial to getting data out of MAS90 using ODBC. Data can be accessed by…
If you need to import sales transactions from another system into Microsoft Dynamics GP as Sales Order Invoices, you may need to store some additional data related to the customer, the transaction, or the line items.  Even if your company is manuall…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question