• 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…
  • Positive export unable to save file in a terminal server environment.

    Able to export and save the positive pay file to the Application Server or the Terminal Server, but unable to save the file to another location on the local network or tsclient. We can export other files and even the ACH file to a local network or tsclient…
  • 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…
  • How can I export any/all the email addresses in paperless office?

    I would like to have a list of all email address associated with every account, but I am not aware of a method to do this.