• 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!
  • 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…
  • Payroll last name field length?

    Just hired employee with a last name greater than 15 characters. We are on version 4.5 and it appears the field length is set to 15 characters. Has anyone had this issue? If so, could you share your resolution.