From bb8493151593420f2d2440c476c2ce43473a2476 Mon Sep 17 00:00:00 2001 From: Ivan Kohler Date: Thu, 3 Mar 2016 13:55:22 -0800 Subject: [PATCH] prevent customer payment type changes from skewing payment report --- FS/FS/UI/Web.pm | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/FS/FS/UI/Web.pm b/FS/FS/UI/Web.pm index cb0cc99f1..d31e918d0 100644 --- a/FS/FS/UI/Web.pm +++ b/FS/FS/UI/Web.pm @@ -273,7 +273,7 @@ sub cust_header { '(service) Latitude' => 'ship_latitude', '(service) Longitude' => 'ship_longitude', 'Invoicing email(s)' => 'invoicing_list_emailonly_scalar', - 'Payment Type' => 'payby', + 'Payment Type' => 'cust_payby', 'Current Balance' => 'current_balance', 'Agent Cust#' => 'agent_custid', ); @@ -373,9 +373,11 @@ sub cust_sql_fields { } } - foreach my $field (qw(daytime night mobile fax payby)) { + foreach my $field (qw(daytime night mobile fax )) { push @fields, $field if (grep { $_ eq $field } @cust_fields); } + push @fields, "payby AS cust_payby" + if grep { 'cust_payby' eq $field } @cust_fields; push @fields, 'agent_custid'; my @extra_fields = (); -- 2.11.0