diff options
author | ivan <ivan> | 2008-07-31 23:32:08 +0000 |
---|---|---|
committer | ivan <ivan> | 2008-07-31 23:32:08 +0000 |
commit | 98589a1241412c3e4c40506075f6266d5669def1 (patch) | |
tree | f8e42d5030de004b2bcb13fee98e9fdb1ad20b44 /httemplate | |
parent | 02b11d5feb7fff6f282c20530b74f57fb901b00f (diff) |
this should fix columns not showing up in receivables report... not surea bout #3801 (credits/etc show up in all time periods)
Diffstat (limited to 'httemplate')
-rwxr-xr-x | httemplate/search/report_receivables.cgi | 8 |
1 files changed, 7 insertions, 1 deletions
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)", }; |