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…

My end user is getting error Task # XXXX is not defined in task definition tables.

Your data is vulnerable to various risks, such as hardware failures, cyberattacks, and natural disasters. Backing up your data and having those backups easily accessible is often the quickest, most affordable way to recover. In fact, backups may be your…

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…

There are a few KB on Sage's support site. That indicate a Data Fix but no download file is available for download. Is there a link anywhere to download all?

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…

In company C we have 3400 customers. Each customer needs to have a new secondary address added. Same address information for all. 1. Is inserting into tciaddr and using the new addrkey then inserting into tarCustAddr (via direct database calls)…

Here are a few friendly suggestions that you might want to park in the back of your minds that could help out with some yearly maintenance and upgrading. These are not day-to-day type things but can help out over time. There is a table in the system…

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…

Newbie here. I am entering items details manually into the different fields of a purchase requisition. I have a csv file with data from an MSC shopping cart. How do I transfer this data into the Purchase requisition grid without copy and pasting field…

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…

Looking for the best method to import transactions. We do not have Data Import Manager. Sage 500 version 2016, upgrading to version 2021 this year.

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…

Hello Sage 500 friends, one of our employees does not have the ability to export data into Excel, see below. I have all options available. We have tried going through permissions and reached out to Impact for help to no avail. Does anyone out there know…

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…

We have an existing payment engine that processes credit card and checking. I have created the ability to lookup invoices with a balance, "grab" all the details, and offer customer payment through other means. Now I need to bring the payment information…

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 can easily find the GL file format, but not the AP file format for importing. How can I import into the AP Module? Where is the file format?

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…

Trying to run Schedule Generation for the first time and i'm getting a few errors. it was going through the steps and stopped at a work order. gave an "Error 5 occurred at frmmfzmn001 in Procedure cmdGenerateSched_Click. Invalid procedure call or argument…

Trying to post a Goods Receipt and get this message during matching. What would cause this?