X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FIR.pm;h=f6cf8b6a0ab05e0ff811c6f3010f444b36eda491;hb=195883fdfd3b10f329036767f027baa6e7c402b9;hp=a02f4fbd96b7864665b7de07113ae8cc43ccaf4f;hpb=d319704a66e9be64da837ccea10af6774c2b0838;p=kivitendo-erp.git diff --git a/SL/IR.pm b/SL/IR.pm index a02f4fbd9..f6cf8b6a0 100644 --- a/SL/IR.pm +++ b/SL/IR.pm @@ -235,17 +235,17 @@ sub post_invoice { # add entry for inventory, this one is for the sold item if ($linetotal != 0) { - $query = qq|INSERT INTO acc_trans (trans_id, chart_id, amount, + $query = qq|INSERT INTO acc_trans (trans_id, chart_id, amount, transdate) VALUES ($ref->{trans_id}, $ref->{inventory_accno_id}, $linetotal, '$ref->{transdate}')|; $dbh->do($query) || $form->dberror($query); # add expense - $query = qq|INSERT INTO acc_trans (trans_id, chart_id, amount, + $query = qq|INSERT INTO acc_trans (trans_id, chart_id, amount, transdate, taxkey) VALUES ($ref->{trans_id}, $ref->{expense_accno_id}, - | . ($linetotal * -1) . qq|, '$ref->{transdate}', + | . ($linetotal * -1) . qq|, '$ref->{transdate}', (SELECT taxkey from tax WHERE chart_id = $ref->{expense_accno_id}))|; $dbh->do($query) || $form->dberror($query); } @@ -443,7 +443,7 @@ sub post_invoice { $form->round_amount($form->{amount}{$trans_id}{$accno}, 2) ) != 0 ) { - $query = qq|INSERT INTO acc_trans (trans_id, chart_id, amount, + $query = qq|INSERT INTO acc_trans (trans_id, chart_id, amount, transdate, taxkey) VALUES ($trans_id, (SELECT c.id FROM chart c WHERE c.accno = '$accno'), @@ -1220,4 +1220,3 @@ SWITCH: { } 1; -