X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=FS%2FFS%2Fcust_bill.pm;h=c59948808347f1e3ec9d883b94a2ad69f18a4c77;hp=1f6f85b4448bf18f0f1e403530695f8dd29d1151;hb=45c73e0d548b950dd29c21d863c239f6114a2083;hpb=df52f854e367f6342e480c22cb6ec7b8244fd334 diff --git a/FS/FS/cust_bill.pm b/FS/FS/cust_bill.pm index 1f6f85b44..c59948808 100644 --- a/FS/FS/cust_bill.pm +++ b/FS/FS/cust_bill.pm @@ -2879,7 +2879,7 @@ sub search_sql { #$orderby = 'ORDER BY cust_bill.custnum ASC, cust_bill._date DESC'; my @newest_where = map { my $x = $_; - $x = s/\bcust_bill\./newest_cust_bill./g; + $x =~ s/\bcust_bill\./newest_cust_bill./g; $x; } grep ! /^cust_main./, @search; @@ -2887,6 +2887,7 @@ sub search_sql { ? ' AND '. join(' AND ', @newest_where) : ''; + push @search, "cust_bill._date = ( SELECT(MAX(newest_cust_bill._date)) FROM cust_bill AS newest_cust_bill WHERE newest_cust_bill.custnum = cust_bill.custnum