Schulz Consulting

Sage 100cloud Consulting

Eight Tips for Speeding Up Sage 100

by Leave a Comment

We’ve heard from some users that after upgrading Sage 100 to version 2020 that they’ve experienced slower performance.

Slow performance can be cause by many things ( see below for a list of the top 8 reasons your Sage 100 might be slow ).

In many instances the slowness of a new Sage 100 upgrade can be traced back to overly aggressive anti-virus or malware scanners causing interruptions in processing.

The suggestions below may ( or may not ) help speed up your Sage 100 system. Prior to calling support I recommend walking through each and seeing if they might apply to your particular installation.

  1. Change the default printer to another physical or network printer and then test/check the performance
    1. Sage 100 Advanced and Premium looks at the default printer on the server every time a task is launched.
    2. Sage 100 Standard edition checks the workstation’s default printer.
    3. Make sure all Network Printers are on-line
    4. If a Network Printer is off-line and no longer needed, remove it from Control Panel, Devices and Printers
  2. Check the path
    1. For Sage 100 Standard, Workstation Setup should be installed from a mapped drive letter path, such that the shortcut to launch Sage 100 also has the mapped drive letter path. The drive letter must be mapped to a directory above “MAS90”
    2. For Sage 100 Advanced or Premium, Workstation Setup should be installed from a UNC path, such that the shortcut to launch Sage 100 also has the UNC path. The UNC share point must be a directory above “MAS90”
  3. Check that the latest Sage Anti-Virus setting exclusions have been applied
  4. Consider temporarily disabling anti-virus and malware scans
    1. This is trickier than it should be – and may require uninstalling and rebooting the server
  5. Consider setting Sage 100 so that the shortcut always “runs as administrator”
  6. Check ping times for Advanced/Premium
    1. PING servername -l 1800 ( Note the -l is lowercase letter L ) 
    2. Anything over 40 ms is slow and may be cause for further investigation
  7. Turn off the Sage Product Enhancement Program
    1. Login to Sage as Administrator
    2. Select Sage Product Enhancement Program
    3. Deselect “Participate in the Program” by removing the checkmark
  8. Never run Sage over WiFi without use of RDP or Terminal Server/Citrix
    1. Customers may refer to this as “using a VPN” but the VPN does NOT act as a remote desktop
    2. Customers running solely over WIFI or the Internet with RDP will see most pronounced slowdowns in printing

All information was drawn from this Sage KB article – Slow performance when opening a new task or starting Sage 100, or when running Sage 100 across a network

Sage 100 data conversion for version 2020.1 takes a long time or appears to hang on IM_LotSerialTransactionHistory when it contains a large number of transactions.

by

If you are using Sage 100 with lot/serial valuation and the conversion time to Sage 100 v2020.1 seems extensive then you should download the latest patch from Sage which can significantly speed inventory conversion.

This fix is ONLY applicable for Inventory data conversions to Sage 100 version 2020 product update 1.

The reason for this is that the product update 1 release added functionality to enable lot serial number tracing when an item of that valuation was used in a Bill of Material production entry.

Inventory Management Functionality Added to Sage 100 v2020.1

  • Ability to Trace Item Use by Lot and Serial Number
  • A Where Used button has been added to the Lot/Serial Inquiry window accessed from the Main menu or from Item Maintenance
  • Additional changes have been made to the Lot/Serial Inquiry window accessed from the Main menu
  • The item code and description now appear on the main window instead of in the list box
  • If a lot or serial number has more than one item associated with it, the Item List window automatically opens so that you can select an item
  • The item code has also been removed from the Search for Lot/Serial Transactions window
  • The Zoom button has been renamed History Inquiry
  • When you click the OK button, the information displayed in the window is cleared, and you can select a different lot or serial number
  • Customer Recall Report has been added to the Reports menu, and it can be accessed from Lot/Serial Inquiry when the task is accessed from the Main menu
  • A Print Where-Used Items check box has been added to the Lot Serial Transaction History Report

Download Program Fix IM6000T for Sage 100 2020.1

Sage 100 Slow After Microsoft Windows Update? Try This

by

 

