Zynk Workflow Documentation

This task will retrieve Unposted Invoices, Unposted Expenses and/or Unposted Procurement data from a previously updated Batch within the Accounting Interface in ConnectWise. This task is typically used for integrations with accounting systems, as the data provided from ConnectWise includes the general ledger account number.

Settings

Connection

Required The ConnectWise Company to Recreate the GL Batch data from.

Output File

Required An absolute or relative file path on the local computer or network to save any downloaded data to.

Download Unposted Expenses

Required Specify whether Unposted Expenses should be included in the data. This will be defaulted to False.  

Download Unposted Invoices

Specify whether Unposted Invoices should be included in the data. This will be defaulted to True.  

Download Unposted Procurement

Required Specify whether Unposted Procurement should be included in the data. This will be defaulted to False.

Excluded Expense Record ID’s

Optional Filter to exclude specific expense records from the Batch being recreated based on ID.

Excluded Inventory Record ID’s

Optional Filter to exclude specific procurement records from the Batch being recreated based on ID.

Excluded Invoice Record ID’s

Optional Filter to exclude specific invoice records from the Batch being recreated based on ID.

Included Expense Record ID’s

Optional Filter to include specific expense records in the Batch being recreated based on ID.

Included Inventory Record ID’s

Optional Filter to include inventory records in the Batch being recreated based on ID.

Included Invoice Record ID’s

Optional Filter to include invoice records in the Batch being recreated based on ID.

Owner Level

Optional Filter to restrict the records that are returned in the batch being recreated based on Location (Level 2 of the Corporate Structure). You can specify the Location Description or Id.

Thru Date

Optional Filter to restrict the records that are returned in the batch being recreated based on the date they were taken. If no value is specified the default used by ConnectWise is the current date.

Zynk Settings

See Common Task Settings

Examples

Sample Unposted Expenses data:

<?xml version="1.0" encoding="utf-8"?>
    <GLExport CogsOption="True" SalesTaxOption="True" SalesTaxGroupsOption="False" InventoryPostOption="True" ExpenseAsBillOption="True" ExpenseSummaryOption="False" ExportInvoices="False" ExportExpenses="True" ExportInventory="False" SyncPayments="False" GLBatchID="dda3abde-ab43-4242-9d3b-780038e674c4" LastPaymentSync="" DropShipCogsOption="False" UomProductOption="False">
    <Vendors>
    	<Vendor MemberID="Admin1" VendorName="Admin1" CompanyName="" VendorNumber="ZYNK" FirstName="Training" MiddleInitial="" LastName="Admin1" AccountNumber="" SiteName="" AddressLine1="" AddressLine2="" AddressLine3="" City="" State="" PostalCode="" Country="" CountryCode="" PhoneNumber="(813) 111-1111" BillingTerms="" DueDays="" TaxGroup="" />
    </Vendors>
    <Customers>
    	<Customer CompanyName="Administration Resources Corporation" ContactName="Marc Mosiman" SiteName="Main" AddressLine1="11490 Xeon St. NW" AddressLine2="Suite 200" AddressLine3="Coon Rapids, MN TT3 PYT" City="Coon Rapids" State="MN" PostalCode="TT3 PYT" Country="United States" CountryCode="" PhoneNumber="7634215510" Taxable="True" AccountNumber="12345678" BillingTerms="Net 10" BillingTermsXref="Net 10" TaxCode="T1" StateTaxXref="T1" CountyTaxXref="" CityTaxXref="" Level4TaxXref="" Level5TaxXref="" StateTaxRate="20.00%" CountyTaxRate="0.00%" CityTaxRate="0.00%" Level4TaxRate="0.00%" Level5TaxRate="0.00%" TaxAgencyXref="12345678" StateTaxAgencyXref="12345678" CountyTaxAgencyXref="12345678" CityTaxAgencyXref="12345678" Level4TaxAgencyXref="12345678" Level5TaxAgencyXref="12345678" TaxAccountNumber="9999" TaxRate="20.00%" DueDays="10" CurrencyID="EUR" CompanyType="Customer" ContactEmailAddress="marcm@arcadministration.com" />
    </Customers>
    <ExpenseBills NonReimbursableExpenseRecIDs="1132,1133,1134,1135,1136,1137">
    	<ExpenseTransaction Memo="Expenses for 2011-04-09 - 2011-04-15" VendorNumber="ZYNK" MemberID="Admin1" FirstName="Training" LastName="Admin1" DocumentType="GENERAL JOURNAL" DocumentDate="2011-04-15" DocumentNumber="1132Admin1" APAccountNumber="5000" Class="" CurrencyID="FRF" GLEntryRecID="1132" Total="33.95">
    		<ExpenseDetail GLTypeID="EE" Memo="Mileage" AccountNumber="5000" Class="" Total="2.45" CompanyName="Administration Resources Corporation" CompanyAccountNumber="12345678" DocumentDate="2011-04-15" Billable="True" Reimbursable="True" CompanyAdvance="False" CurrencyID="FRF" GLEntryRecID="1138,1139" />
    		<ExpenseDetail GLTypeID="EE" Memo="Mileage" AccountNumber="5000" Class="" Total="31.50" CompanyName="Administration Resources Corporation" CompanyAccountNumber="12345678" DocumentDate="2011-04-15" Billable="False" Reimbursable="True" CompanyAdvance="False" CurrencyID="FRF" GLEntryRecID="1140,1141" />
    	</ExpenseTransaction>
    </ExpenseBills>
    </GLExport>

