Index: ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/service/InvoicePlanManagerImpl.java
===================================================================
diff -u -r21385 -r21390
--- ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/service/InvoicePlanManagerImpl.java	(.../InvoicePlanManagerImpl.java)	(revision 21385)
+++ ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/service/InvoicePlanManagerImpl.java	(.../InvoicePlanManagerImpl.java)	(revision 21390)
@@ -1328,7 +1328,7 @@
 			idSql = String.format(" %s ",SqlUtils.getNonStringFieldPredicate("disposableGoodsId", disposableGoodsId));
 		}
 		String sql = buildSqlForGetInvoicePlanByOrgUnitCodingsAndTousseType(departCodes, applyDate, tousseType);
-		String tousseSql = String.format(" po.id in (select invoicePlan.id from TousseItem where (%s) )",idSql);
+		String tousseSql = String.format(" po.id in (select invoicePlan.id from TousseItem where (%s) and %s )",idSql,SqlUtils.getStringFieldPredicate("expressInvoice", Constants.STR_YES));
 		
 		String hql = String.format("select distinct po from %s po inner join fetch po.applicationItems %s and %s", InvoicePlan.class.getSimpleName(),sql,tousseSql);
 		List<InvoicePlan> list =  objectDao.findByHql(hql);