X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2FFS%2Fcust_main%2FCredit_Limit.pm;h=8a2caa46b61ca8af06d836bb9ad2c213c7984428;hb=4fd1280540e2c9b90fa59c0c32d691f5222f65d4;hp=a6beb22d57b2aaea9d11b505cf5a340bbaaee3f0;hpb=2b9200148823cc2badcbcd5793f1ff0c664d7482;p=freeside.git

diff --git a/FS/FS/cust_main/Credit_Limit.pm b/FS/FS/cust_main/Credit_Limit.pm
index a6beb22d5..8a2caa46b 100644
--- a/FS/FS/cust_main/Credit_Limit.pm
+++ b/FS/FS/cust_main/Credit_Limit.pm
@@ -44,8 +44,9 @@ sub check_credit_limit {
   my $sum = qsearchs( {
     'select'    => 'SUM(rated_price) AS rated_price',
     'table'     => 'cdr',
-    'hashref'   => { 'freesidestatus' => 'rated', },
-    'extra_sql' => ' AND svcnum IN ('. join(',',@svcnum). ') ',
+    #'hashref'   => { 'freesidestatus' => 'rated', },
+    'extra_sql' => " WHERE freesidestatus = 'rated' ".
+                   ' AND svcnum IN ('. join(',',@svcnum). ') ',
   } );
 
   return '' unless $sum->rated_price > $credit_limit;