Exporting Purchase Orders from ConnectWise REST Interface

This task will export purchase orders from the Procurement -> Purchase Orders area of ConnectWise in an XML format. The results can be filtered using the Conditions if required. See below for a sample output file.

Settings

ConnectWise REST Interface Connection

Required
The ConnectWise REST Interface connection to use. See the Connecting to ConnectWise REST Interface article if you require more information on how to create/manage connections.

Conditions

Optional
Use this setting to specify where clauses to filter the records returned. This setting is used to specify conditions applying to standard fields.

Condition > Comparison

Required
The following types of filter are available:

• Equals - Returns records where the field matches the specified value.
• Contains - Returns records where the field contains the specified value. This filter type is only valid for String fields on ConnectWise.
• GreaterThan - Returns records where the field is greater than the specified value. This filter type is only valid for Numeric and DateTime fields on ConnectWise.
• GreaterThanOrEqual - Returns records where the field is greater than or equal to the specified value. This filter type is only valid for Numeric and DateTime fields on ConnectWise.
• In - Returns records where the field matches one of the specified values. Must be enclosed in parenthesis, with multiple values separated by a comma. e.g. ("John", "Ben") for string values, (1, 3) for numeric values. See the Condition > Value section below for more information on how different value types should be entered.
• Like - Returns records where the field matches the specified value. The asterisk (*) character can be used as a wild card. This filter type is only valid for String fields on ConnectWise.
• LessThan - Returns records where the field is less than the specified value. This filter type is only valid for Numeric and DateTime fields on ConnectWise.
• LessThanOrEqual - Returns records where the field is less than or equal to the specified value. This filter type is only valid for Numeric and DateTime fields on ConnectWise.
• NotContains - Returns records where the field does not contain the specified value. This filter type is only valid for String fields on ConnectWise.
• NotEqual - Returns records where the field does not match the specified value.
• NotIn - Returns records where the field does not match one of the specified values. Must be enclosed in parenthesis, with multiple values separated by a comma. e.g. ("John", "Ben") for string values, (1, 3) for numeric values etc. See the Condition > Value section below for more information on how different value types should be entered.
• NotLike - Returns records where the field does not match the specified value. The asterisk (*) character can be used as a wild card. This filter type is only valid for String fields on ConnectWise.

Condition > Field

Required
The name of the field the condition applies to. The name should match the API field name, as seen in the output file. If using a reference field, include the name of the reference field followed by a slash, then the field to filter on.

The supported fields are listed below: -

• id (Integer)
• businessUnitId (Integer) nullable
• cancelReason (String)
• closedFlag (Boolean) nullable
• customerCity (String)
• customerCompany/id (Integer) nullable
• customerCompany/identifier (String)
• customerCompany/name (String)
• customerContact/id (Integer) nullable
• customerContact/name (String)
• customerCountry/id (Integer) nullable
• customerCountry/identifier (String)
• customerCountry/name (String)
• customerExtension (String)
• customerName (String)
• customerPhone (String)
• customerSite/id (Integer) nullable
• customerSite/name (String)
• customerSiteName (String)
• customerState (String)
• customerStreetLine1 (String)
• customerStreetLine2 (String)
• customerZip (String)
• dateClosed (String)
• dropShipCustomerFlag (Boolean) nullable
• enteredBy (String)
• freightCost (Decimal) nullable
• freightPackingSlip (String)
• freightTaxTotal (Decimal) nullable
• internalNotes (String)
• locationId (Integer) nullable
• poDate (DateTime) nullable
• poNumber (String)
• salesTax (Decimal) nullable
• shipmentDate (DateTime) nullable
• shipmentMethod/id (Integer) nullable
• shipmentMethod/name (String)
• shippingInstructions (String)
• status/id (Integer) nullable
• status/name (String)
• subTotal (Decimal) nullable
• taxCode/id (Integer) nullable
• taxCode/name (String)
• taxFreightFlag (Boolean) nullable
• taxPoFlag (Boolean) nullable
• terms/id (Integer) nullable
• terms/name (String)
• total (Decimal) nullable
• trackingNumber (String)
• updateShipmentInfo (Boolean) nullable
• updateVendorOrderNumber (Boolean) nullable
• vendorCompany/id (Integer) nullable
• vendorCompany/identifier (String)
• vendorCompany/name (String)
• vendorContact/id (Integer) nullable
• vendorContact/name (String)
• vendorInvoiceDate (DateTime) nullable
• vendorInvoiceNumber (String)
• vendorOrderNumber (String)
• vendorSite/id (Integer) nullable
• vendorSite/name (String)
• warehouse/id (Integer) nullable
• warehouse/name (String)
• currency/id (Integer) nullable
• currency/symbol (String)
• currency/isoCode (String)
• currency/name (String)

Condition > Logic Operator

Optional
The logic operator to use for the condition being added when building the where clause. Choose from:

• And - Will return records which meet both of the conditions specified.
• Or - Will return records which meet at least of the conditions specified.

Condition > Value

Optional
The value to use in the filter.

• String values should be surrounded by quotes. e.g. "John"
• Boolean values should be specified as either True or False, with no quotes.
• Datetime values should be specified in ISO8601 format, surrounded by square brackets. e.g. [2000-01-31T14:51:00Z]
• Null is specified as null.
• When using the In or NotIn comparison, values must be separated by a comma and be surrounded by rounded brackets. e.g. ("John", "Ben"). See how different values types should be specified above.

Custom Field Conditions

Optional
Use this setting to specify where clauses to filter the records returned. This setting is used to specify conditions applying to custom fields.

Custom Field Condition > Comparison

Required
The following types of filter are available:

• Equals - Returns records where the field matches the specified value.
• Contains - Returns records where the field contains the specified value. This filter type is only valid for String fields on ConnectWise.
• GreaterThan - Returns records where the field is greater than the specified value. This filter type is only valid for Numeric and DateTime fields on ConnectWise.
• GreaterThanOrEqual - Returns records where the field is greater than or equal to the specified value. This filter type is only valid for Numeric and DateTime fields on ConnectWise.
• In - Returns records where the field matches one of the specified values. Must be enclosed in parenthesis, with multiple values separated by a comma. e.g. ("John", "Ben") for string values, (1, 3) for numeric values. See the Condition > Value section below for more information on how different value types should be entered.
• Like - Returns records where the field matches the specified value. The asterisk (*) character can be used as a wild card. This filter type is only valid for String fields on ConnectWise.
• LessThan - Returns records where the field is less than the specified value. This filter type is only valid for Numeric and DateTime fields on ConnectWise.
• LessThanOrEqual - Returns records where the field is less than or equal to the specified value. This filter type is only valid for Numeric and DateTime fields on ConnectWise.
• NotContains - Returns records where the field does not contain the specified value. This filter type is only valid for String fields on ConnectWise.
• NotEqual - Returns records where the field does not match the specified value.
• NotIn - Returns records where the field does not match one of the specified values. Must be enclosed in parenthesis, with multiple values separated by a comma. e.g. ("John", "Ben") for string values, (1, 3) for numeric values etc. See the Condition > Value section below for more information on how different value types should be entered.
• NotLike - Returns records where the field does not match the specified value. The asterisk (*) character can be used as a wild card. This filter type is only valid for String fields on ConnectWise.

Custom Field Condition > Field

Required
The caption of the custom field that the condition applies to. You can find the caption by looking at how the custom field appears in ConnectWise or by finding the custom field in an export file via Zynk.

Custom Field Condition > Logic Operator

Optional
The logic operator to use for the condition being added when building the where clause. Choose from:

• And - Will return records which meet both of the conditions specified.
• Or - Will return records which meet at least of the conditions specified.

Custom Field Condition > Value

Optional
The value to use in the filter.

• String values should be surrounded by quotes. e.g. "John"
• Boolean values should be specified as either True or False, with no quotes.
• Datetime values should be specified in ISO8601 format, surrounded by square brackets. e.g. [2000-01-31T14:51:00Z]
• Null is specified as null.
• When using the In or NotIn comparison, values must be separated by a comma and be surrounded by rounded brackets. e.g. ("John", "Ben"). See how different values types should be specified above.

Export Settings > Date Created

Required
When the 'Export Modified, New or All Records' setting is set to 'New', only batches created after this date will be exported. This date will update automatically each time the task runs, to ensure only new batches are exported each time.

Defaults to the current date and time.

Export Settings > Date Modified

Required
When the 'Export Modified, New or All Records' setting is set to 'Modified', only batches updated after this date will be downloaded. This date will update automatically each time the task runs, to ensure only modified batches are exported each time.

Defaults to the current date and time.

Export Settings > Export Modified, New or All Records

Required
Choose which records should be downloaded. The available options are:

• Modified - Only records updated after the date shown in the 'Date Modified' setting will be downloaded.
• New - Only records created after the date shown in the 'Date Created' setting will be downloaded.
• All - All records will be downloaded, regardless of when they were created or updated.

