• Sage 50 CA integration

    I have an application that I need to have integrated with sage 50 CA.  I need to pull info and push back ap and AR invoices, projects and time entries.  Who can help me?

  • 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…

  • TotalTaxAmount SetTaxAmountByRow not working

    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…

  • 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…

  • 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…

  • Woocommerce and SAGE 50 Canadian version 2019.3 integration

    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

  • 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…

  • Deny sales invoice if customer is invalid

    i'm sure this is an easy fix, but i'm not sure how/what to do...

    I have a Small  VS C# console app that creates invoices in SAGE 50 for me.

    When i enter a existing customer name all is good, but if i make a mistake and the customer does not exist…

  • Handling 'This client often pays late. ' message

    Hi Guys, I'm fairly new to Sage 50 SDK 

    Quickly, i used the sample code and did some modification so it does what i need it to.

    I am using a easy peasy loop to read a SQL table and "copy" invoices into Sage.  

    i'm am getting issues with…

  • Can Sage 50 CA 2019 work with SAP Crystal Reports?

    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…

  • SDK - PurchasesJournal - Project Allocations on Line Numbers

    Hi there,

    We're working on creating an integration using our application and Sage 50 Canadian Edition.

    Currently working on creating Purchase Journal Entries - we want to allocate the line-item on the journal to a project.  In the example, it doesn…

  • Create a Receipt (Payment)

    Hello,

    Does any know how to create a receipt  for a invoice (receive payment) using the .net SDK or using SQL injection? If so could you please provide an example ?  

    I looked around in the SDK couldn't find any method which does that... i am guessing…

  • 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…

  • Three questions

    1 ) What is the best SAGE50 CDN supported method to get eCommerce data into Sage 50 CDN  without using a third party tool

    + That is customer, order and custom fees

    + Found SDK online, essentially a set of files that are imported into SAGE50CDN -- is this…

  • System.String Sage.Simply.Work.Repository.get_Func19() Error

    I upgraded our sage .Net SDK to 2018.0. 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.Instance.SetAlertImplementation…

  • 2018.0 SDK and System.String Sage.Simply.Work.Repository.get_Func19() error

    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.Instance…

  • Could not load file or assembly 'Sage_SA.Work, Version=1.0.0.1,

    Downloaded the Sage 50 SDK (Simply Accounting) that has C# Example code to run if we want to add information to Sage 50 Accounting Software.Nothing has been modified on my side yet but running the example code i am getting Following Error.

    Could not load…
  • Distribute to Client Computer

    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…

  • 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…

  • get invoice Number

    Hello,

    could anyone tell me how to get the created invoice number ?

    I have :


    SalesJournal salJourn = SDKInstanceManager.Instance.OpenSalesJournal();
    salJourn.SelectTransType(TransactionType.Invoice); // invoice
    salJourn.SetShipDate(salJourn.GetJournalDate…

  • Can't open Sage Connection using .Net ConnectionManager and EntityFramework

    I need to be able to read the Sage DB using EntityFramework (EF), and The SDK Connection Manager.

    Other users are currently working with this company. You may open the company in multi-user mode or wait for the other users to stop using the company and…

  • Testing Custom Software Integration - Sage Developer's License?

    How do I test my custom software integration with Sage? Is there a Sage developers license? Do I have to buy a normal Sage license, even though I only need it for testing?

    I'm specifically working with Sage 50 Canadian Edition, and part of my integration…

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