From 32b6d9deddc928f98dcad15ff306015d7e0070c5 Mon Sep 17 00:00:00 2001
From: ivan <ivan>
Date: Sun, 7 Jul 2002 13:30:02 +0000
Subject: [PATCH] calculate owed as subquery here too

---
 httemplate/search/cust_bill.cgi | 4 +---
 1 file changed, 1 insertion(+), 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 {
-- 
2.11.0