X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FAM.pm;h=f13fcc7eebbec2dac1e79c9f1aa05264675ec93e;hb=e86c1c2a39bd3287319a134b0889a933ffc50b9e;hp=b991acf394e1d05f84215bf69e55af9c3ecb9392;hpb=ed71ba59d8acc23b8284eafc8f7d1c13070adbdd;p=kivitendo-erp.git

diff --git a/SL/AM.pm b/SL/AM.pm
index b991acf39..f13fcc7ee 100644
--- a/SL/AM.pm
+++ b/SL/AM.pm
@@ -181,17 +181,8 @@ sub get_account {
   $form->{orphaned} = $chart_obj->has_transaction ? 0 : 1;
 
   # check if new account is active
-  $form->{new_chart_valid} = 0;
-  if ($form->{new_chart_id}) {
-    $query = qq|SELECT current_date-valid_from FROM chart
-                WHERE id = ?|;
-    $main::lxdebug->message(LXDebug->QUERY(), "\$query=\n $query");
-    my ($count) = selectrow_query($form, $dbh, $query, $form->{id});
-    if ($count >=0) {
-      $form->{new_chart_valid} = 1;
-    }
-    $sth->finish;
-  }
+  # The old sql query was broken since at least 2006 and always returned 0
+  $form->{new_chart_valid} = $chart_obj->new_chart_valid;
 
   $dbh->disconnect;