Browse By Tags

  • Sage50 Third party integration

    Hello, I am looking for help with the integration of Sage50 and a third-party software. Can anyone help me?
  • Looking for developers wihh US Sage50 Integration

    Hello, I have a client in EU that needs to hire a developer for an integration with Sage50 Accountant and other versions in the US. Can anyone help me?
  • SAGE 50 SDK - Company Open Works on Server but not on Workstation

    I have written an application to post general journals to SAGE 50 using data from a point of sale application. The program works fine on the server where the company files are located but when we moved the application to a workstation where the accounting…
  • 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…
  • Sage 300 CRE JDBC connection via Pervasive

    I am trying to connect to Sage 300 CRE via JDBC. I understand that Sage is built on pervasive and I am able to connect to the default pervasive database called demodata and read tables. i am looking for guide to read Sage specific tables using this…
  • Connection between Sage 50 US and Sage Intacct

    Hello everyone I am wondering if it is possible to share information between these 2 Sage products. A customer uses Sage Intacct and I would like to know if it is possible for these 2 to interact. For example if in Sage 50 I register invoices or purchases…
  • Import Unit Cost for Inventory Adjustments with the COM API

    I'm trying to import the Unit Cost field among others for Inventory adjustments via the COM Interface. For some reason this one field likes to remain at 0.00 even when making a positive adjustment with a value greater than 0.00. Here is an example of…
  • Use of REST with locally installed applications (sage 50 quantum)

    Hi, All wise and mighty sage pros! I am an integrations developer and have been for over 30 years. Having worked with MANY api's I don't think my question will be so much a challenge but rather just details I don't yet know ;) I have had many…
  • Accounting Period

    I've found how to get a list of the Accounting Periods through the SDK (Using .net API). Is there a place to find the current period so I'm not entering or updating records from an accounting period?
  • Integration with Rails app 2019

    Hello and good day to all. I'm looking for a way to access SAGE 50 endpoints for purchase orders, invoice. inventory etc through our front-end system built in Rails. The ideal solution would be through an API which I couldn't find any suitable yet.…
  • 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…
  • SDK seeking permissions every time

    Hi, We are trying to build up an application using the Sage SDK to create invoices in the Sage 50. In our testing , we found that the Sage SDK is prompting for the user to give permission every time (even if it is same company file that we gave permissions…
  • Accessing Sage 100 Contractor 2016 Database with Microsoft Access 2010

    How can the Sage 100 Contractor 2016 (version 20.4.51.0 or greater) databases be accessed using Microsoft Access 2010? I would like to link to the data source by creating a linked table. To do this I have created a Machine Data Source using ODBC in…
  • 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 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…
  • What options do I have to utilize API for grabbing real time data?

    Wondering if anyone has experience with an integrator or service that could help me pull real time data out of Sage 50? For example, a high-level goal would be to display an open orders report compiling new sales orders as they are entered and pulling…