Sage 50 Canada

I am setting up my website with Wix and am wanting to integrate my Sage 50 to it, for speed and efficiency. Is this available? (I know it is for Quickbooks, but I am happy with Sage and do not want to jump ship) If not, is it in the pipeline? James…

I'm not sure if this is the right place for this, so excuse me if not. I'm trying to extract data from Sage fully programmatically (no user intervention required). We have a "hybrid" setup where the data is in the cloud (sort of?) and also on local MySQL…

Hi, Our job control system exports invoices to Sage 50 (Canadian Edition) using the latest version of the SDK 2020.1. We had to update Sage 50 to version 2020.2. which includes the up-to-date tax tables. According to Sage Support, there won't be an…

I'm working on an application that takes in a structured .csv file and can't find any information on how to query and create new Goods Received Notes. I know that parts of them are stored in the titrec and tjourent tables, but adding to them manually…

Hello Guys, Anybody know here how to integrate SAGE 50 with WooCommerce Wordpress plugin? Is there any good solution available in the market? We are using SAGE 50 Canadian version 2019.3 Thank you. Rahul

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…

Hello Friends, I am using SAGE 2019.1 SDK for importing invoice in my application. I am getting error at the time of SetShip date "The field you are trying to change or function you are calling is not accessible under current circumstance.". I am getting…

Hi, A little background... We were asked by a client to create a.Net application to do a few things. The more effort we put in the less success we seem to be having. We are trying to create POs, Time records, and add Cost Codes to the DB. Reading…

Hello all, We've been using the SDK and everything is working great on our development box. However, we are now ready to distribute to our clients computer. The documentation seems pretty sparse in this regard. How do we distribute the SDK to our…

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'm working on extracting data from the database sage 50 CA, but in the documentation containing the data definition , I have not found the relationship of the payment terms with customers, or where it is stored ( table). Here is the information that…

I'm working on the integration of Sage 50 CA with a third party application with .NET. And price levels are within the required information extracted from the database Sage 50 CA, but so far I have not found any information to verify the existence of…

I'm trying to extract data from tables in the database Sage 50 CA 2016, with a Visual Basic application that uses the SDK Sage 50 CA (Simply.ConnectionManagerService.dll). I'm using the function "wSDBSelectRecords" to extract the data And then I 'm…

I´m using ConnectionManagerService.dll and I am using the function wSDBSelectRecords with this syntax: Call wSDBSelectRecords(iDBLink, iTBLink, "", 0, True) But I do not know how to capture the data you are going to select in a DataTable. I´m Working…

Hi, I'm setting up a new POS system (VendPOS) to work with Sage50 2016. I've been playing with the import utility and can create a compatible .IMP file to upload new sales invoices and customers to accounting. Is there a way to modify existing records…

Does anyone have an example of how to receive a payment via the Sage SDK? It's looking to me like you have to go directly at the tables (which is a HUGE gap in the SDK in my opinion) but that sounds risky. Anyone know how to do this?