用友修改UFSYSTEM最大单据号SQL语句

用友修改UFSYSTEM最大单据号SQL语句
在保存任何单据时，出现用友单据保存提示违反了primary key约束'********'不能在对象'****'中插入重复键。

新增单据保存失败的情况时，在SQL查询器中，执行以下语句，就能解决。

update ufsystem..ua_identity Set iFatherId=(Select CASE WHEN Max(dlid) IS NOT NULL THEN Max(dlID) ELSE 0 END As ID From UFDATA_008_2012..DISPATCHlist),
iChildId=(Select CASE WHEN Max(AutoID) IS NOT NULL THEN Max(AutoID) ELSE 0 END As AutoID From UFDA TA_008_2012..DISPA TCHlists)
Where cAcc_Id='008' And cV ouchType='dispatch'
update ufsystem..ua_identity Set iFatherId=(Select CASE WHEN Max(sbvID) IS NOT NULL THEN Max(SBVID) ELSE 0 END As ID From UFDATA_008_2012..SaleBillV ouch),
iChildId=(Select CASE WHEN Max(AutoID) IS NOT NULL THEN Max(AutoID) ELSE 0 END As AutoID From UFDATA_008_2012..SaleBillV ouchs)
Where cAcc_Id='008' And cVouchType='billvouch'
go
update ufsystem..ua_identity Set iFatherId=(Select CASE WHEN Max(poid) IS NOT NULL THEN Max(poid) ELSE 0 END As ID From UFDATA_008_2012..po_POMain),
iChildId=(Select Max(id) As AutoID From UFDATA_008_2012..po_podetails)
Where cAcc_Id='008' And cV ouchType='POMain'
go
update ufsystem..ua_identity Set iFatherId=(Select CASE WHEN Max(ID) IS NOT NULL THEN Max(ID) ELSE 0 END As ID From UFDATA_008_2012..JustInVouch),
iChildId=(Select CASE WHEN Max(AutoID) IS NOT NULL THEN Max(AutoID) ELSE 0 END As AutoID From UFDATA_008_2012..JustInV ouchs)
Where cAcc_Id='008' And cV ouchType='ju'
go
update ufsystem..ua_identity Set iFatherId=(Select CASE WHEN Max(ID) IS NOT NULL THEN Max(ID) ELSE 0 END As ID From UFDATA_008_2012..PU_ArrivalV ouch),
iChildId=(Select CASE WHEN Max(AutoID) IS NOT NULL THEN Max(AutoID) ELSE 0 END As AutoID From UFDATA_008_2012..PU_ArrivalV ouchs)
Where cAcc_Id='008' And cV ouchType='puarrival'
go
update ufsystem..ua_identity Set iFatherId=(Select CASE WHEN Max(ID) IS NOT NULL THEN Max(ID) ELSE 0 END As ID From UFDATA_008_2012..PU_AppV ouch),
iChildId=(Select CASE WHEN Max(AutoID) IS NOT NULL THEN Max(AutoID) ELSE 0 END As AutoID From UFDATA_008_2012..PU_AppV ouchs)
Where cAcc_Id='008' And cV ouchType='puapp'
go
update ufsystem..ua_identity Set iFatherId=(Select CASE WHEN Max(pbVID)IS NOT NULL THEN Max(pbVID) ELSE 0 END As ID From UFDATA_008_2012..PurBillVouch),
iChildId=(Select CASE WHEN Max(ID) IS NOT NULL THEN Max(ID) ELSE 0 END As AutoID From UFDATA_008_2012..PurBillV ouchs)
Where cAcc_Id='008' And cV ouchType='purbill'
go
update ufsystem..ua_identity Set iFatherId=(Select CASE WHEN Max(psvid)IS NOT NULL THEN Max(psvid) ELSE 0 END As ID From UFDATA_008_2012..PurSettleVouch),
iChildId=(Select CASE WHEN Max(ID) IS NOT NULL THEN Max(ID) ELSE 0 END As AutoID From UFDATA_008_2012..PurSettleV ouchs)
Where cAcc_Id='008' And cV ouchType='PURSTID'
go
update ufsystem..ua_identity Set iFatherId=(Select CASE WHEN Max(id) IS NOT NULL THEN Max(id) ELSE 0 END As ID From UFDATA_008_2012..SA_QuoMain),
iChildId=(Select CASE WHEN Max(AutoID) IS NOT NULL THEN Max(AutoID) ELSE 0 END As AutoID From UFDATA_008_2012..SA_Quodetails)
Where cAcc_Id='008' And cV ouchType='QUOMAIN'
go
update ufsystem..ua_identity Set iFatherId=(Select CASE WHEN Max(id)IS NOT NULL THEN Max(id) ELSE 0 END As ID From UFDATA_008_2012..SO_SOMain),
iChildId=(Select CASE WHEN Max(isosid) IS NOT NULL THEN Max(isosid) ELSE 0 END As isosid From UFDATA_008_2012..SO_SOdetails)
Where cAcc_Id='008' And cV ouchType='somain'
go
update ufsystem..ua_identity Set iFatherId=(Select CASE WHEN Max(iid)IS NOT NULL THEN Max(iid) ELSE 0 END As ID From UFDATA_008_2012..Ap_CloseBill),
iChildId=(Select CASE WHEN Max(id)IS NOT NULL THEN Max(id) ELSE 0 END As AutoID From UFDATA_008_2012..Ap_CloseBills)
Where cAcc_Id='008' And cV ouchType='sk'
go
update ufsystem..ua_identity Set iFatherId=(Select CASE WHEN Max(id)IS NOT NULL THEN Max(id) ELSE 0 END As ID From UFDATA_008_2012..TransV ouch),
iChildId=(Select CASE WHEN Max(autoid)IS NOT NULL THEN Max(autoid) ELSE 0 END As AutoID From UFDATA_008_2012..TransV ouchs)
Where cAcc_Id='008' And cV ouchType='tr'
go
update ufsystem..ua_identity Set iFatherId=(Select CASE WHEN Max(id)IS NOT NULL THEN Max(id) ELSE 0 END As ID From UFDATA_008_2012..ExpenseV ouch),
iChildId=(Select CASE WHEN Max(autoid)IS NOT NULL THEN Max(autoid) ELSE 0 END As AutoID From UFDATA_008_2012..ExpenseV ouchS)
Where cAcc_Id='008' And cV ouchType='EXPENSE'
go。