X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/dc7f3c9afe98b033d29c645cd9d9ced238663fbc..d467f40de696218e7cde1b78704c32443fa5b986:/SL/GL.pm diff --git a/SL/GL.pm b/SL/GL.pm index 1b4a59e8c..ef04d9ad6 100644 --- a/SL/GL.pm +++ b/SL/GL.pm @@ -277,7 +277,7 @@ sub all_transactions { (SELECT id FROM chart c2 WHERE c2.category = ?))|; $apwhere .= qq| AND ap.id in (SELECT trans_id FROM acc_trans ac2 WHERE ac2.chart_id IN - (SELECT id FROM chart c2 WHERE c2.category = ?))"|; + (SELECT id FROM chart c2 WHERE c2.category = ?))|; push(@glvalues, $form->{category}); push(@arvalues, $form->{category}); push(@apvalues, $form->{category}); @@ -555,6 +555,11 @@ sub transaction { $query = qq|SELECT closedto, revtrans FROM defaults|; ($form->{closedto}, $form->{revtrans}) = selectrow_query($form, $dbh, $query); + $query = qq|SELECT id, gldate + FROM gl + WHERE id = (SELECT max(id) FROM gl)|; + ($form->{previous_id}, $form->{previous_gldate}) = selectrow_query($form, $dbh, $query); + if ($form->{id}) { $query = qq|SELECT g.reference, g.description, g.notes, g.transdate, g.storno, g.storno_id,