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