Sage 100

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…

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…

I am creating a cross-tab report in crystal reports based on AR_InvoiceHistoryHeader and Detail. I am trying to summarize the number of shipped units per month for a particular year. I have this working fine, except that if there is no data for a given…