Index: ssts-invoice/src/main/java/com/forgon/disinfectsystem/invoicemanager/service/InvoiceManagerImpl.java
===================================================================
diff -u -r17062 -r17083
--- ssts-invoice/src/main/java/com/forgon/disinfectsystem/invoicemanager/service/InvoiceManagerImpl.java	(.../InvoiceManagerImpl.java)	(revision 17062)
+++ ssts-invoice/src/main/java/com/forgon/disinfectsystem/invoicemanager/service/InvoiceManagerImpl.java	(.../InvoiceManagerImpl.java)	(revision 17083)
@@ -8040,13 +8040,14 @@
 			if (!tousseDefinitionIdSet.isEmpty() || !invoicePlanIdSet.isEmpty()) {
 				StringBuilder tousseInstanceSql = new StringBuilder();
 				tousseInstanceSql
-						.append(String.format(" where (%s or %s) and %s", SqlUtils
+						.append(String.format(" where (%s or %s) and %s and %s", SqlUtils
 								.getNonStringFieldInCollectionsPredicate(
 										"po.tousseDefinition.id",
 										tousseDefinitionIdSet),SqlUtils
 										.getNonStringFieldInCollectionsPredicate(
 												"po.invoicePlanID",
-												invoicePlanIdSet),SqlUtils.getStringFieldPredicate("po.status", TousseInstance.STATUS_STERILED)));
+												invoicePlanIdSet),SqlUtils.getStringFieldPredicate("po.status", TousseInstance.STATUS_STERILED),
+												SqlUtils.getStringFieldPredicate("po.departCoding", departCode)));
 				if (StringUtils.isNotBlank(sterileStartTime)) {
 					tousseInstanceSql
 							.append(String.format(