• accounts payable tables

    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
  • How to pass company ID value while running a Data Import Manager job through a SQL scheduled job?

    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…
  • FINRA Requirements

    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?
  • Sage 500 7.3 GL Acct Import for Inactive Accounts

    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…