V2NodesSage 200 Evolution
Sage 200 Evolution
V2

Sage 200 Evolution

Provides integration with a Sage 200 installation. Connects directly to Database.

Revision History

0.0.0.1 - Initial release.
0.0.0.13 - Repair project file SDK version reference.
0.0.0.17 - Fixed template returns and runtime error handling.
0.0.0.20 - Split invoke methods.
0.0.0.23 - Overhaul to new standard.

Connection

Parameter Type Description
Server String The name of the SQL Server instance hosting the Evolution Company database.
Database 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 String
Password Masked
UseWinAuth Boolean Set to true to use Windows Authentication rather than a named SQL username and password.
CommonDbServer String The name of the SQL Server instance hosting the Common database. This is typically the same server as the Company database.
CommonDbDatabase String The name of the Evolution Common database. This is typically EvolutionCommon.
CommonDbUsername String
CommonDbPassword Masked
CommonDbUseWinAuth Boolean Set to true to use Windows Authentication rather than a named SQL username and password.
BranchID Integer The number based ID of the Branch to be referenced.

Setup Notes

  • Ensure IP of tenant is allowed on Sage 200 Evolution server.

Methods

Create

This action is only allowed on the following document(s):

  • InventoryItem, ApPurchaseOrders, ArSalesOrders, ApReturns, ArCreditNotes
Parameter Type Notes
Connection Connection Connection profile.
DocumentType Dropdown Auto Filled by chosen template. Options are: InventoryItem, ApPurchaseOrders, ArSalesOrders, ApReturns, ArCreditNotes.
Request Array Schema provided by chosen template.
Return Type Notes
Response Array Output from Process operation.

Update

This action is only allowed on the following document(s):

  • InventoryItem, ApPurchaseOrders, ArSalesOrders, ApReturns, ArCreditNotes
Parameter Type Notes
Connection Connection Connection profile.
DocumentType Dropdown Auto Filled by chosen template. Options are: InventoryItem, ApPurchaseOrders, ArSalesOrders, ApReturns, ArCreditNotes.
Request Array Schema provided by chosen template.
Return Type Notes
Response Array Output from Process operation.

Complete

This action is only allowed on the following document(s):

  • ApPurchaseOrders
Parameter Type Notes
Connection Connection Connection profile.
DocumentType Dropdown Auto Filled by chosen template. Options are: InventoryItem, ApPurchaseOrders, ArSalesOrders, ApReturns, ArCreditNotes.
Request Array Schema provided by chosen template.
Return Type Notes
Response Array Output from Process operation.

Process

This action is only allowed on the following document(s):

  • ArSalesOrders
Parameter Type Notes
Connection Connection Connection profile.
DocumentType Dropdown Auto Filled by chosen template. Options are: InventoryItem, ApPurchaseOrders, ArSalesOrders, ApReturns, ArCreditNotes.
Request Array Schema provided by chosen template.
Return Type Notes
Response Array Output from Process operation.

Known Issues

  • Only works with Sage version 10.
  • Documents currently available:
    • InventoryItem (Create and Update)
    • Document
      • SalesOrder (Create, Update and Process)
      • CreditNote (Create and Update)
      • PurchaseOrder (Create and Update and Complete)
      • Return (Create and Update)
  • ProcessAllOrNone option not available. Currently, default behaviour is ProcessAllOrNone=false.