Welcome to the Sage 50 Canada Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
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…
Hi,
I'm currently making a third party app for a client using Sage 50 Quantum Accounting 2019.3(26.20.0.2) but I have been given a 2019.0(26.0.0.1) version of the SDK, which is not letting me use it: Message from recources (english version):
I've…
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 have Sage 50 Canadian Accountant company file and following setting are configured in it.
HST tax name is setup
Tax code H is setup and mapped to HST Tax name
For Receivable accounts , Tax code H is setup for new customers sales
…
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…
I upgraded our sage .Net SDK to 2018.0. And from .Net 4.5.2 to 4.6.2. But now when I run our application and try to access sage data I get an exception: System.String Sage.Simply.Work.Repository.get_Func19()
on this line of code:
SDKInstanceManager…
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,
I've developed an internal web application that leverages the Sage 50 Accounting SDK to generate invoices. When I run the app on my local IIS environment I don't run into any problems, however once the app is moved to the live server (the location…
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´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…
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…
I'm trying to obtain a balance for an account via the SDK and am unable to figure out how to do this. Can anyone shed any light on it? It appears that the SDK is very limited, and poorly documented.
Hi everyone
I am looking for example of exporting sales invoice as XML using SDK Sage 50 Canadian Edition 2014.3 July
I couldn't find anything like that in docs that came up with sdk .
Hi,
I got Sage 50 Accounting SDK to develop import utility for invoice. I am facing some problems with this SDK. I tried to make sales invoice with discount rate 5.75. It accepts 5.75 as double value. But in this software , it is calculating for 5.00…