Schulz Consulting

Consulting and Upgrades

Sage 100 ERP Secret System File Rebuild Utilities

by

sage100rebuild

If you’ve ever encountered an issue with Sage 100 ERP having and issue and you suspect that a system file (user names, company master file, etc) could be at fault then you probably already know that there is a hidden utility to help you rebuild those files.

For versions 4.05 and LOWER the utility is accessed by selecting:

Rebuild system file(s) with SVXBLD.

  1. Have all users exit Sage MAS 90 now Sage 100 ERP
  2. Open Windows Explorer and go to ..\Mas90\Home
  3. Double-click PVXWIN32.EXE (or right-click the file and select ‘Open’).
  4. Click the ‘Ok’ button on the splash screen. A blank screen with a ‘Greater Than’ ( > ) prompt should appear.
  5. Type RUN “SVXBLD” (with the quotes) and press ‘Enter’. SVXBLD should open.

Beginning with version 4.10 you use a new hidden utility – sy_rebuildsystem.m4p

  1. Get all users out of Sage ERP MAS 90 or MAS 200. (And for MAS 200, the Service or Application must be stopped).
  2. Via Windows Explorer, access the live “..\MAS90\Home” directory on the server where MAS 90 or 200 is installed.
  3. Double-click on the Pvxwin32.exe program to access a command line window.
  4. Type in the following command and press the Enter key: run “sy_rebuildsystem.m4p
  5. At the User Logon prompt, enter your user logon and password.
  6. Once past the warning prompt, a Rebuild Key Files window will appear, displaying the available system files that can be rebuilt.

 

If neither of the above (depending upon your respective Sage 100 ERP version) does the trick – you can try the UFAR utility which is a character based tool used as a last chance effort to rebuild system files (BACKUP ANYTHING YOU ARE TRYING TO REPAIR BEFORE USING):

 

Use UFAR as a last resort after other methods have failed to restore or repair the file. No log file is created and it is impossible to determine what records are deleted.
Steps to run UFAR:

  1. Make a backup of the file to be repaired and have all users exit MAS 90
  2. On the server double click the file ..\mas90\home\PVXWIN32.EXE
  3. At the command prompt type: RUN “*UFAR”
  4. At ‘Name of KEYED/DIRECT/EFF file’ type: SY0CTL.SOA and press ‘Enter’
  5. If rebuilding a ‘non-system’ file the path is required.
  6. At the prompt for the temporary file name, accept the default backup name (for example: Sy0ctl.b00), and press ENTER.
  7. At the “Recover for Highest Active Index or Physical End of Record” message, select the desired option and press ENTER.
  8. the default ‘Highest Active Index’ is the correct choice for SY0CTL.SOA
  9. Using the cursor keys select ‘D Wrong’ then select ‘E Wrong’ then select Yes and Yes again.
  10. Type BYE to return to the command prompt.

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

by

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.

sage 100 upgrade

 

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

Supported Platforms For Sage 100 ERP v4.30 to 2013

by

Sage issues regular updates to their listing of the supported servers , operating systems and hardware tested and trusted to work as platforms for Sage 100 ERP (formerly Sage ERP MAS 90 and MAS 200).

sage supported platforms

Since these documents are subject to periodic update we recommend that you download a copy of the Sage Supported Platforms Matrix for review immediately prior to making any purchase of new hardware or operating systems upon which Sage 100 ERP will run.

For your convenience we’ve summarized the documents at the following link:

 

http://goo.gl/MW6v0

 

Sage 100 ERP Upgraders: V4.5 vs V2013 – Which Should You Upgrade To?

by

sage 100 upgrade

 

Earlier this week I asked my private 90 Minds Consulting Group which is comprised of 130 experienced Sage partners from across North America whether they’d recommend Sage 100 ERP v4.5 or v2013 for a customer upgrade.

 

 

Here’s my exact question about whether it’s better to upgrade to Sage 100 ERP v4.5 or Sage 100 ERP 2013?:

 

Ok to go with Sage 100 ERP 2013 from v4.3 or are you still recommending 4.5?

