X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=httemplate%2Fsearch%2Fcust_bill.html;fp=httemplate%2Fsearch%2Fcust_bill.html;h=4e40fb06dbd0ebb8f8d82efd4b6bdc2fa7caddb4;hp=cf6ce49997478aaa7f3eb3d09de15a5be1c7d542;hb=033709735189caa804476fc17e9946809516fcf7;hpb=315efbebcacc909a11eb0379bd2f67bd3145243c

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,