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

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

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

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

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

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

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

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

  • Receiving a Payment via SDK

    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?