Zynk Workflow Documentation

This task will export new, modified or all stock inventory data 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

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 All Traceable

Required
Set to true to export all traceable items, or false to only export modified records. Only takes effect when Export Traceable is set to true.

Export Traceable

Required
Set to true to include details of traceable items in the export.

Export Settings

Optional

Query Settings

Optional

Query Timeout

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

Use Sales Trading Warehouse

Required
Set to true to use warehouses marked for trading sales.

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>
  <Inventories>
    <Inventory>
      <UniqueId>6688</UniqueId>
      <Sku>PROD001</Sku>
      <Barcode />
      <Locations>
        <Location>
          <UniqueId>1006</UniqueId>
          <Name>WAREHOUS</Name>
          <QtyInStock>0</QtyInStock>
          <QtyOnOrder>36</QtyOnOrder>
          <QtyAllocated>0</QtyAllocated>
          <AllowSalesTrading>true</AllowSalesTrading>
          <Bins>
            <Bin>
              <UniqueId>6694</UniqueId>
              <Name>Unspecified</Name>
              <QtyInStock>0</QtyInStock>
              <QtyAllocated>0</QtyAllocated>
              <Batches />
            </Bin>
          </Bins>
        </Location>
      </Locations>
    </Inventory>
    <Inventory>
      <UniqueId>6429</UniqueId>
      <Sku>PROD0002</Sku>
      <Barcode />
      <Locations>
        <Location>
          <UniqueId>1006</UniqueId>
          <Name>WAREHOUS</Name>
          <QtyInStock>9</QtyInStock>
          <QtyOnOrder>10</QtyOnOrder>
          <QtyAllocated>0</QtyAllocated>
          <AllowSalesTrading>true</AllowSalesTrading>
          <Bins>
            <Bin>
              <UniqueId>6435</UniqueId>
              <Name>Unspecified</Name>
              <QtyInStock>9</QtyInStock>
              <QtyAllocated>0</QtyAllocated>
              <Batches />
            </Bin>
          </Bins>
        </Location>
      </Locations>
    </Inventory>
  </Inventories>
</Company>

Back | Edit on Github