• ODBC Database tproject dSExpBalNY entries not matching Job Allocation Expense reports.

    I am trying to setup Power BI to be able to view data from Sage 50 Canadian Premium. I can access data tables, and specifically tproject using an ODBC connector. dStrExpBal (starting balance) for a project is correct, which is up to and including LAST…
  • sage 50 database verification tool has found a problem in your company file that it was unable to fix

    Sage 50 is not allowing me to go in new year and shows the message to check the data integrity through Advance database check. While following the message, it shows the message "sage 50 database verification tool has found a problem in your company file…
  • Transaction Data Import

    I'm installing Sage 50 Premium in a Convenience Store which has a POS system. This POS system generates a plethora of reports & data, all of which is available in Excel format. The daily sales report it generates would be the feedstock for the SAGE invoicing…
  • Simply Accounting 8.5B database repair before upgrade

    I need some contacts for help to repair our Simply Accounting 8.5B database before we proceed to upgrade to the current version of Sage. I spoke to Sage Support and they indicated they have a "Repair for Conversion" service to repair the company file…
  • 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. Where else…
  • 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…
  • 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? See…
  • Simply Accounting Cannot Connect to Connection Manager

    FormerMember
    FormerMember
    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
  • 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

    FormerMember
    FormerMember
    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…
  • 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…
  • Needing to correct an error made in previous year after entering 2 months of data in our new year

    FormerMember
    FormerMember
    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…
  • 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'information du compte bancaire…
  • 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…