Sage 50 Accounts

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…

When running the report for supplier turnover, subcontractors who are nett and pay CIS tax, as it is a credit note automatically produced on your system, it is deducted from the turnover figure. We need subcontractor turnover figures to give to the…

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…

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…

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…

We need to upgrade one off our clients to Sage 50 v25 from v23. However, their Access database has ODBC links to the current version. Does anybody here know about the ODBC connector? Specifically, when we upgrade, will the ODBC links still work, or does…

Hi, Is it possible to do subqueries when connecting to Sage 50 via ODBC connection? I would like to do something like: SELECT AUDIT_HEADER.INV_REF, AUDIT_HEADER.DETAILS, AUDIT_HEADER.DATE, AUDIT_HEADER.DUE_DATE, AUDIT_HEADER.NET_AMOUNT, USAGE.AMOUNT…

Hi! Could you provide any information or URL - where I can see the working an example for insertion of a new record to Sage DB via ODBC connection? I can read the data easy but not update and insert. Or it is not possible at all? All my…