Sage 500

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…

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…

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…

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…

I am trying to get the GL Import working for our budget and read that the best way to get the import format is to export the budget data from GL Utilities and modify it with the updated data. I am using the delimited file and have finally gotten the import…

I'm hoping someone can assist me with the set up of Metadata. I'm attempting to import cash receipts using dataporter. The only piece I have left is how to code Metadata to hit finish. I was able to key in the tabFunction to apply to the invoice but I…

Starting with version 2013 (possibly earlier), and persisting through the latest MU of version 2014, we seem to have lost a valuable feature in BIE. In the past, one can create an Excel "template" file that uses the data exported by BIE in the SourceInfo…

We are still on 7.3 of Sage 500. I have a boatload of new Natural Accounts/GL Accounts, and they all need to be inactive for the remainder of this year, and then all of them activated when the new year 2015 begins. Is there a way to import the new accounts…