From 98589a1241412c3e4c40506075f6266d5669def1 Mon Sep 17 00:00:00 2001
From: ivan <ivan>
Date: Thu, 31 Jul 2008 23:32:08 +0000
Subject: [PATCH] this should fix columns not showing up in receivables
 report... not surea bout #3801 (credits/etc show up in all time periods)

---
 httemplate/search/report_receivables.cgi | 8 +++++++-
 1 file changed, 7 insertions(+), 1 deletion(-)

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)",
 };
-- 
2.11.0