Package: interchange
Version: 5.2.0
The QuickBooks extensions page 'generate_new_iif.html' does not create the
desired result set when selecting "Generate any new IIF files". If the field
'deleted' in the transactions table is NULL for any reason (though it
shouldn't be), the record will not be included in the .iif generation. I
found a workaround by applying the patch below:
*** generate_new_iif.html Wed Jul 2 21:24:07 2003
--- generate_new_iif.html Sat Jan 21 17:12:13 2006
***************
*** 142,148 ****
SELECT *
FROM transactions
WHERE 1=1
! AND deleted != 1
[if cgi date_from]
AND order_ymd >= '[cgi date_from]'
AND order_ymd <= '[cgi date_to]'
--- 142,148 ----
SELECT *
FROM transactions
WHERE 1=1
! AND deleted is NULL OR deleted = 0
[if cgi date_from]
AND order_ymd >= '[cgi date_from]'
AND order_ymd <= '[cgi date_to]'
***************
*** 155,161 ****
AND order_number <= '[cgi order_to]'
[/if]
[if cgi query_type eq 'any_new']
! AND comments NOT LIKE '%(syncronized)'
LIMIT [scratch any_new_limit]
[/if]
[/tmp]
--- 155,161 ----
AND order_number <= '[cgi order_to]'
[/if]
[if cgi query_type eq 'any_new']
! AND (comments NOT LIKE '%(syncronized)' OR comments
is NULL)
LIMIT [scratch any_new_limit]
[/if]
[/tmp]
***************
*** 164,170 ****
[tmp mv_add_dot_html]0[/tmp]
! [query prefix=tx list=1 type=list sql='[scratch sql]']
[no-match] No Match. Query was <pre>[scratch sql]</pre>
[/no-match]
[list]
--- 164,170 ----
[tmp mv_add_dot_html]0[/tmp]
! [query base=transactions prefix=tx list=1 type=list sql='[scratch
sql]']
[no-match] No Match. Query was <pre>[scratch sql]</pre>
[/no-match]
[list]
Curt Hauge
Office 763-689-4984
Cell 612-598-5530
www.IWantAConsultant.com
www.MNWebDesign.com
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
