Skip to content

Importing Purchase Orders To Sage 200 Online

This task will insert new purchase orders into Sage 200 Online, from a Sage 200 Online Purchase Order XML file.

Settings

Sage 200 Online Connection

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

Fail File

Required
The XML file to output any records to which fail to upload to Sage.

Input File

Required
The XML file containing the records to upload to Sage. See below for a sample input file.

Success File

Required
The XML file to output any records to which are successfully uploaded to Sage.

Prevent Reprocessing

Required
When set to true this will prevent another record with the same <external_id> as a previously uploaded record from being uploaded to Sage.

Zynk Settings

See Common Task Settings.

Examples

Sample input file:

<?xml version="1.0" encoding="utf-8"?>
<PurchaseOrders xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <PurchaseOrder>
    <document_date>2023-02-28T00:00:00Z</document_date>
    <supplier_document_no>TEST</supplier_document_no>
    <settlement_discount_days>30</settlement_discount_days>
    <settlement_discount_percent>2.50</settlement_discount_percent>
    <document_discount_percent>0.00</document_discount_percent>
    <document_originator_id>0</document_originator_id>
    <requested_delivery_date>2023-03-10T00:00:00Z</requested_delivery_date>
    <analysis_code_1 />
    <analysis_code_2 />
    <analysis_code_3 />
    <analysis_code_4 />
    <analysis_code_5 />
    <analysis_code_6 />
    <analysis_code_7 />
    <analysis_code_8 />
    <analysis_code_9 />
    <analysis_code_10 />
    <analysis_code_11 />
    <analysis_code_12 />
    <analysis_code_13 />
    <analysis_code_14 />
    <analysis_code_15 />
    <analysis_code_16 />
    <analysis_code_17 />
    <analysis_code_18 />
    <analysis_code_19 />
    <analysis_code_20 />
    <lines>
      <line>
        <line_type>EnumLineTypeStandard</line_type>
        <product>
          <code>ENV001</code>
        </product>
        <code>ENV001</code> <!-- Used for additional charges -->
        <description>Envelope - White (110 x 220) Plain</description>
        <supplier_part_ref>UY923E</supplier_part_ref>
        <for_direct_delivery>false</for_direct_delivery>
        <show_on_supplier_docs>true</show_on_supplier_docs>
        <confirmation_intent_type>ConfirmOnReceipt</confirmation_intent_type>
        <line_quantity>40.0</line_quantity>
        <buying_unit_description>Each</buying_unit_description>
        <unit_buying_price>6.0</unit_buying_price>
        <unit_discount_percent>10.0</unit_discount_percent>
        <unit_discount_value>0.6</unit_discount_value>
        <line_total_value>216.0</line_total_value>
        <line_tax_value>43.2</line_tax_value>
        <analysis_code_1 />
        <analysis_code_2 />
        <analysis_code_3 />
        <analysis_code_4 />
        <analysis_code_5 />
        <analysis_code_6 />
        <analysis_code_7 />
        <analysis_code_8 />
        <analysis_code_9 />
        <analysis_code_10 />
        <analysis_code_11 />
        <analysis_code_12 />
        <analysis_code_13 />
        <analysis_code_14 />
        <analysis_code_15 />
        <analysis_code_16 />
        <analysis_code_17 />
        <analysis_code_18 />
        <analysis_code_19 />
        <analysis_code_20 />
        <product_id>34925</product_id>
        <warehouse_id>34627</warehouse_id>
      </line>
    </lines>
    <document_status>EnumDocumentStatusLive</document_status>
    <authorisation_status>EnumPOPAuthorisationStatusNotRequired</authorisation_status>
    <exchange_rate>1.000000</exchange_rate>
    <subtotal_goods_value>527.40</subtotal_goods_value>
    <subtotal_charges_net_value>0.00</subtotal_charges_net_value>
    <subtotal_discount_value>0.00</subtotal_discount_value>
    <subtotal_landed_costs_value>0.00</subtotal_landed_costs_value>
    <total_net_value>527.40</total_net_value>
    <total_tax_value>105.48</total_tax_value>
    <total_gross_value>632.88</total_gross_value>
    <document_originator_name />
    <document_created_by_id>2</document_created_by_id>
    <document_created_by>Jony Ive</document_created_by>
    <supplier>
      <reference>WIS002</reference>
    </supplier>
    <delivery_address>
      <address_1>Zynk Software</address_1>
      <address_2>6-8 Charlotte Square</address_2>
      <address_3 />
      <address_4 />
      <city>Newcastle</city>
      <county>Tyne &amp; Wear</county>
      <postcode>NE1 4XF</postcode>
      <contact>John Smith</contact>
      <postal_name />
      <country>Great Britain</country>
      <telephone_number>0191 820 1484</telephone_number>
      <fax_number />
      <email_address>[email protected]</email_address>
      <address_country_code>
        <code>GB</code>
      </address_country_code>
    </delivery_address>
  </PurchaseOrder>
</PurchaseOrders>