From 8eef2a78c7be08f8a8cfd27ed8850d3ab73e5a55 Mon Sep 17 00:00:00 2001
From: ivan <ivan>
Date: Tue, 25 Oct 2011 00:19:12 +0000
Subject: [PATCH] fix error on advanced broadband report when selecting a
 router, RT#14626

---
 FS/FS/svc_acct.pm      | 2 +-
 FS/FS/svc_broadband.pm | 2 +-
 2 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/FS/FS/svc_acct.pm b/FS/FS/svc_acct.pm
index 7ef8ed3aa..37c55d67c 100644
--- a/FS/FS/svc_acct.pm
+++ b/FS/FS/svc_acct.pm
@@ -2933,7 +2933,7 @@ sub search {
 
   #agentnum
   if ( $params->{'agentnum'} =~ /^(\d+)$/ and $1 ) {
-    push @where, "agentnum = $1";
+    push @where, "cust_main.agentnum = $1";
   }
 
   #custnum
diff --git a/FS/FS/svc_broadband.pm b/FS/FS/svc_broadband.pm
index f1a233b40..576684c56 100755
--- a/FS/FS/svc_broadband.pm
+++ b/FS/FS/svc_broadband.pm
@@ -168,7 +168,7 @@ sub search {
   
   #agentnum
   if ( $params->{'agentnum'} =~ /^(\d+)$/ and $1 ) {
-    push @where, "agentnum = $1";
+    push @where, "cust_main.agentnum = $1";
   }
   push @where, $FS::CurrentUser::CurrentUser->agentnums_sql(
     'null_right' => 'View/link unlinked services',
-- 
2.11.0