X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/5dd59becc5c8a9adb9457754c0ebe564aa94e029..6b87451f5f6d97ce2a3bfcddbca7f715ed9a1333:/SL/IR.pm diff --git a/SL/IR.pm b/SL/IR.pm index 5ea2404ed..5f33d102e 100644 --- a/SL/IR.pm +++ b/SL/IR.pm @@ -1071,7 +1071,7 @@ sub get_vendor { if (!$form->{id} && $form->{type} !~ /_(order|quotation)/) { # setup last accounts used - $query = qq|SELECT c.accno, c.description, c.link, c.category + $query = qq|SELECT c.id, c.accno, c.description, c.link, c.category FROM chart c JOIN acc_trans ac ON (ac.chart_id = c.id) JOIN ap a ON (a.id = ac.trans_id)