Defaults to Modified.

Export Settings > Page Size

Required
The number of records to include in each page of results. Increasing this value will reduce the number of requests made to the API but will increase the amount of memory needed while making each request.

Defaults to 100.
The maximum value is 1000.

Output File

Required
The name of the file to save the exported records to.

Defaults to connectwise_export_purchase_orders.xml

References To Fetch

Optional
The exported data may include fields which reference other record types in ConnectWise. If you specify the reference field names in this setting the task will fetch the related records and include them in the exported data.

The supported record types are listed below: -

• customerCompany
• customerContact
• customerSite
• shipmentMethod
• status
• taxCode
• terms
• vendorCompany
• vendorContact
• vendorSite
• warehouse
• currency
• purchaseOrderItems (Specify to export Products relating to each purchase order)
• purchaseOrderItem/product
• purchaseOrderItem/shipmentMethod
• purchaseOrderItem/warehouse
• purchaseOrderItem/warehouseBin

References To Fetch Page Size

Required
The number of referenced records to fetch per page. Increasing this value will reduce the number of requests made to the API but will increase the amount of memory needed while making each request.

Defaults to 100.
The maximum value is 1000.

Timeout

Optional
The maximum length of time to wait (in seconds) for API requests to be processed. Specifying this value will override the timeout set at the connection level. Leave blank to use the value specified in the connection.

Zynk Settings

See Common Task Settings

Examples

A sample output file is shown below.

