用友U8 软件版本8.51,2006年1月份应收与总帐对帐不平,如3103001客户业务明细账没有余额,但在应付帐款明细账下还有余额。用友U8 软件版本8.51,2006年1月份应收与总帐对帐不平,如3103001客户业务明细账没有余额,但在应付帐款明细账下还有余额。
问题原因:06年度一些已审核的发票,其某些表体记录在AP_DETAIL表中并不存在。参照执行如下脚本即可查出: --当前发票已审核,但是ap_detail表中不存在的发票子表记录 select cVerifier,* FROM SaleBillVouch INNER JOIN SaleBillVouchs ON SaleBillVouch.SBVID = SaleBillVouchs.SBVID WHERE SaleBillVouch.cVouchType in ('27' ,'26') and autoid not in ( select distinct ibvid from ap_detail where cflag='ar' and ccovouchtype in ('27' ,'26') and iperiod=1 and cprocstyle=ccovouchtype ) and salebillvouch.cVerifier is not null and ddate>'2005-12-31 00:00:00.000' 解决方法:取消这些发票的核销、审核等操作,重新审核制单、核销即可。注意做好数据备份!
解决方案:
问题原因:06年度一些已审核的发票,其某些表体记录在AP_DETAIL表中并不存在。参照执行如下脚本即可查出: --当前发票已审核,但是ap_detail表中不存在的发票子表记录 select cVerifier,* FROM SaleBillVouch INNER JOIN SaleBillVouchs ON SaleBillVouch.SBVID = SaleBillVouchs.SBVID WHERE SaleBillVouch.cVouchType in ('27' ,'26') and autoid not in ( select distinct ibvid from ap_detail where cflag='ar' and ccovouchtype in ('27' ,'26') and iperiod=1 and cprocstyle=ccovouchtype ) and salebillvouch.cVerifier is not null and ddate>'2005-12-31 00:00:00.000' 解决方法:取消这些发票的核销、审核等操作,重新审核制单、核销即可。注意做好数据备份!