• Posting an invoice, line items getting added.

    Our software imports invoices into Sage 50 Canadian edition via the SDK. For a couple customers, it seems line items are getting added in that we are not creating when the invoice is posted. 

    After trolling through the database it seems like these line…

  • Anyone have the Sage 50 2019.3 SDK?

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

  • Getting data out of Sage50cloud programatically...

    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…

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

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

  • SDK 2020.1 not working after Sage 50 2020.2 update

    Hi,

    Our job control system exports invoices to Sage 50 (Canadian Edition) using the latest version of the SDK 2020.1. We had to update Sage 50 to version 2020.2. which includes the up-to-date tax tables. According to Sage Support, there won't be an update…

  • Querying and Creating New GRNs

    I'm working on an application that takes in a structured .csv file and can't find any information on how to query and create new Goods Received Notes. I know that parts of them are stored in the titrec and tjourent tables, but adding to them manually…

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

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

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

  • DLL reference

    This is probably pretty straight forward, but could someone point me in the right direction? I am new to Windows programming, and even though I followed the SDK and have copied all the respective dll's into my development folder, when I try to open a…

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

  • Sage 50 Canadian 2019 SDK

    I have a customer that upgraded to Sage 50 Canadian 2019 and I can not find the SDK. When will the SDK be available for Sage 50 - 2019>

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

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

  • If anybody meet the same problem?

    I meet a wired problem when I am upgrading export interface for Sage 50 2016. I am not sure what is the exactly reason cause the problem even I seemed find a solution. I just public some codes here, could anyone take a look and give me any advice? I modified…

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

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

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