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 fiscal year. However, dSExpBalNY (new year expense balance) does NOT equal the amounts allocated to the job in all 5000 series accounts (across the board); some are higher, and some are lower. 

It may be that I don't understand what dSExpBalNY is, but according to the dictionary I believe my understanding is correct: https://www.sage.com/na/~/media/site/sage-50-accounting-ca/PDF/intelligence/DataDict_2013.pdf

Why are these values not matching up? Or more importantly, where can I find the current fiscal year's job allocation expense balance?

Phil

Here is the table extract from the Sage database (ODBC):