Sage 500

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)…

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…

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

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

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…

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

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…

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?

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…

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.

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…

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…

We are having difficulty using the SO Import Utility for a secondary company setup in our SAGE 500 (2013) system. It works fine for our main company, but when we try and use it for the 2nd company it just fails - no real error message. Sage support…

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.

HI, Instead of manually keying in data, we want to have the option to import a .csv file. How would I set this up? I added an image below that shows our current view next to our desired view? Ben

I would like to import orders into our Sage system although the problem is that this is a very old version of sage 500 V7.2. Could anyone please confirm whether this is possible and whether it is native to the application or whether this would require…