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

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

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

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

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

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

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

  • Any Update on this issue

    Hey Guys,

    Any update on this issue iv been looking all over the internet for a solution to this issue. I have .net 4.5.2 installed on my machine and the target framework set to 4.5.2 to no avail any other suggestion would be greatly appreciated thanks…

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

  • How to Get entered Invoice (Purchase/Sales)

    Hi,

    I have to export bill from My Application to Sage 50 Accounting. I am able to add bill but not able to get entered Invoice ID. I have to get inserted invoice Id.

    Sample Code:

    PurchasesJournal purJourn = SDKInstanceManager.Instance.OpenPurchasesJournal…