Browse By Tags

  • Payment Batch Import Into Sage 300

    Hi, Could someone please share what fields are necessary to do a payment import into Sage 300. It keeps giving me the error that 'Invoice Number Cannot Be Blank' but the IDINVC field in the Applied_payments tab is not blank. Could someone share…
  • Best option for extracting data out of Sage 100 into Third-Party software

    We are looking at a Third-Party software called Master Control for our QA/QC documentation processing. With that, we want to be able to extract data out of Sage 100c Advanced v2019.2 (upgrading to v2021 shortly) from Scanco's Manufacturing module, as…
  • 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…
  • How will you make a mass update to HRMS if you haven't been tracking deductions in HRMS?

    Deductions for 1/1/2020 - How will you make a mass update to HRMS if you haven't been tracking deductions in HRMS? We have HRMS and Timberline. We use a 3rd party for Benefits Open Enrollment and monthly maintenance and enrollment. Every year we have…
  • 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…
  • Does Sage 500 ERP have restful web apis?

    Does Sage 500 offer the same set of web APIs that Sage 300 offers (Sage300WabAPI/swagger)?
  • 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…
  • 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…
  • #C and SDK issues

    FormerMember
    FormerMember
    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…
  • 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?
  • OE import error "Negative Inventory Levels"

    Hi All, I have performed an OE import successfully in most of the cases. However, I have encountered the captioned error for some items at zero stock level at the moment which could be imported as OE successfully for one OE, but not the others at different…
  • SDKInstanceManager.Instance.OpenDatabase() always return false

    Hello, Suddenly today our software was not able to have a successful call to SDKInstanceManager.Instance.OpenDatabase. Since were still running on SDK 2016.2, we decided to updated the Sage 50 “Simple Comptable” , the Connexion Manager on the server…
  • access to database

    hello i want to access sage 500 database , i am creating an application where we get the data from the client and we are going to run few calculations and implement it on sage 500 thank you
  • 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
  • Sample ODBC/SQL queries for getting Sales Order information, Customer Information, and inventory information?

    Can anyone offer any sample SQL scripts for getting information, such as Customer Information (given a customer ID), sales order information (given a sales order number or customer ID), and/or inventory information (given an Item ID) out of the database…
  • How do I know if the connection to the database is open ?

    I´m working with sage 50 CA 2016 SDK, and i have a problem with database connection. When I run this code in a console application successfully opens the connection, but when I run the same code in a Winform application , does not open the connection…
  • 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…
  • 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?
  • 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…
  • 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…