From bc193b14d10f81548a659d52f68b58fa7599b646 Mon Sep 17 00:00:00 2001
From: Mark Wells <mark@freeside.biz>
Date: Tue, 19 Mar 2013 11:41:28 -0700
Subject: [PATCH] invoice batch report, #940

---
 httemplate/view/bill_batch.cgi | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/httemplate/view/bill_batch.cgi b/httemplate/view/bill_batch.cgi
index 7d640395e..55ee4be1c 100644
--- a/httemplate/view/bill_batch.cgi
+++ b/httemplate/view/bill_batch.cgi
@@ -13,7 +13,7 @@
                                'hashref' => { },
                                'addl_from' => 
                                  'LEFT JOIN cust_bill USING ( invnum ) '.
-                                 'LEFT JOIN cust_main USING ( custnum )',
+                                 FS::UI::Web::join_cust_main('cust_bill'),
                                'extra_sql' => " WHERE batchnum = $batchnum",
                              },
               'count_query' => "SELECT COUNT(*) FROM cust_bill_batch WHERE batchnum = $batchnum",
-- 
2.11.0