[ic] Quickbooks interface update

[Curt Hauge]

Hi all,

I found a few problems in the Quickbooks file vars/TRANS_QUICKBOOKS. By
applying these changes I was able to import CASH SALEs. I did not test this
for any other type of transaction. It now correctly identifies taxable items
in the sales receipt, shows the percent of sales tax in the receipt, and
correctly identifies the tax item. I imported the results of these changes
to Quickbooks Pro 1999 and 2002 with success. A few of the changes are just
comments so you can find your way around in there.

A side note to anyone using QuickBooks - seems there is a bug in QuickBooks
2001? and up which does not allow you to use your own order number for the
sales id number. QuickBooks forces the use of its own number, there is no
known workaround per the Intuit website forum.
http://www.quickbooksgroup.com/webx/forums/importexport/Importing%20and%20Ex
porting%20Data%20-%20Archived%20Discussions/368

Nice job on the Quickbooks Mike and Dan! Bugzilla is down now. Feel free to
use any or all of this:

--- TRANS_QUICKBOOKS   Sun Dec 11 19:02:38 2005
+++ TRANS_QUICKBOOKS   Mon Dec 12 20:59:14 2005
@@ -80,7 +80,7 @@
 [scratch credit_limit]
 [scratch resale_number]
 [tx-param affiliate]
-[if scratch ISTAXABLE][tx-param state][/if]
+[if scratch ISTAXABLE]__QB_SALES_TAX_ITEM__[else]Out of State[/else][/if]


 [tx-param company]
@@ -122,8 +122,8 @@
 __QB_TRANSACTION_CLASS__
 [tx-param total_cost]
 [scratch order_number]
-IC Order Number: [tx-param order_number].  [filter op=mac
interpoloate=1][tx-param comments][/filter]
-[tx-param order_number]
+IC Order Number: [tx-param order_number].  [filter op=mac
interpoloate=1][tx-param comments][/filter][comment]this is the memo
field[/comment]
+[tx-param order_number] [comment]this is the check number field[/comment]
 N
 N
 [scratch NAMEISTAXABLE]
@@ -161,7 +161,7 @@
        op="qb_safe [scratch filter_length]"
        interpolate=1]@_QB_ITEM_PREFIX_@[either]@_QB_SKU_@[or][ol-param
sku][/either][/filter]

-[if-ol-param taxable][scratch NAMEISTAXABLE][else]N[/else][/if-ol-param]
+[scratch NAMEISTAXABLE][comment]this is the Y/N item taxable
field[/comment]
 N


@@ -198,13 +198,13 @@
 [tx-param state]
 N
 -1
-
+[query list=1 sql=|SELECT tax FROM state WHERE country = '[tx-param
country]' AND state = '[tx-param state]'|][sql-param tax][/query]
[comment]this is percent of sales tax field used in Quickbooks
transactions[/comment]
 [tmp qb_sales_tax_item]__QB_SALES_TAX_ITEM__[/tmp][either][scratch
qb_sales_tax_item][or]Sales Tax Item[/either]

+
 N
 N

-
 AUTOSTAX[/filter]
 ENDTRNS
 [/seti]



Take care!

Curt Hauge
Office 763-689-4984
Cell   612-598-5530
www.IWantAConsultant.com
www.MNWebDesign.com