Sage 300 ERP Connector

Sage 300 ERP Connector

Overview

Sage 300 versions supported: 2014 and higher.  

It can read, write to the following tables (chart updated January 16, 2020)

Sage 300 Entity
Read
Write
Customer
X
X
Contact
1
1
Products
X

Salesperson
X

Quote
X
X
Order
X
X
Invoice
X
X
Payment
X

Job


ChangeOrder


Shipments
X
X
TaxSchedule
X

1 - Contacts are not a separate entity but are included with the Customer entity 

The Creatio Connect Sage 300 Connector accesses Sage 300 via web services.   Please refer to the Options to Connect page for more information on the multiple options for implementing Creatio Connect to access local data.

Once you have established how you will connect Creatio Connect, you will need to run the installer for the Sage 300 locally.

Installation Requirements

.NET Framework 4.7.1+
IIS with ASP.NET enabled

Please install in a location that Sage 300 client has also been installed, it does not have to be directly on the Sage 300 server.

Download

Installation

  1.  Download the installer: https://www.dropbox.com/s/jea9g6461ihvjkr/Starfish%20-%20Sage%20300%20ERP.zip?dl=0
  2. Unzip the file and move the Sage 300 folder to C:\Inetpub\wwwroot\.  This will create a new Default Web Site in IIS.
  3. Right click on the new folder, go to properties and set Write permission for the IIS_IUSRS group            (C:\Inetpub\wwwroot\Starfish300)
      

                  
3.  In the same folder, edit the web.config, configuring the connection string, Sage username/password, and Service username/password.




4.  In IIS, under Default Web Site,  right click and convert Starfish300 to an application.
5.  Another folder from the expanded zip file is SQL Scripts.  Open and execute each script in SQL Management Studio, taking care to change the first line  to USE <your database name> to execute against your Sage 300 database.

In Creatio Connect, create a new connection to Sage 300.  If you changed the username and password for the service in the web config file, please use those instead of the defaults below.

b. Username default is sage300service
c. Password default is letmein

Sage 300 Connection Edit Screen
Parameter
Description
Starfish 300 Web Service URL





    • Related Articles

    • Sage 100 ERP Connector

      Overview Sage 100 versions supported: 2014 and higher. The Creatio Connect Sage 100 Connector accesses Sage 100 via web services. It can be used with Creatio Connect Windows or the Creatio Connect Ray. If you are using the Creatio Connect Windows ...

    • Sage 300 web service setup and configuration

      Setting up Sage 300 web service test Get ready - Prep Sage 300 credentials Sage 300 SQL database Company Username and password System Prereqs .NET Framework 4.7.1+ IIS with ASP.NET enabled. Installed somewhere where the Sage 100 client has also been ...

    • Sage CRM Connector

      SageCRM Origin Make sure you update your standard SageCRM URL to include ../webservices at the end. The SageCRM Origin will not work if you have a blank password. Your user must have a password. Origin Filters "SageCRM Filters should work just like ...

    • Microsoft Dynamics ERP - AX Connector

      Our Microsoft Dynamics AX Connector is no longer supported.  We will offer support for Microsoft Dynamics 365 Finance and Operations in the near future. Parameter Description Domain Object Server Dynamics AX Connection Edit Screen

    • Microsoft Dynamics ERP - GP Connector

      Additional Documentation  This Connector is based on the Dynamics GPADO.NET Provider by CData. For additional help, including String parameters, please see: https://cdn.cdata.com/help/DPG/ado/ Dynamics GP Version Support The provider supports read ...