X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FARAP.pm;h=a2d786400bf267332098c8a7609cc494881f00f6;hb=a27846ef2756ed0f59c29d256a5d43d6caaf0b58;hp=1d044eaade50ffc191e660df824a39cab7bf185a;hpb=92ee7ebd1c5136ca4a314ef4119eebd0ced10f4e;p=kivitendo-erp.git 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;