Edit File - File Manager

Edit File: export_to_iif.tpl

{*!ACCNT{$_d}NAME{$_d}ACCNTTYPE{$_d}SCD{$_d}EXTRA{$_d}HIDDEN
ACCNT{$_d}{$addons.quickbooks.accnt_tax}{$_d}INC{$_d}{$_d}{$_d}
*}
{******************** EXPORT CUSTOMERS *******************}
!CUST{$_d}NAME{$_d}BADDR1{$_d}BADDR2{$_d}BADDR3{$_d}BADDR4{$_d}BADDR5{$_d}SADDR1{$_d}SADDR2{$_d}SADDR3{$_d}SADDR4{$_d}SADDR5{$_d}PHONE1{$_d}FAXNUM{$_d}EMAIL{$_d}CONT1{$_d}SALUTATION{$_d}COMPANYNAME{$_d}FIRSTNAME{$_d}LASTNAME
{foreach from=$order_users item="order"}
CUST{$_d}{$order.lastname}, {$order.firstname}{$_d}{$order.b_firstname} {$order.b_lastname}{$_d}{$order.b_address} {$order.b_address_2}{$_d}{$order.b_city}{$_d}"{$order.b_state}, {$order.b_zipcode}"{$_d}{$order.b_country_descr}{$_d}{$order.s_firstname} {$order.s_lastname}{$_d}{$order.s_address} {$order.s_address_2}{$_d}{$order.s_city}{$_d}"{$order.s_state}, {$order.s_zipcode}"{$_d}{$order.s_country_descr}{$_d}{$order.phone}{$_d}{$order.fax}{$_d}{$order.email}{$_d}{$order.lastname}, {$order.b_firstname}{$_d}{$order.title}{$_d}{$order.company}{$_d}{$order.firstname}{$_d}{$order.lastname}
{/foreach}

{******************** EXPORT ITEMS *******************}
!INVITEM{$_d}NAME{$_d}INVITEMTYPE{$_d}DESC{$_d}PURCHASEDESC{$_d}ACCNT{$_d}ASSETACCNT{$_d}COGSACCNT{$_d}PRICE{$_d}COST{$_d}TAXABLE
{foreach from=$order_products item="product"}
INVITEM{$_d}{if $product.product_code}{$product.product_code}{else}{$product.product_id}{/if}{$_d}INVENTORY{$_d}{$product.product}{$product.selected_options}{$_d}{$product.product}{$product.selected_options}{$_d}{$addons.quickbooks.accnt_product}{$_d}{$addons.quickbooks.accnt_asset}{$_d}{$addons.quickbooks.accnt_cogs}{$_d}{$product.price}{$_d}0{$_d}N
{/foreach}
{hook name="quickbooks:export_items"}
{/hook}

