Sage 100

I have a client running Mas90 4.30 - recently their server was replaced and they adopted hyper V. The virtual Mas90 server running W2008 Std, some of their workstations were replaced as well with Win 7 64. All workstation, XP & Win 7 are up and running, however, they report that the new Win 7 workstations can no longer export to Excel from their Crystal reports and forms. Process just hangs on these units. XP units still work fine. Anyone seen this? Any fixes out there?

Just wondering if it is possible that Excel won't export to Office 64. I know Act had an issue where it would not work with Office 64.

I meant,, Just wondering if it is possible that Crystal won't export .......

I'm pretty sure 64 bit office is not supported. They should consider running 32 bit Office on 64 bit Windows.

I guess the question is whether Office 64 is installed or not. Sounds like it is. If so, the fix is either a 32 bit Office or install Sage 100 ERP v2013.

If they have installed 64 bit Office, most of the exports and integration between Office and other programs (not just MAS) will be broken. This is most commonly seen where a program with some type of automatic ""mail to"" function for Outlook doesn't work and complains it can't find Outlook. I agree with Shawn, 32 bit Office should be installed. The fact Windows 7 is 64 bit won't matter. Since they have moved to Hyper-V and Windows 2008, you also want to find out the following: 1. What type of backup system they are using and how often it is running? Some backup systems that call the VSS writer frequently (think making a backup every 15 minutes) disagree with MAS 90 and can cause drops and performance problems disguised as network issues. 2. Depending on the number of users, if you begin noticing performance problems, you may want to disable SMB2 on the MAS server. We typically see this only become an issue over 10 users, but we disable it as part of setup. 3. For the least amount of headaches, esepcially with paperless office, UAC should be turned off. This might make your system admins grumpy, but it is unfortunately necessary. 4. As long as you've had a server change, it's a good time to check the AV exclusions, power save settings, etc. and make sure anything you would normally check with a physical server replacement is also checked.

Do not know for sure ... on the TS they definitely have 32 bit --- will look into. Of course the end user has no idea...

From a Win 7 machine, open up a custom rpt directly in Crystal Reports designer, refresh the data, then export to Excel. Look for any errors or roadblocks of any kind right there. Hopefully one of those ""aha!"" moments occur. For example if the UAC is enabled possibly a UAC dialog will appear during the export that was suppressed when exporting from the MAS Launcher. You could also try checking Run as Administrator in the MAS 90 icon properties in the Shortcut tab.

Thanks Alnoor - good idea - will let you know how it works. BTW - I am told it is definitely 32 bit MS Office