X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/kivitendo-erp.git/blobdiff_plain/546a969e5d8fc8a996c5484f9277dc55415cd9c4..f8dc549f8eef9f756958d268c6031e26ed39043e:/SL/AM.pm

diff --git a/SL/AM.pm b/SL/AM.pm
index dc6774d87..77c67e65e 100644
--- a/SL/AM.pm
+++ b/SL/AM.pm
@@ -2186,25 +2186,27 @@ sub save_tax {
 
   $form->{rate} = $form->{rate} / 100;
 
-  my @values = ($form->{taxkey}, $form->{taxdescription}, $form->{rate}, $form->{chart_id} );
+  my @values = ($form->{taxkey}, $form->{taxdescription}, $form->{rate}, $form->{chart_id}, $form->{chart_id} );
   if ($form->{id}) {
-    $query = qq|UPDATE _tax SET
+    $query = qq|UPDATE tax SET
                   taxkey         = ?,
                   taxdescription = ?,
                   rate           = ?,
-                  chart_id       = ?
+                  chart_id       = ?,
+                  taxnumber      = (SELECT accno FROM chart WHERE id= ? )
                 WHERE id = ?|;
     push(@values, $form->{id});
   } 
   else {
     #ok
-    $query = qq|INSERT INTO _tax (
+    $query = qq|INSERT INTO tax (
                   taxkey,
                   taxdescription,
                   rate,
-                  chart_id
+                  chart_id,
+                  taxnumber
                 )
-                VALUES (?, ?, ?, ? )|;
+                VALUES (?, ?, ?, ?, (SELECT accno FROM chart WHERE id = ?) )|;
   }
   do_query($form, $dbh, $query, @values);
 
@@ -2221,7 +2223,7 @@ sub delete_tax {
   # connect to database
   my $dbh = $form->dbconnect($myconfig);
 
-  $query = qq|DELETE FROM _tax
+  $query = qq|DELETE FROM tax
               WHERE id = ?|;
   do_query($form, $dbh, $query, $form->{id});