From: Ivan Kohler <ivan@freeside.biz>
Date: Fri, 23 Dec 2016 01:23:08 +0000 (-0800)
Subject: fix "column refnum is ambiguous" error pulling up churn detail when you have a single... 
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=c48c387bf982b95dbd2f0e26e5f4fa967884af35

fix "column refnum is ambiguous" error pulling up churn detail when you have a single advertising source, RT#73852
---

diff --git a/FS/FS/cust_pkg.pm b/FS/FS/cust_pkg.pm
index c1039b59f..819dadeb6 100644
--- a/FS/FS/cust_pkg.pm
+++ b/FS/FS/cust_pkg.pm
@@ -5343,7 +5343,7 @@ sub search {
   }
 
   ###
-  # parse refnum (advertising source)
+  # parse (customer) refnum (advertising source)
   ###
 
   if ( exists($params->{'refnum'}) ) {
@@ -5354,7 +5354,7 @@ sub search {
       @refnum = ( $params->{'refnum'} );
     }
     my $in = join(',', grep /^\d+$/, @refnum);
-    push @where, "refnum IN($in)" if length $in;
+    push @where, "cust_main.refnum IN($in)" if length $in;
   }
 
   ###