X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FDO.pm;h=49dbb9f4ddd8ea5ef98d3b9569f065268caceb4b;hb=1c603341fc02e3a5a7b5126cd7df6478d2e34700;hp=f2675d3e9752c60ca9300e0a0b72f158798bd7a7;hpb=0f5ce3851867ca5dab7893c32a089356b3bfd4f6;p=kivitendo-erp.git

diff --git a/SL/DO.pm b/SL/DO.pm
index f2675d3e9..49dbb9f4d 100644
--- a/SL/DO.pm
+++ b/SL/DO.pm
@@ -81,10 +81,10 @@ sub transactions {
   }
 
   if ($form->{project_id}) {
-    $query .=
+    push @where,
       qq|(dord.globalproject_id = ?) OR EXISTS
           (SELECT * FROM delivery_order_items doi
-           WHERE (doi.project_id = ?) AND (oi.delivery_order_id = dord.id))|;
+           WHERE (doi.project_id = ?) AND (doi.delivery_order_id = dord.id))|;
     push @values, conv_i($form->{project_id}), conv_i($form->{project_id});
   }
 
@@ -660,7 +660,7 @@ sub retrieve {
          doi.reqdate, doi.project_id, doi.serialnumber, doi.lastcost,
          doi.ordnumber, doi.transdate, doi.cusordnumber, doi.longdescription,
          doi.price_factor_id, doi.price_factor, doi.marge_price_factor,
-         pr.projectnumber,
+         pr.projectnumber, dord.transdate AS dord_transdate,
          pg.partsgroup
        FROM delivery_order_items doi
        JOIN parts p ON (doi.parts_id = p.id)