Zynk Workflow Documentation

This task will import supplier records in Zynk XML format to the Purchase Ledger in Sage 200. If the supplier already exists (based on finding a matching account reference) it will be updated, otherwise a new supplier will be created.

Settings

Sage 200 Connection

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

Input File

Required
The source file for importing in Zynk XML format.

Fail File

Required
The name of the file to store failed suppliers in Zynk XML format.

Success File

Required
The name of the file to store the successfully imported suppliers in Zynk XML format.

Auto Generate References

Required

Match Accounts On

Optional
The list of fields to use to try and find an existing account in Sage which matches with the supplier in the input file. These settings will only be used if there is no account reference provided for the supplier in the input file. When multiple fields are selected, only suppliers in Sage where the value of all fields matches those in the input file will be considered a match. The following fields are supported:

Zynk Settings

See Common Task Settings

Examples

A sample input file for creating a supplier is shown below. See our Sage 200 Supplier XML for more details on the Zynk XML Supplier format for Sage 200.

<?xml version="1.0" encoding="utf-8"?>
<Company xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <Suppliers>
    <Supplier>
      <Id>1</Id>
      <AccountReference>CON001</AccountReference>
      <CompanyName>Concept Stationery Supplies</CompanyName>
      <VatNumber>GB988 3453 23</VatNumber>
      <CreditLimit>5000</CreditLimit>
      <SupplierInvoiceAddress>
        <Title>Mr</Title>
        <Forename>Mark</Forename>
        <Surname>Ramsay</Surname>
        <Address1>66 New Street</Address1>
        <Address2>Ridgeway</Address2>
        <Town>Newcastle upon Tyne</Town>
        <Postcode>NE1 4GF</Postcode>
        <County />
        <Country>GB</Country>
        <Telephone>0191 643 4343</Telephone>
        <Fax>0191 643 4345</Fax>
        <Mobile>0191 643 4344</Mobile>
        <Email>newbusinessadvice@sage.com</Email>
        <Website />
        <Notes />
      </SupplierInvoiceAddress>
      <Currency>GBP</Currency>
      <NominalCode>4002</NominalCode>
      <CostCentre>TES</CostCentre>
      <Department>DEP</Department>
      <TermsAgreed>true</TermsAgreed>
      <AnalysisCodes>
        <AnalysisCode>
          <Name>TEST</Name>
          <Value>123</Value>
        </AnalysisCode>
      </AnalysisCodes>
    </Supplier>
  </Suppliers>
</Company>

Back | Edit on Github