Sage 300 System Requirements

Sage 300 System Requirements

Sage 300 System Requirements When Installing or Upgrading Your Sage 300 (Accpac) ERP System

High-Level Overview of Sage 300 System Requirements To Upgrade /Install Sage 300 Change can be difficult, especially when you are implementing a new ERP system or upgrading your existing ERP software. This blog article will give you a high-level overview of the Sage 300 upgrade/install process. For more in-depth information of Sage 300 system requirements, download and review the Sage 300 2020 compatibility guide, and then contact Front Line Systems, with your questions.

Here’s What You Need to Know About Sage 300 Database Requirements

Microsoft SQL Server Requirements – When you install Sage 300 2020, Microsoft SQL Server 2012, 2014, 2017 or 2019 are the supported versions. While older versions may work, they have not been tested by Sage, so technical support will not be available, if you have a problem.

Windows Server Requirements –Windows Server 2012 R2, 2016 or 2019 are the supported versions. As with SQL Server, Sage technical support is not available for older versions, so use them at your own risk.

Must-Know Tips

Sage 300 system requirements – SQL Server Standard Edition or better is highly recommended. With the free version (SQL Express), you may end up with unacceptable performance, even with a powerful new server. SQL Express will work, but is intentionally throttled down by Microsoft and does not use server memory or processors efficiently. SQL Express also omits useful database management, reporting and integration tools.

– You must apply SQL Server Service Pack 1 or a later update on SQL Server 2012 for compatibility with Windows Server 2012 R2.

– Best practice is to avoid installing Sage 300 or SQL Server on a domain server. While possible, it raises system security and server resource capacity issues that need to be taken into consideration.

For more in-depth information on Windows Server and Microsoft SQL Server Compatibility information access the resources below:

– Server application compatibility
– SQL Server and Windows Compatibility

Sage 300 Workstation Requirements

– Supported Sage 300 2020 workstation operating systems include the 64-bit versions of Windows 10 (Professional) and Windows 10 (Enterprise). While Windows 7 may work, it is not specifically supported by Sage. Use it at your own risk. Better yet, upgrade your Windows 7 PC’s to Windows 10. It’s a good move for many reasons.

– To use the GL Financial Reporter, you will need compatible 32-bit versions of Microsoft Excel 2013, 2016 or 2019 on each workstation.

– If you will use the email function, please make sure to use compatible 32-bit versions of Microsoft Outlook 2013, 2016 or 2019 on each workstation.

Sage 300 Web Screens

Interested in using Sage 300 web-screens? Great! Here are a few things to keep in mind:

Sage 300 web screens– We recommend that you get a SSL certification for your website if you are going to allow web access to your system.

– Make sure you use Microsoft Windows Server 2012 R2, 2016 or 2019 with IIS installed, including static content and ASP.Net.

– To view the web screens, please use Internet Explorer 11 or the latest versions of Microsoft Edge, Google Chrome, Apple Safari, or Mozilla Firefox.

Need to Purchase SQL User Licenses?

Talk to your Sage business partner about Sage 300 system requirements, before making a purchase or upgrade decision. Sage allows you to purchase SQL user licenses at a reasonable price. (Note: Ask your Sage 300 business partner to include the SQL User License pricing in your Sage 300 quote.)

Have integrations to 3rd party applications? No problem. Just make sure that the software vendor has already published a software version that is compatible with Sage 300 2020.

sage 300 erp system requirements for an installFor more in-depth information on Sage 300 system requirements, please refer to Sage 300 2020 Compatibility Guide.

This article provides a basic overview of Sage 300 system requirements. There are many details applicable to all installs /upgrades and specific to any single install/ upgrade that must be considered as part of a well-planned, successful ERP implementation.

We recommend that you work closely with your Sage business partner to plan and implement your Sage 300 install/upgrade.

Sage300

Function and Feauture

  • General ledger distribution by department
  • AR Collections Dashboard
  • Budgeting, payroll and general ledger
  • Accrued payables/account for variances
  • Inventory accounting
  • Bank reconciliation
  • Cash flow projection
  • Aging analysis of receivables & payables
  • Repeat payables
  • Calculate terms discounts in cash receipts
  • AP Aging Dashboard
  • Quick generation of check
  • Repeat and reverse journal entries
  • Collection tracking
  • Direct deposit
  • Integrated with Shop Management Solutions
  • Commissions
  • Export data to excel
  • Multiple years of financial records
  • Post to prior years and periods
  • Provide a standard balance sheet and income statement
  • Ability to create/customize financial statements
  • Vacation and sick time accruals by company or employee
  • Drill down into data
  • Integrated with Shop Floor Data Collection
  • Calculate monthly depreciation