Schulz Consulting

Consulting and Upgrades

  • Home
  • Services
  • Contact

11 Things To Know Before Starting Your Sage 100 ERP 2013 Upgrade (Updated)

July 31, 2013 by Wayne Schulz

One of the most common misconceptions about ERP software upgrades is that you can simply take the upgrade disk, load the automated setup program and magically be upgraded to the latest version with minimal advance preparation.

 

While this may be true in some cases we’ve found that in almost all upgrades of Sage 100 ERP 2013 you will want to consider some critical items before you begin your upgrade. If any of them seem foreign to you or you’re not sure what they mean then it’s a good idea to contact your Sage Business Partner.

What’s New In Sage 100 ERP 2013?

Often users will ask “what’s new” in their upgrade. The answer to this question can be found at the following Sage Upgrade Guide PDF – http://goo.gl/bu0mi or online via http://services.sagesoftwareinc.com/mas/whatsnew/.

#1 Download new registration keys from Sage’s portal after having Sage validate them

Why:

1. Beginning in late 2013 all tax forms will require access to the included Sage e-Filing solution. Access to e-Filing requires that you have the latest registration codes with your current Sage account number.
2. The reason to have Sage validate them is that if the client has not had any changes to their account since Atlas (new Sage Portal containing a list of products owned by each customer and their registration keys) went live in 2012, the keys on the Portal may be old and not work.

How:

Access the Sage portal via http://na.sage.com/Log-On and navigate to your company information to obtain updated registration keys.

#2 Obtain a complete list of all third party enhancements – including Extended Solutions

Why:

If you are using v4.3 or earlier of Sage 100 ERP (formerly Sage ERP MAS90 or MAS200) and also have Extended Solutions installed then you’ll need to either insure those solutions were incorporated to Sage 100 ERP 2013 – or purchase the solution from a 3rd party developer.

Sage discontinued selling Extended Solutions after v4.30 and turned future development of some over to third party developers and incorporated others into the core product functionality of future Sage 100 ERP releases.  If you have questions on whether your Extended Solutions were incorporated check with your Sage Business Partner.

Same general concept for any third party programs (Example: Starship, EDI, Job Ops). These enhancements likely require upgraded versions to work with Sage 100 ERP 2013.

How:

Contact the software developer of your third party solution for advice on whether an upgrade is needed. For Extended Solutions you can contact your Sage Partner or a Sage Master Developer and inquire about whether the enhancement is available. Remember some Extended Solutions were added to the Sage 100 ERP core product so you could find that an Extended Solution you are using (example – Positive Pay) does not need to be upgraded because it is now part of the core program.

 

#3 Get Rid of Any UNUSED Third Party Enhancements or Modules BEFORE You Migrate Data

Why:

Midway through the migration process you’re going to be stopped and warned that conversion can’t proceed without the modules that existed previously. Therefore you should uninstall any module or add-on that is not actively being used.

How:

Two options to remove unused enhancements:

a) Uninstall the unused enhancements from your live company.

b) Perform upgrades from a copy of the live system, not the original. Uninstall the enhancements from the copy, not the live system. Many times, enhancements may not function as they previously did, and without access to the original installation, troubleshooting becomes extremely difficult.

#4 Determine if using integrated credit card processing or if currently storing credit card data in Sage 100.

Why:

Migration related to credit cards can be extremely lengthy, even if not using integrated credit card processing and only just storing credit card data in Sage 100.

How:

There’s a process/utility for determining how long the migration is expected to take. Otherwise it may be recommended to first get rid of all Sage 100 credit card data (i.e., reinitializing the applicable credit card related data files) – if it’s not truly needed to retain that data.

PS – Beginning with Sage 100 ERP 2013 the only integrated credit card processor supported is Sage Payment Solutions. The use of PC Charge is no longer supported by Sage which also means that you may be required to change processors. If this impacts you then stop your upgrade and talk about your options with your Sage partner.

#5 Disable Sage Advisor Update (SAU) Automatic Upgrading

Why:  

