X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FIR.pm;h=8fb9b77753853a71e29ce5cd3d8ebb62d8ad37c9;hb=ac0c6a8692e05549cb2dc0a60e692f550fa72894;hp=2077e6b0e60aff9a27b719147e04b9815355ec3e;hpb=5b47ed3efe5f4ef0810096b0f4849047cee54690;p=kivitendo-erp.git diff --git a/SL/IR.pm b/SL/IR.pm index 2077e6b0e..8fb9b7775 100644 --- a/SL/IR.pm +++ b/SL/IR.pm @@ -1002,8 +1002,10 @@ sub get_vendor { my $query = qq|SELECT v.name AS vendor, v.creditlimit, v.terms, v.email, v.cc, v.bcc, v.language_id, v.payment_id, v.street, v.zipcode, v.city, v.country, v.taxzone_id, - $duedate + v.terms AS duedate + $duedate + v.terms AS duedate, + b.description AS business FROM vendor v + LEFT JOIN business b ON b.id = v.business_id WHERE v.id = $form->{vendor_id}|; my $sth = $dbh->prepare($query); $sth->execute || $form->dberror($query);