I’m very hesitant to put a customer on a version (4.5) that’s already one level back when the upgrade fee is fairly costly to begin with.

If I hop to 4.5 then I will presumably still have a decent hop to 2013 (given the credit card upload which this customer is using).

 

What say everyone – 4.5 or is 2013 ready?

 

Notes:

1. Credit Card Upload is a reference to Sage 100 ERP 2013 requiring integrated credit card users to move to Sage Payments (if they are not already on the platform). During the upgrade all payment data is uploaded to the Sage Vault which can be time consuming depending upon the volume.

2. This information is general in nature and may not be applicable to your company. Please consult with your Sage Business Partner.

3. The responses are unfiltered and come from experienced Sage 100 consultants with a varying degree of experience with the Sage 100 ERP 2013 upgrade. Complexity of upgrades vary from company to company and it’s impossible to list every complicating factor from an upgrade which might have tainted one person’s opinion.

 

Is It “Safe” To Upgrade To Sage 100 ERP 2013?

(A compilation of feedback received from 90 Minds members)

I’m installing 2013 whenever I can. Because if not now, when? Before you know it 2014 will be released and your client will again be 2 versions behind.

We are going to 2013 as a rule, unless they have a third party that is not yet ready, such as JobOps. JobOps 2013 is out some time in June, so then we’ll recommend 2013 for most.

The real $64,000 question that the customer asks “will there be any bugs if we go 2013 v 4.5? ” … talk about setting yourself up to be blamed for making the decision if there are any v2013 issues that arise…….

Answer: Yes, but that is true with any software, no matter how mature. However, we will make sure all patches are installed on a timely manner, as needed, and we’ll help you as new bugs are discovered to mitigate any problems that arise. That is our job. However, we are not the publishers of the software and we can not, and do not, make any guarantees regarding the software.

We are starting to roll it out for smaller clients. For a 20 user wholesale distribution customer I would still be nervous, but if they were anxious to upgrade “now” I would probably go with it and do as much testing as possible.  Pretty sorry state of affairs when the software has been out for 6+ months and people have little confidence.

In the good old days… we would wait until the first fix collection came out.  I am not as close as I used to be, but it seems 2013 is having some underlying technical issues in our hosted environment which makes me wonder…

We also are running into situations where the Extended Solutions people still rely upon are taking time to be upgraded.

My biggest issues are all Crystal and workstation related.

I would go for it – we have a client, 100 advanced, Distribution BOM, a lot of custom fields/scripting, things have been running well.  My feeling is that it’s ready, and it’s a separate install, so you have the opportunity to do some good testing prior to a final migration.

I say 4.5, I had one upgrade from 371 to 5.0 (Sage 100 ERP 2013) everything went wonderfully with exception to Printing and Sage Exchange communication errors that were invalid and seemed to be locking issues. Spent several weeks dealing with it , Sage Support was involved but got the typical answer of Reinstalling the applications. I did not reinstall. However after …

 

 

Here is a nice collection of Sage 100 ERP (formerly Sage ERP MAS 90 and 200) links which might be helpful to you as you try to decide on which version to upgrade your system to. This includes a link to Sage’s page showing what’s new in almost every version of Sage 100 ERP since the 3.x days. Sage 100 ERP Technical Resource Links for Upgraders

 

Adobe PDF Reader Update: Possible Issue With Paperless Office for Sage 100 ERP

by

adobe reader paperless office

Just a heads up for a problem one of my 90 Minds group members encountered today with #Adobe Reader.

Updates released last week on the 14th to level 11.0.3 and 10.1.7 caused problems with #PDF documents created via #PaperlessOfficeon Windows 8 machines.

Example:
Windows 7 machine on 11.0.3 could no longer open any PDF created on a Windows 8 machine.

Windows 8 machine on 10.1.7 could not create any PDF.

Solution was to roll back to a prior release and then turn off automatic updates.

This is #Sage100 Advanced version 4.40.0.10.

Contact Us

Schulz Consulting
Connecticut Office
Click Here To Contact Schulz Consulting
Phone: 860-657-8544
Email Us
Available remotely nationwide.
We are a local branch of DSD Business Systems Connecticut.
Schulz Consulting