T6问题解答

wecooerp

T6 销售发票复核提示： Pubic Function: Makedispatch Error(0):发货单主表ID申请失败或单据号重复，请稍后再试发货单保存提示：操作过
原因分析：此问题由最大单据号表错误引起
解决方案：请在查询分析器中执行如下脚本（其中具体的数据库视用户实际情况更改）
use ufsystem

update ua_identity
set iFatherid = ( select max(dlid) from ufdata_002_2010..dispatchlist) ,
iChildID = (select max(idlsid) from ufdata_002_2010..dispatchlists)
where cacc_id ='002'
and cVouchType = 'Dispatch'

update ua_identity
set iFatherid = (select max(id) from ufdata_002_2010..rdrecord) ,
iChildID = (select max(autoid) from ufdata_002_2010..rdrecords)
where cacc_id ='002' and cVouchType = 'rd'

update ua_identity set iFatherid = ( select max(sbvid) from ufdata_002_2010..SaleBillVouch) ,
iChildID = (select max(autoid) from ufdata_002_2010..SaleBillVouchs)
where cacc_id ='002' and cVouchType = 'billvouch'

anny102

关注中。。。。。。。