X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fsearch%2Fcust_pay_batch.cgi;h=c0f84ec877df2f0c1a4c2dd718f21da7cd90a221;hb=ba92d105395292725e293f79a561d22902c13a91;hp=d5fe52ba5553eeeb91a6b02e03a1520c021ebd9c;hpb=d5fa12d1022afb592e80803971e90d18eac414e0;p=freeside.git diff --git a/httemplate/search/cust_pay_batch.cgi b/httemplate/search/cust_pay_batch.cgi index d5fe52ba5..c0f84ec87 100755 --- a/httemplate/search/cust_pay_batch.cgi +++ b/httemplate/search/cust_pay_batch.cgi @@ -72,7 +72,7 @@ if ( $cgi->param('batchnum') && $cgi->param('batchnum') =~ /^(\d+)$/ ) { } if ( $cgi->param('custnum') && $cgi->param('custnum') =~ /^(\d+)$/ ) { - push @search, "custnum = $1"; + push @search, "cust_pay_batch.custnum = $1"; } if ( $cgi->param('status') && $cgi->param('status') =~ /^(\w)$/ ) { @@ -116,7 +116,6 @@ $sql_query = { 'hashref' => {}, 'addl_from' => 'LEFT JOIN pay_batch USING ( batchnum ) '. 'LEFT JOIN cust_main USING ( custnum ) '. - 'LEFT JOIN cust_pay USING ( batchnum, custnum ) ', 'extra_sql' => $search, 'order_by' => "ORDER BY $orderby",