Browse By Tags

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…

We set up SQL replication last week and it is working well. However I am having trouble finding where our HH2 imports actually end up in the SQL database. We import a HH2 payroll each week via the import tool in Payroll > Tools > Import Time... Where…

Hello. We are attempting to get two years of pay history out of Sage 100 as well as other employee information. I have attempted to use an Excel Query, but I really have no idea what I am doing. Where do I go to find an expert that knows how to retrieve…

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…

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…