• Sage 50 CA integration

    I have an application that I need to have integrated with sage 50 CA.  I need to pull info and push back ap and AR invoices, projects and time entries.  Who can help me?

  • 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 SDK…

  • Sage 50 ODBC Connection

    I try to connect MS Excel to Sage file via ODBC. I got following message:

    Details: "ODBC: ERROR [IM014] The specified DSN contains an architecture mismatch between the Driver (32-bit) and Application (64-bit)"

    I am using Windows 10 64-bit…

  • Woocommerce and SAGE 50 Canadian version 2019.3 integration

    Hello Guys,

    Anybody know here how to integrate SAGE 50 with WooCommerce Wordpress plugin?

    Is there any good solution available in the market?

    We are using SAGE 50 Canadian version 2019.3

    Thank you.

    Rahul

  • ODBC issue (works from Excel when sysadmin has no password but not when sysadmin has a password

    Trying to connect to the Sage 50 Canadian (non cloud) database using excel through ODBC

    MySql connector allow me to select the Sage50:COMPANYNAME.SAI file and the population of the correct path to the server and port 

    Initial attempts with the sysadmin…

  • Can Sage 50 CA 2019 work with SAP Crystal Reports?

    Hi,

    I know that the Sage 50 US edition 2019 works currently with SAP Crystal reports, but I just want to confirm if SAP Crystal Reports can also work with Sage 50 CA 2019?

    I saw in SAP Crystal reports knowledgebase that they can work with data source…

  • SDK - PurchasesJournal - Project Allocations on Line Numbers

    Hi there,

    We're working on creating an integration using our application and Sage 50 Canadian Edition.

    Currently working on creating Purchase Journal Entries - we want to allocate the line-item on the journal to a project.  In the example, it doesn…

  • 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.".

  • Three questions

    1 ) What is the best SAGE50 CDN supported method to get eCommerce data into Sage 50 CDN  without using a third party tool

    + That is customer, order and custom fees

    + Found SDK online, essentially a set of files that are imported into SAGE50CDN -- is this…

  • Direct DB Connections via Connection Manager | Changing Port #s

    Hi folks,

    I have a client that uses Sage 50 (2018.1 + Connection Manager v7.0).  They host Sage on a MS Azure server.  They have 6 Companies (DBs) that I'd like to be able to connect to so that I can pull some high-level data into a custom reporting tool…

  • ODBC Connection Access Denied (Password error)

    Since we installed the latest upgrade for Sage 50 to Version 2018.0, we are unable to connect to the simply database with our third party software using a ODBC Connection.

    Over the past 10 years I have always managed to make the appropriate adjustments…

  • #C and SDK issues

    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 from…

  • 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…

  • SDKInstanceManager OpenDatabase always returns false and has no error messages

    Hi, 

    I'm trying to work through the C# sample project in the Sage 50 Accounting SDK (Simply) but for some reason I can't get the opendatabase connection to let me access the database. I have set up my user in the Sage app and I know my username and password…

  • Testing Custom Software Integration - Sage Developer's License?

    How do I test my custom software integration with Sage? Is there a Sage developers license? Do I have to buy a normal Sage license, even though I only need it for testing?

    I'm specifically working with Sage 50 Canadian Edition, and part of my integration…

  • 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…

  • Modifying customer records and/or invoices with .IMP format

    Hi,

    I'm setting up a new POS system (VendPOS) to work with Sage50 2016.  I've been playing with the import utility and can create a compatible .IMP file to upload new sales invoices and customers to accounting.  Is there a way to modify existing…

  • 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?

  • ODBC connection failing

    I am trying to connect to the Sage 50 database using ODBC/My SQL connection.  In MySQL Connector/ODBC, I enter Sage username and password, , I select TCP/IP Server : localhost (database is local on this computer), I leave the port to default (13540), and…