From: ivan <ivan>
Date: Mon, 25 Oct 2004 21:35:32 +0000 (+0000)
Subject: fix joins for proper tax reporting
X-Git-Tag: BEFORE_FINAL_MASONIZE~893
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=7c17ae7d898fcbaa1b95c821b72b2250e02a0f3b

fix joins for proper tax reporting
---

diff --git a/httemplate/search/report_tax.cgi b/httemplate/search/report_tax.cgi
index f37e1275d..8b1c095b6 100755
--- a/httemplate/search/report_tax.cgi
+++ b/httemplate/search/report_tax.cgi
@@ -44,8 +44,8 @@ foreach my $r (
     FROM cust_bill_pkg
       JOIN cust_bill USING ( invnum ) 
       JOIN cust_main USING ( custnum )
-      JOIN cust_pkg USING ( pkgnum )
-      JOIN part_pkg USING ( pkgpart )
+      LEFT OUTER JOIN cust_pkg USING ( pkgnum )
+      LEFT OUTER JOIN part_pkg USING ( pkgpart )
     WHERE _date >= $beginning AND _date <= $ending
       AND ( county  = ? OR ? = '' )
       AND ( state   = ? OR ? = '' )