X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FAP.pm;h=4d651e4124b9674b23dc383ef7f83138867772f6;hb=ab3f3ed87a12c70d9538b1a07fc0e4659dc43d28;hp=cc7e06f94bacb4cd0700968f1f3baf3e6d8117fd;hpb=8b74179bbabd61a374ba84c1763ac5bef3422f03;p=kivitendo-erp.git 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}); }