+ @cust_bill = qsearch(
+ 'cust_bill',
+ {},
+ 'cust_bill.*,
+ charged - coalesce(sum(cust_bill_pay.amount),0)
+ - coalesce(sum(cust_credit_bill.amount),0) as owed',
+ "left outer join cust_bill_pay using ( invnum )
+ left outer join cust_credit_bill using ( invnum )
+ $where
+ group by ". join(', ', map "cust_bill.$_", fields('cust_bill') ). ' '.
+ $having
+ );