• Development System Pointers

    We are having trouble with the Sage 500 ERP application on our Development server pointing to our Production Database. We have corrected the application it is pointed to using the Client Configuration Utility. However, it keeps reverting back to our production…
  • SQL Server 2022 Compatibility

    Hello, We are purchasing new hardware to replace our outdated server. Does anyone know if the latest version of Sage 500 will be compatible with SQL Server 2022. I like to believe that there won't be any issues but you never know. Has anyone been running…
  • Error 701 Insufficient memory in SQL Server 2019 when running Scalar Functions in Sage 500 2021

    Came across a weird issue today where the function fnIMRoundQty in Sage 500 2021 was causing a 701 Insufficient memory error on SQL 2019. However, on a SQL 2016 system, the issue would not occur. Doing a little research, I found that there is a known…
  • Mas 500 7.4 Registration

    I have the database on SQL Server 2008 R2. I'm trying to access our database for historical purposes but it's telling me it is not registered. I've attempted to register manually and it tells me the user must sign out and back in for the changes to take…
  • Sage 500 ERP on AWS

    We are using Sage MAS 500 March 2011 Update (Version 7.30.6.0) and want to migrate it to AWS RDS. Is that supported. Does it work in EC2 or at all? Thanks, Verne
  • Sage 500 2018.1 database backward incompatibility

    The Database Utilities 2018 link in Sage 500 ERP 2018 download page can only upgrade databases to v7.90. After upgrading ERP Client to 2018.1, it can only open databases in v7.90.1 version. Now we cannot run Sage 500 anymore. Is there a 2018.1 copy of…
  • SQL Server 2014 trigger problem

    Microsoft SQL Server 2008 Standard R2 was upgraded to SQL standard version 2014 on 64-bit machine. Upgrade was successful without any error, but when users tried to save Purchase Order, message 'Append' is not a recognized option appeared and PO was not…
  • Multicurrency

    When entering a sales order that has a different currency, the sales order does not calculate the conversion until I close the order reopen and drill into the conversion. If this doesn't happen, then the currency never gets converted and posts and flows…
  • SQL Server 2014

    I'm trying to plan my upgrade from 7.4, which also has to include a server migration, OS upgrade to 2012R2, and a SQL Server upgrade. Has anybody tested any version on SQL Server 2014? I created a 7.4 blank db (except for COA, etc.) and migrated it…