X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/8b74179bbabd61a374ba84c1763ac5bef3422f03..7eaf45a5d2ac3b81601a6a7e8b569e20febde4df:/SL/AP.pm diff --git a/SL/AP.pm b/SL/AP.pm index cc7e06f94..4d651e412 100644 --- a/SL/AP.pm +++ b/SL/AP.pm @@ -167,10 +167,10 @@ sub post_transaction { ($form->{id}) = selectrow_query($form, $dbh, qq|SELECT nextval('glid')|); $query = - qq|INSERT INTO ap (id, invnumber, employee_id,currency_id) | . + qq|INSERT INTO ap (id, invnumber, employee_id,currency_id, taxzone_id) | . qq|VALUES (?, ?, (SELECT e.id FROM employee e WHERE e.login = ?), - (SELECT id FROM currencies WHERE name = ?) )|; - do_query($form, $dbh, $query, $form->{id}, $form->{invnumber}, $form->{login}, $form->{currency}); + (SELECT id FROM currencies WHERE name = ?), (SELECT taxzone_id FROM vendor WHERE id = ?) )|; + do_query($form, $dbh, $query, $form->{id}, $form->{invnumber}, $form->{login}, $form->{currency}, $form->{vendor_id}); }