X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/e82db1a7b5f8cfce019012e60a689c9142851a63..0a7acc87a3c4c016b324795c4c777643ee1517fc:/SL/GL.pm diff --git a/SL/GL.pm b/SL/GL.pm index a42287735..ada29ac6a 100644 --- a/SL/GL.pm +++ b/SL/GL.pm @@ -171,10 +171,10 @@ sub post_transaction { qq|INSERT INTO acc_trans (trans_id, chart_id, amount, transdate, source, memo, project_id, taxkey, tax_id, chart_link) VALUES (?, (SELECT chart_id FROM tax WHERE id = ?), - ?, ?, ?, ?, ?, ?, ?, (SELECT link - FROM chart - WHERE id = (SELECT chart_id - FROM tax + ?, ?, ?, ?, ?, ?, ?, (SELECT link + FROM chart + WHERE id = (SELECT chart_id + FROM tax WHERE id = ?)))|; @values = (conv_i($form->{id}), conv_i($form->{"tax_id_$i"}), $tax, conv_date($form->{transdate}), $form->{"source_$i"}, @@ -198,6 +198,7 @@ sub post_transaction { dbh => $dbh, from => $transdate, to => $transdate, + trans_id => $form->{id}, ); $datev->export;