X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=reporting%2Fincludes%2Freports_classes.inc;h=0d150930760c79f8c096e1599f1561f73c161a5a;hb=c82cbc67f22454e4afd30e53c40043b54a732be3;hp=77399c3f3a663b3c08631bc5909f57a101c7e5fa;hpb=ad0504645e3632d169d0f253bb5eb4db8b7e18b9;p=fa-stable.git

diff --git a/reporting/includes/reports_classes.inc b/reporting/includes/reports_classes.inc
index 77399c3f..0d150930 100644
--- a/reporting/includes/reports_classes.inc
+++ b/reporting/includes/reports_classes.inc
@@ -410,7 +410,8 @@ class BoxReports
 						FROM ".TB_PREF."stock_master item,"
 							.TB_PREF."workorders wo 
 							LEFT JOIN ".TB_PREF."voided v ON wo.id=v.id and v.type=".ST_WORKORDER."
-						WHERE item.stock_id=wo.stock_id
+						WHERE ISNULL(v.id)
+						AND item.stock_id=wo.stock_id
 						ORDER BY wo.id DESC";
 					return combo_input($name, '', $sql, 'id', 'IName',array('order'=>false));