Sample Unposted Invoices data:

<?xml version="1.0" encoding="utf-8"?>
    <GLExport CogsOption="True" SalesTaxOption="True" SalesTaxGroupsOption="False" InventoryPostOption="True" ExpenseAsBillOption="True" ExpenseSummaryOption="False" ExportInvoices="True" ExportExpenses="False" ExportInventory="False" SyncPayments="False" GLBatchID="4531905d-2e3e-428c-b5b6-0ea196534ba8" LastPaymentSync="" DropShipCogsOption="False" UomProductOption="False">
    <Customers>
    	<Customer CompanyName="Zynk Software Limited" ContactName="Zynk Support" SiteName="Main" AddressLine1="6 - 8 Charlotte Square" AddressLine2="" AddressLine3="Newcastle Upon Tyne, HI NE1 4XF" City="Newcastle Upon Tyne" State="HI" PostalCode="NE1 4XF" Country="United Kingdom" CountryCode="" PhoneNumber="" Taxable="True" AccountNumber="ZYNK0001" BillingTerms="Net 10" BillingTermsXref="Net 10" TaxCode="T1" StateTaxXref="T1" CountyTaxXref="" CityTaxXref="" Level4TaxXref="" Level5TaxXref="" StateTaxRate="20.00%" CountyTaxRate="0.00%" CityTaxRate="0.00%" Level4TaxRate="0.00%" Level5TaxRate="0.00%" TaxAgencyXref="ZYNK0001" StateTaxAgencyXref="ZYNK0001" CountyTaxAgencyXref="ZYNK0001" CityTaxAgencyXref="ZYNK0001" Level4TaxAgencyXref="ZYNK0001" Level5TaxAgencyXref="ZYNK0001" TaxAccountNumber="9999" TaxRate="20.00%" DueDays="10" CurrencyID="GBP" CompanyType="Customer" ContactEmailAddress="support@zynk.com" />
    </Customers>
    <Transactions>
    	<Transaction DocumentType="INVOICE" DocumentDate="2014-05-07" CompanyName="Zynk Software Limited" ProjectName="" Total="42.00" TaxableTotal="35.00" SalesTax="7.00" StateTax="7.00" CountyTax="0.00" CityTax="0.00" TaxableAmount1="35.00" TaxableAmount2="0.00" TaxableAmount3="0.00" TaxableAmount4="0.00" TaxableAmount5="0.00" DocumentNumber="12331233" Memo="Imported from ConnectWise" Description="Accounts Receivable" Taxable="Y" TaxCode="1" TaxGroup="Standard VAT" TaxGroupRate="20.000000" TaxAccountNumber="9999" PiggyBackFlag="False" Attention="Zynk Support" SiteName="Main" AddressLine1="6 - 8 Charlotte Square" AddressLine2="" AddressLine3="Newcastle Upon Tyne, HI NE1 4XF" City="Newcastle Upon Tyne" State="HI" PostalCode="NE1 4XF" Country="United Kingdom" CountryCode="" PhoneNumber="01913037279" ShipCompanyAccountNumber="ZYNK0001" ShipCompanyType="Customer" ShipTaxID="" ShipCompanyName="Zynk Software Limited" ShipSiteName="Main" ShipAddressLine1="6 - 8 Charlotte Square" ShipAddressLine2="" ShipAddressLine3="Newcastle Upon Tyne, HI NE1 4XF" ShipCity="Newcastle Upon Tyne" ShipState="HI" ShipPostalCode="NE1 4XF" ShipCountry="United Kingdom" ShipCountryCode="" ShipPhoneNumber="01913037279" ShipContactName="Zynk Support" BillingTerms="Net 10" BillingTermsXref="Net 10" DueDays="10" DueDate="2014-05-17" AccountNumber="9999" Class="" GLEntryRecID="1504,1505,1506,1507,1508,1509" CompanyAccountNumber="ZYNK0001" TaxAgencyXref="ZYNK0001" StateTaxXref="T1" CountyTaxXref="" CityTaxXref="" SalesRepID="" SalesRepName="" PONumber="CUSTOMER PO" GLTypeID="AR" SalesTerritory="My Accounts" CurrencyID="FRF" CompanyType="Customer" BillingType="Miscellaneous" TaxDPAppliedFlag="N" EmailDeliveryFlag="N" PrintDeliveryFlag="N" AgreementPrePaymentFlag="N" TaxID="" UseAvalara="N" SendAvalaraTax="N">
    		<Detail DocumentType="INVOICE" DocumentDate="2014-05-07" AccountNumber="4001:" Class="" Cost="1.25" CostAccountNumber="1111" InventoryAccountNumber="1111" ProductAccountNumber="4001:" SalesCode="1111" Taxable="Y" Taxable2="N" Taxable3="N" Taxable4="N" Taxable5="N" ItemTaxable="Y" ItemID="PATCH10" ItemPrice="7.00" ItemCost="0.25" Memo="10ft Patch Cat5E Cable" Description="Taxable Products" GLEntryRecID="1503" GLTypeID="RP" GLItemID="PATCH10" ItemTypeXref="" InventoryXref="1111" CogsXref="1111" SalesDescription="10ft Patch Cat5E Cable" ItemDescription="10ft Patch Cable" CurrencyID="FRF" UomName="Each" PriceLevelXref="DEFAULT" LocationXref="DEFAULT" BinDescription="Default" WarehouseSiteName="" WarehouseAddressLine1="" WarehouseAddressLine2="" WarehouseCity="" WarehouseState="" WarehouseZip="" WarehouseCountry="" WarehouseCountryCode="" UomScheduleXref="" SubCatDescription="Miscellaneous" Serialized="N" SerialNumbers="" Dropshipped="Y" ShipmentMethod="" TaxCodeXref="T1" InvoiceSummaryOption="0" TimeEntryRecId="" Total="-35.00" Quantity="-5.00" TaxRate="" TaxCode="" TaxAgencyXref="" TaxNote="" />
    		<Detail DocumentType="INVOICE" DocumentDate="2014-05-07" AccountNumber="9999" Class="" Cost="0.00" CostAccountNumber="" InventoryAccountNumber="" ProductAccountNumber="4000" SalesCode="" Taxable="N" Taxable2="N" Taxable3="N" Taxable4="N" Taxable5="N" ItemTaxable="N" ItemID="" ItemPrice="0" ItemCost="0" Memo="Sales Tax" Description="Level 1 Sales Tax" GLEntryRecID="1510" GLTypeID="ST" GLItemID="" ItemTypeXref="" InventoryXref="" CogsXref="" SalesDescription="" ItemDescription="" CurrencyID="FRF" UomName="Hour" PriceLevelXref="DEFAULT" LocationXref="DEFAULT" BinDescription="DEFAULT" WarehouseSiteName="" WarehouseAddressLine1="" WarehouseAddressLine2="" WarehouseCity="" WarehouseState="" WarehouseZip="" WarehouseCountry="" WarehouseCountryCode="" UomScheduleXref="" SubCatDescription="DEFAULT" Serialized="N" SerialNumbers="" Dropshipped="N" ShipmentMethod="" TaxCodeXref="T9" InvoiceSummaryOption="0" TimeEntryRecId="" Total="-7.00" Quantity="0" TaxRate="0.20%" TaxRatePercent="20.00%" TaxCode="T1" TaxAgencyXref="" TaxNote="AUTOSTAX" />
    	</Transaction>
    </Transactions>
    </GLExport>

