From: Sven Schöling Date: Wed, 26 Jul 2017 09:07:57 +0000 (+0200) Subject: SL::Helper::ShippedQty: SQL Fehler im stock_fill_up query X-Git-Tag: release-3.5.4~954 X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/kivitendo-erp.git/commitdiff_plain/e5e8dfae3a1edcdcfe64338112923ec40fc0353c?ds=sidebyside SL::Helper::ShippedQty: SQL Fehler im stock_fill_up query --- diff --git a/SL/Helper/ShippedQty.pm b/SL/Helper/ShippedQty.pm index cf1c70bfe..80ee73d9c 100644 --- a/SL/Helper/ShippedQty.pm +++ b/SL/Helper/ShippedQty.pm @@ -61,7 +61,7 @@ my $stock_item_links_query = <<''; ORDER BY oi.trans_id, oi.position my $stock_fill_up_doi_query = <<''; - SELECT doi.id, doi.delivery_order_id, doi.position, doi.parts_id, doi.description, doi.reqdate, doi.serialnumber, i.qty, i.unit + SELECT doi.id, doi.delivery_order_id, doi.position, doi.parts_id, doi.description, doi.reqdate, doi.serialnumber, i.qty, p.unit FROM delivery_order_items doi INNER JOIN parts p ON p.id = doi.parts_id INNER JOIN delivery_order_items_stock dois ON dois.delivery_order_item_id = doi.id