X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=httemplate%2Fsearch%2Freport_receivables.cgi;h=0e95ad73c079505a45ae650192b5beecfcbedd58;hp=ad353a1b3b80e492182d3c77a1f6de318d1acdb1;hb=cec266740d89b82ce9075954928c5b336d0ec18e;hpb=86794f71a5fec8cbb6ab3a49d9bfe7fdaf21d183 diff --git a/httemplate/search/report_receivables.cgi b/httemplate/search/report_receivables.cgi index ad353a1b3..0e95ad73c 100755 --- a/httemplate/search/report_receivables.cgi +++ b/httemplate/search/report_receivables.cgi @@ -93,7 +93,7 @@ where 0 < ,0 ) -order by lower(company), lower(last) +order by coalesce(lower(company), ''), lower(last) END