X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=httemplate%2Fview%2Fcust_main%2Fchange_history.html;fp=httemplate%2Fview%2Fcust_main%2Fchange_history.html;h=11777b54ce04d96408a9f41435ffe78b8c46ec3b;hp=4ff604d7ac88d662e0dd46d54bec0e1d58944e31;hb=63488b6ec28a6546bb8d43b7b1273d0362d99b57;hpb=ae40f1d7aa1a0fcf8c32c60660a51de3551854d8

diff --git a/httemplate/view/cust_main/change_history.html b/httemplate/view/cust_main/change_history.html
index 4ff604d7a..11777b54c 100644
--- a/httemplate/view/cust_main/change_history.html
+++ b/httemplate/view/cust_main/change_history.html
@@ -151,7 +151,7 @@ foreach my $table ( keys %tables ) {
   elsif ($table eq 'contact') {
 
     my $contact_addl_from = "
-      INNER JOIN (select contactnum, min(history_date) as min_history_date, max(history_date) as max_history_date FROM h_cust_contact WHERE custnum = ".$cust_main->custnum." AND history_date >= $newer_than GROUP BY contactnum) a ON h_cust_contact.contactnum = a.contactnum
+      INNER JOIN (select contactnum, min(history_date) as min_history_date, max(history_date) as max_history_date, max(historynum) as max_historynum FROM h_cust_contact WHERE custnum = ".$cust_main->custnum." AND history_date >= $newer_than GROUP BY contactnum) a ON h_cust_contact.contactnum = a.contactnum
     ";
 
     ## get list with add and remove dates of contacts for customer
@@ -159,7 +159,7 @@ foreach my $table ( keys %tables ) {
       'table' => "h_cust_contact",
       'select' => "a.contactnum, a.min_history_date, a.max_history_date, history_action AS max_history_action",
       'addl_from' => $contact_addl_from,
-      'extra_sql' => " WHERE history_date = a.max_history_date",
+      'extra_sql' => " WHERE historynum = a.max_historynum",
     });
 
     foreach my $c (@h_cust_contacts) {