• Export data from Sage 50 CA using SDK

    Hi all,

    Is there anyone has an idea to export the data from Sage 50 CA? I was looking at the method w the class "CustomerLedger" but it has only the Save method it does not have the get method, Please let me know if you have any idea of hints to solve…

  • Sage 50 CA Alert issue with the SDK Import Invoice

    Hi 

    I am getting this error w the SDK import. 

    on this method objSalesJournal.Post();

    Error in ImportSalesOrder() Error: This customer order has not been printed or emailed. Record anyway? | Stack Trace: à SimplySDK.Support.SDKAlert.AskAlert(SimplyMessage…

  • So where do we download the Sage 50 CA SDK now?

    So now that Sage has overhauled their website, I can no longer find a way to download the SDK. I used to be able to find it on the public facing site, but now they've made sure to make no mention of it. All the old links suggesting how to download the SDK…

  • Set TimeSlips Payroll Income using C# .NET SDK

    Hello Friends,

    I am using SAGE 2019.2 SDK for importing time slips from my application.

    In sage, when I click on "Payroll Income ", its showing below payroll Items and I think, its coming from table "tCompPy5"

    I would like to do same…

  • How to set an item inactive through Sage SDK

    I am trying to make an item inactive through Sage SDK, but I am unable to find any method or property in InventoryLedger class to do the same?

    Anyone, please help me to do the same?

    Thanks in advance

  • Developing C# application for Sage 50 Quantum Accounting 2019.3 (Canadian)

    Hi Team,

    I am new to Sage50 SDK development in C#. My Sage version is "Sage 50 Quantum Accounting 2019.3 (Canadian)"

    Getting started understanding development process, I downloaded Sage50SDK20193 and installed it. Here i found C# sample code…

  • Sage 2019.2 - Get Open Invoices using Query?

    Hello would like to know if it's possible to get a list of all open invoices using  SDKDatabaseUtility RunSelectQuery command?

    I've looked around here and also the DataDict but can't really find what tables I need to link to get this data.  Any…

  • Get all active Sales Taxes

    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…

  • Sage 50 CA SDK and Delphi

    We program in Delphi and I’m attempting to access a Sage 50 2019 database using the SDK, question is, can the SDK be used in a Delphi environment ?  I’ve made a program (based on the C++, C#, VB code samples) to simply open (wSDBOpenDatabase) and…

  • SalesJournal SetShipDate The field you are trying to change or function you are calling is not accessible under current circumstance.

    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.".

  • SDK question

    Hi,

    can someone point me to the right place to ask questions about Sage 50 Premium Accounting (trial) SDK integration in C# ?

    Lots of support links and phone numbers are broken and lead nowhere..

    Also, I get asked a customer id, and a chat bot told…

  • inventory liste price

    I want to know if is it possible to change the all the price for an inventory item via c sharp app ? Here is an exemple of the code i use to update inventory item:


    If (SDKInstanceManager.Instance.OpenDatabase(saiFile, username, password, False, "Sage…

  • Is there a version of the Sage 50 SDK that can be installed for .NET Core on Linux?

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

  • SDKInstanceManager OpenDatabase always returns false and has no error messages

    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…

  • Sage 50 Canadian SDK - how to do wSDBGetDBVer in c#

    I am trying to use some of the features described in the documentation that came with the SDK. In the doc, dev-progref.pdf, I've read about the methods and they all seem to start with wSDB. I've seen that the wSDB* methods can be called in C++ and VB…

  • Add payments to invoices added through the SalesJournal?

    I am using the .NET SDK (C#) to export invoices and payments of those invoices from my own database into Sage50.

    I managed to create invoices (payment type = pay later) in the Sage50 db using the SalesJournal class.

    I now need to add payments for those…

  • Sage 50 - SDK Download

    Hi,

    I would like to know where I can get the Sage 50 SDK?

    Thanks!

    Simon

  • Where payment terms are stored for the customer in Sage 50 CA Edition?


    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…
  • Exist the price levels in Sage 50 CA?

    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…

  • Where stored the data returned by the function wSDBFetchRecord ?


    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…

  • How to capture the data returned wSDBSelectRecords in sage 50 2016 CA SDK with Visual Basic .NET?

    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…

  • SAGE 50 2016.0 SDK Unable to open company database with sample source code

     Anybody has an idea? Code compiles fine, using Visual Studio 2015, .NET framework 4, The program exits normally and shows Unable to open company file.

  • Strong-name signed assemblies must specify a public key in their InternalsVisibleTo declarations.

    Hi All,

    I am getting the message Strong-name signed assemblies must specify a public key in their InternalsVisibleTo declarations. when I am calling OpenSalesJournal in the 2015.3 SDK. The call stack is:

    System.MethodAccessException: [F:\Development\ServiceBox…

  • RE: […\Sage_SA.Domain.dll] Strong-name signed assemblies must specify a public key in their InternalsVisibleTo declarations” in the latest SDK (2015.3 CA)

    I've submitted enough bugs to know that my response of 'works on my machine' isn't terribly helpful.  But an error message without some code isn't test-able.

    If you have purchased the SDK, you have access to free support.

    If not, based…

  • dbClient.GetConnectionInfo(szFileDir, szHost, szPort) parameters

    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…