Zynk Workflow Documentation

This task will insert new and update existing credit memos in Quickbooks Online, from an XML file. The logic surrounding inserting/updating credit memos works as follows:

  1. If an Id is provided for the credit memo, and a credit memo already exists in Quickbooks with this Id, the existing credit memo will be updated.
  2. If an ExternalId is provided for the credit memo, and a match is found in Zynk’s truth table, the existing credit memo will be updated.
  3. If a DocNumber is provided for the credit memo, and a credit memo already exists in Quickbooks with this DocNumber, the existing credit memo will be updated.
  4. If none of the above conditions are fulfilled, a new credit memo will be created.

Upload Credit Memos

Connection

Required
Select a connection to the Quickbooks Online company you want to use. See Connecting to QuickBooks Online

Fail File

Required
The XML file to output any records to which fail to import to Quickbooks.

Input File

Required
The XML file containing the records to import to Quickbooks. See below for a sample input file.

Success File

Required
The XML file to output any records to which are successfully imported to Quickbooks.

Prevent Reprocessing

Required
Set to true to prevent the same records being imported to Quickbooks more than once. Only works on records where an ExternalId is provided in the input file.

Examples

Sample input file:

    <?xml version="1.0" encoding="utf-8"?>
    <ArrayOfCreditMemo xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
      <RecordOfCreditMemo>
        <ExternalId>7440</ExternalId>
        <Data domain="QBO" xmlns="http://schema.intuit.com/finance/v3">
          <AutoDocNumber>true</AutoDocNumber>
          <TxnDate>2016-07-06T00:00:00</TxnDate>
          <CurrencyRef>GBP</CurrencyRef>
          <Line>
            <LineNum>1</LineNum>
            <Description>Catering -- food &amp;amp; beverage</Description>
            <Amount>50</Amount>
            <DetailType>SalesItemLineDetail</DetailType>
            <SalesItemLineDetail>
              <ItemRef name="Catering"></ItemRef>
              <UnitPrice>50</UnitPrice>
              <Qty>1</Qty>
              <TaxCodeRef name="20.0% S"></TaxCodeRef>
            </SalesItemLineDetail>
          </Line>
          <CustomerRef name="Zynk Software">
          </CustomerRef>
          <GlobalTaxCalculation>TaxExcluded</GlobalTaxCalculation>
          <PrintStatus>NotSet</PrintStatus>
          <EmailStatus>NeedToSend</EmailStatus>
          <BillEmail>
            <Address>support@zynk.com</Address>
          </BillEmail>
          <DeliveryInfo>
            <DeliveryType>Email</DeliveryType>
          </DeliveryInfo>
          <BillAddr>
            <Line1>Zynk Software</Line1>
            <Line2>Nelson House</Line2>
            <Line3>Jesmond</Line3>
            <City>Newcastle</City>
            <CountrySubDivisionCode>Tyne &amp;amp; Wear</CountrySubDivisionCode>
            <Country>England</Country>
            <PostalCode>NE2 3AE</PostalCode>
          </BillAddr>
          <ShipAddr>
            <Line1>Zynk Software</Line1>
            <Line2>Nelson House</Line2>
            <Line3>Jesmond</Line3>
            <City>Newcastle</City>
            <CountrySubDivisionCode>Tyne &amp;amp; Wear</CountrySubDivisionCode>
            <Country>England</Country>
            <PostalCode>NE2 3AE</PostalCode>
          </ShipAddr>
        </Data>
      </RecordOfCreditMemo>
    </ArrayOfCreditMemo>


Back | Edit on Github