Skip to content

Export Custom Data from Sage 200 Evolution

This task will run a custom query against the Sage 200 Evolution database and output the results to an XML file.

Settings

Connection

Required
The Sage 200 Evolution connection to use. See Connecting to Sage 200 Evolution

Export New, Modified or All Records

Required
Choose the type of export to perform against Sage. The following options are available:

  • New - Will output any record that has not been output by Zynk before. This is determined based on the entries in the Truth Table.
  • Modified - Will output any record that has not been output by Zynk before, or has changed since it was last output by Zynk. This is determined based on the entries in the Truth Table.
  • All - Will output all records.

Internal ID Field

Required
The database column that will act as the unique identifier for each record. The column must have either the 'bigint' or 'int' data type. You must specify the table name the column belongs to, for example PostAR.AutoIdx.

Query

Required
Provide the SQL select query to use to export the data from Sage. For example SELECT * FROM PostAR

Output File

Required
The XML file to save the exported records to.

Zynk Settings

See Common Task Settings

Examples

A sample output file is shown below.

<?xml version="1.0" encoding="utf-8"?>
<Rows>
  <Row>
    <Id>2</Id>
    <Field Name="AutoIdx" Value="2" />
    <Field Name="TxDate" Value="2025-11-28T00:00:00" />
    <Field Name="Id" Value="ARTx" />
    <Field Name="AccountLink" Value="2" />
    <Field Name="TrCodeID" Value="10" />
    <Field Name="Debit" Value="20" />
    <Field Name="Credit" Value="0" />
    <Field Name="iCurrencyID" Value="0" />
    <Field Name="fExchangeRate" Value="1" />
    <Field Name="fForeignDebit" Value="20" />
    <Field Name="fForeignCredit" Value="0" />
    <Field Name="Description" Value="Invoice" />
    <Field Name="TaxTypeID" Value="1" />
    <Field Name="Reference" Value="ZYNKTEST0001" />
    <Field Name="Order_No" Value="ZYNKTEST0001" />
    <Field Name="ExtOrderNum" Value="" />
    <Field Name="cAuditNumber" Value="0.7.0001" />
    <Field Name="Tax_Amount" Value="2.61" />
    <Field Name="fForeignTax" Value="2.61" />
    <Field Name="Project" Value="0" />
    <Field Name="Outstanding" Value="0" />
    <Field Name="fForeignOutstanding" Value="20" />
    <Field Name="cAllocs" Value="I=3;A=20;D=20251128" />
    <Field Name="InvNumKey" Value="0" />
    <Field Name="RepID" Value="0" />
    <Field Name="LinkAccCode" Value="0" />
    <Field Name="TillID" Value="0" />
    <Field Name="CRCCheck" />
    <Field Name="DTStamp" Value="2025-11-28T14:23:35" />
    <Field Name="UserName" Value="SDK" />
    <Field Name="iTaxPeriodID" />
    <Field Name="cReference2" Value="ZYNKTEST0001" />
    <Field Name="fJCRepCost" Value="0" />
    <Field Name="iAge" />
    <Field Name="dDateAged" />
    <Field Name="iPostSettlementTermsID" Value="0" />
    <Field Name="iTxBranchID" Value="0" />
    <Field Name="iMBPropertyID" Value="0" />
    <Field Name="iMBPortionID" Value="0" />
    <Field Name="iMBServiceID" Value="0" />
    <Field Name="iMBMeterID" Value="0" />
    <Field Name="iMBPropertyPortionServiceID" Value="0" />
    <Field Name="bPBTPaid" Value="False" />
    <Field Name="iGLTaxAccountID" Value="104" />
    <Field Name="iTransactionType" Value="0" />
    <Field Name="PostAR_iBranchID" Value="0" />
    <Field Name="PostAR_dCreatedDate" Value="2025-11-28T14:23:35" />
    <Field Name="PostAR_dModifiedDate" Value="2025-11-28T14:23:35" />
    <Field Name="PostAR_iCreatedBranchID" Value="0" />
    <Field Name="PostAR_iModifiedBranchID" Value="0" />
    <Field Name="PostAR_iCreatedAgentID" Value="0" />
    <Field Name="PostAR_iModifiedAgentID" Value="0" />
    <Field Name="PostAR_iChangeSetID" Value="1" />
    <Field Name="PostAR_Checksum" Value="0xE8CD5CFB63F40A4C27FFB85DD174944C0D337A5D" />
    <Field Name="SagePayExtra1" Value="" />
    <Field Name="SagePayExtra2" Value="" />
    <Field Name="SagePayExtra3" Value="" />
    <Field Name="iMajorIndustryCodeID" Value="0" />
    <Field Name="iTaxBadDebtState" Value="0" />
    <Field Name="cHash" Value="" />
    <Field Name="iKeyVersion" Value="0" />
  </Row>
</Rows>