diff options
Diffstat (limited to 'httemplate/search/cust_bill.cgi')
| -rwxr-xr-x | httemplate/search/cust_bill.cgi | 4 |
1 files changed, 1 insertions, 3 deletions
diff --git a/httemplate/search/cust_bill.cgi b/httemplate/search/cust_bill.cgi index f4ead7042..d2a3573d4 100755 --- a/httemplate/search/cust_bill.cgi +++ b/httemplate/search/cust_bill.cgi @@ -79,9 +79,7 @@ if ( $cgi->keywords ) { @cust_bill = qsearch( 'cust_bill', {}, - 'cust_bill.*, - charged - coalesce(sum(cust_bill_pay.amount),0) - - coalesce(sum(cust_credit_bill.amount),0) as owed', + "cust_bill.*, $owed as owed" "$extra_sql $orderby $limit" ); } else { |