X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2FFS%2Fcust_main%2FCredit_Limit.pm;h=8a2caa46b61ca8af06d836bb9ad2c213c7984428;hb=47d3ba763306e281c0c4b736877ac8c5d4e9e4a1;hp=4b2fbdfe4bc1ff1a17ac4f8c2191a544593c50a3;hpb=0eee55572b0f8d841f7d1a863d92211d3a6d9e31;p=freeside.git diff --git a/FS/FS/cust_main/Credit_Limit.pm b/FS/FS/cust_main/Credit_Limit.pm index 4b2fbdfe4..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' => { 'status' => '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;