Browse By Tags

  • Intermittent "[ProvideX][ODBC Driver]Internal error"

    I am encountering an intermittent "[ProvideX][ODBC Driver]Internal error" within an Excel workbook containing several worksheets, each of which contains a Microsoft Query (MSQuery) to various Sage 100 Advanced v. 2019 PU 2 files/tables. The query results…

  • Pulling data from Sage 50 Database with ODBC at a specific time in the past to produce a trial balance

    FormerMember
    FormerMember
    The current situation : We are using ODBC to pull data from the Sage 50 database to Excel. For example, if we pull the table taccount from the database we get the table with the GL accounts list and the amount at the present time. It produces a trial…

  • Direct DB Connections via Connection Manager | Changing Port #s

    Hi folks, I have a client that uses Sage 50 (2018.1 + Connection Manager v7.0). They host Sage on a MS Azure server. They have 6 Companies (DBs) that I'd like to be able to connect to so that I can pull some high-level data into a custom reporting tool…

  • Sample ODBC/SQL queries for getting Sales Order information, Customer Information, and inventory information?

    Can anyone offer any sample SQL scripts for getting information, such as Customer Information (given a customer ID), sales order information (given a sales order number or customer ID), and/or inventory information (given an Item ID) out of the database…

  • GL -> Account Inquiry -> History Best way to extract similar info for external report

    I'm looking to pull the current balance of the GL for each account, basically exactly what is in the History Tab of account inquiry. Whats the best way to accomplish this? I've looked around the GL tables for any sort of summary. Will I have to sum the…

*Community Hub is the new name for Sage City