<?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>
    <id>1</id>
    <externalId />
    <_info>
      <dateEntered>2011-03-23T18:48:40Z</dateEntered>
      <enteredBy>Admin1</enteredBy>
      <lastUpdated>2011-03-23T18:48:40Z</lastUpdated>
      <updatedBy>Admin1</updatedBy>
    </_info>
    <businessUnitId>10</businessUnitId>
    <closedFlag>false</closedFlag>
    <customerCompany>
      <id>37</id>
      <name>Arts Midwest</name>
      <record>
        <id>37</id>
        <_info>
          <dateEntered>2006-11-29T14:53:30Z</dateEntered>
          <enteredBy>CONVERSION</enteredBy>
          <lastUpdated>2006-11-29T14:53:30Z</lastUpdated>
          <updatedBy>Import2</updatedBy>
        </_info>
        <identifier>ArtsMidwest</identifier>
        <name>Arts Midwest</name>
        <status>
          <id>1</id>
          <name>Active</name>
        </status>
        <type>
          <id>1</id>
          <name>Customer</name>
        </type>
        <addressLine1>2908 Hennepin Avenue</addressLine1>
        <city>Minneapolis</city>
        <state>MN</state>
        <zip>55408</zip>
        <phoneNumber>6123410755</phoneNumber>
        <website>http://www.artsmidwest.org</website>
        <territory>
          <id>42</id>
          <name>Clearwater Office</name>
        </territory>
        <marketId>0</marketId>
        <accountNumber>Arts Midwest</accountNumber>
        <dateAcquired>2006-11-29T14:53:30Z</dateAcquired>
        <annualRevenue>0.00</annualRevenue>
        <numberOfEmployees>0</numberOfEmployees>
        <timeZone>
          <id>1</id>
          <name>US Eastern</name>
        </timeZone>
        <leadSource />
        <leadFlag>false</leadFlag>
        <unsubscribeFlag>false</unsubscribeFlag>
        <calendarId xsi:nil="true" />
        <taxCode>
          <id>11</id>
          <name>Standard VAT</name>
        </taxCode>
        <billingTerms>
          <id>2</id>
          <name>Net 10</name>
        </billingTerms>
        <billToCompany>
          <id>37</id>
          <name>Arts Midwest</name>
          <identifier>ArtsMidwest</identifier>
        </billToCompany>
        <invoiceDeliveryMethod>
          <id>1</id>
          <name>Mail</name>
        </invoiceDeliveryMethod>
        <deletedFlag>false</deletedFlag>
        <dateDeleted xsi:nil="true" />
        <mobileGuid>1590344d-f093-4d56-b073-07188657d2c5</mobileGuid>
        <customFields>
          <customField>
            <id>3</id>
            <caption>test</caption>
            <type>Text</type>
            <entryMethod>EntryField</entryMethod>
            <numberOfDecimals>0</numberOfDecimals>
          </customField>
          <customField>
            <id>6</id>
            <caption>CustomNumber</caption>
            <type>Number</type>
            <entryMethod>EntryField</entryMethod>
            <numberOfDecimals>2</numberOfDecimals>
          </customField>
          <customField>
            <id>7</id>
            <caption>Salesperson</caption>
            <type>Text</type>
            <entryMethod>List</entryMethod>
            <numberOfDecimals>0</numberOfDecimals>
          </customField>
        </customFields>
      </record>
      <identifier>ArtsMidwest</identifier>
    </customerCompany>
    <customerSite>
      <id>41</id>
      <name>Main</name>
      <record>
        <id>41</id>
        <_info>
          <dateEntered>2006-11-29T09:53:30Z</dateEntered>
          <enteredBy>CONVERSION</enteredBy>
          <lastUpdated>2006-11-29T09:53:30Z</lastUpdated>
          <updatedBy>Import2</updatedBy>
        </_info>
        <name>Main</name>
        <addressLine1>2908 Hennepin Avenue</addressLine1>
        <city>Minneapolis</city>
        <state>MN</state>
        <zip>55408</zip>
        <taxCodeId xsi:nil="true" />
        <expenseReimbursement xsi:nil="true" />
        <primaryAddressFlag>true</primaryAddressFlag>
        <defaultShippingFlag>false</defaultShippingFlag>
        <defaultBillingFlag>false</defaultBillingFlag>
        <defaultMailingFlag>false</defaultMailingFlag>
        <inactiveFlag>false</inactiveFlag>
        <mobileGuid>daaaed17-52ca-4cc3-afbb-6ae22602948e</mobileGuid>
        <timeZone>
          <id>1</id>
          <name>US Eastern</name>
        </timeZone>
        <company>
          <id>37</id>
          <name>Arts Midwest</name>
          <identifier>ArtsMidwest</identifier>
        </company>
      </record>
    </customerSite>
    <dateClosed xsi:nil="true" />
    <dropShipCustomerFlag>true</dropShipCustomerFlag>
    <enteredBy>Admin1</enteredBy>
    <freightCost>0</freightCost>
    <freightTaxTotal>0.00</freightTaxTotal>
    <locationId>2</locationId>
    <poDate>2011-03-23T00:00:00Z</poDate>
    <poNumber>0</poNumber>
    <salesTax>0.00</salesTax>
    <shipmentDate xsi:nil="true" />
    <shipmentMethod>
      <id>8</id>
      <name>Courier Service</name>
      <record>
        <id>8</id>
        <_info>
          <lastUpdated>2006-10-25T04:00:00Z</lastUpdated>
          <updatedBy>risaacs</updatedBy>
        </_info>
        <name>Courier Service</name>
        <defaultFlag>false</defaultFlag>
        <shippingType>CourierService</shippingType>
      </record>
    </shipmentMethod>
    <status>
      <id>1</id>
      <name>New</name>
      <record>
        <id>1</id>
        <_info>
          <dateEntered>2015-08-31T16:53:37Z</dateEntered>
          <enteredBy>CONVERSION</enteredBy>
          <lastUpdated>2015-08-31T16:53:37Z</lastUpdated>
          <updatedBy>CONVERSION</updatedBy>
        </_info>
        <name>New</name>
        <defaultFlag>true</defaultFlag>
        <closedFlag>false</closedFlag>
        <inactiveFlag>false</inactiveFlag>
        <defaultClosedFlag>false</defaultClosedFlag>
        <sortOrder>1</sortOrder>
      </record>
    </status>
    <subTotal>200.00000000</subTotal>
    <taxCode>
      <id>11</id>
      <name>Standard VAT</name>
      <record>
        <id>11</id>
        <_info>
          <dateEntered>2013-07-11T13:55:59Z</dateEntered>
          <enteredBy>CONVERSION</enteredBy>
          <lastUpdated>2013-07-11T13:55:59Z</lastUpdated>
          <updatedBy>Admin1</updatedBy>
        </_info>
        <identifier>1</identifier>
        <description>Standard VAT</description>
        <invoiceCaption>VAT</invoiceCaption>
        <country>
          <id>1</id>
          <name>United States</name>
        </country>
        <effectiveDate>2005-05-02T00:00:00Z</effectiveDate>
        <defaultFlag>false</defaultFlag>
        <displayOnInvoiceFlag>false</displayOnInvoiceFlag>
        <canadaCalculateGSTFlag>false</canadaCalculateGSTFlag>
        <levelOneRate>0.200000</levelOneRate>
        <levelOneRateType>Percent</levelOneRateType>
        <levelOneTaxableMax xsi:nil="true" />
        <levelOneCaption>Standard VAT</levelOneCaption>
        <levelOneTaxCodeXref>T1</levelOneTaxCodeXref>
        <levelOneServicesFlag>true</levelOneServicesFlag>
        <levelOneExpensesFlag>true</levelOneExpensesFlag>
        <levelOneProductsFlag>true</levelOneProductsFlag>
        <levelOneApplySingleUnitFlag>false</levelOneApplySingleUnitFlag>
        <levelOneApplySingleUnitMin xsi:nil="true" />
        <levelOneApplySingleUnitMax xsi:nil="true" />
        <levelTwoRate>0.000000</levelTwoRate>
        <levelTwoRateType>Percent</levelTwoRateType>
        <levelTwoTaxableMax xsi:nil="true" />
        <levelTwoServicesFlag>false</levelTwoServicesFlag>
        <levelTwoExpensesFlag>false</levelTwoExpensesFlag>
        <levelTwoProductsFlag>false</levelTwoProductsFlag>
        <levelTwoApplySingleUnitFlag>false</levelTwoApplySingleUnitFlag>
        <levelTwoApplySingleUnitMin xsi:nil="true" />
        <levelTwoApplySingleUnitMax xsi:nil="true" />
        <levelThreeRate>0.000000</levelThreeRate>
        <levelThreeRateType>Percent</levelThreeRateType>
        <levelThreeTaxableMax xsi:nil="true" />
        <levelThreeServicesFlag>false</levelThreeServicesFlag>
        <levelThreeExpensesFlag>false</levelThreeExpensesFlag>
        <levelThreeProductsFlag>false</levelThreeProductsFlag>
        <levelThreeApplySingleUnitFlag>false</levelThreeApplySingleUnitFlag>
        <levelThreeApplySingleUnitMin xsi:nil="true" />
        <levelThreeApplySingleUnitMax xsi:nil="true" />
        <levelFourRate>0.000000</levelFourRate>
        <levelFourRateType>Percent</levelFourRateType>
        <levelFourTaxableMax xsi:nil="true" />
        <levelFourServicesFlag>false</levelFourServicesFlag>
        <levelFourExpensesFlag>false</levelFourExpensesFlag>
        <levelFourProductsFlag>false</levelFourProductsFlag>
        <levelFourApplySingleUnitFlag>false</levelFourApplySingleUnitFlag>
        <levelFourApplySingleUnitMin xsi:nil="true" />
        <levelFourApplySingleUnitMax xsi:nil="true" />
        <levelFiveRate>0.000000</levelFiveRate>
        <levelFiveRateType>Percent</levelFiveRateType>
        <levelFiveTaxableMax xsi:nil="true" />
        <levelFiveServicesFlag>false</levelFiveServicesFlag>
        <levelFiveExpensesFlag>false</levelFiveExpensesFlag>
        <levelFiveProductsFlag>false</levelFiveProductsFlag>
        <levelFiveApplySingleUnitFlag>false</levelFiveApplySingleUnitFlag>
        <levelFiveApplySingleUnitMin xsi:nil="true" />
        <levelFiveApplySingleUnitMax xsi:nil="true" />
        <levelSixRate>0.000000</levelSixRate>
        <levelSixRateType>Percent</levelSixRateType>
        <levelSixTaxableMax xsi:nil="true" />
        <levelSixServicesFlag>false</levelSixServicesFlag>
        <levelSixExpensesFlag>false</levelSixExpensesFlag>
        <levelSixProductsFlag>false</levelSixProductsFlag>
        <levelSixApplySingleUnitFlag>false</levelSixApplySingleUnitFlag>
        <levelSixApplySingleUnitMin xsi:nil="true" />
        <levelSixApplySingleUnitMax xsi:nil="true" />
        <addAllWorkRoles xsi:nil="true" />
        <removeAllWorkRoles xsi:nil="true" />
        <expenseTypeIds>
          <int>5</int>
          <int>6</int>
        </expenseTypeIds>
        <addAllExpenseTypes xsi:nil="true" />
        <removeAllExpenseTypes xsi:nil="true" />
        <addAllProductTypes xsi:nil="true" />
        <removeAllProductTypes xsi:nil="true" />
      </record>
    </taxCode>
    <taxFreightFlag>false</taxFreightFlag>
    <taxPoFlag>false</taxPoFlag>
    <terms>
      <id>2</id>
      <name>Net 10</name>
      <record>
        <id>2</id>
        <_info>
          <dateEntered>2010-02-26T20:41:59Z</dateEntered>
          <enteredBy>CONVERSION</enteredBy>
          <lastUpdated>2010-02-26T20:41:59Z</lastUpdated>
          <updatedBy>zadmin</updatedBy>
        </_info>
        <name>Net 10</name>
        <defaultFlag>true</defaultFlag>
        <dueDays>10</dueDays>
        <termsXref>Net 10</termsXref>
      </record>
    </terms>
    <total>200.00</total>
    <updateShipmentInfo xsi:nil="true" />
    <updateVendorOrderNumber xsi:nil="true" />
    <vendorCompany>
      <id>8</id>
      <name>Angry Fox, Co.</name>
      <record>
        <id>8</id>
        <_info>
          <dateEntered>2005-03-21T15:43:44Z</dateEntered>
          <enteredBy>CONVERSION</enteredBy>
          <lastUpdated>2018-05-08T15:07:00Z</lastUpdated>
          <updatedBy>zynk</updatedBy>
        </_info>
        <identifier>AngryFoxCo</identifier>
        <name>Angry Fox, Co.</name>
        <status>
          <id>1</id>
          <name>Active</name>
        </status>
        <type>
          <id>1</id>
          <name>Customer</name>
        </type>
        <addressLine1>711 N. Franklin St.</addressLine1>
        <city>Detroit</city>
        <state>MI</state>
        <zip>92344</zip>
        <country>
          <id>1</id>
          <name>United States</name>
        </country>
        <phoneNumber>8131782000</phoneNumber>
        <faxNumber>8131782001</faxNumber>
        <website>http://www.AngryFox.com</website>
        <territory>
          <id>41</id>
          <name>Arnie's Accounts</name>
        </territory>
        <marketId xsi:nil="true" />
        <accountNumber>ANGRYF01</accountNumber>
        <defaultContact>
          <id>20</id>
          <name>Robert Storts</name>
        </defaultContact>
        <dateAcquired>2005-03-21T05:00:00Z</dateAcquired>
        <annualRevenue>0.00</annualRevenue>
        <numberOfEmployees xsi:nil="true" />
        <timeZone>
          <id>1</id>
          <name>US Eastern</name>
        </timeZone>
        <leadSource>Microsoft Tradeshow</leadSource>
        <leadFlag>false</leadFlag>
        <unsubscribeFlag>false</unsubscribeFlag>
        <calendarId xsi:nil="true" />
        <vendorIdentifier>AngryFox1010</vendorIdentifier>
        <taxCode>
          <id>11</id>
          <name>Standard VAT</name>
        </taxCode>
        <billingTerms>
          <id>2</id>
          <name>Net 10</name>
        </billingTerms>
        <billToCompany>
          <id>8</id>
          <name>Angry Fox, Co.</name>
          <identifier>AngryFoxCo</identifier>
        </billToCompany>
        <billingSite>
          <id>31</id>
          <name>Main</name>
        </billingSite>
        <billingContact>
          <id>20</id>
          <name>Robert Storts</name>
        </billingContact>
        <invoiceDeliveryMethod>
          <id>2</id>
          <name>E-Mail</name>
        </invoiceDeliveryMethod>
        <invoiceToEmailAddress>[email protected]</invoiceToEmailAddress>
        <deletedFlag>false</deletedFlag>
        <dateDeleted xsi:nil="true" />
        <mobileGuid>38a5f551-d40d-49e7-99f8-4fb5029df6ea</mobileGuid>
        <customFields>
          <customField>
            <id>3</id>
            <caption>test</caption>
            <type>Text</type>
            <entryMethod>EntryField</entryMethod>
            <numberOfDecimals>0</numberOfDecimals>
          </customField>
          <customField>
            <id>6</id>
            <caption>CustomNumber</caption>
            <type>Number</type>
            <entryMethod>EntryField</entryMethod>
            <numberOfDecimals>2</numberOfDecimals>
          </customField>
          <customField>
            <id>7</id>
            <caption>Salesperson</caption>
            <type>Text</type>
            <entryMethod>List</entryMethod>
            <numberOfDecimals>0</numberOfDecimals>
          </customField>
        </customFields>
      </record>
      <identifier>AngryFoxCo</identifier>
    </vendorCompany>
    <vendorContact>
      <id>20</id>
      <name>Robert Storts</name>
      <record>
        <id>20</id>
        <_info>
          <lastUpdated>2010-07-19T16:42:32Z</lastUpdated>
          <updatedBy>Admin1</updatedBy>
        </_info>
        <firstName>Robert</firstName>
        <lastName>Storts</lastName>
        <company>
          <id>8</id>
          <name>Angry Fox, Co.</name>
          <identifier>AngryFoxCo</identifier>
        </company>
        <site>
          <id>7</id>
          <name>Main</name>
        </site>
        <relationship>
          <id xsi:nil="true" />
        </relationship>
        <inactiveFlag>false</inactiveFlag>
        <defaultMergeContactId xsi:nil="true" />
        <managerContactId xsi:nil="true" />
        <assistantContactId xsi:nil="true" />
        <title>President</title>
        <marriedFlag>false</marriedFlag>
        <childrenFlag>false</childrenFlag>
        <portalSecurityLevel>6</portalSecurityLevel>
        <disablePortalLoginFlag>true</disablePortalLoginFlag>
        <unsubscribeFlag>false</unsubscribeFlag>
        <mobileGuid>59862c1a-fd4b-48c2-84db-3736e82f591e</mobileGuid>
        <defaultBillingFlag>true</defaultBillingFlag>
        <defaultFlag>true</defaultFlag>
        <communicationItems>
          <ContactCommunicationItem>
            <id>47</id>
            <type>
              <id>2</id>
              <_info />
              <name>Direct</name>
            </type>
            <value>8139888241</value>
            <defaultFlag>true</defaultFlag>
            <communicationType>Phone</communicationType>
          </ContactCommunicationItem>
          <ContactCommunicationItem>
            <id>48</id>
            <type>
              <id>1</id>
              <_info />
              <name>Email</name>
            </type>
            <value>[email protected]</value>
            <defaultFlag>true</defaultFlag>
            <communicationType>Email</communicationType>
          </ContactCommunicationItem>
        </communicationItems>
      </record>
    </vendorContact>
    <vendorInvoiceDate xsi:nil="true" />
    <vendorSite>
      <id>7</id>
      <name>Main</name>
      <record>
        <id>7</id>
        <_info>
          <dateEntered>2010-07-19T12:42:32Z</dateEntered>
          <enteredBy>CONVERSION</enteredBy>
          <lastUpdated>2010-07-19T12:42:32Z</lastUpdated>
          <updatedBy>Admin1</updatedBy>
        </_info>
        <name>Main</name>
        <addressLine1>711 N. Franklin St.</addressLine1>
        <city>Detroit</city>
        <state>MI</state>
        <zip>92344</zip>
        <country>
          <id>1</id>
          <name>United States</name>
        </country>
        <addressFormat>[companyaddressline1]
