Zynk Workflow Documentation

This task will export sales orders from Sage 50 to Zynk XML format.

Settings

Sage 50 Connection

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

Export Settings

Required

Query Settings

Optional

Query Timeout

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

Use Base Currency

Required
Set to true to export all monetary values in the base currency, or false to use the account currency.

Output File

Required
The name of the file to export to. Data is exported in Zynk XML format

Zynk Settings

See Common Task Settings

Examples

Sample output file:

<?xml version="1.0"?>
<Company>
    <SalesOrders>
        <SalesOrder>
            <UniqueId>5</UniqueId>
            <CustomerId />
            <SalesOrderNumber>5</SalesOrderNumber>
            <CustomerOrderNumber />
            <Notes1 />
            <Notes2 />
            <Notes3 />
            <ForeignRate>1</ForeignRate>
            <AccountReference>BRO001</AccountReference>
            <CurrencyUsed>false</CurrencyUsed>
            <VatInclusive>false</VatInclusive>
            <SalesOrderDate>2009-01-24T00:00:00</SalesOrderDate>
            <DespatchDate>0001-01-01T00:00:00</DespatchDate>
            <DespatchStatus>Complete</DespatchStatus>
            <PromisedDeliveryDate xsi:nil="true" />
            <RequestedDeliveryDate xsi:nil="true" />
            <SalesOrderAddress>
                <Title />
                <Forename>Paul</Forename>
                <Surname>Guy</Surname>
                <Company>Bronson Inc</Company>
                <Description>Paul Guy - </Description>
                <Address1>18989 Royster Road</Address1>
                <Address2>Suite 343</Address2>
                <Address3 />
                <Town>Dallas Texas 769544</Town>
                <Postcode />
                <County>USA</County>
                <Country />
                <Email>newbusinessadvice@sage.com</Email>
                <Birthdate xsi:nil="true" />
                <Notes />
                <TaxCode>1</TaxCode>
                <CustomFields />
                <Activities />
                <Groups />
            </SalesOrderAddress>
            <SalesOrderDeliveryAddress>
                <Company>Bronson Inc</Company>
                <Description> - </Description>
                <Address1>18989 Royster Road</Address1>
                <Address2>Suite 343</Address2>
                <Address3 />
                <Town>Dallas Texas 769544</Town>
                <Postcode />
                <County>USA</County>
                <Country />
                <Email>newbusinessadvice@sage.com</Email>
                <Birthdate xsi:nil="true" />
                <Notes />
                <TaxCode>1</TaxCode>
                <CustomFields />
                <Activities />
                <Groups />
            </SalesOrderDeliveryAddress>
            <SalesOrderItems>
                <Item>
                    <Sku>PRN004</Sku>
                    <Name>JP020 Jet Printer</Name>
                    <Description />
                    <Comments>
                    </Comments>
                    <UnitOfSale>Each</UnitOfSale>
                    <QtyOrdered>6</QtyOrdered>
                    <UnitPrice>171</UnitPrice>
                    <UnitDiscountAmount>0</UnitDiscountAmount>
                    <UnitDiscountPercentage>0</UnitDiscountPercentage>
                    <Reference />
                    <TaxRate>0</TaxRate>
                    <CustomFields />
                    <AnalysisCodes />
                    <Batches />
                    <TotalNet>1026</TotalNet>
                    <TotalTax>0</TotalTax>
                    <TaxCode>0</TaxCode>
                    <NominalCode>4000</NominalCode>
                    <Type>Stock</Type>
                    <QtyAllocated>0</QtyAllocated>
                    <QtyDespatched>6</QtyDespatched>
                    <QtyReceived xsi:nil="true" />
                    <QtyInvoiced xsi:nil="true" />
                    <Status>Complete</Status>
                    <PromisedDeliveryDate xsi:nil="true" />
                    <RequestedDeliveryDate xsi:nil="true" />
                </Item>
                <Item>
                    <Sku>PC002</Sku>
                    <Name>PC Combo Pack 2</Name>
                    <Description />
                    <Comments>
                    </Comments>
                    <UnitOfSale>Each</UnitOfSale>
                    <QtyOrdered>5</QtyOrdered>
                    <UnitPrice>617.5</UnitPrice>
                    <UnitDiscountAmount>0</UnitDiscountAmount>
                    <UnitDiscountPercentage>0</UnitDiscountPercentage>
                    <Reference />
                    <TaxRate>0</TaxRate>
                    <CustomFields />
                    <AnalysisCodes />
                    <Batches />
                    <TotalNet>3087.5</TotalNet>
                    <TotalTax>0</TotalTax>
                    <TaxCode>0</TaxCode>
                    <NominalCode>4000</NominalCode>
                    <Type>Stock</Type>
                    <QtyAllocated>0</QtyAllocated>
                    <QtyDespatched>5</QtyDespatched>
                    <QtyReceived xsi:nil="true" />
                    <QtyInvoiced xsi:nil="true" />
                    <Status>Complete</Status>
                    <PromisedDeliveryDate xsi:nil="true" />
                    <RequestedDeliveryDate xsi:nil="true" />
                </Item>
                <Item>
                    <Sku>TR004</Sku>
                    <Name>JP020 Jet Printer Cartridge</Name>
                    <Description />
                    <Comments>
                    </Comments>
                    <UnitOfSale>Each</UnitOfSale>
                    <QtyOrdered>2</QtyOrdered>
                    <UnitPrice>14.25</UnitPrice>
                    <UnitDiscountAmount>0</UnitDiscountAmount>
                    <UnitDiscountPercentage>0</UnitDiscountPercentage>
                    <Reference />
                    <TaxRate>0</TaxRate>
                    <CustomFields />
                    <AnalysisCodes />
                    <Batches />
                    <TotalNet>28.5</TotalNet>
                    <TotalTax>0</TotalTax>
                    <TaxCode>0</TaxCode>
                    <NominalCode>4000</NominalCode>
                    <Type>Stock</Type>
                    <QtyAllocated>0</QtyAllocated>
                    <QtyDespatched>2</QtyDespatched>
                    <QtyReceived xsi:nil="true" />
                    <QtyInvoiced xsi:nil="true" />
                    <Status>Complete</Status>
                    <PromisedDeliveryDate xsi:nil="true" />
                    <RequestedDeliveryDate xsi:nil="true" />
                </Item>
                <Item>
                    <Sku>TR003</Sku>
                    <Name>JP010 Jet Printer Cartridge</Name>
                    <Description />
                    <Comments>
                    </Comments>
                    <UnitOfSale>Each</UnitOfSale>
                    <QtyOrdered>2</QtyOrdered>
                    <UnitPrice>17.1</UnitPrice>
                    <UnitDiscountAmount>0</UnitDiscountAmount>
                    <UnitDiscountPercentage>0</UnitDiscountPercentage>
                    <Reference />
                    <TaxRate>0</TaxRate>
                    <CustomFields />
                    <AnalysisCodes />
                    <Batches />
                    <TotalNet>34.2</TotalNet>
                    <TotalTax>0</TotalTax>
                    <TaxCode>0</TaxCode>
                    <NominalCode>4000</NominalCode>
                    <Type>Stock</Type>
                    <QtyAllocated>0</QtyAllocated>
                    <QtyDespatched>2</QtyDespatched>
                    <QtyReceived xsi:nil="true" />
                    <QtyInvoiced xsi:nil="true" />
                    <Status>Complete</Status>
                    <PromisedDeliveryDate xsi:nil="true" />
                    <RequestedDeliveryDate xsi:nil="true" />
                </Item>
            </SalesOrderItems>
            <Carriage>
                <Sku />
                <QtyOrdered xsi:nil="true" />
                <UnitPrice>0</UnitPrice>
                <UnitDiscountAmount xsi:nil="true" />
                <UnitDiscountPercentage xsi:nil="true" />
                <TaxRate xsi:nil="true" />
                <CustomFields />
                <AnalysisCodes />
                <Batches />
                <TotalNet>0</TotalNet>
                <TotalTax>0</TotalTax>
                <TaxCode>0</TaxCode>
                <NominalCode />
                <Department>6</Department>
                <Type>ChargeLine</Type>
                <QtyAllocated xsi:nil="true" />
                <QtyDespatched xsi:nil="true" />
                <QtyReceived xsi:nil="true" />
                <QtyInvoiced xsi:nil="true" />
                <PromisedDeliveryDate xsi:nil="true" />
                <RequestedDeliveryDate xsi:nil="true" />
            </Carriage>
            <TakenBy />
            <ConsignmentNo />
            <Courier xsi:nil="true" />
            <SettlementDays xsi:nil="true" />
            <SettlementDiscount>4071.79</SettlementDiscount>
            <GlobalTaxCode xsi:nil="true" />
            <PaymentRef />
            <PaymentAmount>0</PaymentAmount>
            <BankAccount>1200</BankAccount>
            <TaxNumber />
            <Status>Complete</Status>
            <NetValueDiscountComment1 />
            <NetValueDiscountComment2 />
            <NetValueDiscountDescription />
            <NetValueDiscount>0</NetValueDiscount>
            <NetValueDiscountPercent>0</NetValueDiscountPercent>
            <DiscountType xsi:nil="true" />
            <CustomFields />
            <AnalysisCodes />
        </SalesOrder>
    </SalesOrders>
</Company>

Back | Edit on Github