Sage 500

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 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?

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…

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…

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…

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…

Hi all, I would like to import customer and sales order details in Sage 500. Any API/ Web service example is available in vb or c# ? Please let me know if documentation is available for API or Web service list. Thank you.

hello! we're working on automating processes and making use of data export and imports. the feed from our credit card service can include a return transactions, and consequently a negative numbers. the data import process is throwing a fit saying…

Hi I'm trying to run a using upload manager a way to update payments. I see that there's an AR pending payments, but i can't find an AP pending payment. is there one? and if so, where can i find that? what's the name of the destination entity? …

We have been importing Journal Entries for year through the GL Import, however we decided to begin to import more Journal Entries to save time. Currently when we are importing the system will assign a Journal Number to it but it there a way for us to…

hello i want to access sage 500 database , i am creating an application where we get the data from the client and we are going to run few calculations and implement it on sage 500 thank you