X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=reporting%2Frep402.php;h=5cbb6994c08cb1b12fbe7b80f4b723ecf1cdcc1a;hb=3bd9d76da0a8c8f014f83fc5203b9954b66737ab;hp=447a730573273d6a3e57215bfedca5b7160aa066;hpb=d8d40a67b517dd35425a1fa0eb02f84c3f9fd843;p=fa-stable.git

diff --git a/reporting/rep402.php b/reporting/rep402.php
index 447a7305..5cbb6994 100644
--- a/reporting/rep402.php
+++ b/reporting/rep402.php
@@ -43,10 +43,12 @@ function getTransactions($items, $open_only, $location)
 		workorder.required_by,
 		workorder.closed,
 		workorder.stock_id
-		FROM ".TB_PREF."workorders as workorder,"
-			.TB_PREF."stock_master as item,"
+		FROM ".TB_PREF."workorders as workorder
+			LEFT JOIN ".TB_PREF."voided v ON v.id=workorder.id and v.type=".ST_WORKORDER.","
+ 			.TB_PREF."stock_master as item,"
 			.TB_PREF."locations as location
-		WHERE workorder.stock_id=item.stock_id 
+		WHERE ISNULL(v.id)
+			AND workorder.stock_id=item.stock_id 
 			AND workorder.loc_code=location.loc_code";
 
 	if ($open_only != 0)