To prevent automatically installing an update or anything prematurely, especially if there’s modifications / enhancements installed.

How:  

Verify that the option within Sage Advisor regarding automatic updates is set to download only and NOT to download and apply.

UPDATE:  Sounds like you may just be able to uninstall SAU via Windows Control Panel, which also removes the SAU Service.  And it does not appear that SAU gets reinstalled/re-enabled upon installing a Product Update

#6 If You are installing to Windows 2008 R2 Server Remotely – Run Everything As Administrator (Right Click – Run as Administrator). Run Workstation Setups from Autorun.

Why:

There are some security features in Windows 2008 R2 which seem to require that Sage 100 ERP be run as administrator (provided you are on the server or remotely connected to the server via RDP, etc).
How:

You can also right click the Sage 100 ERP icon and select properties and compatibility and there’s a checkbox to automatically run as administrator.

Also you may need to turn off Data Execution Prevention (Start – Control Panel – System – Advanced – Performance – Settings – Data Execution Prevention) for Launch32.exe and/or Pvxwin32.exe. Use caution with system changes.

#7 Hyper-V Virtual Servers May Need Performance Tuning

Why:

For more information about Hyper-V see – Wikipedia . Some users have noted that their Sage 100 ERP systems run very slowly in a Hyper-V (virtual server) environment. This can also result in errors which may at first glance appear to be connectivity related.

How:

Configuration of Hyper-V allows an administrator to specify the number of processing cores to allocate. In many cases if only one core is specified then you may notice performance related issues. If you can allocate 4 cores these issues may resolve themselves.

#8 U25store.dll that implements this function is missing

Why:
Some upgrades to Sage 100 ERP 2013 will also involve custom Accounts Payable check forms. If you open the form and attempt a “Database – Verify Database” you may be greeted with the error “U25Store.dll that implements this function is missing”. This is because Sage and/or Crystal changed some functions. Running MASCRCW will NOT update function changes (only fields). Instead you must manually change the AP check form. Note that this should only be an issue with migrated custom Accounts Payable check forms.

How:
Replace the formulas in your custom Accounts Payable Check with these:

Main report:

Formula PrintGLVariable
Old value: formula = StoreStringVar(“PrintGL”,{@PrintGLDistribution})
New value: Shared PrintGL As String
PrintGl = {@PrintGLDistribution}
Formula = PrintGL

Subreport: (Note: This may come up multiple times as it appears several times on sub report)
Formula PrintGLDistribution
Old value: formula = FetchStringVar(“PrintGL”)
New value:
Shared GLPrint as String
Formula = GLPrint

The above formulas are copied/pasted from a generic Accounts Payable check (Standard).

#9 FRx Reports CAN be converted to Sage Intelligence.

Why:

The FRx conversion tool is not yet compatible with Sage 100 ERP 2013. There are three main options for those using FRX and needing to migrate:

Updated 8/13/13 via Debbie Hill at Sage – The FRx Conversion Utility has always been compatible with Sage 100 2013 and Sage 500 2013.  It is not available for Sage PFW nor Sage Business Works.  The conversion utility converts the Reporting Trees into the new Report Designer Add-In report format.  There’s a quick 8 minute video if you’re interested:

 

a. Sage Intelligence – single user license included with Sage 100 ERP – MS Excel based – good choice for users who want to access data other than pure GL in a spreadsheet. View Sage Intelligence FRX Conversion Guide (pdf)

b. BizNet – Similar to Sage Intelligence but offered by a third party

c. RenovoFYI – Offered by some ex-employees of FRX. Claim to convert about 90% of existing FRX report layouts for a fixed fee of about $800. Good choice for anyone using FRX and happy with no desire to create Excel based reports.

How:
Create Sage Intelligence reports using the Report Designer add on.

# 10 Install Sage 100 ERP 2013 from the server

Why:

Starting with Sage 100 ERP 2013 installation must happen at the server. This has to do with the installation routine and helps make future updates easier.

How:

