X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FPE.pm;h=28f3ba5c11fb26d338136945cf35c80e7d12cd78;hb=fb03d191f53516cbf1022e755665556e7f1acb82;hp=9906a72d9a7249103a5bb51e40279843ed965735;hpb=9bd3030a376850c427c102c6e0c54f19bd19332e;p=kivitendo-erp.git diff --git a/SL/PE.pm b/SL/PE.pm index 9906a72d9..28f3ba5c1 100644 --- a/SL/PE.pm +++ b/SL/PE.pm @@ -172,7 +172,7 @@ sub pricegroups { my $first = 1; $where .= qq| AND id NOT IN (|; - foreach my $table (qw(invoice orderitems prices rmaitems)) { + foreach my $table (qw(invoice orderitems prices)) { $where .= "UNION " unless ($first); $first = 0; $where .= @@ -253,7 +253,7 @@ sub get_pricegroup { my @values = (); $query = qq|SELECT |; - foreach my $table (qw(invoice orderitems prices rmaitems)) { + foreach my $table (qw(invoice orderitems prices)) { $query .= " + " unless ($first); $first = 0; $query .= qq|(SELECT COUNT(*) FROM $table WHERE pricegroup_id = ?) |;