Skip to content

Export Sales Orders from Sage 200 Evolution

This task will export sales orders from Sage 200 Evolution 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.

Filter

Optional
Provide an SQL where clause if you would like to filter the records returned by export. You will need to consult the Sage 200 Evolution database via the SQL Server Management Studio application to obtain the field names.

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"?>
<SalesOrders xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <SalesOrder>
    <Id>2</Id>
    <Account>
      <Code>ZYNK0001</Code>
    </Account>
    <AccountId>2</AccountId>
    <ActiveSalesOpportunity>false</ActiveSalesOpportunity>
    <AllowInvoiceRounding>true</AllowInvoiceRounding>
    <Branch>
      <Code>(global)</Code>
    </Branch>
    <Currency />
    <Customer>
      <Id>2</Id>
      <AccountDescription>This is the description field</AccountDescription>
      <AccountTerms>0</AccountTerms>
      <Active>true</Active>
      <Addressee>Adam</Addressee>
      <AutomaticDiscount>0</AutomaticDiscount>
      <Branch>
        <Code>(global)</Code>
      </Branch>
      <CellPhone>0191 303 7280</CellPhone>
      <ChargeTax>true</ChargeTax>
      <CheckTerms>true</CheckTerms>
      <Code>ZYNK0001</Code>
      <ContactPerson>Adam</ContactPerson>
      <Country />
      <CreditLimit>0</CreditLimit>
      <Currency />
      <DeliverTo />
      <Description>Zynk Software</Description>
      <EmailAddress>[email protected]</EmailAddress>
      <Fax>0191 303 7281</Fax>
      <IdNumber />
      <Initials />
      <InterestRate>0</InterestRate>
      <IsOnHold>false</IsOnHold>
      <PhysicalAddress>
        <Line1>i6</Line1>
        <Line2>Charlotte Square</Line2>
        <Line3>Newcastle-upon-Tyne</Line3>
        <Line4>Tyne &amp; Wear</Line4>
        <Line5>UK</Line5>
        <PostalCode>NE1 4XF</PostalCode>
      </PhysicalAddress>
      <PostalAddress>
        <Line1>i6</Line1>
        <Line2>Charlotte Square</Line2>
        <Line3>Newcastle-upon-Tyne</Line3>
        <Line4>Tyne &amp; Wear</Line4>
        <Line5>UK</Line5>
        <PostalCode>NE1 4XF</PostalCode>
      </PostalAddress>
      <Registration />
      <SettlementDiscount>0</SettlementDiscount>
      <StatementZipPassword />
      <TaxNumber />
      <Telephone>0191 303 7279</Telephone>
      <Telephone2 />
      <Title />
      <UseEmail>false</UseEmail>
      <Webpage>www.zynk.com</Webpage>
      <AgeingMethod>OpenItem</AgeingMethod>
      <AgentID>0</AgentID>
      <ElectronicDocumentAcceptance>false</ElectronicDocumentAcceptance>
      <EmailSourceDocument>false</EmailSourceDocument>
      <EmailStatement>false</EmailStatement>
      <IsCashDebtor>false</IsCashDebtor>
      <MainAccount />
      <PrintSourceDocument>false</PrintSourceDocument>
      <PrintStatement>true</PrintStatement>
      <PromptTaxNumber>false</PromptTaxNumber>
    </Customer>
    <DeliveryDate>2025-11-27T00:00:00</DeliveryDate>
    <DeliveryMethod />
    <DeliveryNote />
    <DeliverTo>
      <Line1>i6</Line1>
      <Line2>Charlotte Square</Line2>
      <Line3>Newcastle-upon-Tyne</Line3>
      <Line4>Tyne &amp; Wear</Line4>
      <Line5>UK</Line5>
      <PostalCode>NE1 4XF</PostalCode>
    </DeliverTo>
    <Description>Sales Order</Description>
    <Discount>0</Discount>
    <DiscountForeign>0</DiscountForeign>
    <DiscountLastProcessed>0</DiscountLastProcessed>
    <DiscountPercent>0</DiscountPercent>
    <DiscountToProcess>0</DiscountToProcess>
    <DueDate>2025-11-27T00:00:00</DueDate>
    <ExchangeRate>1</ExchangeRate>
    <ExternalOrderNo>12345</ExternalOrderNo>
    <InvoiceDate>2025-11-27T00:00:00</InvoiceDate>
    <InvoiceTo>
      <Line1>i6</Line1>
      <Line2>Charlotte Square</Line2>
      <Line3>Newcastle-upon-Tyne</Line3>
      <Line4>Tyne &amp; Wear</Line4>
      <Line5>UK</Line5>
      <PostalCode>NE1 4XF</PostalCode>
    </InvoiceTo>
    <InvTotalRounding>0</InvTotalRounding>
    <InvTotalRoundingForeign>0</InvTotalRoundingForeign>
    <IsPartialProcessingAllowed>true</IsPartialProcessingAllowed>
    <MessageLine1 />
    <MessageLine2 />
    <MessageLine3 />
    <OrderDate>2025-11-27T00:00:00</OrderDate>
    <OrderItems>
      <OrderItem>
        <Id>3</Id>
        <Account>
          <Code>Service Item</Code>
        </Account>
        <Branch>
          <Code>(global)</Code>
        </Branch>
        <Description>Service Item</Description>
        <Discount>0</Discount>
        <DiscountPercent>0</DiscountPercent>
        <GlAccount />
        <GrvLineId>0</GrvLineId>
        <Index>1</Index>
        <InventoryItem>
          <Code>Service Item</Code>
        </InventoryItem>
        <JobId>0</JobId>
        <LastProcess>0</LastProcess>
        <Lot />
        <Module>Inventory</Module>
        <Note />
        <Outstanding>1</Outstanding>
        <OverrideCostOfSalesAccount />
        <OverridePurchaseAccount />
        <OverrideSalesAccount />
        <OverrideStockAccount />
        <Processed>0</Processed>
        <Quantity>1</Quantity>
        <Representative />
        <Reserved>0</Reserved>
        <TaxMode>Inclusive</TaxMode>
        <TaxType>
          <Id>1</Id>
          <Code>1</Code>
          <Description>Standard Rate (Excluding Capital Goods)</Description>
          <Rate>15</Rate>
        </TaxType>
        <ToProcess>1</ToProcess>
        <TotalAdditionalCost>0</TotalAdditionalCost>
        <TotalExcl>10</TotalExcl>
        <TotalExclBeforeDiscount>8.7</TotalExclBeforeDiscount>
        <TotalExclBeforeDiscountForeign>0</TotalExclBeforeDiscountForeign>
        <TotalExclBeforeDiscountForeignRaw>0</TotalExclBeforeDiscountForeignRaw>
        <TotalExclBeforeDiscountRaw>8.7</TotalExclBeforeDiscountRaw>
        <TotalExclForeign>0</TotalExclForeign>
        <TotalExclRaw>10</TotalExclRaw>
        <TotalIncl>10</TotalIncl>
        <TotalInclBeforeDiscount>10</TotalInclBeforeDiscount>
        <TotalInclBeforeDiscountForeign>0</TotalInclBeforeDiscountForeign>
        <TotalInclForeign>0</TotalInclForeign>
        <TotalLastProcessExcl>0</TotalLastProcessExcl>
        <TotalLastProcessExclAfterDocumentDiscount>0</TotalLastProcessExclAfterDocumentDiscount>
        <TotalLastProcessExclForeign>0</TotalLastProcessExclForeign>
        <TotalLastProcessExclForeignAfterDocumentDiscount>0</TotalLastProcessExclForeignAfterDocumentDiscount>
        <TotalLastProcessIncl>0</TotalLastProcessIncl>
        <TotalLastProcessInclForeign>0</TotalLastProcessInclForeign>
        <TotalLastProcessTax>0</TotalLastProcessTax>
        <TotalLastProcessTaxAfterDocumentDiscount>0</TotalLastProcessTaxAfterDocumentDiscount>
        <TotalLastProcessTaxForeign>0</TotalLastProcessTaxForeign>
        <TotalLastProcessTaxForeignAfterDocumentDiscount>0</TotalLastProcessTaxForeignAfterDocumentDiscount>
        <TotalOutstandingExcl>10</TotalOutstandingExcl>
        <TotalOutstandingExclForeign>0</TotalOutstandingExclForeign>
        <TotalOutstandingIncl>10</TotalOutstandingIncl>
        <TotalOutstandingInclForeign>0</TotalOutstandingInclForeign>
        <TotalOutstandingTax>1.3</TotalOutstandingTax>
        <TotalOutstandingTaxForeign>0</TotalOutstandingTaxForeign>
        <TotalProcessedExcl>0</TotalProcessedExcl>
        <TotalProcessedExclForeign>0</TotalProcessedExclForeign>
        <TotalProcessedIncl>0</TotalProcessedIncl>
        <TotalProcessedInclForeign>0</TotalProcessedInclForeign>
        <TotalProcessedTax>0</TotalProcessedTax>
        <TotalProcessedTaxForeign>0</TotalProcessedTaxForeign>
        <TotalSalesCost>0</TotalSalesCost>
        <TotalTax>1.3</TotalTax>
        <TotalTaxBeforeDiscount>1.3</TotalTaxBeforeDiscount>
        <TotalTaxBeforeDiscountForeign>0</TotalTaxBeforeDiscountForeign>
        <TotalTaxForeign>0</TotalTaxForeign>
        <TotalTaxForeignRaw>0</TotalTaxForeignRaw>
        <TotalTaxRaw>0</TotalTaxRaw>
        <TotalToProcessExcl>10</TotalToProcessExcl>
        <TotalToProcessExclBeforeDiscount>8.7</TotalToProcessExclBeforeDiscount>
        <TotalToProcessExclBeforeDiscountForeign>0</TotalToProcessExclBeforeDiscountForeign>
        <TotalToProcessExclForeign>0</TotalToProcessExclForeign>
        <TotalToProcessExclRaw>10</TotalToProcessExclRaw>
        <TotalToProcessIncl>10</TotalToProcessIncl>
        <TotalToProcessInclBeforeDiscount>10</TotalToProcessInclBeforeDiscount>
        <TotalToProcessInclBeforeDiscountForeign>0</TotalToProcessInclBeforeDiscountForeign>
        <TotalToProcessInclForeign>0</TotalToProcessInclForeign>
        <TotalToProcessTax>1.3</TotalToProcessTax>
        <TotalToProcessTaxAfterDocumentDiscount>1.3</TotalToProcessTaxAfterDocumentDiscount>
        <TotalToProcessTaxBeforeDiscount>1.3</TotalToProcessTaxBeforeDiscount>
        <TotalToProcessTaxBeforeDiscountForeign>0</TotalToProcessTaxBeforeDiscountForeign>
        <TotalToProcessTaxForeign>0</TotalToProcessTaxForeign>
        <TotalToProcessTaxForeignAfterDocumentDiscount>0</TotalToProcessTaxForeignAfterDocumentDiscount>
        <TotalToProcessTaxForeignRaw>0</TotalToProcessTaxForeignRaw>
        <TotalToProcessTaxRaw>0</TotalToProcessTaxRaw>
        <Unit />
        <UnitCostPrice>0</UnitCostPrice>
        <UnitSellingPrice>10</UnitSellingPrice>
        <UnitSellingPriceAfterDiscount>10</UnitSellingPriceAfterDiscount>
        <UnitSellingPriceAfterDocumentDiscountExcl>8.7</UnitSellingPriceAfterDocumentDiscountExcl>
        <UnitSellingPriceExclAfterLineDiscount>8.7</UnitSellingPriceExclAfterLineDiscount>
        <UnitSellingPriceForeign>0</UnitSellingPriceForeign>
        <Warehouse>
          <Code>Mstr</Code>
        </Warehouse>
      </OrderItem>
      <OrderItem>
        <Id>4</Id>
        <Account>
          <Code>Office Supplies</Code>
        </Account>
        <Branch>
          <Code>(global)</Code>
        </Branch>
        <Description>Office Supplies</Description>
        <Discount>1</Discount>
        <DiscountPercent>10</DiscountPercent>
        <GlAccount>
          <Code>Office Supplies</Code>
        </GlAccount>
        <GrvLineId>0</GrvLineId>
        <Index>2</Index>
        <InventoryItem />
        <JobId>0</JobId>
        <LastProcess>0</LastProcess>
        <Lot />
        <Module>GL</Module>
        <Note />
        <Outstanding>1</Outstanding>
        <OverrideCostOfSalesAccount />
        <OverridePurchaseAccount />
        <OverrideSalesAccount />
        <OverrideStockAccount />
        <Processed>0</Processed>
        <Quantity>1</Quantity>
        <Representative />
        <Reserved>0</Reserved>
        <TaxMode>Inclusive</TaxMode>
        <TaxType>
          <Id>1</Id>
          <Code>1</Code>
          <Description>Standard Rate (Excluding Capital Goods)</Description>
          <Rate>15</Rate>
        </TaxType>
        <ToProcess>1</ToProcess>
        <TotalAdditionalCost>0</TotalAdditionalCost>
        <TotalExcl>9</TotalExcl>
        <TotalExclBeforeDiscount>8.7</TotalExclBeforeDiscount>
        <TotalExclBeforeDiscountForeign>0</TotalExclBeforeDiscountForeign>
        <TotalExclBeforeDiscountForeignRaw>0</TotalExclBeforeDiscountForeignRaw>
        <TotalExclBeforeDiscountRaw>8.7</TotalExclBeforeDiscountRaw>
        <TotalExclForeign>0</TotalExclForeign>
        <TotalExclRaw>9</TotalExclRaw>
        <TotalIncl>9</TotalIncl>
        <TotalInclBeforeDiscount>10</TotalInclBeforeDiscount>
        <TotalInclBeforeDiscountForeign>0</TotalInclBeforeDiscountForeign>
        <TotalInclForeign>0</TotalInclForeign>
        <TotalLastProcessExcl>0</TotalLastProcessExcl>
        <TotalLastProcessExclAfterDocumentDiscount>0</TotalLastProcessExclAfterDocumentDiscount>
        <TotalLastProcessExclForeign>0</TotalLastProcessExclForeign>
        <TotalLastProcessExclForeignAfterDocumentDiscount>0</TotalLastProcessExclForeignAfterDocumentDiscount>
        <TotalLastProcessIncl>0</TotalLastProcessIncl>
        <TotalLastProcessInclForeign>0</TotalLastProcessInclForeign>
        <TotalLastProcessTax>0</TotalLastProcessTax>
        <TotalLastProcessTaxAfterDocumentDiscount>0</TotalLastProcessTaxAfterDocumentDiscount>
        <TotalLastProcessTaxForeign>0</TotalLastProcessTaxForeign>
        <TotalLastProcessTaxForeignAfterDocumentDiscount>0</TotalLastProcessTaxForeignAfterDocumentDiscount>
        <TotalOutstandingExcl>9</TotalOutstandingExcl>
        <TotalOutstandingExclForeign>0</TotalOutstandingExclForeign>
        <TotalOutstandingIncl>9</TotalOutstandingIncl>
        <TotalOutstandingInclForeign>0</TotalOutstandingInclForeign>
        <TotalOutstandingTax>1.17</TotalOutstandingTax>
        <TotalOutstandingTaxForeign>0</TotalOutstandingTaxForeign>
        <TotalProcessedExcl>0</TotalProcessedExcl>
        <TotalProcessedExclForeign>0</TotalProcessedExclForeign>
        <TotalProcessedIncl>0</TotalProcessedIncl>
        <TotalProcessedInclForeign>0</TotalProcessedInclForeign>
        <TotalProcessedTax>0</TotalProcessedTax>
        <TotalProcessedTaxForeign>0</TotalProcessedTaxForeign>
        <TotalSalesCost>0</TotalSalesCost>
        <TotalTax>1.17</TotalTax>
        <TotalTaxBeforeDiscount>1.3</TotalTaxBeforeDiscount>
        <TotalTaxBeforeDiscountForeign>0</TotalTaxBeforeDiscountForeign>
        <TotalTaxForeign>0</TotalTaxForeign>
        <TotalTaxForeignRaw>0</TotalTaxForeignRaw>
        <TotalTaxRaw>0</TotalTaxRaw>
        <TotalToProcessExcl>9</TotalToProcessExcl>
        <TotalToProcessExclBeforeDiscount>8.7</TotalToProcessExclBeforeDiscount>
        <TotalToProcessExclBeforeDiscountForeign>0</TotalToProcessExclBeforeDiscountForeign>
        <TotalToProcessExclForeign>0</TotalToProcessExclForeign>
        <TotalToProcessExclRaw>9</TotalToProcessExclRaw>
        <TotalToProcessIncl>9</TotalToProcessIncl>
        <TotalToProcessInclBeforeDiscount>10</TotalToProcessInclBeforeDiscount>
        <TotalToProcessInclBeforeDiscountForeign>0</TotalToProcessInclBeforeDiscountForeign>
        <TotalToProcessInclForeign>0</TotalToProcessInclForeign>
        <TotalToProcessTax>1.17</TotalToProcessTax>
        <TotalToProcessTaxAfterDocumentDiscount>1.17</TotalToProcessTaxAfterDocumentDiscount>
        <TotalToProcessTaxBeforeDiscount>1.3</TotalToProcessTaxBeforeDiscount>
        <TotalToProcessTaxBeforeDiscountForeign>0</TotalToProcessTaxBeforeDiscountForeign>
        <TotalToProcessTaxForeign>0</TotalToProcessTaxForeign>
        <TotalToProcessTaxForeignAfterDocumentDiscount>0</TotalToProcessTaxForeignAfterDocumentDiscount>
        <TotalToProcessTaxForeignRaw>0</TotalToProcessTaxForeignRaw>
        <TotalToProcessTaxRaw>0</TotalToProcessTaxRaw>
        <Unit />
        <UnitCostPrice>0</UnitCostPrice>
        <UnitSellingPrice>10</UnitSellingPrice>
        <UnitSellingPriceAfterDiscount>9</UnitSellingPriceAfterDiscount>
        <UnitSellingPriceAfterDocumentDiscountExcl>7.8299999999999992</UnitSellingPriceAfterDocumentDiscountExcl>
        <UnitSellingPriceExclAfterLineDiscount>7.8299999999999992</UnitSellingPriceExclAfterLineDiscount>
        <UnitSellingPriceForeign>0</UnitSellingPriceForeign>
        <Warehouse />
      </OrderItem>
    </OrderItems>
    <OrderNo>SO0001</OrderNo>
    <OrderPriority>
      <Description>Normal</Description>
    </OrderPriority>
    <OrderStatus />
    <OrderTotalRounding>0</OrderTotalRounding>
    <OrderTotalRoundingForeign>0</OrderTotalRoundingForeign>
    <PrintCount>0</PrintCount>
    <ProcessOnHold>false</ProcessOnHold>
    <Project />
    <Prospect />
    <Reference />
    <Reference2 />
    <Representative />
    <SettlementTerms />
    <State>Unprocessed</State>
    <TaxMode>Inclusive</TaxMode>
    <TaxNumber />
    <TaxType />
    <TotalDiscountAdjusted>0</TotalDiscountAdjusted>
    <TotalDiscountAdjustedForeign>0</TotalDiscountAdjustedForeign>
    <TotalExcl>19</TotalExcl>
    <TotalExclForeign>0</TotalExclForeign>
    <TotalIncl>21.47</TotalIncl>
    <TotalInclBeforeInvoiceRounding>21.47</TotalInclBeforeInvoiceRounding>
    <TotalInclForeign>0</TotalInclForeign>
    <TotalInclForeignBeforeInvoiceRounding>0</TotalInclForeignBeforeInvoiceRounding>
    <TotalLastProcessExcl>0</TotalLastProcessExcl>
    <TotalLastProcessExclForeign>0</TotalLastProcessExclForeign>
    <TotalLastProcessIncl>0</TotalLastProcessIncl>
    <TotalLastProcessInclForeign>0</TotalLastProcessInclForeign>
    <TotalLastProcessTax>0</TotalLastProcessTax>
    <TotalLastProcessTaxForeign>0</TotalLastProcessTaxForeign>
    <TotalOutstandingExcl>19</TotalOutstandingExcl>
    <TotalOutstandingExclForeign>0</TotalOutstandingExclForeign>
    <TotalOutstandingIncl>21.47</TotalOutstandingIncl>
    <TotalOutstandingInclForeign>0</TotalOutstandingInclForeign>
    <TotalOutstandingTax>2.47</TotalOutstandingTax>
    <TotalOutstandingTaxForeign>0</TotalOutstandingTaxForeign>
    <TotalTax>2.47</TotalTax>
    <TotalTaxForeign>0</TotalTaxForeign>
    <TotalToProcessExcl>19</TotalToProcessExcl>
    <TotalToProcessExclForeign>0</TotalToProcessExclForeign>
    <TotalToProcessIncl>21.47</TotalToProcessIncl>
    <TotalToProcessInclForeign>0</TotalToProcessInclForeign>
    <TotalToProcessTax>2.47</TotalToProcessTax>
    <TotalToProcessTaxForeign>0</TotalToProcessTaxForeign>
    <Type>SalesOrder</Type>
    <CustomFields>
      <CustomField>
        <Name>cQuoteNum</Name>
        <Value />
      </CustomField>
    </CustomFields>
  </SalesOrder>
</SalesOrders>