Be careful because during installation the system might prompt you to install some Microsoft prerequisites. And those prerequisites may require a system reboot of which the only option displayed will be “Ok”. Often it is not convenient to reboot midday on an active server.

After you’ve installed you can click the Sage Advisor button in the task tray (lower right) to check for product updates. Upon approval you can automatically install the latest product update (PU).

# 11 Will Sage 100 ERP 2013 Run on XXXXX Operating System or Hardware?

Before installing the latest Sage 100 ERP upgrade many users will also be updating servers and workstations and possibly operating systems.

Invariably the question arises of which operating systems and servers/workstations are supported by Sage. Because this list is subject to change it’s always easiest to download the latest supported hardware and operating systems directly from the Sage Software site.

Why:
Sage only supports the operating system and hardware published periodically in a document referred to as the “Supported Platforms Matrix”. There is one document for each version (or ranges of versions) which contains the environments tested and certified by Sage as compatible with their ERP system.

How:

Click this link to view a page where you can select your version of Sage 100 ERP and view the supported platforms.

Sage 100 ERP Support Links

BONUS #12 – Prerequisites for Windows XP Workstations

If you are upgrading Sage 100 ERP 2013 or 2014 to Windows XP workstations be advised that these workstations must have SP3 loaded. Because this can take some time to install you may want to check the workstations several days before the date of your upgrade.

In addition all Windows XP workstations require these prerequisites:

  • .NET 3.5 (will reboot)
  • .NET 4.0 (will reboot)
  • Windows Installer 4.5 (will reboot)
  • C++ 2005 (no reboot required)
  • C++ 2010 (no reboot required)

 

Need Assistance With Your Sage 100 ERP Upgrade?

If you’re not comfortable installing the upgrade yourself we would be happy to provide you with a fixed price to assist. Our upgrade services all include:

a. Installing the latest update, patches, integrations
b. Working with you on testing the data conversion, forms conversion, integrations
c. Go live assistance
d. Post go live support

For more information please email – wayne@s-consult.com

Filed Under: Sage 100 ERP, slider Tagged With: extended solutions, mas200, sage 100, Sage 100 ERP, tips, tricks, upgrade

Year End Closing Tips for Sage 100 ERP (formerly MAS 90) – Special Newsletter

December 6, 2012 by Wayne Schulz

Our special year end newsletter for Sage 100 ERP (formerly known as MAS90 or MAS200) users is now available. In this issue we explore tips and tricks for closing every module – including the order in which they should be closed.

Are you following best practices by creating year-end archive companies? If not – we will show you how to use the built-in features that allow Sage 100 ERP to quickly create backup copies of your live data. These copies of data are especially helpful for anyone using the payroll module since you can refer back to the archived companies throughout the year as your employees request copies of W2 and other forms which they may have lost.

This issue also has information on the payroll tax updates and provides information about when and how to apply them to your system to meet new IRS and state tax guidelines.

Sage 100 ERP Year In Review – 2012 Closing Tips (PDF)

Filed Under: mas200, Sage 100 ERP, Sage 100 ERP Premium, Sage software Tagged With: Closing, faq, mas200, Sage 100 ERP, tips, year end

Sage Summit 2012 Tip: Battery Survival Kit

June 26, 2012 by Wayne Schulz

When you hit the Sage Summit 2012 conference floor in August 2012 you’ll probably be carrying either a smartphone and/or tablet. I use my iPad almost exclusively these days for note taking (Evernote) and my iPhone for capturing images.

The downfall to long days spend wandering the halls of conferences is that your battery power runs out long before the end of the day.

That’s why I have been travelling with a backup battery and dual split (micr0-usb and iPhone) adapter cord. Using this battery I’m able to get about three iPhone or one iPad recharge.

The battery is a little on the heavy side but the benefit is that during the conference my smartphone and iPad always have a full electronic charge and I’m not hunting for an electrical outlet by 2pm.

Here’s a link to the essential equipment via Amazon:

 

Battery – Energi to go

Dual Micro-USB and iPhone Charging Cord

 

For hard core iPhone users – check out the Mophie line of case/battery combos.

 

 

 

 

 

 

 

