X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fsearch%2Fcust_bill.html;h=4e40fb06dbd0ebb8f8d82efd4b6bdc2fa7caddb4;hb=38458c0c9135228828b5a477ed1710ef687ec3d3;hp=cf6ce49997478aaa7f3eb3d09de15a5be1c7d542;hpb=afedae91da04b21f86e3dc97fa83e3391969a993;p=freeside.git diff --git a/httemplate/search/cust_bill.html b/httemplate/search/cust_bill.html index cf6ce4999..4e40fb06d 100755 --- a/httemplate/search/cust_bill.html +++ b/httemplate/search/cust_bill.html @@ -22,6 +22,13 @@ sub { time2str('%b %d %Y', shift->_date ) }, \&FS::UI::Web::cust_fields, ], + 'sort_fields' => [ + 'COALESCE( agent_invid, invnum )', + FS::cust_bill->owed_sql, + FS::cust_bill->net_sql, + 'charged', + '_date', + ], 'align' => 'rrrrl'.FS::UI::Web::cust_aligns(), 'links' => [ $link,