Sage 50 Canada

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…

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…

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…

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…

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

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…

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

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…

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…

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…

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…

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…

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.

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…

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…

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…