Sage 200 Evolution

The Sage Evolution Flowgear Connector enables you to integrated into Sage 200 Evolution via the Sage Evolution SDK.

This Node may be affected by Windows Regional Settings.

Revision History

7.20.0.7 - Added support for Branch Accounting and Inventory Items User Defined Field
9.0.0.2 - Added support to override GL accounts on documents
9.0.0.3 - Added support for user defined fields on document lines
9.0.0.4 - Fixed bug where only sales orders could be completed using the order number
9.0.0.5 - Removed versions before 7.0.0.0
10.1.0.0 - Added the SDK for version 10.1.0.12
10.1.0.2 - Added support for Reserved quantity on orders. Updated to SDK 10.1.0.21
10.1.0.8 - Added support for Project field on Documents. Updated to SDK 10.1.0.37
10.1.0.9 - Added support for Lot tracking on Documents and Warehouse Transfer
10.1.0.10 - Created a workaround when the DocumentID is larger than an int in the db.
10.1.0.11 - Added the SDK for version 10.1.0.41
11.0.0.0 - Added the SDK for version 11.0.0.4
11.0.0.1 - Added the SDK for version 10.1.0.47 & bug fix on inventory item create
11.0.0.2 - Added the SDK for version 9.20.0.44
11.0.0.3 - Updated SDK to version 11.0.0.10
11.0.0.4 - Updated SDK to version 11.0.0.17 and use SDK 11.0.0.17 for Sage 11.1
11.0.1.3 - Updated to .NET Framework 4.8, refactored samples and configuration.

Connection

Type: Connection Input
The Connection Property

Server
Type: String
The name of the SQL Server instance hosting the Evolution Company database

Database
Type: String
The name of the Evolution Company database. Note that the SQL Database name is exactly the same as the registered company name and may contain spaces.

Username
Type: String

Password
Type: String

UseWinAuth
Type: Boolean
Set to true to use Windows Authentication rather than a named SQL username and password. The account used for Windows Authentication is the account under which the DropPoint service is running.

CommonDbServer
Type: String
The name of the SQL Server instance hosting the Common database. This is typically the same server as the Company database.

CommonDbDatabase
Type: String
The name of the Evolution Common database. This is typically EvolutionCommon

CommonDbUsername
Type: String

CommonDbPassword
Type: String

CommonDbUseWinAuth
Type: Boolean

RequestXml

Type: Xml Input
The RequestXml Property

ResponseXml

Type: Xml Output
The ResponseXml Property

Requirements

The Sage Evolution Connector requires the SDK Client Connector (not the Developer Connector) to be licensed. See http://www.sage.com/za/partners/developers/sage-pastel-accounting for further information and current licensing.

Troubleshooting

The value '6.22' for [field] could not be set

You may encounter this error when attempting to set a number containing a decimal point on a specific field. This error occurs if the regional setting on the computer on which the Node is executing (i.e. the computer hosting the DropPoint) does not use a point as a decimal symbol. For example, if your locale is set to South Africa, a comma will be used instead.

To resolve this, change the decimal symbol to a point. To access this setting, open Control Panel, then Region, then Additional Settings and change the decimal symbol under the Numbers tab.

This will change the setting for the current user profile only. Typically DropPoints run under the LOCAL SYSTEM account so it is then necessary to copy the changed settings to the LOCAL SYSTEM account.

To do this, go back to the Region Dialog, click the Administrative tab and click Copy Settings. Tick the checkboxes Welcome screen and system accounts as well as New user accounts and click Ok.

Restart the computer for changes to take effect.

Values are rounded to only 2 decimal places

Some items need higher decimal places on the unit price. The default is set to 2 decimal places. To increase the number of decimal places, navigate to Maintenance -> Inventory -> Inventory Defaults and set the required number of decimal places.

Database connection failure or invalid Evolution SDK license. Pastel Evolution registration is invalid: Server Table Error. Version: 0

First check that the SDK Connector is listed in the licensed modules under Help>About in Sage.

The SQL user needs to have db_owner permission on the SageCommon database, and at least db_datareader & db_datawriter on the company database.

A read-only user can be set up for a SQL connection, and only need db_datareader on the company database.

Examples

Refer to Node Samples for data schemas.