Sample Unposted Procurement data:

<?xml version="1.0" encoding="utf-8"?>
    <GLExport CogsOption="True" SalesTaxOption="True" SalesTaxGroupsOption="False" InventoryPostOption="True" ExpenseAsBillOption="True" ExpenseSummaryOption="False" ExportInvoices="False" ExportExpenses="False" ExportInventory="True" SyncPayments="False" GLBatchID="ec5dfcd6-1084-477d-b28a-2bcdf1f2b746" LastPaymentSync="" DropShipCogsOption="False" UomProductOption="False">
    <Vendors>
    	<Vendor MemberID="" VendorName="ConnectWise" CompanyName="ConnectWise" VendorNumber="CW0001" FirstName="Arnie" MiddleInitial="" LastName="Bellini" AccountNumber="CW0001" SiteName="Main" AddressLine1="2803 W Busch Blvd" AddressLine2="Suite 204" AddressLine3="Tampa, FL 33618" City="Tampa" State="FL" PostalCode="33618" Country="" CountryCode="" PhoneNumber="8139357100" BillingTerms="Net 10" DueDays="10" TaxGroup="Standard VAT" />
    </Vendors>
    <Customers>
    	<Customer CompanyName="Zynk Software Limited" ContactName="Zynk Support" SiteName="Main" AddressLine1="6 - 8 Charlotte Square" AddressLine2="" AddressLine3="Newcastle Upon Tyne, HI NE1 4XF" City="Newcastle Upon Tyne" State="HI" PostalCode="NE1 4XF" Country="United Kingdom" CountryCode="" PhoneNumber="" Taxable="True" AccountNumber="ZYNK0001" BillingTerms="Net 10" BillingTermsXref="Net 10" TaxCode="T1" StateTaxXref="T1" CountyTaxXref="" CityTaxXref="" Level4TaxXref="" Level5TaxXref="" StateTaxRate="20.00%" CountyTaxRate="0.00%" CityTaxRate="0.00%" Level4TaxRate="0.00%" Level5TaxRate="0.00%" TaxAgencyXref="ZYNK0001" StateTaxAgencyXref="ZYNK0001" CountyTaxAgencyXref="ZYNK0001" CityTaxAgencyXref="ZYNK0001" Level4TaxAgencyXref="ZYNK0001" Level5TaxAgencyXref="ZYNK0001" TaxAccountNumber="9999" TaxRate="20.00%" DueDays="10" CurrencyID="GBP" CompanyType="Customer" ContactEmailAddress="support@zynk.com" />
    </Customers>
    <PurchaseTransactions>
    	<PurchaseTransaction DocumentNumber="COMPANYBPO" DocumentDate="2014-05-01" PurchaseDate="2014-05-01" VendorName="ConnectWise" VendorNumber="CW0001" VendorAccountNumber="CW0001" VendorInvoiceNumber="COMPANYBINV" VendorInvoiceDate="2014-05-01" FreightAmount="" FreightPackingSlip="COMPANYBPO" APAccountNumber="9000" Class="" ContactName="Arnie Bellini" SiteName="Main" AddressLine1="2803 W Busch Blvd" AddressLine2="Suite 204" AddressLine3="Tampa, FL 33618" City="Tampa" State="FL" PostalCode="33618" Country="" CountryCode="" PhoneNumber="8139357100" Description="Purchase" Memo="PO #COMPANYBPO, Packing Slip: COMPANYBPO" BillingTerms="Net 10" CurrencyID="GBP" PackingSlip="COMPANYBPO" BillingTermsXref="Net 10" CompanyType="Vendor" TaxCode="1" TaxGroup="Standard VAT" TaxGroupRate="20.000000" TaxAgencyXref="" StateTaxXref="T1" CountyTaxXref="" CityTaxXref="" ShipToCompanyName="Zynk Software Limited" ShipToCompanyAccountNumber="ZYNK0001" ShipToCompanyType="Customer" ShipToContactName="Zynk Support" ShipToSiteName="Main" ShipToAddressLine1="6 - 8 Charlotte Square" ShipToAddressLine2="" ShipToAddressLine3="Newcastle Upon Tyne, HI NE1 4XF" ShipToCity="Newcastle Upon Tyne" ShipToState="HI" ShipToPostalCode="NE1 4XF" ShipToCountry="United Kingdom" ShipToCountryCode="" ShipToPhoneNumber="" ShipToTaxGroup="Standard VAT" Dropshipped="Y" DueDays="10" UseAvalara="N" PurchaseHeaderTaxGroup="Standard VAT" PurchaseHeaderTaxable="N" PurchaseHeaderFreightTaxable="N" PurchaseInformation="PO #COMPANYBPO, Packing Slip: COMPANYBPO" Total="12.50">
    		<PurchaseDetail DocumentDate="5/1/2014 5:21:58 AM" AccountNumber="4001" Class="" Cost="12.50" CostAccountNumber="1111" InventoryAccountNumber="1111" SalesCode="1111" Taxable="Y" ItemID="PATCH10" Quantity="-50.00" ItemPrice="7.00" ItemCost="0.25" Total="-12.50" Description="Purchase" GLEntryRecID="1299" GLTypeID="RP" GLItemID="PATCH10" ItemTypeXref="" InventoryXref="1111" CogsXref="1111" SalesDescription="10ft Patch Cat5E Cable" ItemDescription="10ft Patch Cable" Memo="10ft Patch Cable" TaxNote="" VendorAccountNumber="CW0001" VendorNumber="CW0001" CurrencyID="GBP" UomName="Each" PriceLevelXref="DEFAULT" LocationXref="DEFAULT" BinDescription="DEFAULT" WarehouseSiteName="" WarehouseAddressLine1="" WarehouseAddressLine2="" WarehouseCity="" WarehouseState="" WarehouseZip="" WarehouseCountry="" WarehouseCountryCode="" UomScheduleXref="DEFAULT" SubCatDescription="Miscellaneous" Serialized="N" SerialNumbers="" Dropshipped="Y" LineNumber="1" ShipmentMethod="USPS Priority" PurchaseHeaderTaxGroup="Standard VAT" TaxCodeXref="T1" TaxRate="" TaxCode="" TaxAgencyXref="" />
    	</PurchaseTransaction>
    	<PurchaseTransaction DocumentNumber="23" DocumentDate="2015-03-18" PurchaseDate="2015-03-18" VendorName="ConnectWise" VendorNumber="CW0001" VendorAccountNumber="CW0001" VendorInvoiceNumber="" VendorInvoiceDate="2015-03-18" FreightAmount="" FreightPackingSlip="23" APAccountNumber="9000" Class="" ContactName="Arnie Bellini" SiteName="Main" AddressLine1="2803 W Busch Blvd" AddressLine2="Suite 204" AddressLine3="Tampa, FL 33618" City="Tampa" State="FL" PostalCode="33618" Country="" CountryCode="" PhoneNumber="8139357100" Description="Purchase" Memo="PO #23, Packing Slip: 23" BillingTerms="Net 10" CurrencyID="FRF" PackingSlip="23" BillingTermsXref="Net 10" CompanyType="Vendor" TaxCode="1" TaxGroup="Standard VAT" TaxGroupRate="20.000000" TaxAgencyXref="" StateTaxXref="T1" CountyTaxXref="" CityTaxXref="" ShipToCompanyName="" ShipToCompanyAccountNumber="CW0001" ShipToCompanyType="" ShipToContactName="" ShipToSiteName="" ShipToAddressLine1="" ShipToAddressLine2="" ShipToAddressLine3="" ShipToCity="" ShipToState="" ShipToPostalCode="" ShipToCountry="" ShipToCountryCode="" ShipToPhoneNumber="" ShipToTaxGroup="" Dropshipped="N" DueDays="10" UseAvalara="N" PurchaseHeaderTaxGroup="Standard VAT" PurchaseHeaderTaxable="N" PurchaseHeaderFreightTaxable="N" PurchaseInformation="PO #23, Packing Slip: 23" Total="1110.00">
    		<PurchaseDetail DocumentDate="3/18/2015 12:15:16 PM" AccountNumber="4000" Class="" Cost="1110.00" CostAccountNumber="0000" InventoryAccountNumber="0000" SalesCode="0000" Taxable="N" ItemID="System Support" Quantity="-555.00" ItemPrice="250.00" ItemCost="2.00" Total="-1110.00" Description="Purchase" GLEntryRecID="1519" GLTypeID="RP" GLItemID="" ItemTypeXref="" InventoryXref="0000" CogsXref="0000" SalesDescription="Systems Support&amp;#xD;&amp;#xA;&amp;#xD;&amp;#xA;- Network File Server covered&amp;#xD;&amp;#xA;- Network Tape Backup covered&amp;#xD;&amp;#xA;- File Server UPS covered&amp;#xD;&amp;#xA;- Network Adapters covered&amp;#xD;&amp;#xA;- Network Workstation Connections&amp;#xD;&amp;#xA;     All Network hardware cabling to allow proper functioning of &amp;#xD;&amp;#xA;     the Workstation on the Local Area Network&amp;#xD;&amp;#xA;- All Network Concentrators/HUBs covered&amp;#xD;&amp;#xA;- All Network Print Server covered&amp;#xD;&amp;#xA;- All Network cabling covered&amp;#xD;&amp;#xA;- All Network Printer cabling covered&amp;#xD;&amp;#xA;- Extended Warranty &amp; Onsite Repair" ItemDescription="System Support" Memo="System Support" TaxNote="" VendorAccountNumber="CW0001" VendorNumber="CW0001" CurrencyID="FRF" UomName="Month" PriceLevelXref="SERVICE" LocationXref="DEFAULT" BinDescription="Default" WarehouseSiteName="" WarehouseAddressLine1="" WarehouseAddressLine2="" WarehouseCity="" WarehouseState="" WarehouseZip="" WarehouseCountry="" WarehouseCountryCode="" UomScheduleXref="DEFAULT" SubCatDescription="Managed Services" Serialized="N" SerialNumbers="" Dropshipped="N" LineNumber="1" ShipmentMethod="" PurchaseHeaderTaxGroup="Standard VAT" TaxCodeXref="T9" TaxRate="" TaxCode="" TaxAgencyXref="" />
    	</PurchaseTransaction>
    </PurchaseTransactions>
    </GLExport>

Back | Edit on Github