Hello all - I'm new to Sage 500 ERP and want to access the data tables using MS Access or similar product for ad hoc queries. I managed to find the tables on our server and link to them but cannot find the table containing general ledger balances - essentially the information necessary for viewing a trial balance (ending balances). I have read through the table listing and schema with descriptions of the various tables but the best I can find is tglAcctHist which contains debit and credit activity - but not balances. Does anyone have any suggestions?
Thank you!