Browse By Tags

  • Nominal Ledger Activity Data import into Microsoft Power BI

    Hi, I am a Business Intelligence Developer in my company and importing data from Sage 50 accounts database into Power BI using sage ODBC driver. Nominal Ledger table has data at month level but now, our requirement is data at the invoice level. There…

  • Sage 300 - sql query for recalculating AP Balances - reconciling to GL

    Hi, I am trying to determine why my GL and AP control accounts dont balance. Yes, I know I can isolate GL only transactions from my control account, but I would like to build a more robust answer. To this end, I would like to build a query in sql…

*Community Hub is the new name for Sage City