Browse By Tags

  • Sage 300 SDK read function

    Hi all, I am trying to read the vendor using SDK, But I dont get any result with that, Can any one help me how to make a call to read all the vendors using Sage SDK? Thanks
  • How to set date range for customer export? sage50 api question.

    Im exporting sage50 customer details in this code. Please let me know how can I set date range to the exporter object so that will pull only contact updates within certain dates. Code- exporter = (Export)ptApp.CreateExporter(PeachwIEObj.peachwIEObjContactsList…
  • Incompatible Company Version Exception

    I went to deploy a desktop application on a clients machine after completing development and testing. Upon authentication, I get the following exception message. I verified that we are using the same version of Sage50 and the build number. Does anyone…
  • 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,…
  • 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…
  • update onhand on MasterStockItem

    Hi, Is there any way to update the onhand qyt in a MasterStockItem from the SDK?
  • 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…
  • 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…
  • 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…
  • C# GetApplication returns null with Peachtree 2008

    I am creating an automated import of Purchase Invoices for a client who is using Peachtree 2008 Premier, and I've downloaded Sage 50 2016.0 SDK. I'm using the credentials that were provided when I downloaded the SDK and the function returns NULL. When…
  • 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 …
  • Add "date due" into an invoice from API SDK

    Hi, I am developing an application to enter an invoice to Peachtree using the API .NET SDK for Sage 50 2013 , and I want to set the date due into the invoice object ( I noted that the property is visible and it can accept a nulleable value) but when I…
  • Upgrade to 2014 Sage-50 US edition causing me major headaches

    Hello, I was prompted to perform the upgrade to 2014 Sage-50 US Edition. Was prompted to convert database. Afterward, when I attempted to use the Sage .NET API to talk to it, I ran into errors... Sage.Peachtree.API.Exceptions.UntranslatedException…