X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FIC.pm;h=da83c33b8ed18fc9ef1593b8f849ef140f4c4982;hb=e0900c89f30e6a0ebe9c9152cabbe4410e5b3c31;hp=f36ca04855b952fb96481f7002e756c0dc1ea840;hpb=5fea7d824ad41bb81f6ed50c529783984718ad96;p=kivitendo-erp.git diff --git a/SL/IC.pm b/SL/IC.pm index f36ca0485..da83c33b8 100644 --- a/SL/IC.pm +++ b/SL/IC.pm @@ -524,6 +524,8 @@ sub all_parts { # simple search for assemblies by items used in assemblies if ($form->{bom} eq '2' && $form->{l_assembly}) { + # assembly_qty is the column name + $form->{l_assembly_qty} = 1; # nuke where clause and bind vars $where_clause = ' 1=1 AND p.id in (SELECT id from assembly where parts_id IN ' . ' (select id from parts where 1=1'; @@ -563,7 +565,7 @@ sub all_parts { my @assemblies; if ($form->{l_assembly} && $form->{bom}) { $query = - qq|SELECT p.id, p.partnumber, p.description, a.qty AS onhand, + qq|SELECT p.id, p.partnumber, p.description, a.qty AS assembly_qty, p.unit, p.notes, p.itime::DATE as insertdate, p.sellprice, p.listprice, p.lastcost, p.rop, p.weight,