X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FAP.pm;h=f754137eef4d1292e9af8f1422297d317ad53d46;hb=642c04d614c96555add111e983ef7a756a6362a1;hp=bc5a362025ce9373a039afe6b8383763de5e85e8;hpb=82053b457be3de2ee5285dc13633222f4d30802c;p=kivitendo-erp.git diff --git a/SL/AP.pm b/SL/AP.pm index bc5a36202..f754137ee 100644 --- a/SL/AP.pm +++ b/SL/AP.pm @@ -170,9 +170,10 @@ sub post_transaction { $uid = substr($uid, 2, 75); $query = - qq|INSERT INTO ap (invnumber, employee_id) | . - qq|VALUES (?, (SELECT e.id FROM employee e WHERE e.login = ?))|; - do_query($form, $dbh, $query, $uid, $form->{login}); + qq|INSERT INTO ap (invnumber, employee_id,currency_id) | . + qq|VALUES (?, (SELECT e.id FROM employee e WHERE e.login = ?), + (SELECT id FROM currencies WHERE name = ?) )|; + do_query($form, $dbh, $query, $uid, $form->{login}, $form->{currency}); $query = qq|SELECT a.id FROM ap a WHERE a.invnumber = ?|; @@ -370,7 +371,7 @@ sub post_transaction { $query = qq|INSERT INTO acc_trans (trans_id, chart_id, amount, transdate, fx_transaction, cleared, project_id, taxkey, tax_id, chart_link) | . qq|VALUES (?, (SELECT id FROM chart WHERE accno = ?), ?, ?, 't', 'f', ?, | . - qq| (SELECT taxkey_id FROM chart WHERE accno = ?)| . + qq| (SELECT taxkey_id FROM chart WHERE accno = ?),| . qq| (SELECT tax_id| . qq| FROM taxkeys| . qq| WHERE chart_id= (SELECT id | . @@ -877,4 +878,3 @@ sub storno { } 1; -