How to receive access to Account Receivables documents via API

Hello Team,

I have an application and want to integrate it with Sage 100 cloud.
I found the following specification:

help-sage100.na.sage.com/.../index.htm

As I understood, this API allows receiving all Account Receivables documents from Sage 100.
I would be extremely grateful if you could explain how to extract AR documents according to this specification via API?
Maybe you could provide any links to the documentation?

  • I didn't have any experience with Sage 100 API previously, so it is a reason why I ask to help me with documentations.

  • in reply to Andrew1986

    If you are only reading data, not writing back to Sage, use ODBC instead.  That is much easier to set up.

  • in reply to Kevin M

    Kevin,

    Thank you for the information.
    Could you provide a link to the documentation on how to integrate data using ODBC?
    We didn't use previously ODBC. 
    I want to understand how to install ODBC, how to open the connection to the DB using ODBC, and how my application can use ODBC to receive data from Sage 100.

    Yes, we will only read data.
    But I cannot find a specification of how to use it (

  • in reply to Andrew1986

    If you don't know what ODBC is, you going to have serious difficulties setting it up on your own.  Contact your client's Sage Partner / reseller, and they can help you "hands on".

    Note, this only works from machines directly on the same local network as the Sage server.  In spite of previously having the word "cloud" in the name, Sage 100 is actually on premise architecture, with no built-in web API.  For reading Sage data over the web, you'll definitely want to get the Sage Partner / reseller involved in your project.

    Reference to a similar question here with more details on options:

    https://www.sagecity.com/us/sage100_erp/f/sage-100-business-object-interface/175185/integration-with-sage-100/447106#447106

  • in reply to Kevin M

    Kevin,

    As I understood, I cannot integrate data using web services, SData, and OData.

    The single most suitable way is ODBC.

    I want to clarify, is it possible to use OData without Power Apps?
    For instance, add OData in Sage and use published URLs to extract data from Sage 100?

    Sorry, that I repeat my question, but my team asks me to provide detailed information about how they can integrate data and which approach they can use, and how.

  • in reply to Andrew1986

    If you are referring to the new Office 365 connectors, I have not used them before (only seen demos) and have no insights to share.

    Asking general questions and expecting detailed information won't work. Again, I strongly recommend consulting with the client's Sage Partner.  Sage 100 is NOT designed for integration over the web, so you won't get a definitive answer without doing detailed research of alternatives yourself, based on your detailed technical requirements.

    Not being developers ourselves, we have two general strategies that we use for our customers who need Sage data available externally:

    • SFTP push upload of CSV files, initiated by automated processes running on the Sage server.  This is often applicable for daily uploads, not real time data.
    • Run 3rd party software on the Sage server to act as a bridge.  Costs and features vary with different software solutions.
  • in reply to Kevin M

    Kevin,

    I analyzed Customer requirements and we should push payments from our application to Sage 100.
    ODBC only allows receiving data. Which approach we can use to send data to Sage 100?
    As I understood it is BOI.
    How I can use it?
    Should the Customer buy a license for BOI?
    Is it possible to receive documentation for BOI?

  • in reply to Andrew1986

    I'd recommend you consider InSynch / ROI for that.  Their software (which uses BOI) is a connector for Sage 100 and they will help you with the process.

    A DIY solution (when you know nothing about Sage 100 to start) will cost a lot more ($ and time) in learning / development / debugging.

  • in reply to Kevin M

    Kevin,

    I found the course 100E - Sage 100 - Object Interface Course.

    This Anytime Learning package is designed to introduce programmers to the ProvideX OLE server (ProvideX COM) and MAS 90 and MAS 200 Object Interface. You will be viewing examples created in both VBScript and VB.NET, where you are shown how to use the Object Interface to interact with the Sage 100 application.

    Is it correct, that the integration language for BOI is only VBScript and VB.NET. 
    Or does Sage 100 allows using Java for BOI?