• ODBC Database tproject dSExpBalNY entries not matching Job Allocation Expense reports.

    I am trying to setup Power BI to be able to view data from Sage 50 Canadian Premium. I can access data tables, and specifically tproject using an ODBC connector. dStrExpBal (starting balance) for a project is correct, which is up to and including LAST…
  • Inventory out of balance

    I have never used the inventory feature of Sage as I've never had a client that needed it. Now one of my existing clients opened up a small shop. I took all the invoices of the items she purchased and entered the quantity & value of the goods on the history…