Filed Under: sage summit Tagged With: battery, sage summit, tips

How to manually purge Sage 100 ERP deferred print jobs

June 20, 2012 by Wayne Schulz

Version(s): 4.x

Problem / Description:

Is there a way to manually purge deferred print jobs?

Resolution:

How to manually remove deferred print jobs The way to correct this issue with the default printer is to go to do a complete purge from all files that contain the deferred print.

On the Sage MAS 90 or 200 File menu, click Deferred Printing.

  1. Select the print job.
  2. Click the Delete Report button to remove the job from the list.
  3. In Windows Explorer, browse to the ..\Mas90\Home\Deferred\ folder, and delete all of the .m4d files.
  4. Browse to the ..\Mas90\Home\Textout\ folder, and delete all of the dpxxx files (xxx = the print job number).
  5. Browse to the ..\Mas90\Soa\ folder and rename the Sy0def.soa file.
  6. Browse to the ..\Mas90\Mas_System\ folder, and rename the Sy_Deferred.m4t file.
  7. On the Sage MAS 90 or 200 File menu, click Deferred Printing. Verify that all deferred print jobs have been removed.

Date Created: June 19, 2012
Created By: Wayne Schulz
Source: Robert Wood/SC
Updated: June 19, 2012

Filed Under: Sage 100 ERP Tagged With: deferred, print, Sage 100 ERP, sage 200, tips

Year End 2011 Newsletter: Sage ERP MAS 90 and 200

November 17, 2011 by Wayne Schulz

We’ve just received our year end MAS 90 and MAS 200 newsletter – 2011 edition.

This issue covers a lot of ground  – including:

  • What’s new and what’s coming for Sage ERP MAS 90 and 200
  • Creating a new company in Sage ERP MAS 90
  • The importance of budgeting
  • Sage ERP MAS 90 and MAS 200 Module Closing sequence
  • Year end compliance issues (W2 , 1099, tax tables)
  • SQL Payroll for Sage ERP MAS 200 SQL customers
  • General module closing: Purchase Order , Sales Order
  • General module closing: Inventory Management, Payroll
  • General module closing: Accounts Receivable, Accounts Payable
  • General Module Closing: General Ledger
  • Tips to help your Sage ERP MAS 90 year end processing run smoothly
  • DSD Business Systems office locations

 

Whether you have been working with Sage ERP MAS 90 or MAS 200 as a novice or expert – there’s something for everyone in our year end newsletter. You can view the information online or click to download the newsletter.

 
MAS90 Newsletter Year-End 2011

Filed Under: Sage 100 ERP Tagged With: 2011, Closing, newsletter, tips, tricks, year end

  • 1
  • 2
  • 3
  • Next Page »
Access Sage 100 in the cloud today. 3rd party applications supported Available 24/7 from anywhere. Dedicated hosts

Call 1-888-244-6559 (toll-free)

Search Our Site

Sage 100 Newsletter

Sage 100 News

  • Sage 100 Updated TLS 1.2 Licensing Requirements ( February 2023 )
  • Shipment Tracking Functionality Restored to Sage 100
  • How To Edit 1099 Totals In Sage 100
  • How to Reconcile Sage 100 Accounts Payable Detail to the General ledger
  • Sage 100 Year-End 2022 Training Series
  • Minimum Sage 100 Versions for E-Filing for Tax Year 2022
  • What Are The Differences Between These Sage Fixed Asset Versions: Lite, Single-User, Network and Premier?
  • Sage 100 Paperless Email Electronic Delivery Failing With Rackspace
  • How To Check Sage 100 Compatibility with Avalara’s TLS 1.2 Requirement
  • Sage 100 TLS 1.2 Compliance Update ( Nov 2022)

Contact Us

Schulz Consulting
Connecticut Office
Click Here To Contact Schulz Consulting
Email Us
Available remotely nationwide.
We are a local branch of DSD Business Systems Connecticut.

Copyright © 2023 · Parallax Pro Theme on Genesis Framework · WordPress · Log in