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;
# said order. Again consider both direct conversions and indirect
# conversions via delivery orders.
foreach my $oe_id (@oe_ids) {
+
+ # Dont close orders with periodic invoice
+ next if SL::DB::Manager::PeriodicInvoicesConfig->find_by(oe_id => $oe_id);
+
# Direct conversions "order -> invoice":
@links = RecordLinks->get_links('dbh' => $dbh,
'from_table' => 'oe',