• How do I find out where a data inconsistency is between debits and credits?

    I ran a data integrity report and everything is balanced except my total debits and credits.  I have run an "ALL JOURNALS" report going back to our first year of operation in 2011 and every year shows a balance between total debits and credits.…

  • Cannot Start a New Year

    I am running Sage 50 Premium Accounting with Payroll version 2021.1 and trying to roll over to a new year.  When I go into Maintenance -> Start new year.  The error that comes up is:  Sage 50 - Duplicate Entry.  You have entered a value that has been assigned…

  • Sage 50 Cannot open the database

    Environment : 

    Sage 50 version 2021 ( Canada ) recently upgraded from Sage 50 version 2020 ( Canada ).   

    The .SAI and .SAJ files are stored on Microsoft OneDrive. My https://ceo365portal.na.sage.com/ has been activated and the Microsoft 365 Integration feature…

  • Part 1 of 2: Sage 50 CA Data Conversion Tips

    You may have heard that the latest release of the Sage 50 CA  re-released version 2020.1 FULL product download  is now available (see KB 100797 or French KB 260-1009042,  the download's file size is 395 MB). Not sure which version you have installed? …

  • Simply Accounting Cannot Connect to Connection Manager

    Please I cannot start my Simply Accounting Set up.

    It keep telling me cannot connect to Connection Manager.

    What should I do.

    Will Need an URGENT ASSISTANCE

  • Sage 2019.2 - Get Open Invoices using Query?

    Hello would like to know if it's possible to get a list of all open invoices using  SDKDatabaseUtility RunSelectQuery command?

    I've looked around here and also the DataDict but can't really find what tables I need to link to get this data.  Any…

  • Can't start new year

    I spent the day reading forums and trying to find a solution and I don't know what to do even though I think I isolated the source of the problem.

    The problem : 

    I can't start a new year. When I do so I get this error message : 

    An error occurred…

  • Creating a new database file

    How would I go about creating a new database with a new fiscal year?

  • How to copy a company structure

    Hi,

    How do I copy a structure of a certain company? I have one existing company (a construction company) and I want to create a new company from scratch with the same general ledger codes and structure of the company.

    I searched for answers online but…

  • ODBC Connection Access Denied (Password error)

    Since we installed the latest upgrade for Sage 50 to Version 2018.0, we are unable to connect to the simply database with our third party software using a ODBC Connection.

    Over the past 10 years I have always managed to make the appropriate adjustments…

  • Retour à une date de session antérieure

    Bonjour,  

    Je suis dans ma première année financière. J'ai inscrit dans SAGE le 31 août comme date de fin d'année alors que cela aurait dû être le 31 juillet. Ma date de session est le 31 août. J'ai fait des écritures en août dont les paies. Que dois-je…

  • Needing to correct an error made in previous year after entering 2 months of data in our new year

    We have completed our year end, moved our systems forward, entered about 2 1/2 months of data into our new year. After this we found we had an error at the end of our previous year that has to be corrected. We went back and corrected the error in the…

  • InnoDB error- new install on Windows 10 Home

    Sage50 Pro 2013

    I am currently using a laptop, and trying to move to a desktop.

    The laptop was purchased new 9 months ago - was Vista "refurbished" to Windows 10 Home 64-bit before I purchased it.

    I installed the program with the offline installer…

  • How to check if there's issues with your Sage Database

    Scare tactics and money upfront requests are warning signs. Sage does not contact clients to warn them about their data issues. We cannot see percentage (%) levels of corruption. 3rd parties do exist for working with Sage Software data. This is useful…

  • Is it possible to import employee pay into Sage using the SDK?

    Is it possible to use the SDK to import employee pay into Sage? I'm thinking it would need to be able to create paychecks but if anyone knows of a better way for employee pay please let me know. I know you can import employees but I want to take all their…

  • SDKInstanceManager OpenDatabase always returns false and has no error messages

    Hi, 

    I'm trying to work through the C# sample project in the Sage 50 Accounting SDK (Simply) but for some reason I can't get the opendatabase connection to let me access the database. I have set up my user in the Sage app and I know my username and password…

  • Sage 50 Canadian SDK - how to do wSDBGetDBVer in c#

    I am trying to use some of the features described in the documentation that came with the SDK. In the doc, dev-progref.pdf, I've read about the methods and they all seem to start with wSDB. I've seen that the wSDB* methods can be called in C++ and VB…

  • How to find log in credentials for Sage 50 database

    I am trying to go through some of the code examples in the SDK, obviously one of the first functions that runs is the database connection function. I have tried sysadmin with various passwords but I can never successfully connect to the database to try…

  • What is the process to create Purchase Orders or Sales Orders via uploading a .csv file?

    I am a new user of Sage 50. I am trying to figure out how to create Purchase Orders or Sales Orders in Sage 50 via uploading an excel file (or CSV). Any help would be appreciated.

  • SDKInstanceManager.Instance.OpenDatabase always returning false with no reason why or error message

    I have a C# application that executes a call to SDKInstanceManager.Instance.OpenDatabase to open the data file but it keeps returning false, and it does not give any error message as to why. I have the proper parameters sent because this same data file…

  • Error when opening Sage Pro 2012 Database in Sage 50 Pro 2015

    I just installed Sage 50 2015 Pro.  Until now I have been using Sage 2012 Pro.  I'm having problems using my existing company file in the new version:

    It seems that Sage 50 2015 Pro is having problems connecting to the 2012 Pro version's company file…

  • EFT 2015 versus SAGE 50 2015.3

    Est-ce qu'il est possible d'exporter les informations de l'onglet Débit pré-autorisé de SAGE 50 vers EFT 2015?

    La connexion avec la compagnie se fait correctement pour les clients; fournisseurs et employés. SAUF que l…

  • ODBC connection failing

    I am trying to connect to the Sage 50 database using ODBC/My SQL connection.  In MySQL Connector/ODBC, I enter Sage username and password, , I select TCP/IP Server : localhost (database is local on this computer), I leave the port to default (13540), and…

  • dbClient.GetConnectionInfo(szFileDir, szHost, szPort) parameters

    I'm writing an application in VB.NET to run custom queries against the Sage 50 database. I've gone through the SDK manuals, but have some additional questions while walking through the sample code. We run the connection manager on the server and install…