Sage 50 Canada

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, I am trying to update invoice's total tax using below code TaxSummaryInfo taxSummaryInfo = journal.GetTotalTaxAmountInfo(); if (taxSummaryInfo.GetCount() > 0) { double totalTax = 10; taxSummaryInfo.SetTaxAmountByRow(1, totalTax); taxSummaryInfo…

Hi, I am trying to get all active Tax Codes and iit's taxes using .NET SDK. From tTaxAuth table, I can get all Taxes ,from tTaxCode I am able to get all taxcodes and from tTxCdDtl table I am able to get Tax rate for each Taxcode's tax. I have removed…

I would like to create a web service that can run on a Linux host. Is there any way to do this?

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…

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…

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?