x Want to participate? Join the group to interact

  • Sage ODBC with Sage 100 V2020

    I am upgrading a client to Sage 100 V2020 and am running into issues with some Excel spreadsheets that have been working for years in prior versions of Sage 100. In V2020 the client upgraded their Excel version from 2013 to Excel 365 Enterprise 64 bit…

  • Pull posted AR invoices to a table when 5 companies are setup.

    I'd like to pull posted AR invoices from each of our 5 companies and update a table daily. Can anyone tell me how to find/distinguish the data for each company? Any recomended procedure to pull this data to the table? Thanks for all responses!

  • Need to pull invoices from AR tables.

    Is there an ERD or easy way to identify the AR Invoice tables. We are using SQL Server as our database and trying to pull the daily invoices to a table. We currently have about 10 companies setup and need the data from all companies. Thanks

  • 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