copy – Schulz Consulting

One of the most common questions we hear from our customers is around moving Sage 100 from one server to another. As hardware ages and requires replacement it is not unusual for an IT department to upgrade the accounting department’s server systems. Naturally this also requires that each application is migrated off the old server(s) to a new server(s).

Sage have created an excellent document that tells you how to move your Sage 100 ERP (formerly MAS 90 or MAS 200) to a new server. There are some missing tidbits of information – such as failing to remind you that you might have to reinstall workstation setup if the new location is not the same drive mapping or not recommending you check your Paperless Office setup.

This is one of the more complete guides that I’ve seen and starts at version 3.x of MAS 90 and MAS 200 and works all the way through Sage 100 ERP 2013. Each version has it’s own set of specific instructions.

Worth a look!

Visit the Sage KB online at

110-1143 – How To Move Or Copy Sage MAS 90 or MAS 200 To A New Location

One of our most used hidden utilities within MAS90 and MAS200 is a program SVTRNA. What the program does is allow you to copy master data (no financial totals only names, descriptions, addresses) from the accounts payable, accounts receivable or inventory modules of an existing MAS90 or MAS200 company code into a brand new code.

This is super helpful when establishing a new company within MAS that is virtually a mirror image of an existing one and which will make use of all (or virtually all) of the same customers, vendors or inventory.

One of my 90 Minds Consulting Group colleagues just noticed that on version 4.4 product update 5 that when he copied over inventory data he was also receiving a little more than he bargained for. Normally only the master information for each inventory item would copy (description, product line, etc). It appears there may be a bug in v4.4 product update 5 which results in some totals (quantities on hand) also transferring if you use the SVTRNA utility.

This isn’t a huge issue – except according to my colleague there’s no way to fix the totals by using the Visual Integrator module. So if you’ve made a data transfer using SVTRNA into inventory and hadn’t thought to keep a backup – you could find yourself in a bit of a pickle.

Your best bet when making copies of data is to always make a complete backup of your MAS data BEFORE attempting the transfer (here’s one way that Sage recommends). We’ll update you with more information on this as we hear about it.

90Minds

How To Move or Copy Sage 100 ERP (MAS 90 or MAS 200) To A New Location

MAS90 and MAS200 v4.4 Product Update 5: SVTRNA Bug Advisory

Contact Us