Stephen Smith's Blog

Musings on Machine Learning…

Sage 300 ERP 2012 Supported Platforms

with 43 comments


Introduction

Whenever a new version is released, it is tested with the latest operating systems and usually bundled components are updated to the latest versions As always there will be a detailed list of all supported platforms and exact versions will be published on our website. This blog posting is a bit more informal and talks about what I think are interesting on the list. Some of this is my opinions on the various supported platforms and some of the pros and cons.

Browsers

We now have added support for Chrome, Firefox and Safari. We support IE 9 everywhere and are testing on IE 10 (need a released version before we can give a final say). We support IE 8 for Sage CRM and Quotes to Orders, but we don’t support IE 8 for the Web Portal in Sage 300 ERP.

Windows XP

We continue to support Windows XP at the SP3 level. Beware that Microsoft is currently scheduled to discontinue this support on April 8, 2014. They have extended this deadline several times already, so stay tuned. This will be dangerous since they say they will stop issuing security updates at this point. From our own surveys we know we have a large number of users still running on XP and that people may not want to have to buy new computers until absolutely necessary.

The worst thing about XP is that Microsoft doesn’t support IE 9 there and that IE8 is quite slow and buggy. The big benefit for Sage 300 ERP users is that now that we support the Chrome, Firefox and Safari browsers, that is, you don’t need to use IE 8 anymore for our products. We highly recommend that you install Firefox or Chrome (you can still use IE for other things like SharePoint if you need it). In fact the Sage 300 Web Portal no longer supports IE 8 so you will need to use one of these browsers to access it. For Sage CRM (and the Quotes to Orders function), we still support IE 8.

As another note, we don’t support using Windows XP as a web server for either Sage CRM or for the Web Portal in Sage 300 ERP. If you need a web server running Windows 7 works great or use a true server version of Windows.

Windows 7

This is the main client platform we support. Sage 300 ERP runs best here and we highly recommend using this client operating system.

We support the 64-Bit version equally to the 32-Bit version. In fact we recommend the 64-Bit version since this is the only way to take advantage of the memory in any newer computer.

Windows 8/Windows Server 2012

We are running our automated tests against the release previews of these products. We can’t officially support these until we can test against the released versions, but we are hoping that if the released version doesn’t spring a major surprise, then we can support these very quickly after their release.

Note that for Windows RT (the ARM processor version of Windows 8), you can only run true web components here, any VB UIs will not run.

Initial reviews of Windows 8 are rather mixed, but like MS Vista, it will start appearing on new computers whether you like it or not.

SQL Server 2012

With this release we will be both supporting SQL Server 2012 and making SQL Server 2012 available for purchase from Sage. Microsoft provides lots of information on all the new features there. The most obvious one is that the SQL Server Management Studio is now built on the Visual Studio 2012 platform. Besides some color and style changes it appears pretty much the same to me as the previous one, only now it takes much longer to start up. I think the idea is that it then leverages the better developer tools in VS for debugging and such.

Pervasive.SQL 11

We now support Pervasive.SQL 11. One notable “feature” of this product is that product licensing and activation are more stringent. You cannot share licenses and your computer must be on-line to validate your activation code. Otherwise checkout out Pervasive’s web site for new features like multi-core support.

Crystal 2011

We now fully support designing reports with Crystal Reports 2011. We now bundle the matching runtime for this version of Crystal. Beware that SAP has separated the runtime from the Crystal Reports product, so it is actually called “SAP Crystal Reports runtime engine for .NET Framework 4” (strangely rather than for Crystal Reports 2011).  The internal version of the runtime is Version 13.  Our current plans are to bundle SP3 of this runtime and its internal version is 13.0.3.612. Since we are just starting regression on the 2012 release, there is some chance that we will end up bundling SP4 if it comes out soon.

Generally this upgrade was fairly painless. We did tweak a small number of reports, but these tended to be things that were already wrong. We did find some reports with an incorrect page size, which was ignored by the previous runtime, but now worked and caused problems. Anyway you should try your customized reports and check for alignment issues, especially for things that print on pre-printed forms.

Virtualization

Here we support Citrix Xen Apps, VMware ESX 4.1 and ESXi 4.1, and Windows Server 2008 Standard R2 – Hyper V.

Just remember virtualization does add some overhead and if you are running multiple images on one server, beware memory use and CPU contention.

Office

For MS Office we support 2003, 2007 and 2010. Note that we only support 32-bit office because of the way our Financial Reporter Excel plug-in works.

Summary

I didn’t cover everything here; we support Oracle 11gR2 and MS Vista SP2 for instance. But to give you a flavor and some highlights of our upgraded platform support.

Written by smist08

June 23, 2012 at 5:47 pm

43 Responses