[companyaddressline2]
[companycitytown], [companystateprovince] [companypostalcode]
[companycountry]</addressFormat>
        <taxCodeId xsi:nil="true" />
        <expenseReimbursement xsi:nil="true" />
        <primaryAddressFlag>true</primaryAddressFlag>
        <defaultShippingFlag>false</defaultShippingFlag>
        <defaultBillingFlag>false</defaultBillingFlag>
        <defaultMailingFlag>false</defaultMailingFlag>
        <inactiveFlag>false</inactiveFlag>
        <mobileGuid>136a7dd0-343b-4e3f-88d5-44645f7f4f13</mobileGuid>
        <timeZone>
          <id>1</id>
          <name>US Eastern</name>
        </timeZone>
        <company>
          <id>8</id>
          <name>Angry Fox, Co.</name>
          <identifier>AngryFoxCo</identifier>
        </company>
      </record>
    </vendorSite>
    <currency>
      <id>4</id>
      <name>French Francs</name>
      <record>
        <id>4</id>
        <_info>
          <dateEntered>1999-06-21T12:03:44Z</dateEntered>
          <enteredBy>CONVERSION</enteredBy>
          <lastUpdated>2019-06-13T12:43:44Z</lastUpdated>
          <updatedBy>CURR_CONVERSION</updatedBy>
        </_info>
        <currencyIdentifier>FRF</currencyIdentifier>
        <name>French Francs</name>
        <symbol>FFr</symbol>
        <displayIdFlag>false</displayIdFlag>
        <displaySymbolFlag>false</displaySymbolFlag>
        <isoCode>EUR</isoCode>
      </record>
      <symbol>FFr</symbol>
      <isoCode>EUR</isoCode>
    </currency>
    <customFields>
      <customField>
        <id>1</id>
        <caption>Sign Off</caption>
        <type>Checkbox</type>
        <entryMethod>EntryField</entryMethod>
        <numberOfDecimals>0</numberOfDecimals>
      </customField>
    </customFields>
    <purchaseOrderItems>
      <purchaseOrderItem>
        <id>1</id>
        <_info>
          <dateEntered>2011-03-23T18:48:40Z</dateEntered>
          <enteredBy>Conversion</enteredBy>
          <lastUpdated>2011-03-23T18:48:40Z</lastUpdated>
          <updatedBy>Admin1</updatedBy>
        </_info>
        <backorderedFlag>false</backorderedFlag>
        <canceledFlag>false</canceledFlag>
        <closedFlag>false</closedFlag>
        <dateCanceled xsi:nil="true" />
        <dateCanceledUtc xsi:nil="true" />
        <description>SPAM -ConnectFilter</description>
        <displayInternalNotesFlag>false</displayInternalNotesFlag>
        <expectedShipDate xsi:nil="true" />
        <lineNumber>1</lineNumber>
        <packingSlip>0</packingSlip>
        <product>
          <id>750</id>
          <record>
            <id>750</id>
            <_info>
              <lastUpdated>2019-04-23T10:12:32Z</lastUpdated>
              <updatedBy>Admin1</updatedBy>
            </_info>
            <identifier>SPAM -ConnectFilter</identifier>
            <description>SPAM -ConnectFilter</description>
            <inactiveFlag>false</inactiveFlag>
            <subcategory>
              <id>38</id>
              <name>Managed Services</name>
            </subcategory>
            <type>
              <id>33</id>
              <name>Fixed Cost Service</name>
            </type>
            <productClass>NonInventory</productClass>
            <serializedFlag>false</serializedFlag>
            <serializedCostFlag>false</serializedCostFlag>
            <phaseProductFlag>false</phaseProductFlag>
            <unitOfMeasure>
              <id>12</id>
              <name>User-based</name>
            </unitOfMeasure>
            <minStockLevel>0</minStockLevel>
            <price>30.000000</price>
            <cost>2.000000</cost>
            <taxableFlag>false</taxableFlag>
            <customerDescription>ConnectFilter (10 accounts) 
--Powerful Spam Filtering
         -  Heuristic-based content analysis providing over 95% accuracy
         -  End-user flexibility: users can customize own filters
         -  Quarantined messages are accessible via a web-based Message Center for review and disposition
