Zynk Workflow Documentation

This task will export new, modified or all customers in Sage 200 XML format.

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

Contact Settings

Required

Delivery Address Settings

Required

Characters To Cleanse

Optional
A list of characters to remove from the output file. Use this if your Sage data contains characters that are not valid for XML documents (e.g.  �).

Export Settings

Optional

Query Settings

Optional

Query Timeout

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

Output File

Required
The file to save the exported records to, in Zynk XML format.

Zynk Settings

See Common Task Settings

Examples

Sample output file:

<?xml version="1.0" encoding="utf-8"?>
<Company>
  <Customers>
    <Customer>
      <UniqueId>1228</UniqueId>
      <AccountReference>ZYN0001</AccountReference>
      <CompanyName>Zynk Software Limited</CompanyName>
      <Balance>299.28</Balance>
      <VatNumber />
      <SendElectronicInvoice xsi:nil="true" />
      <SendElectronicLetter xsi:nil="true" />
      <CustomerInvoiceAddress>
        <UniqueId>1229</UniqueId>
        <Title>Mr.</Title>
        <Forename>A</Forename>
        <Middlename />
        <Surname>W</Surname>
        <Company>Zynk Software Limited</Company>
        <Description> - NE1 4XF</Description>
        <Address1>Nelson House</Address1>
        <Address2>Fleming Business Centre</Address2>
        <Address3 />
        <Address4 />
        <Town>Jesmond</Town>
        <Postcode>NE2 3AE</Postcode>
        <County>Tyne &amp; Wear</County>
        <Country> </Country>
        <CountryName><Non-European></CountryName>
        <Telephone>0845 123 2920</Telephone>
        <TelephoneCountryCode />
        <TelephoneAreaCode />
        <Fax />
        <FaxCountryCode />
        <FaxAreaCode />
        <Email />
        <ContactName />
        <Birthdate xsi:nil="true" />
        <Notes />
        <TaxCode>1</TaxCode>
        <CustomFields />
        <Activities />
        <Groups />
      </CustomerInvoiceAddress>
      <CustomerDeliveryAddress>
        <UniqueId>1229</UniqueId>
        <Title>Mr.</Title>
        <Forename>A</Forename>
        <Middlename />
        <Surname>W</Surname>
        <Company>Zynk Software Limited</Company>
        <Description> - NE1 4XF</Description>
        <Address1>Nelson House</Address1>
        <Address2>Fleming Business Centre</Address2>
        <Address3 />
        <Address4 />
        <Town>Jesmond</Town>
        <Postcode>NE2 3AE</Postcode>
        <County>Tyne &amp; Wear</County>
        <Country> </Country>
        <CountryName><Non-European></CountryName>
        <Telephone>0845 123 2920</Telephone>
        <TelephoneCountryCode />
        <TelephoneAreaCode />
        <Fax />
        <FaxCountryCode />
        <FaxAreaCode />
        <Email />
        <ContactName />
        <Birthdate xsi:nil="true" />
        <Notes />
        <TaxCode>1</TaxCode>
        <CustomFields />
        <Activities />
        <Groups />
      </CustomerDeliveryAddress>
      <Analysis1 />
      <Analysis2 />
      <Analysis3 />
      <NominalCode>PREPAYME</NominalCode>
      <CostCentre />
      <Department />
      <OverrideNominalCode xsi:nil="true" />
      <TaxCode>1</TaxCode>
      <OverrideTaxCode xsi:nil="true" />
      <Currency>GBP</Currency>
      <FixedDiscount xsi:nil="true" />
      <LineDiscount>0</LineDiscount>
      <PriceListReference>Standard</PriceListReference>
      <DiscountGroupReference />
      <OrderValueDiscountReference />
      <DiscountType xsi:nil="true" />
      <CreditLimit>0</CreditLimit>
      <SettlementDays>0</SettlementDays>
      <SettlementDiscount>0</SettlementDiscount>
      <PaymentDays>0</PaymentDays>
      <Terms />
      <AccountStatus xsi:nil="true" />
      <DUNSNumber xsi:nil="true" />
      <TermsAgreed>true</TermsAgreed>
      <AccountOnHold>false</AccountOnHold>
      <AccountOpened>2013-10-04T00:00:00</AccountOpened>
      <LastCreditReview xsi:nil="true" />
      <NextCreditReview xsi:nil="true" />
      <ApplicationDate xsi:nil="true" />
      <DateReceived xsi:nil="true" />
      <LastInvoiceDate xsi:nil="true" />
      <LastPaymentDate xsi:nil="true" />
      <TurnoverMTD xsi:nil="true" />
      <TurnoverYTD xsi:nil="true" />
      <PriorYear xsi:nil="true" />
      <Priority xsi:nil="true" />
      <RestrictMailing xsi:nil="true" />
      <ChargeCredit xsi:nil="true" />
      <Banks />
      <Attachments />
      <Memo />
      <CreateOnly xsi:nil="true" />
      <ShortName>Websales</ShortName>
      <Contacts>
        <Contact>
          <UniqueId>1230</UniqueId>
          <Title>Mr.</Title>
          <Forename>A</Forename>
          <Middlename />
          <Surname>W</Surname>
          <Company>Zynk Software Limited</Company>
          <Description> - NE1 4XF</Description>
          <Address1>Nelson House</Address1>
          <Address2>Fleming Business Centre</Address2>
          <Address3 />
          <Address4 />
          <Town>Jesmond</Town>
          <Postcode>NE2 3AE</Postcode>
          <County>Tyne &amp; Wear</County>
          <Country> </Country>
          <Telephone>0845 123 2920</Telephone>
          <TelephoneCountryCode />
          <TelephoneAreaCode />
          <Fax />
          <FaxCountryCode />
          <FaxAreaCode />
          <Mobile />
          <MobileCountryCode />
          <MobileAreaCode />
          <Email />
          <Website />
          <Birthdate xsi:nil="true" />
          <Notes />
          <TaxCode>1</TaxCode>
          <Activities />
          <Groups />
        </Contact>
      </Contacts>
      <DeliveryAddresses />
      <AnalysisCodes>
        <AnalysisCode>
          <Name>Web Customer</Name>
          <Value>false</Value>
        </AnalysisCode>
      </AnalysisCodes>
      <Activities />
      <Groups />
      <Notes />
    </Customer>
  </Customers>
</Company>

Back | Edit on Github