x Want to participate? Join the group to interact

  • ODBC link to Excel in current year before the ledgers are closed for the prior year

    Hi, I have the ODBC link set up to extract info from Sage for our monthly accounts, by month and nominal codes. We don't close our ledgers until our Stat accounts are completed so the ledger is still showing prior year. Is there a way I can change…

  • Empty Sage50 database table : Connection with Power Bi/Excel

    Hi, I am a business intelligence developer in my company, importing data from sage50 database into Microsoft Power bi right now. One specific table, Update_Ledger, is not showing any data and this is the main table for our reporting needs. Why is it…

  • ODBC Date Conversion

    Hi All, Hopefully someone has dealt with this issue before ODBC links are set up and usually work fine as lone as I don't use anything beyond SELECT, FROM, WHERE, AND, GROUP BY and ORDER BY However, I want to convert a date field to "MM-YY" for…

*Community Hub is the new name for Sage City