x Want to participate? Join the group to interact

  • Looking to Export AP Payment Transaction History-System Limiting Export

    When exporting payment history for AP I am only getting a few years information. If I run a report I can see the system has 20 years worth of data but its only giving me 2+ years which is more like just the time frame for viewing in the system. I tried…

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

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

  • Visa Commercial Format (VCF)

    Has anyone used Visa Commercial Format (VCF) with MAS 90? I've been told I need to export a file in "VCF" format. Is anyone familiar with this requirement? Thanks.

*Community Hub is the new name for Sage City