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…

Hello all - I'm new to Sage 500 ERP and want to access the data tables using MS Access or similar product for ad hoc queries. I managed to find the tables on our server and link to them but cannot find the table containing general ledger balances - essentially…

Hi, Did anyone used to use the website http://www.sageusernetwork.com/ >? It used to give a brief description of ERP tables that were used in Sage 500 and also would provide a ERP Diagram to show relationships between tables. Would anyone know if…

FINRA Requirements for financial institutions are very vague and subject to a lot of interpretation. How does your firm meet FINRA requirements? Are you storing all your SQL backup files on WORM storage? Other financial reports on WORM? How long?

Will Sage officially support SQL 2016 with Sage 500 2016 release? Is it in the plan at all? If so, what might the timing look like? Thanks!

We use cieTrade and Sage 500, do you know if everything is updated on both sides to work with 2016 updates?

Is there a way to rebuild tarCustStatus? I looked through a few stored procedures and did not find any that do it (though I did not do an exhaustive search). Our Open Order Amount is wrong for one customer. Thanks

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…

Sage v7.4, Dec11Update A receipt of invoice batch is stuck at postStatus of 200 (module posting started) and batch status of "posting", postError of 0. tapVoucherLog records have status of 2 (pending). The batch is not accessible from Process Receipt…

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…

Over the past year or so, I have been tasked with writing data fixes for AR Cash Receipt Transactions that do not have all their records created when they are posted. In all cases it is hit or miss as to what records are not created such as tarCustPmtAppl…

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…