Sage 500

We have a new Windows Server 2019 and SQL Server 2019 for our Sage 500 upgrade to version 2021. We use Sage via RDP. The Client is not installed on user PCs. They RDP to the server which is configured to launch a Sage session for the user. Sage is working…

Does anyone know if there are any Sage SQL DF to check for data consistency after SQL Crash Recovery? SQL Server was not committing records to MDF. MDF and LDF are no longer consistent and corrupt. Missing Batch Do you know Sage ever released a Data…

WE have a custom Sage 500 task that creates sales orders from external data - I am seeing an issue where I get an error in my SQL profiler when creating a sales order and calling the stored proc spsoGetSOLineDist That does an insert into #tsoSOLineDist…

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…

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…

One of my users receives an error when they attempt an update Detail on a recurring invoice. Other aspects of the invoice can be updated, and Detail can be updated for the other companies in our system. This error is triggered on all recurring invoices…

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…

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…

We moved our database from SQL-02 to SQL-03 server name. I am unable to register the application to use it's modules. I've ran the Database Synchronization Utility be get the following error: I also tried to manually register but receive this error…

After trying to import an SO using SOAPI, the import fails and I receive this error in the tdmmigrationlogwrk table: "Error Creating SO Kit Component Records". All the items look to be set up as singular items. What could be causing this error?

Is there a way to commit sales orders and then create invoices for them by inserting into staging tables/executing stored procedures?

Hello Community, I have a couple questions that i need help with. We are thinking of moving our sister company, that is using Sage 300, to our Sage 500 software. Has anyone successfully done this before? Can someone point me in the correct direction…

Module: "ms" Application: "Menu" Company:"" Abnormal Termination WFinish: FEMessage: failed to flush data to socket: errno 22: Invalid argument Please help- getting the error on client PC while accessing Sage 500 customize module. ([Microsoft]ODBC…

Hi my name is Miguel and I work for a small company. One of my coworkers has been able to export data to Excel before, but suddenly ran into this issue and I haven't been able to find a solution. I believe they are running Office 2010.

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

When Sage 500 creates a back up plan, the Step within the job has the Option RetainDays included with it. The question came up today if this option deletes the older back files the job created. The option does not delete any back up files. The option…

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…

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…

Hi, We have a vendor that sends us invoices in pdf and an xml file. To save the people in accounting some time, we are looking at importing the vendors invoice(s) into Sage 500. We have the Data Import Module. Is there an example of an XML file or…

Hello! I'm trying to setup a data import task for pending gl transactions and am getting this error when running: Description: "output "JournalDetl$" (9)" contains no output columns. An asynchronous output must contain output columns. We have a…

In Data Import Manager > Maintain Source Connection, I'm creating a new connection to a comma-delimited file. I'm selecting "Flat Text File" as the type. I'm getting the following error when I try to save it: Unable to preview the text file contents…

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…

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…