Skip to content

Export Purchase Orders from Sage 200 Evolution

This task will export purchase 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"?>
<PurchaseOrders>
  <PurchaseOrder>
    <Id>1</Id>
    <Account>
      <Code>ZYNK0001</Code>
    </Account>
    <AccountId>1</AccountId>
    <AllowInvoiceRounding>true</AllowInvoiceRounding>
    <Branch>
      <Code>(global)</Code>
    </Branch>
    <Currency />
    <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>
    <DeliveryDate>2025-11-25T00:00:00</DeliveryDate>
    <DeliveryMethod />
    <Description>Purchase Order</Description>
    <Discount>0</Discount>
    <DiscountForeign>0</DiscountForeign>
    <DiscountLastProcessed>0</DiscountLastProcessed>
    <DiscountPercent>0</DiscountPercent>
    <DiscountToProcess>0</DiscountToProcess>
    <DueDate>2025-11-25T00:00:00</DueDate>
    <ExchangeRate>1</ExchangeRate>
    <ExternalOrderNo>TEST</ExternalOrderNo>
    <GrvState>GRV</GrvState>
    <InvoiceDate>2025-11-26T00: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>
    <MessageLine1 />
    <MessageLine2 />
    <MessageLine3 />
    <OrderDate>2025-11-25T00:00:00</OrderDate>
    <OrderItems>
      <OrderItem>
        <Id>2</Id>
        <Account>
          <Code>Office Supplies</Code>
        </Account>
        <Branch>
          <Code>(global)</Code>
        </Branch>
        <Description>Office Supplies</Description>
        <Discount>0.05</Discount>
        <DiscountPercent>1</DiscountPercent>
        <GlAccount>
          <Code>Office Supplies</Code>
        </GlAccount>
        <GrvLineId>0</GrvLineId>
        <Index>1</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>3</Id>
          <Code>3</Code>
          <Description>Zero Rate (Excluding Goods Exported)</Description>
          <Rate>0</Rate>
        </TaxType>
        <ToProcess>1</ToProcess>
        <TotalAdditionalCost>0</TotalAdditionalCost>
        <TotalExcl>4.95</TotalExcl>
        <TotalExclBeforeDiscount>5</TotalExclBeforeDiscount>
        <TotalExclBeforeDiscountForeign>0</TotalExclBeforeDiscountForeign>
        <TotalExclBeforeDiscountForeignRaw>0</TotalExclBeforeDiscountForeignRaw>
        <TotalExclBeforeDiscountRaw>5</TotalExclBeforeDiscountRaw>
        <TotalExclForeign>0</TotalExclForeign>
        <TotalExclRaw>4.95</TotalExclRaw>
        <TotalIncl>4.95</TotalIncl>
        <TotalInclBeforeDiscount>5</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>4.95</TotalOutstandingExcl>
        <TotalOutstandingExclForeign>0</TotalOutstandingExclForeign>
        <TotalOutstandingIncl>4.95</TotalOutstandingIncl>
        <TotalOutstandingInclForeign>0</TotalOutstandingInclForeign>
        <TotalOutstandingTax>0</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>0</TotalTax>
        <TotalTaxBeforeDiscount>0</TotalTaxBeforeDiscount>
        <TotalTaxBeforeDiscountForeign>0</TotalTaxBeforeDiscountForeign>
        <TotalTaxForeign>0</TotalTaxForeign>
        <TotalTaxForeignRaw>0</TotalTaxForeignRaw>
        <TotalTaxRaw>0</TotalTaxRaw>
        <TotalToProcessExcl>4.95</TotalToProcessExcl>
        <TotalToProcessExclBeforeDiscount>5</TotalToProcessExclBeforeDiscount>
        <TotalToProcessExclBeforeDiscountForeign>0</TotalToProcessExclBeforeDiscountForeign>
        <TotalToProcessExclForeign>0</TotalToProcessExclForeign>
        <TotalToProcessExclRaw>4.95</TotalToProcessExclRaw>
        <TotalToProcessIncl>4.95</TotalToProcessIncl>
        <TotalToProcessInclBeforeDiscount>5</TotalToProcessInclBeforeDiscount>
        <TotalToProcessInclBeforeDiscountForeign>0</TotalToProcessInclBeforeDiscountForeign>
        <TotalToProcessInclForeign>0</TotalToProcessInclForeign>
        <TotalToProcessTax>0</TotalToProcessTax>
        <TotalToProcessTaxAfterDocumentDiscount>0</TotalToProcessTaxAfterDocumentDiscount>
        <TotalToProcessTaxBeforeDiscount>0</TotalToProcessTaxBeforeDiscount>
        <TotalToProcessTaxBeforeDiscountForeign>0</TotalToProcessTaxBeforeDiscountForeign>
        <TotalToProcessTaxForeign>0</TotalToProcessTaxForeign>
        <TotalToProcessTaxForeignAfterDocumentDiscount>0</TotalToProcessTaxForeignAfterDocumentDiscount>
        <TotalToProcessTaxForeignRaw>0</TotalToProcessTaxForeignRaw>
        <TotalToProcessTaxRaw>0</TotalToProcessTaxRaw>
        <Unit />
        <UnitCostPrice>0</UnitCostPrice>
        <UnitSellingPrice>5</UnitSellingPrice>
        <UnitSellingPriceAfterDiscount>4.95</UnitSellingPriceAfterDiscount>
        <UnitSellingPriceAfterDocumentDiscountExcl>4.95</UnitSellingPriceAfterDocumentDiscountExcl>
        <UnitSellingPriceExclAfterLineDiscount>4.95</UnitSellingPriceExclAfterLineDiscount>
        <UnitSellingPriceForeign>0</UnitSellingPriceForeign>
        <Warehouse />
      </OrderItem>
      <OrderItem>
        <Id>1</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>2</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>
    </OrderItems>
    <OrderNo>PO0001</OrderNo>
    <OrderPriority>
      <Description>Normal</Description>
    </OrderPriority>
    <OrderStatus />
    <OrderTotalRounding>0</OrderTotalRounding>
    <OrderTotalRoundingForeign>0</OrderTotalRoundingForeign>
    <PrintCount>0</PrintCount>
    <ProcessOnHold>false</ProcessOnHold>
    <Project />
    <Prospect />
    <Reference />
    <Reference2>TEST</Reference2>
    <SettlementTerms />
    <State>Unprocessed</State>
    <Supplier>
      <Id>1</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>5000</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 />
      <StatementZipPassword />
      <TaxNumber />
      <Telephone>0191 303 7279</Telephone>
      <Telephone2 />
      <Title />
      <UseEmail>false</UseEmail>
      <Webpage>www.zynk.com</Webpage>
      <BalanceBroughtForward>0</BalanceBroughtForward>
      <EmailRemittance>false</EmailRemittance>
      <PrintRemittance>false</PrintRemittance>
    </Supplier>
    <SupplierInvoiceNo>TEST</SupplierInvoiceNo>
    <TaxMode>Inclusive</TaxMode>
    <TaxNumber />
    <TaxType />
    <TotalDiscountAdjusted>0</TotalDiscountAdjusted>
    <TotalDiscountAdjustedForeign>0</TotalDiscountAdjustedForeign>
    <TotalExcl>14.95</TotalExcl>
    <TotalExclForeign>0</TotalExclForeign>
    <TotalIncl>16.25</TotalIncl>
    <TotalInclBeforeInvoiceRounding>16.25</TotalInclBeforeInvoiceRounding>
    <TotalInclForeign>0</TotalInclForeign>
    <TotalInclForeignBeforeInvoiceRounding>0</TotalInclForeignBeforeInvoiceRounding>
    <TotalLastProcessIncl>0</TotalLastProcessIncl>
    <TotalLastProcessInclForeign>0</TotalLastProcessInclForeign>
    <TotalLastProcessTax>0</TotalLastProcessTax>
    <TotalLastProcessTaxForeign>0</TotalLastProcessTaxForeign>
    <TotalLastProcessExcl>0</TotalLastProcessExcl>
    <TotalLastProcessExclForeign>0</TotalLastProcessExclForeign>
    <TotalOutstandingExcl>14.95</TotalOutstandingExcl>
    <TotalOutstandingExclForeign>0</TotalOutstandingExclForeign>
    <TotalOutstandingIncl>16.25</TotalOutstandingIncl>
    <TotalOutstandingInclForeign>0</TotalOutstandingInclForeign>
    <TotalOutstandingTax>1.3</TotalOutstandingTax>
    <TotalOutstandingTaxForeign>0</TotalOutstandingTaxForeign>
    <TotalTax>1.3</TotalTax>
    <TotalTaxForeign>0</TotalTaxForeign>
    <TotalToProcessExcl>14.95</TotalToProcessExcl>
    <TotalToProcessExclForeign>0</TotalToProcessExclForeign>
    <TotalToProcessIncl>16.25</TotalToProcessIncl>
    <TotalToProcessInclForeign>0</TotalToProcessInclForeign>
    <TotalToProcessTax>1.3</TotalToProcessTax>
    <TotalToProcessTaxForeign>0</TotalToProcessTaxForeign>
    <CustomFields>
      <CustomField>
        <Name>cQuoteNum</Name>
        <Value />
      </CustomField>
    </CustomFields>
  </PurchaseOrder>
</PurchaseOrders>