Several users of Sage 100 and Sage 100cloud have reported Sage100 slowdowns shortly after applying a Microsoft Windows system update. This doesn’t appear to impact all users which may be due to not everyone applying Windows updates at the same pace.

The issue has been reported by several users on the Sage City community beginning in June 2017 and described as:

Updated a few machines to 1703 and had some issues with Sage100 2016 being laggy. Windows would take 5-10 seconds to close or open. I then rolled back to the previous build and all was fine again.

Until recently the primary way many users dealt with this slowdown was to roll back the Windows update. Users report that there is a 10-day window within which to revert to the prior Windows version.

Now another potential solution has appeared and several users say this has helped to speed up their workstation running Sage 100 or Sage 100 cloud.

From the website Tenforums:

…here is how to fix it:

1, Hit start menu and type “Defender”, it should bring up “Windows Defender settings” entry, so open it.

2, Another juicy part – if you use another AV software, like for example in my case – ESET, then you would naturally assume everything Defender related is disabled, and you would be wrong. If you use Defender, you will be brought to the Windows Defender Security Center straight away, but if you don’t, you will end up on a Settings page saying that Windows Defender is not available because it’s turned off. Click “Turn on Windows Defender Antivirus” – don’t worry, your AV software will disable it again straight away.

3, Once you are in Windows Defender Security Center, Click App & browser control button

4, Scroll all the way down, to Exploit protection, and click Exploit protection settings text

5, Once on Exploit protection page, set Control flow guard (CFG) to OFF.

6, It will prompt you to restart your PC

7, After the restart, enjoy your smooth Windows experience again

 

Although this may not work in every case – it’s worth trying to see if you can bring an impacted workstation back to full speed. One user on the Sage City forum reports that the Spring Creators Update (due April 2018) may cure this slow speed issue without the need to perform the fix noted above.

Slow Sage 100? Try This First

by

Is your Sage 100 speed slower than you’d like? In many cases we have seen this issue after a system upgrade. Often the root cause is not Sage 100 itself (or the upgrade) but one of the following:

 

  • Check Anti-Virus: Exclude these files on both your server (Important Note: Some versions of anti-virus don’t let you exclude server scans and may require that you update your anti-virus to an enterprise or professional edition – check with your IT staff).
    • ..\MAS90\PVXWIN32.EXE
    • ..\MAS90\LAUNCH32.EXE
  • Exclude this folder on the server
    • ..\MAS90\*.*
  • Exclude these file extensions from scanning – both on the server and the workstation
    • DCL, DD, DDE, DDF, LIB, M4L, M4P, M4T, PRM, PVC, PVX, RPT, SOA, XEQ
  • Are you on a virtual server?
    • Allocate sufficient memory and processing cores
    • Whatever the present memory and cores allocated are – increase them temporarily and test performance
  • Adjust malware scanners to temporarily remove aggressive scanning within the ..\MAS90 folder
  • Check the Sage 100 Supported Platforms for your particular version of Sage 100 to ensure you have enough memory on both server and workstation

Slow Sage 100 Speed On VMWARE Virtual Server?

  • Install ‘VMWare Tools’ on Sage 100 Server
  • Reboot Server
  • Install ‘VMXNET 3’ virtual network adapter and make active adapter

NOTE: Consult Network Administrator to ensure changes will not affect other application running on Server.

Concerned About Network Speed Influencing Sage 100 Performance?

Try this free utility to measure the speed of your network. This will let you verify that a slow overall network is not to blame for the underlying speed problems with Sage 100.

lst_lite1

LAN Speed Test (Lite)

 

 

A Final Note About Sage 100 Upgrades And Changes In Speed

When you are upgrading to a different server or server location (which is almost always) be aware that the file exclusions for anti-virus scans for your old implementation of Sage 100 probably need to be redone with the new Sage 100 location in mind.

In some cases you’ll find that slower hardware or network interface cards (NIC) might be the culprit. In most cases we are finding Anti-virus and malware scanners are the cause. Check with your Sage partner for assistance on further diagnosing the issue or contact us for Sage 100 support.

10 Ways To Speed Up Sage 100

by

speeding_ticket

How Can I Speed Up Sage 100? What Causes Slowdowns?

