Browse By Tags

  • 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.". I am getting…
  • Sage 2018 - upgraded to 2019 and then downgraded back to 2018, now API won't work

    We have written a program for one of our clients using the Sage Peachtree API. Every time they upgrade versions, we always have to get the latest DLLs and rebuild our app to make it work again. However recently they say that they installed Sage 2019,…
  • SDK and Updating Employees

    FormerMember
    FormerMember
    When we hire new employees where I work, we have to create accounts in all kinds of different programs. Plus create windows accounts and email accounts. I wrote a Information Management Program that I have connectors to all our programs (all Microsoft…
  • Getting PeachTree API exception - Entity is read-only

    FormerMember
    FormerMember
    The company account is accessible through the desktop Sage 50 US Edition just fine. When we try to access through our app that uses Sage API to access it gives the following message. ANyone knows what the issue is? WIndows 2012 Server R2 Sage 50…
  • NullReferenceException when creating invoice line items

    Getting this error when I try and add lines to a new sales invoice: // Create invoice var invoice = Company.Factories.SalesInvoiceFactory.Create(); // Invoice #, Date, Customer ID invoice.CustomerReference = customer.Key; invoice.ReferenceNumber…
  • There was a problem opening company.: (inner exception: FileNotFound)

    var companyId = GetCompany(); try { // Request authorization from Sage 50 for our third-party application. AuthorizationResult authorizationResult = Session.RequestAccess(companyId); This line Session.RequestAccess throws a PeachtreeException: FileNotFound…
  • 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?
  • CriptographicException and System.InvalidOperationException

    I can hit all the sample databases and my private database locally; however, when deployed I get this exception: System.Security.Cryptography.CryptographicException","StackTrace": " at Sage.Peachtree.API.PeachtreeSession.VerifyOrRequestAccess(CompanyIdentifier…
  • 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…
  • 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. I´m Working…
  • 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…
  • Sage 50 2016 SDK - The type or namespace name 'Sage' could not be found (are you missing a using directive or an assembly reference?)

    Hi, I tried to connect to Sage 50 2016 but It is impossible, when I compile my code, I get this error: Error 4 The type or namespace name 'Sage' could not be found (are you missing a using directive or an assembly reference?) It is a little weird…
  • 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…
  • Purchase orders and character limits

    Currently i am working on a program meant to create purchase orders using excel files to import some data into said order. So far the only problem i seem to keep having is that certain things, such as the Term and Address fields have a "Character limit…
  • SDK Getting Started

    I am a senior developer who is VERY new to Sage. I haven't ever used it or even seen it. A client wants me to use the SDK to get some very basic invoice and payment information out of Sage 50, but even the "Getting Started" info around here seems a little…
  • setting the ReferenceNumber when creating (importing) a new SalesOrder into Sage50

    Hi, What is the recommended way to set the ReferenceNumber when creating a new SalesOrder. Currently I'm doing this: var invoiceList = sageCompany.Factories.SalesOrderFactory.List(); invoiceList.Load(); var top1 = invoiceList.OrderByDescending(x …