X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;ds=sidebyside;f=SL%2FOE.pm;h=888f422bea062ce8a3efa55c97906b2d6268c861;hb=92daa1a66a9ff737c92df86da3c28d663c421032;hp=7813f3350b7d6b8efcf37a0bd577e29186d96777;hpb=604959deb2d2d058a4c421468027e0d55066cffd;p=kivitendo-erp.git diff --git a/SL/OE.pm b/SL/OE.pm index 7813f3350..888f422be 100644 --- a/SL/OE.pm +++ b/SL/OE.pm @@ -806,7 +806,7 @@ sub retrieve { o.sellprice, o.parts_id AS id, o.unit, o.discount, p.bin, p.notes AS partnotes, p.inventory_accno_id AS part_inventory_accno_id, o.reqdate, o.project_id, o.serialnumber, o.ship, o.ordnumber, o.transdate, o.cusordnumber, o.subtotal, o.longdescription, - pr.projectnumber, p.alu, p.formel, + pr.projectnumber, p.formel, pg.partsgroup, o.pricegroup_id, (SELECT pricegroup FROM pricegroup WHERE id=o.pricegroup_id) as pricegroup FROM orderitems o JOIN parts p ON (o.parts_id = p.id)