Subscribe to comments with RSS.

  1. Is there plans to support the SageCRM Quotes and Orders screens on IE9, Chrome and Firefox?

    Stacy Denunzio

    June 25, 2012 at 1:34 pm

  2. What about installing CRM/ERP on Window SBS 64 bits with Exchange? Before due to many changes in IIS config files we could not install or make it work…

    Jaime Schmulson

    June 25, 2012 at 3:43 pm

    • We are supporting this for Sage 300 ERP. I asked the group testing this to make sure they add Sage CRM to see if there are any problems. Will let you know.

      smist08

      June 26, 2012 at 2:52 pm

  3. […] New in the Sage CRM Integration for Sage 300 ERP 2012 SageCRM 7.1 Released Sage 300 on Windows 8 Sage 300 ERP 2012 Supported Platforms SData Enhancements for Sage 300 ERP 2012 SData Referenced […]

  4. Hi Stephen
    What tools do you guys use for automated testing?

    Tim Purcell

    July 15, 2012 at 8:14 am

  5. Peter – do you have any updated news regarding Windows 2012 Server and Sage 300 (Accpac) compatibility? That server o/s is being released 9/1/2012 and for a number of reasons we feel it should be used. Please share your thoughts.

    Kandi Messerschmidt

    August 17, 2012 at 6:06 pm

    • Sorry – I meant the first line to be Stephen – I tried emailing Peter but he is out until 8/24 which is why I posted the blog. Can you please update it before posted.

      Kandi Messerschmidt

      August 17, 2012 at 6:07 pm

    • We are doing full testing on this as part of the regression testing on our Sage 300 ERP 2012 release. So far we haven’t found any problems. The final released version should have just been posted while I was at Summit. So if nothing is broken in the final build, then we should be able to certify/support it at that point.

      smist08

      August 18, 2012 at 3:20 pm

  6. […] our Sage 300 ERP 2012 release we updated our Crystal Reports runtime to the newest Crystal 2011 runtime (SP3 actually). The intent is to move to a fully supported version of Crystal Reports, so as they […]

  7. “For MS Office we support 2003, 2007 and 2010. Note that we only support 32-bit office because of the way our Financial Reporter Excel plug-in works.” That’s most unfortunate as we all want to move to 64-bit OS and applications. Any idea of when ERP gets to be a 64-bit app? When office 64-bit will be supported?
    thanks as always for the great posts and the solid product.

    Ram

    September 23, 2012 at 6:45 pm

    • At least you can fully utilize the 64 bit version of the operating system. Right now 64 bit programs can’t directly call 32 bit programs. So we either need to break the Financial Reporter into two portion and have them communicate via the network stack or develop a 64 bit core version of System Manager and G/L. The scope and various trade-offs are being looked at, but at this stage its too early to commit to anything.

      This is a general problem and why by default Microsoft runs the 32-bit version of IE on 64-bit operating systems, because any add-ins for either IE or Office need to be the same bitness.

      smist08

      September 24, 2012 at 8:54 pm

      • Thanks for the reply – please do keep in mind that this is an increasingly common and practical concern. No pressure 😉

        Ram

        September 24, 2012 at 9:09 pm

  8. […] Introduction Whenever a new version is released, it is tested with the latest operating systems and usually bundled components are updated to the latest versions As always there will be a detailed …  […]

  9. Documentation regarding Sage 300 ERP Portal mentions that the Portal runs on Safari Browser. However, it does not state whether it runs on either Safari for Windows or Safari on Apple O/S or both. Does it run on Apple Safari O/S ?

    Mark Gerada

    October 2, 2013 at 10:27 am

    • Yes, that includes support for Apple OS/X.

      smist08

      October 2, 2013 at 3:04 pm

      • Thanks for your reply. Do you know of any forum where any known issues and/or troubleshooting methods are discussed regarding the portal on Apple OS/X as I cannot seem to get it to work ?

        Mark Gerada

        October 3, 2013 at 6:32 am

      • What is the problem you are having? Is it rendering incorrectly? If you are trying to run the VB screens from the Portal, these will only work on Windows since they are Windows programs.

        smist08

        October 4, 2013 at 3:49 am

      • I can go as far as logging into the portal and all the displays are correct. However, when I come to running any of the module programs, I get an error stating that an unexpected error has occurred and that I should run the workstation setup. Notwithstanding this however, Safari is not prompting me to install the missing plug-in which I presume is why I am getting this error. Is there a way to manually install this plug-in ?

        Mark Gerada

        October 4, 2013 at 6:36 am

  10. Hi,

    Any suggestions on this issue ?

    Mark Gerada

    October 16, 2013 at 7:04 am

    • You can only run the VB programs on a Windows computer. On non-Windows you can only run the web (HTML) parts.

      smist08

      October 16, 2013 at 8:11 pm

      • OK Thanks for your input on the matter. Much appreciated

        Mark Gerada

        October 17, 2013 at 6:09 am

  11. Is report printing now supported in Sage 300 ERP 2012 web deployed on Windows Server 2008 and later releases?

    Chris De Guzman

    April 16, 2014 at 5:49 am

    • Yes it is. The problem was that the Crystal Report Server wasn’t compatible, so we changed the printing process so we don’t use the report server anymore. This way we work with all the newer Windows Servers and you don’t have the extra complexity of getting the Crystal RAS Server installed and working.

      smist08

      April 16, 2014 at 4:08 pm

      • OK Thanks for the reply.

        Chris De Guzman

        April 22, 2014 at 1:16 am

      • We noticed that in SAGE 300 ERP 2012 web deployed, the report printing only produce pdf report for GL module. In desktop version, we are able to export the report into many different format.

        Are there ways to support other format (e.g. excel) for web deployed? Thanks.

        xhaydn

        May 8, 2014 at 10:58 pm

      • Sorry, but its limited to PDF when running web deployed.

        smist08

        May 11, 2014 at 7:43 pm

      • Thanks Stephen.

        Any plans to support xls report in the future for web deployed? Or web deployed itself will be phased out and replaced with full web implementation?

        And if we switch back to Windows Server 2003, is it possible to get excel report for web deployed?

        xhaydn

        May 11, 2014 at 11:48 pm

      • Once you are running the new way, it doesn’t matter what the server is. Right now we don’t have any plans to add other formats.

        smist08

        May 12, 2014 at 2:50 am

      • Hi Stephen,

        Thanks for the confirmation.

        For workaround to support XLS format, we think of extending existing Accpac report forms. Add logic to intercept the form parameters. Pass the parameters to the server and trigger a command line using those parameter. We will install Accpac Desktop in the same server, and XLS report will be produced from the command line which trigger Accpac Desktop.
        The form will redirect user to the XLS report instead of PDF report after report generation finished.

        Is the above workaround viable?

        xhaydn

        May 14, 2014 at 4:12 am

      • That sounds very difficult.

        smist08

        May 14, 2014 at 7:16 pm

  12. Hi Stephen,

    We encountered this error when we tried printing using web deployment. (i can’t attach/paste screenshot)

    Error Code: -2147467259
    An existing connection was forcibly closed by the remote host

    We are currently using this specs.
    Specs: 6.1 Sage 300 ERP
    Database: MS SQL 2008
    Server OS: Windows 2008

    glosantisidad

    May 2, 2014 at 2:32 am

  13. Hi Stephen,

    We encountered this error when we tried printing using web deployment. (i can’t attach/paste screenshot)

    Error Code: -2147467259
    An existing connection was forcibly closed by the remote host

    We are currently using this specs.
    Specs: 6.1 Sage 300 ERP
    Database: MS SQL 2008
    Server OS: Windows 2008

    What do you think is the cause of this error?

    glosantisidad

    May 2, 2014 at 5:51 am

    • Hard to say, sounds like something crashed on the server. Make sure you have the latest service pack installed for Sage 300. You may need to call tech support.

      You could try running COM Spy on various server objects to get a clue as to what is going wrong, since the server runs as a service you need to use advanced mode and set it up to log to a file (remember to turn it off again when you are done).

      smist08

      May 2, 2014 at 2:40 pm

      • Thank you so much. We will try this and we’ll see the result.

        glosantisidad

        May 5, 2014 at 2:44 am

  14. Hello Stephen,
    We are getting ready to purchase the operating system for the server, is Microsoft server 2012 Essentials suppportd by Sage 300?
    thanks,
    Laura

    Laura

    May 12, 2014 at 4:45 pm

  15. Hi Stephen,

    I have encountered an error on revenue recognition. Here’s the error: AMTSR is – 13214.286 but should be rounded to -13214.290 Message: No error Recognition worksheet was generated.

    Sage Accpac v.5.6,
    Database: Pervasive SQL 10.2;
    Workstation OS – Wndows 7

    Thank you.

    glosantisidad

    May 21, 2014 at 6:16 am

    • I think you will need to work with customer support on this one. I suspect they will need to look at your data.

      smist08

      May 21, 2014 at 4:02 pm

  16. Hello Stephen,
    We have installed sage 300 2014 and we are using web deployment. We do not use Sage CRM. Do you know if Sage offers a course on how to deploy our customized screens with VB6 and how to add customized reports to the web interface? If Sage doesn’t offer anything like that, can you give me a recommendation on another firm that might be able to help us learn how to do this, or at least point me to some documentation that can help? We currently run Sage 300 ERP 6.0 from the server and have made may customizations in VB6 on that system.

    Thank you so much!
    LeShel Rich

    LeShel Rich

    May 18, 2015 at 7:49 pm

    • i suspect Sage doesn’t have anything like that, and web deployment dates back to before I started blogging. You might want to post on Sage City http://sagecity.na.sage.com/ to see if you can find someone that can help you.

      smist08

      May 18, 2015 at 10:21 pm


Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.