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