X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/d5dece1e36e57b7ea9a0de28755b3518c548c22f..c82106b1c6eae4b7abbf60fb3e9ae4ecad7dcb04:/SL/IC.pm diff --git a/SL/IC.pm b/SL/IC.pm index 5314d4b8e..ea8b92926 100644 --- a/SL/IC.pm +++ b/SL/IC.pm @@ -698,8 +698,9 @@ sub assembly_item { my $dbh = $form->dbconnect($myconfig); my $query = - qq|SELECT p.id, p.partnumber, p.description, p.sellprice, p.weight, p.onhand, p.unit, pg.partsgroup, - p.price_factor_id, pfac.factor AS price_factor + qq|SELECT p.id, p.partnumber, p.description, p.sellprice, + p.weight, p.onhand, p.unit, pg.partsgroup, p.lastcost, + p.price_factor_id, pfac.factor AS price_factor FROM parts p LEFT JOIN partsgroup pg ON (p.partsgroup_id = pg.id) LEFT JOIN price_factors pfac ON pfac.id = p.price_factor_id