X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/92ee7ebd1c5136ca4a314ef4119eebd0ced10f4e..e47fdf34451bb7c091b29144e041532c4960718a:/SL/ARAP.pm

diff --git a/SL/ARAP.pm b/SL/ARAP.pm
index 1d044eaad..a2d786400 100644
--- a/SL/ARAP.pm
+++ b/SL/ARAP.pm
@@ -67,7 +67,8 @@ sub close_orders_if_billed {
   my $q_ordered = qq|SELECT oi.parts_id, oi.qty, oi.unit, p.unit AS partunit
                       FROM orderitems oi
                       LEFT JOIN parts p ON (oi.parts_id = p.id)
-                      WHERE oi.trans_id = ?|;
+                      WHERE oi.trans_id = ?
+                      AND not oi.optional|;
   my $h_ordered = prepare_query($form, $dbh, $q_ordered);
 
   my @close_oe_ids;