Browse By Tags

  • Get All customers, vendors details using .Net SDK

    Hello, How can i get data of all customers and vendors using .NET SDK ? In Development Guide I can see there is a method "Load by name", which can only return 1 Customer/Vendor. But I want to retrieve all the Customers/Vendors. Is it possible…
  • So where do we download the Sage 50 CA SDK now?

    So now that Sage has overhauled their website, I can no longer find a way to download the SDK. I used to be able to find it on the public facing site, but now they've made sure to make no mention of it. All the old links suggesting how to download the…
  • Integrate Sage 300 (non-cloud) with a PHP website

    Hello, We have a Sage 300 On Premise (non-cloud) version. We are looking to integrate it with our e-commerce website (PHP). We want to do two-way integration. 1) : From Sage 300 to website Customer invoice, order history, tracking information from…
  • 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…
  • ValidationException when building CustomerCreditMemo - Sage 50 SDK .NET

    Greetings all, We use the .NET SDK for Sage 50 to integrate our software with Sage 50. I've got a situation where we're trying to make a Credit Memo in our software to push over in to sage 50. During a relatively routine step, we are getting a Sage ValidationException…
  • Does Sage 500 ERP have restful web apis?

    Does Sage 500 offer the same set of web APIs that Sage 300 offers (Sage300WabAPI/swagger)?
  • 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…
  • Distribute to Client Computer

    Hello all, We've been using the SDK and everything is working great on our development box. However, we are now ready to distribute to our clients computer. The documentation seems pretty sparse in this regard. How do we distribute the SDK to our…
  • update onhand on MasterStockItem

    Hi, Is there any way to update the onhand qyt in a MasterStockItem from the SDK?
  • how to download sdk

    i am trying to integrate sage 500 with my application , but i am unable to find from where i can download sage 500 sdk ....can any one help me out ? thank you
  • 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…
  • 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…
  • Creating customer through API aka stored procedures

    I have been trying to create a customer in Sage 500 by means of sage provided stored procedures. To start with, I have my own stored procedure which creates a record in staging table, ie. stgCustomer. Thereafter, I invoke a stored procedure(api by Sage…
  • Are there any stored procedure to create/update customer and customer contact?

    I recently started working with sage 500 api which is really a set of stored procedures. At this stage, I want to create/update a customer as well as the corresponding contact. Does anyone have any idea of what stored procedures to use for this purpose…
  • Update Inventory Worksheet via SDK

    Hi Guys, I am having an issue while updating Inventory Counts in SAGE300. I have created the Macro but it actually does not update the Quantity Counted in I/C Physical Inventory Quantities. Has someone successfully updated /C Physical Inventory…
  • Cannot send journal to Sage 50 US via SDK importer

    I am trying to use the SDK (COM) to transfer a journal entry to Sage 50 (Peactree) but cannot make it work. I can see the import status screen flash out and there is no error occurs during the import; but nothing appears in the sage 50 journal entry report…