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

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

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

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

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

  • 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…
  • #C and SDK issues

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

  • Is it possible to import employee pay into Sage using the SDK?

    Is it possible to use the SDK to import employee pay into Sage? I'm thinking it would need to be able to create paychecks but if anyone knows of a better way for employee pay please let me know. I know you can import employees but I want to take all their…

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

  • How to find log in credentials for Sage 50 database

    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…

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

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

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

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

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