summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMark Wells <mark@freeside.biz>2014-04-09 12:52:01 -0700
committerMark Wells <mark@freeside.biz>2014-04-09 12:52:01 -0700
commit16055ddbd7cf41399df4a24a337584225c34c91b (patch)
tree33a5bfad0f75c982448580542026f48f223b5df4
parent2e915f90c35f3a2e567dfdcde95569ed9cf934e1 (diff)
correctly alias itemdesc column, #28506
-rw-r--r--httemplate/search/cust_bill_pkg.cgi2
1 files changed, 1 insertions, 1 deletions
diff --git a/httemplate/search/cust_bill_pkg.cgi b/httemplate/search/cust_bill_pkg.cgi
index 769a13d82..6cda34a7f 100644
--- a/httemplate/search/cust_bill_pkg.cgi
+++ b/httemplate/search/cust_bill_pkg.cgi
@@ -302,7 +302,7 @@ push @select, "COALESCE($part_pkg.taxclass, part_fee.taxclass) AS taxclass"
# the non-tax case
if ( $cgi->param('nottax') ) {
- push @select, $itemdesc;
+ push @select, "($itemdesc) AS itemdesc";
push @where,
'(cust_bill_pkg.pkgnum > 0 OR cust_bill_pkg.feepart IS NOT NULL)';