Sage 500

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?

I've tried searching this question, and have not found answer. I'm using the Data Porter to update information on existing sales orders, such as comments, ship dates, etc. However, I have only been able to make these updates on the 1st line of the sales…

We have a customer group that is wholesale. In the Matrix Pricing GUI - the group is set to: Method - Discount Amt Base - List Price Amount - 0 The customers in this price group do not show up in the timCustItemPrice table at all. We have…

I am using the data import manager API to migrate sales orders into Sage 500. After they are imported and picklists are created however, the shipments that are generated only include the first line of every sales order. I need the shipments to include…

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

Hi everyone, Can someone provide a list of accounts payable tables to show AP invoice payment history? Also, I am looking for vendor master tables. thank you

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…

What is the process of creating shipments in Sage through insertion into the sql database? I have inserted into the picklist table, the shipment/ship line table, and the batch table and shipments are still not showing up in the Sage 500 software. The…

During a GL Import I am receiving the following error message: "Incorrect import file header. Please verify the header information. " I use the same template every time. Most of the time there is no issue, but this has been happening every so often. I…

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…

Can somebody take a look at their database, and verify the following? I'm on Sage 500 2016 January 2018 MU (i.e. 7.70.6.0). tciCarton contains CartonKey, but it is NOT a primary key, nor are any constraints. As a result, I've got a few duplicate…

For reasons I won't go into in this post, I cannot use Excel as a source for my data imports. Because of that, I'm looking at other formats. I got a flat text file to work for a very simple import which had only one staging table, but now I'm looking…

Upon attempting to migrate StgSOLine table to the tsoSOLine table an error comes up saying: "Header record is missing". What exactly is contained in this header record?

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…

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…

Need your solution, I am using Sage 500 ERP and the below issue is from client PC. in the server, the system works fine, but when I am trying to access from client PC I am getting the below error. I have checked the client ODBC connection and configured…

We want to import a csv file instead o manual entries to save time. I select file "Select Import/Export" select "General Ledger" and then we created a template for our import file. The fields are in this order Reference Description Number of Distributions…

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…

Does anyone know what the file format needs to be for the 1099 Beginning balance import function? i tried Excel and it kicked out immediately, i tried CSV and it's not reading the comma delineation. I did some digging and it sounds like it's expecting…

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…

Hi, I have built a DIM job for AP Vouchers on Sage 500 v7.90 and have it working properly but now I need to set it up to run every night unattended. How do I tell SQL or SSIS which company code to import the data into? My current Sage 500 database…