{******************** EXPORT ORDERS *******************}
!TRNS{$_d}TRNSTYPE{$_d}DATE{$_d}ACCNT{$_d}NAME{$_d}CLASS{$_d}AMOUNT{$_d}DOCNUM{$_d}MEMO{$_d}ADDR1{$_d}ADDR2{$_d}ADDR3{$_d}ADDR4{$_d}ADDR5{$_d}PAID{$_d}SHIPVIA{$_d}SADDR1{$_d}SADDR2{$_d}SADDR3{$_d}SADDR4{$_d}SADDR5{$_d}TOPRINT
!SPL{$_d}TRNSTYPE{$_d}DATE{$_d}ACCNT{$_d}NAME{$_d}CLASS{$_d}AMOUNT{$_d}DOCNUM{$_d}MEMO{$_d}PRICE{$_d}QNTY{$_d}INVITEM{$_d}TAXABLE{$_d}EXTRA
!ENDTRNS
{foreach from=$orders item="order"}
TRNS{$_d}INVOICE{$_d}{$order.timestamp|date_format:"%m/%d/%Y"}{$_d}Accounts Receivable{$_d}{$order.b_lastname}, {$order.b_firstname}{$_d}{$addons.quickbooks.trns_class}{$_d}{$order.total}{$_d}{$order.order_id}{$_d}Website Order: {$order.details|replace:"\r":" "|replace:"\n":" "|replace:"\t":" "}{$_d}{$order.b_firstname} {$order.b_lastname}{$_d}{$order.b_address} {$order.b_address_2}{$_d}"{$order.b_city}, {$order.b_state} {$order.b_zipcode}"{$_d}{$order.b_countryname}{$_d}{$_d}{if ($order.status == "P" || $order.status == "C")}Y{else}N{/if}{$_d}{$_d}{$order.s_firstname} {$order.s_lastname}{$_d}{$order.s_address} {$order.s_address_2}{$_d}"{$order.s_city}, {$order.s_state} {$order.s_zipcode}"{$_d}{$order.s_countryname}{$_d}{$_d}Y
{*********  PRODUCTS  **********}
{foreach from=$order.products item="item"}
{strip}
{assign var="_tax" value=0}
{assign var="p_id" value=$item.cart_id}
{************* calculate tax for product *********}
{foreach from=$order.taxes item=tax}
{foreach from=$tax.applies item=tax_value key=cart_id}
{if ($tax_value > 0) && ($item.cart_id==$cart_id|substr:2) && $tax.price_includes_tax == "Y"}
{math equation="tax + tax2" tax=$_tax|default:"0" tax2=$tax_value|default:"0" assign="_tax"}
{/if}
{/foreach}
{/foreach}
{************* \calculate tax for product *********}
{math equation="price*amount - tax" price=$item.price|default:"0" amount=$item.amount|default:"1" tax=$_tax|default:"0" assign="p_subtotal"}
{if $order_products.$p_id.product_code}
    {assign var="p_code" value=$order_products.$p_id.product_code}
{else}
    {assign var="p_code" value=$order_products.$p_id.product_id}
{/if}
SPL{$_d}INVOICE{$_d}{$order.timestamp|date_format:"%m/%d/%Y"}{$_d}{$addons.quickbooks.accnt_product}{$_d}{$order.b_lastname}, {$order.b_firstname}{$_d}{$addons.quickbooks.trns_class}{$_d}-{$p_subtotal|fn_format_price}{$_d}{$order.order_id}{$_d}{$order_products.$p_id.product}{$order_products.$p_id.selected_options}{$_d}{$item.price|fn_format_price}{$_d}-{$item.amount}{$_d}{$p_code}{$_d}N{$_d}{/strip}
{*** product discount ***
{if $item.discount != 0}
SPL{$_d}INVOICE{$_d}{$order.timestamp|date_format:"%m/%d/%Y"}{$_d}{$addons.quickbooks.accnt_discount}{$_d}{$order.b_lastname}, {$order.b_firstname}{$_d}{$addons.quickbooks.trns_class}{$_d}{$item.discount}{$_d}{$order.order_id}{$_d}DISCOUNT FOR {$p_code}{$_d}-{$item.discount}{$_d}-1{$_d}DISCOUNT FOR {$p_code}{$_d}N{$_d}
{/if*}
{*** product TAXES ***}
{foreach from=$order.taxes item=tax}
{foreach from=$tax.applies item=tax_value key=cart_id}
{if ($tax_value > 0) && ($item.cart_id==$cart_id|substr:2)}
SPL{$_d}INVOICE{$_d}{$order.timestamp|date_format:"%m/%d/%Y"}{$_d}{$addons.quickbooks.accnt_tax}{$_d}{$order.b_lastname}, {$order.b_firstname}{$_d}{$addons.quickbooks.trns_class}{$_d}-{$tax_value|fn_format_price}{$_d}{$order.order_id}{$_d}{$tax.description} {include file="common/modifier.tpl" mod_value=$tax.rate_value mod_type=$tax.rate_type} FOR {$p_code}{$_d}{$_tax|fn_format_price}{$_d}-1{$_d}TAX{$_d}N{$_d}
{/if}
{/foreach}
{/foreach}
{/foreach}
{*********  GIFT CERTIFICATES  **********}
{hook name="quickbooks:export_gift_certificates"}
{/hook}
{**********  DISCOUNT  **********}
{if $order.subtotal_discount > 0}
SPL{$_d}INVOICE{$_d}{$order.timestamp|date_format:"%m/%d/%Y"}{$_d}{$addons.quickbooks.accnt_discount}{$_d}{$order.b_lastname}, {$order.b_firstname}{$_d}{$addons.quickbooks.trns_class}{$_d}{$order.subtotal_discount}{$_d}{$order.order_id}{$_d}DISCOUNT{$_d}-{$order.subtotal_discount}{$_d}-1{$_d}DISCOUNT{$_d}N{$_d}
{/if}
{*********  PAID BY REWARD POINTS  **********}
{if $order.points_info.in_use.cost > 0}
SPL{$_d}INVOICE{$_d}{$order.timestamp|date_format:"%m/%d/%Y"}{$_d}{$addons.quickbooks.accnt_discount}{$_d}{$order.b_lastname}, {$order.b_firstname}{$_d}{$addons.quickbooks.trns_class}{$_d}{$order.points_info.in_use.cost}{$_d}{$order.order_id}{$_d}DISCOUNT{$_d}-{$order.points_info.in_use.cost}{$_d}-1{$_d}DISCOUNT{$_d}N{$_d}
{/if}
{*********  PAYMENT BY GIFT CERTIFICATE  **********}
{hook name="quickbooks:export_payments"}
{/hook}
{*********  SHIPPING  **********}
{if $order.shipping_cost > 0}
{assign var="ship_name" value=""}
{foreach from=$order.shipping item=ship}
{if $ship_name}{assign var="ship_name" value="$ship_name; "}{/if}
{assign var="ship_name" value="$ship_name`$ship.shipping`"}
{/foreach}
SPL{$_d}INVOICE{$_d}{$order.timestamp|date_format:"%m/%d/%Y"}{$_d}{$addons.quickbooks.accnt_shipping}{$_d}{$order.b_lastname}, {$order.b_firstname}{$_d}{$addons.quickbooks.trns_class}{$_d}-{$order|@fn_order_shipping_cost}{$_d}{$order.order_id}{$_d}{$ship_name}{$_d}{$order|@fn_order_shipping_cost}{$_d}-1{$_d}SHIPPING{$_d}N{$_d}
{/if}
{*********  SURCHARGE  **********} 
{if $order.payment_surcharge > 0} 
SPL{$_d}INVOICE{$_d}{$order.timestamp|date_format:"%m/%d/%Y"}{$_d}{$addons.quickbooks.accnt_surcharge}{$_d}{$order.b_lastname}, {$order.b_firstname}{$_d}{$addons.quickbooks.trns_class}{$_d}-{$order.payment_surcharge}{$_d}{$order.order_id}{$_d}Payment processor surcharge{$_d}{$order.payment_surcharge}{$_d}-1{$_d}SURCHARGE{$_d}N{$_d}
{/if}
{********** AUTO TAX  ************}
{if !$order.taxes}
SPL{$_d}INVOICE{$_d}{$order.timestamp|date_format:"%m/%d/%Y"}{$_d}{$addons.quickbooks.accnt_tax}{$_d}{$order.b_lastname}, {$order.b_firstname}{$_d}{$addons.quickbooks.trns_class}{$_d}0{$_d}{$order.order_id}{$_d}TAX{$_d}{$_d}{$_d}{$_d}N{$_d}AUTOSTAX
{/if}
ENDTRNS
{/foreach}
{******************** PROCCESSED ORDERS *******************}

!TRNS{$_d}TRNSTYPE{$_d}DATE{$_d}ACCNT{$_d}NAME{$_d}AMOUNT{$_d}PAYMETH{$_d}DOCNUM
!SPL{$_d}TRNSTYPE{$_d}DATE{$_d}ACCNT{$_d}NAME{$_d}AMOUNT{$_d}DOCNUM
!ENDTRNS
{foreach from=$orders item="order"}
{if ($order.status == "P" || $order.status == "C")}
TRNS{$_d}PAYMENT{$_d}{$order.timestamp|date_format:"%m/%d/%Y"}{$_d}Undeposited Funds{$_d}{$order.b_lastname}, {$order.b_firstname}{$_d}{$order.total}{$_d}{$order.payment_method.payment}{$_d}{$order.order_id}
SPL{$_d}PAYMENT{$_d}{$order.timestamp|date_format:"%m/%d/%Y"}{$_d}Accounts Receivable{$_d}{$order.b_lastname}, {$order.b_firstname}{$_d}-{$order.total}{$_d}{$order.order_id}
ENDTRNS
{/if}
{/foreach}

Back to File Manager