From 02b85ee2753668691df8da85adad438b38281fbe Mon Sep 17 00:00:00 2001
From: ivan <ivan>
Date: Mon, 22 Oct 2007 22:29:48 +0000
Subject: [PATCH] fix more fallout from agent-virtualized packages

---
 FS/FS/Report/Table/Monthly.pm | 5 +++--
 1 file changed, 3 insertions(+), 2 deletions(-)

diff --git a/FS/FS/Report/Table/Monthly.pm b/FS/FS/Report/Table/Monthly.pm
index a44cafe3e..33fdfd80c 100644
--- a/FS/FS/Report/Table/Monthly.pm
+++ b/FS/FS/Report/Table/Monthly.pm
@@ -331,11 +331,12 @@ sub in_time_period_and_agent {
   my $sql = "$col >= $speriod AND $col < $eperiod";
 
   #agent selection
-  $sql .= " AND agentnum = $agentnum"
+  $sql .= " AND cust_main.agentnum = $agentnum"
     if $agentnum;
 
   #agent virtualization
-  $sql .= ' AND '. $FS::CurrentUser::CurrentUser->agentnums_sql;
+  $sql .= ' AND '.
+          $FS::CurrentUser::CurrentUser->agentnums_sql( 'table'=>'cust_main' );
 
   $sql;
 }
-- 
2.11.0