One of the top questions  we receive about Sage 100 centers on speed. Typically, how to improve slow network performance on a Sage 100 system. Often the questions center around the amount of time  it takes to start Sage 100, the time it takes to  print forms or reports or the time that a posting routine will take to complete.

In most cases the speed of Sage 100 can be drastically improved simply by following a few easy tips. These are things that you can probably do yourself to get your system back in fighting shape.

Top 10 Tips To Improve Sage 100 Speed

 

  1. Check your anti-virus – Test your anti-virus settings by excluding all the files in your \MAS90 folder. Do this on both the server and workstation. During testing exclude ..\MAS90\Pvxwin32.exe and ..\MAS90\Launch32.exe as well as files with the extensions: DCL, DD, DDE, DDF, LIB, M4L, M4P, M4T, PRM, PVC, PVX, RPT, SOA. Once you narrow the problem down to a specific area, gradually increase the level of anti-virus scanning. Never run your system with anti-virus turned completely off.
  2. Check your malware scanning – Aggressive malware scanners – on both workstation and file server can be the source of slowness. Begin the diagnosis by excluding your \MAS90 folder from scanning.  As with anti-virus, you should not completely de-activate malware scanning. Once you determine the cause, be sure you gradually reactivate malware scanners.
  3. Trim data files – Large data files can slow the posting process. How large is large? Typically at sizes over 2  GB we hear from customers with slow speed concerns. Set data retention options in the setup menu of each module so that files are automatically purged at month and year end.
  4. Use Remote Desktop – If your office is home to a large number of Windows XP (ie – underpowered) computers and an upgrade is not on the horizon, think about using Remote Desktop to virtualize those workstations.  With Remote Desktop Connection, you can sit at a PC and connect to another PC in a different location (the remote PC). For example, you can sit at your home PC and connect to your work PC, and use all of your apps, files, and network resources as if you were sitting right in front of your work PC.
  5. Get Sage 100 Advanced or Premium – An upgrade from Sage 100 Standard to either Advanced or Premium is almost always guaranteed to boost speed. Don’t upgrade before ruling out the other sources of slow speed mentioned in this list. Those who upgrade are seldom disappointed in the additional performance boost. This upgrade seems to give the most noticeable speed boost to users with 15 or more simultaneous (concurrent) users within Sage 100.
  6. Use sub-reports – Crystal Reports which use complicated table linking can bog down like a car stuck in 4 feet of mud. One tried and true way to work around this is with the use of sub-reports inside of Crystal. They are not complex to create and the speed boost can be amazing. Additionally, if you’re using Sage 100 Advanced use the C/S (client server) ODBC driver.
  7. Double check links in your forms or reports – A good rule of thumb when designing Crystal Reports is to use the least number of table links possible. Often Crystal Reports will use a table wizard to create automatic joins (links) between different tables. Sometimes it is good at guessing at the links needed. Other times it will create many more table links than required – which can slow your reporting to a crawl. It’s worth taking a look at your table links on any Crystal Report which is running slowly.
  8. Upgrade servers – More memory. Faster hard drives. This may be the best way to boost performance and is especially advisable if you’re running other applications on the server or have over 15 users of Sage 100. One user on Sage City recommends Lan Speed Test (Lite) which measures the speed of your network connection.
  9. Upgrade workstations – Upgrading to the latest operating system with 8 GB or more of memory can help improve almost any application performance.
  10. Mirror data tables to SQL – One trick of the trade which can save lots of time over upgrading or purchasing new hardware is a software add-on called “SQL Mirroring”. This program constantly replicates your Sage native tables into a SQL database. From this SQL database you can generate forms and reports at significantly faster speeds.

 

Demonstration: DSD SQL Mirroring

 

 

 

Before Contacting Support: Use This Form To Gather Information On Your System

 

 

 

Contact Schulz Consulting

Please provide your contact information and a brief description of your question. We will reply within 2 business hours.
  • Please describe in detail any issue you are experiencing which you would like assistance with.
  • This field is for validation purposes and should be left unchanged.

Contact Us

Schulz Consulting
Connecticut Office
Phone: 860.657-8544
Email Us
Locally serving all of Connecticut, Massachusetts, Rhode Island, Vermont,
New York, New Jersey. Available remotely nationwide.
We are a local branch of DSD Business Systems Connecticut.