Index: ssts-diposablegoods/src/main/java/com/forgon/disinfectsystem/diposablegoods/dwr/table/DiposableGoodsTableManager.java
===================================================================
diff -u -r21968 -r22073
--- ssts-diposablegoods/src/main/java/com/forgon/disinfectsystem/diposablegoods/dwr/table/DiposableGoodsTableManager.java	(.../DiposableGoodsTableManager.java)	(revision 21968)
+++ ssts-diposablegoods/src/main/java/com/forgon/disinfectsystem/diposablegoods/dwr/table/DiposableGoodsTableManager.java	(.../DiposableGoodsTableManager.java)	(revision 22073)
@@ -733,7 +733,7 @@
 			"from DisposableGoodsIdentification dgi join DisposableGoods dg on dgi.disposableGoodsID=dg.id "+
 			"join DisposableGoodsBatch dgb on dgi.disposableGoodsBatchID=dgb.id "+
 			"left join JXINVENTORYSTOCK js on dgi.batchIdFromHisSync=js.batchid "+
-			"where dgi.amount > 0 and convert(decimal(20,4),js.quantity) > 0 and dgi.amount <> convert(decimal(20,4),js.quantity) group by dg.idFromHisSync ,dgi.batchIdFromHisSync , dg.externalCode ,dg.name ,dg.specification ,dgb.batchNumber "+
+			"where dgi.amount > 0 and convert(decimal(20,4),js.quantity) > 0 and dgi.amount <> convert(decimal(20,4),js.quantity) group by dg.idFromHisSync ,dgi.batchIdFromHisSync , dg.externalCode ,dg.name ,dg.specification ,dgb.batchNumber having sum(dgi.amount) <> avg(js.quantity) "+
 			
 			"union "+