• Connecting via ODBC

    Hello everyone, we are looking to connect to Sage 50 data as a third party for enhanced reporting. Our goal is to use the ODBC capabilities to access the data. We are trying to access the data from over the internet via ODBC and report through Microsoft…
  • 64 bit ODBC driver?

    I saw a link from over a year ago to an Actian page. It requires a login. Is there a 64 bit driver. I just did the install of the latest Sage 50 and an ODBC driver a couple months ago. But all I have is a 32 bit version. I have Access connected via…
  • Bar Coding Inventory

    We currently use Sage 50 US and are looking at bar coding our inventory for a more accurate and efficient method of managing our inventory. We are a small company of 20 employees so I am not looking at anything more than 1 or 2 users. I have not been…
  • exporting reports to excel

    I used to be able to export balance sheets and income statement to excel where the headers would be included in the body of the report. Recently, when I export the same reports, I cannot get the headers to be included in the body of the report. Why…
  • Sage 50 2020 with Intelligence Reporting - won't connect

    Upgraded to Sage 50 2020 and Intelligence Reporting does not work. It starts, it connects, but does not execute any of the reports. Tried others than the custom that was created. Is there a different version of Intelligence Reporting to install?
  • GL Source Codes

    Hello Everyone, How we can get the data from Sage 50 US ( Accountant Edition 2019) ) for GL Source Codes, Hierarchy of Account Segments using COM API or .Net API?
  • ODBC access counts as active Sage50 users

    I'm looking a Sage documentation that says third party applications entered using CrystalReprts.UDL file counts as active users. When I use an addon, Sage50 says the maximum number of users .... Does anyone have information about this?
  • Intelligence Reporting Error

    Whenever I try to open the Intelligence Reporting on Sage50, I get an error that says: "To use Sage 50 Intelligence Reporting, you must have Microsoft Excel 2003 or higher installed on your computer." I definitely have Excel way beyond 2003 (and…
  • Window 10 Sage 50 and Crystal compatibility - GetPeach Functions not working

    Does anyone know how to get the GetPeach Functions working in Crystal after upgrading to Windows 10? We have confirmed that the file U2Lpeach.dll is installed on the machine and Crystal can clearly see the functions but it can't seem to pull the data…
  • UFL 'u2lpeach.dll' that implements this function is missing. Error in File...

    I'm trying to run a report in visual studio using asp.net. I had other issues before with version and running it with visual studio 2013 so ended up doing a simple application in visual studio 2010 with framework 2.0. A report will work fine unless…