Zynk Workflow Documentation

This task will export statements from Sage 50 to Zynk XML format.

Settings

Sage 50 Connection

Required
The connection to Sage 50 UK to use. See the Connecting to Sage 50 UK article if you require more information on how to create/manage connections.

Export Settings

Required

Query Settings

Optional

Query Timeout

Optional
The maximum amount of time (in seconds) the query should be allowed to run.

Output File

Required
The name of the file to export to. Data is exported in Zynk XML format

Zynk Settings

See Common Task Settings

Examples

Sample output file:

<?xml version="1.0"?>
<Company>
  <Statements>
    <Statement>
      <AccountReference>ABS001</AccountReference>
      <Date>2013-10-25T14:41:44.476383+01:00</Date>
      <InvoiceAddress>
        <Title />
        <Forename>Mike</Forename>
        <Surname>Hall</Surname>
        <Company>ABS Garages Ltd</Company>
        <Description>Mike Hall - NE31 1VB</Description>
        <Address1>Unit 34</Address1>
        <Address2>Holystone Ind Estate</Address2>
        <Town>Hebburn</Town>
        <Postcode>NE31 1VB</Postcode>
        <County>Tyne & Wear</County>
        <Telephone>0191 254 5909</Telephone>
        <Fax>0191 254 5907</Fax>
        <Mobile>0191 254 5908</Mobile>
        <Email>newbusinessadvice@sage.com</Email>
        <Website>www.sage.co.uk</Website>
        <Birthdate xsi:nil="true" />
        <Notes />
        <TaxCode>1</TaxCode>
        <CustomFields />
        <TradeContact>Peter Yates</TradeContact>
        <Activities />
        <Groups />
      </InvoiceAddress>
      <Balance>2533.31</Balance>
      <CreditLimit>4000</CreditLimit>
      <Transactions>
        <Transaction>
          <Id>1010</Id>
          <TransactionType>SalesInvoice</TransactionType>
          <AccountReference>ABS001</AccountReference>
          <TransactionDate>2009-04-24T00:00:00</TransactionDate>
          <PostedDate>2009-04-24T00:00:00</PostedDate>
          <Reference>58</Reference>
          <PaymentReference>1010</PaymentReference>
          <Details>A4 Carbon Copy Book - Triplicate</Details>
          <NetAmount>2110.55</NetAmount>
          <TaxRate xsi:nil="true" />
          <TaxCode xsi:nil="true" />
          <TaxAmount>422.76</TaxAmount>
          <ElectronicTransaction>false</ElectronicTransaction>
          <OutstandingAmount>2533.31</OutstandingAmount>
          <TransactionNumber>1010</TransactionNumber>
          <BankReference />
          <Discount xsi:nil="true" />
          <ExchangeRate>1</ExchangeRate>
          <VatInclusive>false</VatInclusive>
          <CustomFields />
        </Transaction>
      </Transactions>
    </Statement>
  </Statements>
</Company>

Back | Edit on Github