--Real-Time Virus Protection
         -  All message parts are scanned for infected viruses, and infected messages are quarantined in the user's ConnectFilter Message Center for review and disposition
         -  Built-in protection from new techniques, including message fragments
         -  Industry leading McAfee AVERT provides dedicated connection to McAfee virus definition servers, protecting customers from new viruses</customerDescription>
            <recurringFlag>false</recurringFlag>
            <recurringRevenue xsi:nil="true" />
            <recurringCost xsi:nil="true" />
            <recurringOneTimeFlag>false</recurringOneTimeFlag>
            <dateEntered>2014-04-11T16:07:49Z</dateEntered>
            <category>
              <id>18</id>
              <name>Managed Services</name>
            </category>
          </record>
          <identifier>SPAM -ConnectFilter</identifier>
        </product>
        <purchaseOrderId>1</purchaseOrderId>
        <quantity>20.00</quantity>
        <receivedQuantity>20</receivedQuantity>
        <shipDate xsi:nil="true" />
        <shipmentMethod>
          <id>8</id>
          <name>Courier Service</name>
          <record>
            <id>8</id>
            <_info>
              <lastUpdated>2006-10-25T04:00:00Z</lastUpdated>
              <updatedBy>risaacs</updatedBy>
            </_info>
            <name>Courier Service</name>
            <defaultFlag>false</defaultFlag>
            <shippingType>CourierService</shippingType>
          </record>
        </shipmentMethod>
        <tax>0.00</tax>
        <unitCost>10.000000</unitCost>
        <unitOfMeasure>
          <id>12</id>
          <name>User-based</name>
        </unitOfMeasure>
        <customFields>
          <customField>
            <id>9</id>
            <caption>Invoice No</caption>
            <type>Text</type>
            <entryMethod>EntryField</entryMethod>
            <numberOfDecimals>0</numberOfDecimals>
          </customField>
          <customField>
            <id>10</id>
            <caption>Invoice Date</caption>
            <type>Date</type>
            <entryMethod>EntryField</entryMethod>
            <numberOfDecimals>0</numberOfDecimals>
          </customField>
          <customField>
            <id>11</id>
            <caption>Confirmed</caption>
            <type>Checkbox</type>
            <entryMethod>EntryField</entryMethod>
            <numberOfDecimals>0</numberOfDecimals>
          </customField>
          <customField>
            <id>12</id>
            <caption>Invoice Cost Price</caption>
            <type>Number</type>
            <entryMethod>EntryField</entryMethod>
            <numberOfDecimals>2</numberOfDecimals>
          </customField>
        </customFields>
      </purchaseOrderItem>
    </purchaseOrderItems>
  </PurchaseOrder>
  <PurchaseOrder>
    <id>13</id>
    <externalId />
    <_info>
      <dateEntered>2014-04-30T09:57:49Z</dateEntered>
      <enteredBy>Admin1</enteredBy>
      <lastUpdated>2014-04-30T09:57:49Z</lastUpdated>
      <updatedBy>Admin1</updatedBy>
    </_info>
    <businessUnitId>10</businessUnitId>
    <closedFlag>false</closedFlag>
    <dateClosed xsi:nil="true" />
    <dropShipCustomerFlag>false</dropShipCustomerFlag>
    <enteredBy>Admin1</enteredBy>
    <freightCost>0</freightCost>
    <freightTaxTotal>0.00</freightTaxTotal>
    <locationId>2</locationId>
    <poDate>2014-04-11T10:56:28Z</poDate>
    <poNumber>12</poNumber>
    <salesTax>0.00</salesTax>
    <shipmentDate xsi:nil="true" />
    <status>
      <id>1</id>
      <name>New</name>
      <record>
        <id>1</id>
        <_info>
          <dateEntered>2015-08-31T16:53:37Z</dateEntered>
          <enteredBy>CONVERSION</enteredBy>
          <lastUpdated>2015-08-31T16:53:37Z</lastUpdated>
          <updatedBy>CONVERSION</updatedBy>
        </_info>
        <name>New</name>
        <defaultFlag>true</defaultFlag>
        <closedFlag>false</closedFlag>
        <inactiveFlag>false</inactiveFlag>
        <defaultClosedFlag>false</defaultClosedFlag>
        <sortOrder>1</sortOrder>
      </record>
    </status>
    <subTotal>86.00000000</subTotal>
    <taxCode>
      <id>11</id>
      <name>Standard VAT</name>
      <record>
        <id>11</id>
        <_info>
          <dateEntered>2013-07-11T13:55:59Z</dateEntered>
          <enteredBy>CONVERSION</enteredBy>
          <lastUpdated>2013-07-11T13:55:59Z</lastUpdated>
          <updatedBy>Admin1</updatedBy>
        </_info>
        <identifier>1</identifier>
        <description>Standard VAT</description>
        <invoiceCaption>VAT</invoiceCaption>
        <country>
          <id>1</id>
          <name>United States</name>
        </country>
        <effectiveDate>2005-05-02T00:00:00Z</effectiveDate>
        <defaultFlag>false</defaultFlag>
        <displayOnInvoiceFlag>false</displayOnInvoiceFlag>
        <canadaCalculateGSTFlag>false</canadaCalculateGSTFlag>
        <levelOneRate>0.200000</levelOneRate>
        <levelOneRateType>Percent</levelOneRateType>
        <levelOneTaxableMax xsi:nil="true" />
        <levelOneCaption>Standard VAT</levelOneCaption>
        <levelOneTaxCodeXref>T1</levelOneTaxCodeXref>
        <levelOneServicesFlag>true</levelOneServicesFlag>
        <levelOneExpensesFlag>true</levelOneExpensesFlag>
        <levelOneProductsFlag>true</levelOneProductsFlag>
        <levelOneApplySingleUnitFlag>false</levelOneApplySingleUnitFlag>
        <levelOneApplySingleUnitMin xsi:nil="true" />
        <levelOneApplySingleUnitMax xsi:nil="true" />
        <levelTwoRate>0.000000</levelTwoRate>
        <levelTwoRateType>Percent</levelTwoRateType>
        <levelTwoTaxableMax xsi:nil="true" />
        <levelTwoServicesFlag>false</levelTwoServicesFlag>
        <levelTwoExpensesFlag>false</levelTwoExpensesFlag>
        <levelTwoProductsFlag>false</levelTwoProductsFlag>
        <levelTwoApplySingleUnitFlag>false</levelTwoApplySingleUnitFlag>
        <levelTwoApplySingleUnitMin xsi:nil="true" />
        <levelTwoApplySingleUnitMax xsi:nil="true" />
        <levelThreeRate>0.000000</levelThreeRate>
        <levelThreeRateType>Percent</levelThreeRateType>
        <levelThreeTaxableMax xsi:nil="true" />
        <levelThreeServicesFlag>false</levelThreeServicesFlag>
        <levelThreeExpensesFlag>false</levelThreeExpensesFlag>
        <levelThreeProductsFlag>false</levelThreeProductsFlag>
        <levelThreeApplySingleUnitFlag>false</levelThreeApplySingleUnitFlag>
        <levelThreeApplySingleUnitMin xsi:nil="true" />
        <levelThreeApplySingleUnitMax xsi:nil="true" />
        <levelFourRate>0.000000</levelFourRate>
        <levelFourRateType>Percent</levelFourRateType>
        <levelFourTaxableMax xsi:nil="true" />
        <levelFourServicesFlag>false</levelFourServicesFlag>
        <levelFourExpensesFlag>false</levelFourExpensesFlag>
        <levelFourProductsFlag>false</levelFourProductsFlag>
        <levelFourApplySingleUnitFlag>false</levelFourApplySingleUnitFlag>
        <levelFourApplySingleUnitMin xsi:nil="true" />
        <levelFourApplySingleUnitMax xsi:nil="true" />
        <levelFiveRate>0.000000</levelFiveRate>
        <levelFiveRateType>Percent</levelFiveRateType>
        <levelFiveTaxableMax xsi:nil="true" />
        <levelFiveServicesFlag>false</levelFiveServicesFlag>
        <levelFiveExpensesFlag>false</levelFiveExpensesFlag>
        <levelFiveProductsFlag>false</levelFiveProductsFlag>
        <levelFiveApplySingleUnitFlag>false</levelFiveApplySingleUnitFlag>
        <levelFiveApplySingleUnitMin xsi:nil="true" />
        <levelFiveApplySingleUnitMax xsi:nil="true" />
        <levelSixRate>0.000000</levelSixRate>
        <levelSixRateType>Percent</levelSixRateType>
        <levelSixTaxableMax xsi:nil="true" />
        <levelSixServicesFlag>false</levelSixServicesFlag>
        <levelSixExpensesFlag>false</levelSixExpensesFlag>
        <levelSixProductsFlag>false</levelSixProductsFlag>
        <levelSixApplySingleUnitFlag>false</levelSixApplySingleUnitFlag>
        <levelSixApplySingleUnitMin xsi:nil="true" />
        <levelSixApplySingleUnitMax xsi:nil="true" />
        <addAllWorkRoles xsi:nil="true" />
        <removeAllWorkRoles xsi:nil="true" />
        <expenseTypeIds>
          <int>5</int>
          <int>6</int>
        </expenseTypeIds>
        <addAllExpenseTypes xsi:nil="true" />
        <removeAllExpenseTypes xsi:nil="true" />
        <addAllProductTypes xsi:nil="true" />
        <removeAllProductTypes xsi:nil="true" />
      </record>
    </taxCode>
    <taxFreightFlag>false</taxFreightFlag>
    <taxPoFlag>false</taxPoFlag>
    <terms>
      <id>2</id>
      <name>Net 10</name>
      <record>
        <id>2</id>
        <_info>
          <dateEntered>2010-02-26T20:41:59Z</dateEntered>
          <enteredBy>CONVERSION</enteredBy>
          <lastUpdated>2010-02-26T20:41:59Z</lastUpdated>
          <updatedBy>zadmin</updatedBy>
        </_info>
        <name>Net 10</name>
        <defaultFlag>true</defaultFlag>
        <dueDays>10</dueDays>
        <termsXref>Net 10</termsXref>
      </record>
    </terms>
    <total>86.00</total>
    <updateShipmentInfo xsi:nil="true" />
    <updateVendorOrderNumber xsi:nil="true" />
    <vendorCompany>
      <id>3</id>
      <name>CONNECTWISE</name>
      <record>
        <id>3</id>
        <_info>
          <dateEntered>2003-01-16T19:17:29Z</dateEntered>
          <enteredBy>CONVERSION</enteredBy>
          <lastUpdated>2018-05-08T15:06:55Z</lastUpdated>
          <updatedBy>zynk</updatedBy>
        </_info>
        <identifier>ConnectWise</identifier>
        <name>CONNECTWISE</name>
        <status>
          <id>13</id>
          <name>not-Approved</name>
        </status>
        <type>
          <id>6</id>
          <name>Vendor</name>
        </type>
        <addressLine1>2803 W Busch Blvd</addressLine1>
        <addressLine2>Suite 204</addressLine2>
        <city>Tampa</city>
        <state>FL</state>
        <zip>33618</zip>
        <phoneNumber />
        <faxNumber>8139302738</faxNumber>
        <marketId xsi:nil="true" />
        <accountNumber />
        <defaultContact>
          <id>2</id>
          <name>Arnie Bellini</name>
        </defaultContact>
        <dateAcquired>2003-01-16T19:17:29Z</dateAcquired>
        <annualRevenue>0.00</annualRevenue>
        <numberOfEmployees xsi:nil="true" />
        <timeZone>
          <id>1</id>
          <name>US Eastern</name>
        </timeZone>
        <leadFlag>false</leadFlag>
        <unsubscribeFlag>false</unsubscribeFlag>
        <calendarId xsi:nil="true" />
        <taxIdentifier>1</taxIdentifier>
        <taxCode>
          <id>11</id>
          <name>Standard VAT</name>
        </taxCode>
        <billingTerms>
          <id>2</id>
          <name>Net 10</name>
        </billingTerms>
        <billToCompany>
          <id>3</id>
          <name>CONNECTWISE</name>
          <identifier>ConnectWise</identifier>
        </billToCompany>
        <invoiceDeliveryMethod>
          <id>1</id>
          <name>Mail</name>
        </invoiceDeliveryMethod>
        <deletedFlag>false</deletedFlag>
        <dateDeleted xsi:nil="true" />
        <mobileGuid>89b7b64d-9d36-447b-acf3-525abc2a865a</mobileGuid>
        <customFields>
          <customField>
            <id>3</id>
            <caption>test</caption>
            <type>Text</type>
            <entryMethod>EntryField</entryMethod>
            <numberOfDecimals>0</numberOfDecimals>
          </customField>
          <customField>
            <id>6</id>
            <caption>CustomNumber</caption>
            <type>Number</type>
            <entryMethod>EntryField</entryMethod>
            <numberOfDecimals>2</numberOfDecimals>
          </customField>
          <customField>
            <id>7</id>
            <caption>Salesperson</caption>
            <type>Text</type>
            <entryMethod>List</entryMethod>
            <numberOfDecimals>0</numberOfDecimals>
          </customField>
        </customFields>
      </record>
      <identifier>ConnectWise</identifier>
    </vendorCompany>
    <vendorContact>
      <id>2</id>
      <name>Arnie Bellini</name>
      <record>
        <id>2</id>
        <_info>
          <lastUpdated>2005-11-30T00:53:25Z</lastUpdated>
          <updatedBy>User1</updatedBy>
        </_info>
        <firstName>Arnie</firstName>
        <lastName>Bellini</lastName>
        <company>
          <id>3</id>
          <name>CONNECTWISE</name>
          <identifier>ConnectWise</identifier>
        </company>
        <site>
          <id>2</id>
          <name>Main</name>
        </site>
        <relationship>
          <id xsi:nil="true" />
        </relationship>
        <inactiveFlag>false</inactiveFlag>
        <defaultMergeContactId xsi:nil="true" />
        <managerContactId xsi:nil="true" />
        <assistantContactId xsi:nil="true" />
        <title>CPA, MBA</title>
        <marriedFlag>false</marriedFlag>
        <childrenFlag>false</childrenFlag>
        <portalSecurityLevel>6</portalSecurityLevel>
        <disablePortalLoginFlag>true</disablePortalLoginFlag>
        <unsubscribeFlag>false</unsubscribeFlag>
        <mobileGuid>b3fc861c-0d33-48fd-b061-7178e57c17d4</mobileGuid>
        <defaultBillingFlag>false</defaultBillingFlag>
        <defaultFlag>true</defaultFlag>
        <communicationItems>
          <ContactCommunicationItem>
            <id>2</id>
            <type>
              <id>2</id>
              <_info />
              <name>Direct</name>
            </type>
            <value>8139357100</value>
            <extension>401</extension>
            <defaultFlag>true</defaultFlag>
            <communicationType>Phone</communicationType>
          </ContactCommunicationItem>
          <ContactCommunicationItem>
            <id>3</id>
            <type>
              <id>1</id>
              <_info />
              <name>Email</name>
            </type>
            <value>[email protected]</value>
            <defaultFlag>true</defaultFlag>
            <communicationType>Email</communicationType>
          </ContactCommunicationItem>
        </communicationItems>
      </record>
    </vendorContact>
    <vendorInvoiceDate xsi:nil="true" />
    <vendorSite>
      <id>2</id>
      <name>Main</name>
      <record>
        <id>2</id>
        <_info>
          <dateEntered>2003-12-19T08:28:17Z</dateEntered>
          <enteredBy>CONVERSION</enteredBy>
          <lastUpdated>2018-05-08T15:06:55Z</lastUpdated>
          <updatedBy>zynk</updatedBy>
        </_info>
        <name>Main</name>
        <addressLine1>2803 W Busch Blvd</addressLine1>
        <addressLine2>Suite 204</addressLine2>
        <city>Tampa</city>
        <state>FL</state>
        <zip>33618</zip>
        <phoneNumber />
        <faxNumber />
        <taxCodeId xsi:nil="true" />
        <expenseReimbursement xsi:nil="true" />
        <primaryAddressFlag>true</primaryAddressFlag>
        <defaultShippingFlag>false</defaultShippingFlag>
        <defaultBillingFlag>false</defaultBillingFlag>
        <defaultMailingFlag>false</defaultMailingFlag>
        <inactiveFlag>false</inactiveFlag>
        <mobileGuid>526247cf-bd58-489c-9695-14e4f74ae62a</mobileGuid>
        <timeZone>
          <id>1</id>
          <name>US Eastern</name>
        </timeZone>
        <company>
          <id>3</id>
          <name>CONNECTWISE</name>
          <identifier>ConnectWise</identifier>
        </company>
      </record>
    </vendorSite>
    <warehouse>
      <id>1</id>
      <name>Default</name>
      <record>
        <id>1</id>
        <_info>
          <lastUpdated>2019-10-08T16:06:34Z</lastUpdated>
          <updatedBy>Admin1</updatedBy>
        </_info>
        <name>Default</name>
        <company>
          <id>2</id>
          <name>Your Company</name>
          <identifier>YourCompany</identifier>
        </company>
        <location>
          <id>2</id>
          <name>Tampa Office</name>
        </location>
        <department>
          <id>10</id>
          <name>Professional Services</name>
        </department>
        <manager>
          <id>150</id>
          <name>zSys Admin</name>
          <identifier>zAdmin</identifier>
        </manager>
        <site>
          <id>133</id>
          <name>test</name>
        </site>
        <locationDefaultFlag>true</locationDefaultFlag>
        <overallDefaultFlag>false</overallDefaultFlag>
        <inactiveFlag>false</inactiveFlag>
        <currency>
          <id>4</id>
          <name>French Francs</name>
          <symbol>FFr</symbol>
          <isoCode>EUR</isoCode>
        </currency>
      </record>
    </warehouse>
    <currency>
      <id>4</id>
      <name>French Francs</name>
      <record>
        <id>4</id>
        <_info>
          <dateEntered>1999-06-21T12:03:44Z</dateEntered>
          <enteredBy>CONVERSION</enteredBy>
          <lastUpdated>2019-06-13T12:43:44Z</lastUpdated>
          <updatedBy>CURR_CONVERSION</updatedBy>
        </_info>
        <currencyIdentifier>FRF</currencyIdentifier>
        <name>French Francs</name>
        <symbol>FFr</symbol>
        <displayIdFlag>false</displayIdFlag>
        <displaySymbolFlag>false</displaySymbolFlag>
        <isoCode>EUR</isoCode>
      </record>
      <symbol>FFr</symbol>
      <isoCode>EUR</isoCode>
    </currency>
    <customFields>
      <customField>
        <id>1</id>
        <caption>Sign Off</caption>
        <type>Checkbox</type>
        <entryMethod>EntryField</entryMethod>
        <numberOfDecimals>0</numberOfDecimals>
      </customField>
    </customFields>
    <purchaseOrderItems>
      <purchaseOrderItem>
        <id>14</id>
        <_info>
          <dateEntered>2014-04-11T14:58:35Z</dateEntered>
          <enteredBy>Conversion</enteredBy>
          <lastUpdated>2014-04-11T14:58:35Z</lastUpdated>
          <updatedBy>Admin1</updatedBy>
        </_info>
        <backorderedFlag>false</backorderedFlag>
        <canceledFlag>false</canceledFlag>
        <closedFlag>false</closedFlag>
        <dateCanceled xsi:nil="true" />
        <dateCanceledUtc xsi:nil="true" />
        <description>10ft Patch Cable</description>
        <displayInternalNotesFlag>false</displayInternalNotesFlag>
        <expectedShipDate xsi:nil="true" />
        <lineNumber>1</lineNumber>
        <packingSlip>TEST</packingSlip>
        <product>
          <id>743</id>
          <record>
            <id>743</id>
            <_info>
              <lastUpdated>2019-10-02T09:40:06Z</lastUpdated>
              <updatedBy>Admin1</updatedBy>
            </_info>
            <identifier>PATCH10</identifier>
            <description>10ft Patch Cable</description>
            <inactiveFlag>false</inactiveFlag>
            <subcategory>
              <id>24</id>
              <name>Miscellaneous</name>
            </subcategory>
            <type>
              <id>32</id>
              <name>Miscellaneous</name>
            </type>
            <productClass>NonInventory</productClass>
            <serializedFlag>false</serializedFlag>
            <serializedCostFlag>false</serializedCostFlag>
            <phaseProductFlag>false</phaseProductFlag>
            <unitOfMeasure>
              <id>13</id>
              <name>Each</name>
            </unitOfMeasure>
            <minStockLevel>0</minStockLevel>
            <price>7.000000</price>
            <cost>0.250000</cost>
            <taxableFlag>true</taxableFlag>
            <customerDescription>10ft Patch Cat5E Cable</customerDescription>
            <vendor>
              <id>6</id>
              <name>Blue Light, Co.</name>
              <identifier>BlueLightCo</identifier>
            </vendor>
            <vendorSku>PATCH10</vendorSku>
            <recurringFlag>false</recurringFlag>
            <recurringRevenue xsi:nil="true" />
            <recurringCost xsi:nil="true" />
            <recurringOneTimeFlag>false</recurringOneTimeFlag>
            <dateEntered>2014-10-22T08:52:26Z</dateEntered>
            <category>
              <id>15</id>
              <name>Miscellaneous</name>
            </category>
          </record>
          <identifier>PATCH10</identifier>
        </product>
        <purchaseOrderId>13</purchaseOrderId>
        <quantity>3.00</quantity>
        <receivedQuantity>3</receivedQuantity>
        <shipDate xsi:nil="true" />
        <tax>0.00</tax>
        <unitCost>2.000000</unitCost>
        <unitOfMeasure>
          <id>13</id>
          <name>Each</name>
        </unitOfMeasure>
        <warehouse>
          <id>1</id>
          <name>Default</name>
          <record>
            <id>1</id>
            <_info>
              <lastUpdated>2019-10-08T16:06:34Z</lastUpdated>
              <updatedBy>Admin1</updatedBy>
            </_info>
            <name>Default</name>
            <company>
              <id>2</id>
              <name>Your Company</name>
              <identifier>YourCompany</identifier>
            </company>
            <location>
              <id>2</id>
              <name>Tampa Office</name>
            </location>
            <department>
              <id>10</id>
              <name>Professional Services</name>
            </department>
            <manager>
              <id>150</id>
              <name>zSys Admin</name>
              <identifier>zAdmin</identifier>
            </manager>
            <site>
              <id>133</id>
              <name>test</name>
            </site>
            <locationDefaultFlag>true</locationDefaultFlag>
            <overallDefaultFlag>false</overallDefaultFlag>
            <inactiveFlag>false</inactiveFlag>
            <currency>
              <id>4</id>
              <name>French Francs</name>
              <symbol>FFr</symbol>
              <isoCode>EUR</isoCode>
            </currency>
          </record>
        </warehouse>
        <warehouseBin>
          <id>1</id>
          <name>Default</name>
          <record>
            <id>1</id>
            <_info>
              <lastUpdated>2009-03-19T16:03:53Z</lastUpdated>
              <updatedBy>Conversion</updatedBy>
            </_info>
            <name>Default</name>
            <warehouse>
              <id>1</id>
              <name>Default</name>
            </warehouse>
            <location>
              <id>2</id>
              <name>Tampa Office</name>
            </location>
            <department>
              <id>10</id>
              <name>Professional Services</name>
            </department>
            <minQuantity xsi:nil="true" />
            <maxQuantity xsi:nil="true" />
            <manager>
              <id>150</id>
              <name>zSys Admin</name>
              <identifier>zAdmin</identifier>
            </manager>
            <length xsi:nil="true" />
            <width xsi:nil="true" />
            <height xsi:nil="true" />
            <weight xsi:nil="true" />
            <defaultFlag>true</defaultFlag>
            <inactiveFlag>false</inactiveFlag>
            <quantityOnHand>8</quantityOnHand>
          </record>
        </warehouseBin>
        <customFields>
          <customField>
            <id>9</id>
            <caption>Invoice No</caption>
            <type>Text</type>
            <entryMethod>EntryField</entryMethod>
            <numberOfDecimals>0</numberOfDecimals>
          </customField>
          <customField>
            <id>10</id>
            <caption>Invoice Date</caption>
            <type>Date</type>
            <entryMethod>EntryField</entryMethod>
            <numberOfDecimals>0</numberOfDecimals>
          </customField>
          <customField>
            <id>11</id>
            <caption>Confirmed</caption>
            <type>Checkbox</type>
            <entryMethod>EntryField</entryMethod>
            <numberOfDecimals>0</numberOfDecimals>
          </customField>
          <customField>
            <id>12</id>
            <caption>Invoice Cost Price</caption>
            <type>Number</type>
            <entryMethod>EntryField</entryMethod>
            <numberOfDecimals>2</numberOfDecimals>
          </customField>
        </customFields>
      </purchaseOrderItem>
      <purchaseOrderItem>
        <id>18</id>
        <_info>
          <dateEntered>2014-04-24T09:36:39Z</dateEntered>
          <enteredBy>Conversion</enteredBy>
          <lastUpdated>2014-04-24T09:36:39Z</lastUpdated>
          <updatedBy>Admin1</updatedBy>
        </_info>
        <backorderedFlag>false</backorderedFlag>
        <canceledFlag>false</canceledFlag>
        <closedFlag>false</closedFlag>
        <dateCanceled xsi:nil="true" />
        <dateCanceledUtc xsi:nil="true" />
        <description>10ft Patch Cat5E Cable</description>
        <displayInternalNotesFlag>false</displayInternalNotesFlag>
        <expectedShipDate xsi:nil="true" />
        <lineNumber>2</lineNumber>
        <packingSlip>12</packingSlip>
        <product>
          <id>743</id>
          <record>
            <id>743</id>
            <_info>
              <lastUpdated>2019-10-02T09:40:06Z</lastUpdated>
              <updatedBy>Admin1</updatedBy>
            </_info>
            <identifier>PATCH10</identifier>
            <description>10ft Patch Cable</description>
            <inactiveFlag>false</inactiveFlag>
            <subcategory>
              <id>24</id>
              <name>Miscellaneous</name>
            </subcategory>
            <type>
              <id>32</id>
              <name>Miscellaneous</name>
            </type>
            <productClass>NonInventory</productClass>
            <serializedFlag>false</serializedFlag>
            <serializedCostFlag>false</serializedCostFlag>
            <phaseProductFlag>false</phaseProductFlag>
            <unitOfMeasure>
              <id>13</id>
              <name>Each</name>
            </unitOfMeasure>
            <minStockLevel>0</minStockLevel>
            <price>7.000000</price>
            <cost>0.250000</cost>
            <taxableFlag>true</taxableFlag>
            <customerDescription>10ft Patch Cat5E Cable</customerDescription>
            <vendor>
              <id>6</id>
              <name>Blue Light, Co.</name>
              <identifier>BlueLightCo</identifier>
            </vendor>
            <vendorSku>PATCH10</vendorSku>
            <recurringFlag>false</recurringFlag>
            <recurringRevenue xsi:nil="true" />
            <recurringCost xsi:nil="true" />
            <recurringOneTimeFlag>false</recurringOneTimeFlag>
            <dateEntered>2014-10-22T08:52:26Z</dateEntered>
            <category>
              <id>15</id>
              <name>Miscellaneous</name>
            </category>
          </record>
          <identifier>PATCH10</identifier>
        </product>
        <purchaseOrderId>13</purchaseOrderId>
        <quantity>40.00</quantity>
        <receivedQuantity>40</receivedQuantity>
        <shipDate xsi:nil="true" />
        <tax>0.00</tax>
        <unitCost>1.000000</unitCost>
        <unitOfMeasure>
          <id>13</id>
          <name>Each</name>
        </unitOfMeasure>
        <warehouse>
          <id>1</id>
          <name>Default</name>
          <record>
            <id>1</id>
            <_info>
              <lastUpdated>2019-10-08T16:06:34Z</lastUpdated>
              <updatedBy>Admin1</updatedBy>
            </_info>
            <name>Default</name>
            <company>
              <id>2</id>
              <name>Your Company</name>
              <identifier>YourCompany</identifier>
            </company>
            <location>
              <id>2</id>
              <name>Tampa Office</name>
            </location>
            <department>
              <id>10</id>
              <name>Professional Services</name>
            </department>
            <manager>
              <id>150</id>
              <name>zSys Admin</name>
              <identifier>zAdmin</identifier>
            </manager>
            <site>
              <id>133</id>
              <name>test</name>
            </site>
            <locationDefaultFlag>true</locationDefaultFlag>
            <overallDefaultFlag>false</overallDefaultFlag>
            <inactiveFlag>false</inactiveFlag>
            <currency>
              <id>4</id>
              <name>French Francs</name>
              <symbol>FFr</symbol>
              <isoCode>EUR</isoCode>
            </currency>
          </record>
        </warehouse>
        <warehouseBin>
          <id>1</id>
          <name>Default</name>
          <record>
            <id>1</id>
            <_info>
              <lastUpdated>2009-03-19T16:03:53Z</lastUpdated>
              <updatedBy>Conversion</updatedBy>
            </_info>
            <name>Default</name>
            <warehouse>
              <id>1</id>
              <name>Default</name>
            </warehouse>
            <location>
              <id>2</id>
              <name>Tampa Office</name>
            </location>
            <department>
              <id>10</id>
              <name>Professional Services</name>
            </department>
            <minQuantity xsi:nil="true" />
            <maxQuantity xsi:nil="true" />
            <manager>
              <id>150</id>
              <name>zSys Admin</name>
              <identifier>zAdmin</identifier>
            </manager>
            <length xsi:nil="true" />
            <width xsi:nil="true" />
            <height xsi:nil="true" />
            <weight xsi:nil="true" />
            <defaultFlag>true</defaultFlag>
            <inactiveFlag>false</inactiveFlag>
            <quantityOnHand>8</quantityOnHand>
          </record>
        </warehouseBin>
        <customFields>
          <customField>
            <id>9</id>
            <caption>Invoice No</caption>
            <type>Text</type>
            <entryMethod>EntryField</entryMethod>
            <numberOfDecimals>0</numberOfDecimals>
          </customField>
          <customField>
            <id>10</id>
            <caption>Invoice Date</caption>
            <type>Date</type>
            <entryMethod>EntryField</entryMethod>
            <numberOfDecimals>0</numberOfDecimals>
          </customField>
          <customField>
            <id>11</id>
            <caption>Confirmed</caption>
            <type>Checkbox</type>
            <entryMethod>EntryField</entryMethod>
            <numberOfDecimals>0</numberOfDecimals>
          </customField>
          <customField>
            <id>12</id>
            <caption>Invoice Cost Price</caption>
            <type>Number</type>
            <entryMethod>EntryField</entryMethod>
            <numberOfDecimals>2</numberOfDecimals>
          </customField>
        </customFields>
      </purchaseOrderItem>
      <purchaseOrderItem>
        <id>19</id>
        <_info>
          <dateEntered>2014-04-30T09:57:49Z</dateEntered>
          <enteredBy>Conversion</enteredBy>
          <lastUpdated>2014-04-30T09:57:49Z</lastUpdated>
          <updatedBy>Admin1</updatedBy>
        </_info>
        <backorderedFlag>false</backorderedFlag>
        <canceledFlag>false</canceledFlag>
        <closedFlag>false</closedFlag>
        <dateCanceled xsi:nil="true" />
        <dateCanceledUtc xsi:nil="true" />
        <description>10ft Patch Cat5E Cable</description>
        <displayInternalNotesFlag>false</displayInternalNotesFlag>
        <expectedShipDate xsi:nil="true" />
        <lineNumber>3</lineNumber>
        <packingSlip>6999</packingSlip>
        <product>
          <id>743</id>
          <record>
            <id>743</id>
            <_info>
              <lastUpdated>2019-10-02T09:40:06Z</lastUpdated>
              <updatedBy>Admin1</updatedBy>
            </_info>
            <identifier>PATCH10</identifier>
            <description>10ft Patch Cable</description>
            <inactiveFlag>false</inactiveFlag>
            <subcategory>
              <id>24</id>
              <name>Miscellaneous</name>
            </subcategory>
            <type>
              <id>32</id>
              <name>Miscellaneous</name>
            </type>
            <productClass>NonInventory</productClass>
            <serializedFlag>false</serializedFlag>
            <serializedCostFlag>false</serializedCostFlag>
            <phaseProductFlag>false</phaseProductFlag>
            <unitOfMeasure>
              <id>13</id>
              <name>Each</name>
            </unitOfMeasure>
            <minStockLevel>0</minStockLevel>
            <price>7.000000</price>
            <cost>0.250000</cost>
            <taxableFlag>true</taxableFlag>
            <customerDescription>10ft Patch Cat5E Cable</customerDescription>
            <vendor>
              <id>6</id>
              <name>Blue Light, Co.</name>
              <identifier>BlueLightCo</identifier>
            </vendor>
            <vendorSku>PATCH10</vendorSku>
            <recurringFlag>false</recurringFlag>
            <recurringRevenue xsi:nil="true" />
            <recurringCost xsi:nil="true" />
            <recurringOneTimeFlag>false</recurringOneTimeFlag>
            <dateEntered>2014-10-22T08:52:26Z</dateEntered>
            <category>
              <id>15</id>
              <name>Miscellaneous</name>
            </category>
          </record>
          <identifier>PATCH10</identifier>
        </product>
        <purchaseOrderId>13</purchaseOrderId>
        <quantity>40.00</quantity>
        <receivedQuantity>40</receivedQuantity>
        <shipDate xsi:nil="true" />
        <tax>0.00</tax>
        <unitCost>1.000000</unitCost>
        <unitOfMeasure>
          <id>13</id>
          <name>Each</name>
        </unitOfMeasure>
        <warehouse>
          <id>1</id>
          <name>Default</name>
          <record>
            <id>1</id>
            <_info>
              <lastUpdated>2019-10-08T16:06:34Z</lastUpdated>
              <updatedBy>Admin1</updatedBy>
            </_info>
            <name>Default</name>
            <company>
              <id>2</id>
              <name>Your Company</name>
              <identifier>YourCompany</identifier>
            </company>
            <location>
              <id>2</id>
              <name>Tampa Office</name>
            </location>
            <department>
              <id>10</id>
              <name>Professional Services</name>
            </department>
            <manager>
              <id>150</id>
              <name>zSys Admin</name>
              <identifier>zAdmin</identifier>
            </manager>
            <site>
              <id>133</id>
              <name>test</name>
            </site>
            <locationDefaultFlag>true</locationDefaultFlag>
            <overallDefaultFlag>false</overallDefaultFlag>
            <inactiveFlag>false</inactiveFlag>
            <currency>
              <id>4</id>
              <name>French Francs</name>
              <symbol>FFr</symbol>
              <isoCode>EUR</isoCode>
            </currency>
          </record>
        </warehouse>
        <warehouseBin>
          <id>1</id>
          <name>Default</name>
          <record>
            <id>1</id>
            <_info>
              <lastUpdated>2009-03-19T16:03:53Z</lastUpdated>
              <updatedBy>Conversion</updatedBy>
            </_info>
            <name>Default</name>
            <warehouse>
              <id>1</id>
              <name>Default</name>
            </warehouse>
            <location>
              <id>2</id>
              <name>Tampa Office</name>
            </location>
            <department>
              <id>10</id>
              <name>Professional Services</name>
            </department>
            <minQuantity xsi:nil="true" />
            <maxQuantity xsi:nil="true" />
            <manager>
              <id>150</id>
              <name>zSys Admin</name>
              <identifier>zAdmin</identifier>
            </manager>
            <length xsi:nil="true" />
            <width xsi:nil="true" />
            <height xsi:nil="true" />
            <weight xsi:nil="true" />
            <defaultFlag>true</defaultFlag>
            <inactiveFlag>false</inactiveFlag>
            <quantityOnHand>8</quantityOnHand>
          </record>
        </warehouseBin>
        <customFields>
          <customField>
            <id>9</id>
            <caption>Invoice No</caption>
            <type>Text</type>
            <entryMethod>EntryField</entryMethod>
            <numberOfDecimals>0</numberOfDecimals>
          </customField>
          <customField>
            <id>10</id>
            <caption>Invoice Date</caption>
            <type>Date</type>
            <entryMethod>EntryField</entryMethod>
            <numberOfDecimals>0</numberOfDecimals>
          </customField>
          <customField>
            <id>11</id>
            <caption>Confirmed</caption>
            <type>Checkbox</type>
            <entryMethod>EntryField</entryMethod>
            <numberOfDecimals>0</numberOfDecimals>
          </customField>
          <customField>
            <id>12</id>
            <caption>Invoice Cost Price</caption>
            <type>Number</type>
            <entryMethod>EntryField</entryMethod>
            <numberOfDecimals>2</numberOfDecimals>
          </customField>
        </customFields>
      </purchaseOrderItem>
    </purchaseOrderItems>
  </PurchaseOrder>
</PurchaseOrders>