From: ivan <ivan>
Date: Thu, 31 Jul 2008 23:32:08 +0000 (+0000)
Subject: this should fix columns not showing up in receivables report... not surea bout #3801... 
X-Git-Tag: root_of_webpay_support~455
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=98589a1241412c3e4c40506075f6266d5669def1

this should fix columns not showing up in receivables report... not surea bout #3801 (credits/etc show up in all time periods)
---

diff --git a/httemplate/search/report_receivables.cgi b/httemplate/search/report_receivables.cgi
index b2fbb4d3c..58d87fa53 100755
--- a/httemplate/search/report_receivables.cgi
+++ b/httemplate/search/report_receivables.cgi
@@ -127,7 +127,13 @@ my $count_sql = "select count(*) from cust_main $where";
 my $sql_query = {
   'table'     => 'cust_main',
   'hashref'   => {},
-  'select'    => "*, $owed_cols, $packages_cols",
+  'select'    => join(',',
+                   #'cust_main.*',
+                   'custnum',
+                   $owed_cols,
+                   $packages_cols,
+                   FS::UI::Web::cust_sql_fields(),
+                 ),
   'extra_sql' => $where,
   'order_by'  => "order by coalesce(lower(company), ''), lower(last)",
 };