Fix group by

diff --git a/enyo-client/database/source/xt/functions/cust_outstanding_credit.sql b/enyo-client/database/source/xt/functions/cust_outstanding_credit.sql
index fa626f8..6aa15db 100644 (file)
--- a/enyo-client/database/source/xt/functions/cust_outstanding_credit.sql
+++ b/enyo-client/database/source/xt/functions/cust_outstanding_credit.sql
@@ -18,7 +18,7 @@ from (
   where aropen_cust_id = $1
   and aropen_open
   --and aropen_posted = false
-  group by aropen_id
+  group by aropen_id, aropen_cust_id, aropen_curr_id, aropen_amount
 ) unalloc;
 
 $$ language sql;