From 45d8ea4c5d8d66f2945c05a71f2e695c0bf00dac Mon Sep 17 00:00:00 2001 From: Ivan Kohler Date: Wed, 4 Jan 2017 15:57:44 -0800 Subject: [PATCH] fix "column reference "refnum" is ambiguous" is credit detail report (when no advertising sources are configured yet), RT#73994 --- httemplate/search/cust_credit_bill.html | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/httemplate/search/cust_credit_bill.html b/httemplate/search/cust_credit_bill.html index 88f897d70..fb7106162 100644 --- a/httemplate/search/cust_credit_bill.html +++ b/httemplate/search/cust_credit_bill.html @@ -79,14 +79,14 @@ my $title = 'Net Credit Search Results'; my @search = (); if ( $cgi->param('agentnum') && $cgi->param('agentnum') =~ /^(\d+)$/ ) { - push @search, "agentnum = $1"; + push @search, "cust_main.agentnum = $1"; my $agent = qsearchs('agent', { 'agentnum' => $1 } ); die "unknown agentnum $1" unless $agent; $title = $agent->agent. " $title"; } if ( $cgi->param('refnum') && $cgi->param('refnum') =~ /^(\d+)$/ ) { - push @search, "refnum = $1"; + push @search, "cust_main.refnum = $1"; my $part_referral = qsearchs('part_referral', { 'refnum' => $1 } ); die "unknown refnum $1" unless $part_referral; $title = $part_referral->referral. " $title"; -- 2.11.0