用友U8常见问题之最大单据号修复语句

问题：按保存时提示说:操作过程中发生资源共享冲突(可能单据号重复),请稍后重试!
解决：最大单据号检测修复,更改发货单的最大单据号的语句
use ufsystem update ua_identity set ifatherid=(select max(dlid)from ufdata_111_2012..dispatchlist),ichildid=(select max(idlsid)from ufdata_111_2012..dispatchlists) where cacc_id='111' and cvouchtype='DISPATCH'

问题：按保存时提示说：单据保存失败，不能在具有唯一索引...的对象..中出入重复键的行。
解决：最大单据号检测修复,更改入库单的最大单据号的语句
Update UFSystem..UA_Identity 
Set  iFatherId=(Select Max(ID) As ID From UFDATA_111_2012..RdRecord),
iChildId=(Select Max(AutoID) As AutoID From UFDATA_111_2012..RdRecords)
Where  cAcc_Id='111' And  cVouchType='rd'

应付应收单最大单据号
Update UFSystem..UA_Identity 
Set  iFatherId=(Select Max(ID) As IID From UFDATA_111_2012..ap_closebill),
iChildId=(Select Max(AutoID) As ID From UFDATA_111_2012..ap_closebills)
Where  cAcc_Id='111' And  cVouchType='sk'

PS: as 代表重命名列名或表名 111为要修改的帐套名 ufdata_111_2012为要修改的帐套数据库