x Want to participate? Join the group to interact

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

  • Datetime fields ALL no longer allow nulls

    We've recently moved from Sage 100 providex to SQL. Upon looking at our tables in SQL it appears that every field of type datetime now has been set to not allow null values. As a result all of those fields now automatically populate with 1753-01-01 (SQL…

  • AR TRANSACTION TYPES

    Hi, I'm writing a query of my Version 4.5, I need a listing of TransactionType used in AR_TransactionPaymentHistory and what mathematical sign should be used with each in creating a report in Excel. I know about the following Transaction Types: I, P…

*Community Hub is the new name for Sage City