原因:有未审核单据
解决方法:在sql的查询分析器中执行下列语句,所查询出来的结果既是没有审核的单据。
select * from DispatchList where rtrim(ltrim(IsNull(cVerifier,‘‘)))=
‘‘ And (dDate <=‘2001-12-31‘)select * from
EnDispatch where rtrim(ltrim(IsNull(cVerifier,‘‘)))=
‘‘ And (dDate <=‘2001-12-31‘)select * from
EnDispatch where rtrim(ltrim(IsNull(cVerifier,‘‘)))=
‘‘ And bFirst=1select * from SaleBillVouch where
rtrim(ltrim(IsNull(cInvalider,‘‘)))=‘‘
And rtrim(ltrim(IsNull(cChecker,‘‘)))=‘‘ And
IsNull(cST+Code,‘‘)<>‘‘ And IsNull(bFirst,0)=0 And (dDate
<=‘2001-12-31‘)select * from ExpenseVouch where
rtrim(ltrim(IsNull(cVerifier,‘‘)))=‘‘ And (dDate <=‘2001-12-31‘)
具体操作如下:
1.点击【库存管理】-【日常业务】-【单据列表】-【采购入库单列表】;
2.在【高级条件】中选择,条件设置为:审核人=NULL,点击【加入条件】,之后点【过滤】即可。