From: ivan <ivan>
Date: Wed, 3 May 2006 09:47:31 +0000 (+0000)
Subject: pg 8.1 fix from Chris Cappuccio
X-Git-Tag: BEFORE_FINAL_MASONIZE~150
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=29644d5921c99520965b884b25800ed084891e94

pg 8.1 fix from Chris Cappuccio
---

diff --git a/httemplate/search/report_receivables.cgi b/httemplate/search/report_receivables.cgi
index d675346f0..1dd0fee86 100755
--- a/httemplate/search/report_receivables.cgi
+++ b/httemplate/search/report_receivables.cgi
@@ -110,7 +110,7 @@ END
     $owed_cols =~
       s/cust_bill\.custnum/cust_bill.custnum AND cust_main.agentnum = '$agentnum'/g;
   }
-  my $total_sql = "select $owed_cols";
+  my $total_sql = "select $owed_cols from cust_main";
   my $total_sth = dbh->prepare($total_sql) or die dbh->errstr;
   $total_sth->execute or die $total_sth->errstr;
   my $row = $total_sth->fetchrow_hashref();