• 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…
  • Have a problem accessing the company data in network

    Hello, I have a Simply Accounting Premium 2008 version. I have recently added another computer to the network (the 2 computers are connected using an Ethernet cable) and I have access to the company data and back up from the second computer (read/write…
  • Sage 50 Quantum - Create a Positive Pay File

    Has anyone ever created a Positive File for Sage 50 Quantum version?
  • "Unable to open company file" message returned

    Hi all, We're developing a COM-aware .Net assembly that is used in a legacy VB6 app and keep getting the above message when opening a connection via SDKInstanceManager.Instance.OpenDatabase. When we call our method from inside another .Net assembly…
  • 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…
  • Multiuser issues

    I was recently added as a user on Sage 50 premium CA and we have discovered that anything I post/enter is not updating/transferring to the other users and vice versa. We have installed the new update and refreshed multiple times, but nothing seems to…
  • Sage 50 CA Clean Re-Install Tips

    Does your machine have lots of old installs of Sage 50CA? Are you looking to wipe your system to "start" fresh? Below are resources on how to backup your data, wipe your system of Sage 50 install history and then re-install and restore your company data…
  • 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…
  • Advanced the year too far in Sage 50 CA?

    What happens if you've advanced your year too far into the future in Sage 50 CA and don't have the option of launching a backup and or don't have time to re-input all the current year entries? In other words, say it's 2020, you've created the 2020 year…
  • Which table/field stores the transaction comments/description and JE# in Sage 50 Quantum Accounting (Release 2019.3)?

    Which table/field stores the transaction comments/description and JE# in Sage 50 Quantum Accounting (Release 2019.3)? I am referring to the comment column and JE# values when you run a General Ledger report.
  • Can Sage 50 CA 2019 work with SAP Crystal Reports?

    Hi, I know that the Sage 50 US edition 2019 works currently with SAP Crystal reports, but I just want to confirm if SAP Crystal Reports can also work with Sage 50 CA 2019? I saw in SAP Crystal reports knowledgebase that they can work with data source…
  • 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?
  • Multi User Mode

    FormerMember
    FormerMember
    Our business is expanding and we need to work on Sage 50 on more then one computer at once. Does the Cloud do this or do I need to buy a multi user edition?
  • 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…
  • Sharing data file simultaneously

    FormerMember
    FormerMember
    Hello, how can my client share thier "sage 50 pro" data file with me (I have the accountant edition of sage 50), so i can work on thier file remotely? And simultaneously? Also, is there a link and/or video that discusses the information to show the client…
  • Top 3 items to do when setting up a new company

    New to Sage 50? Or do you just need to re-create a database? Here are the top 3 tips to help get you started after you've installed and activated your software. For full details see KB 29934 . Tip #1: Talk to your Accountant and Set Fiscal Start and…
  • 4 Steps for How to get Windows to trust Sage 50 to Stop Slow Performance or Crashing

    Sage 50 wants full Administrator Rights to run processes and services in the background of the Windows Registry. Newer operating systems like Windows 11 crack down on this behaviour, especially when recent updates are released. When running as administration…
  • Upgrading MySQL Connector/ODBC from version 5.2.4 to 5.3.8

    I was going through and trying to update one of the servers we have and found an older version of the MySQL Connector/ODBC and was wondering if anyone has had any experiences with upgrading the ODBC Connector from version 5.2(a) to 5.3.8 for "Sage 50…
  • 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…