Sage 500

Hello, I am trying to get data about transactions made per account between dates and get information about related documents with transactions. Payable and receivable. So I need Purchase Orders and Sales Orders documents etc. What I know / discovered…

We have a large number of items in our inventory that were setup incorrectly. The items have activity posted against them. Is there any way in the data tables to flip a raw material item to a finished good? For example, our BOM pulls together the…

Does anyone know where the Item Type table is in Sage 500? Thanks, Tina McLauchlan, Business Analyst Industrial Fabricators, Inc. 2408 Forbes Road Gastonia, NC 28052 (704) 864-3032 Ex 211 “Carpe Diem”

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…

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…

Luego de actualizada la base de datos el sistema muestra un error al comprometer las transacciones de órdenes de venta Batch Key. Batch No: Cannot find SO system batch in the batch log." prints on the Commit SO Transactions Error Log Alguien pudiera…

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…

I am receiving an error when trying to generate a shipment for a sales order. I have created a picklist and confirmed it however when I try to generate a shipment I receive a message: "No lines fit the specified criteria for generating shipments". I have…

I have successfully inserted sales orders with their respective lines but now I need to create shipments for them. Which stored procedure is used to do this?

Upon attempting to execute stored procedure, spsoCreateShipLines, the console says that it could not find a specific stored procedure executed within this procedure. This specific procedure is called spGetNextBlockSurrogateKey. I cannot find this procedure…

Trying to execute stored procedure spSOapiSalesOrdIns but I am getting errors that some stored procedures cannot be found. When I look inside those stored procedures, they have errors saying that a specific table cannot be found. This table is: #tsoAPIValid…

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

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…

Over the years of use and lots of data imported from our various sales channels, our database has grown to about 80gb in size. Maintenance on a database that big can be cumbersome when rebuilding indexes, doing backups, dbcc checks, et al . Is it…

Hi, Did anyone used to use the website http://www.sageusernetwork.com/ >? It used to give a brief description of ERP tables that were used in Sage 500 and also would provide a ERP Diagram to show relationships between tables. Would anyone know if…

Does any one at Sage still monitor the Sage 500 ERP Ideas site and keep it up to date? I just entered a new one today and was reviewing some of the existing items. It's hard to tell what has been considered and rejected as far as ideas go. It would be…

Will Sage officially support SQL 2016 with Sage 500 2016 release? Is it in the plan at all? If so, what might the timing look like? Thanks!

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…

We use cieTrade and Sage 500, do you know if everything is updated on both sides to work with 2016 updates?

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…

When access has been taken away from on a task, how do you delete this task which has been grayed out in your My Task view? Tried to right click and delete but there was no option.

We are currently using Sage 100 and want to move away from a proprietary database. We were looking into Sage 500. In all my researching someone just mentioned to me that Sage 500 has been classified as a ‘sunset’ product meaning… while companies can still…

Good morning. I am a new user to Sage with my new position. I am curious if there are any training options that one could sign up for to learn the aspects of Sage for analysis, reporting, entry, etc. I do a variety of items in Sage and need to now dig…