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

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


Connection

Type: Connection Input

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

The Connection Property

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.

Examples

Refer to Node Samples for data schemas.

Did this answer your question?