問(wèn)題現(xiàn)象：升級(jí)后可能會(huì)出現(xiàn)發(fā)貨單（銷售發(fā)票）調(diào)用訂單不能保存，提示操作過(guò)程中發(fā)生資源共享沖突，可能單據(jù)號(hào)重復(fù)
問(wèn)題分析：ufsystem數(shù)據(jù)庫(kù)中表ua_iadentity中ifather，ichildid小于出錯(cuò)數(shù)據(jù)庫(kù)中所對(duì)應(yīng)的主表和
子表。
用sql執(zhí)行語(yǔ)句可解決：（ufdata_008_2010改為你所修改的帳套名）
發(fā)貨單重復(fù)
use ufsystem
update ua_identity set ifatherid=(select max(dlid)from
ufdata_008_2010..dispatchlist),ichildid=(select max(idlsid)from
ufdata_008_2010..dispatchlists) where cacc_id='帳套號(hào)' and cvouchtype='DISPATCH'
銷售發(fā)票重復(fù)
use ufsystem
update ua_identity set ifatherid=(select max(sbvid)from
ufdata_008_2010..salebillvouch),ichildid=(select max(autoid)from
ufdata_008_2010..salebillvouchs) where cacc_id='帳套號(hào)' and cvouchtype='billvouch'
（如果出錯(cuò)的是其他類型的單據(jù)，可以根據(jù)紅色的字段，與下列ua_identity表中所對(duì)應(yīng)的數(shù)據(jù)庫(kù)表進(jìn)行替換，下面的主子表代表出錯(cuò)的數(shù)據(jù)庫(kù)中的表，不是ufsystem數(shù)據(jù)庫(kù)中的。）
下表是UfSystem..Ua_identity 表中常用記錄所對(duì)應(yīng)的數(shù)據(jù)表及字段，
字段標(biāo)識(shí)描述主表字段子表字段
Rd收發(fā)記錄主子表Rdrecord.idRdrecords.autoid
BILLVOUCH銷售發(fā)票主子表SaleBillVouch.SBVID SaleBillVouchs.autoid
DISPATCH發(fā)貨退貨單主子表DispatchList.dlidDispatchLists.idlsid
POMain采購(gòu)訂單主子表PO_Pomain.POIDPO_Podetails.id
SOMain銷售訂單主子表SO_SOMain.idSO_SODetails.autoid
PURBILL采購(gòu)發(fā)票主子表PurBillVouch.PBVIDPurBillVouchs.ID
PURSTID采購(gòu)結(jié)算單主子表PurSettleVouch.PSVIDPurSettleVouchs.ID
SETTLEVOUCH委托代銷結(jié)算單主子表SA_SettleVouch.IDSA_SettleVouchs.Autoid
Ju出入庫(kù)調(diào)整單主子表JustInVouch.IDJustInVouch.Autoid
PUAPP采購(gòu)請(qǐng)購(gòu)單主子表PU_AppVouch.IDPU_AppVouchs.Autoid
PUARRIVAL采購(gòu)到貨單主子表PU_ArrivalVouch.IDPU_ArrivalVouchs.Autoid
Tr庫(kù)存調(diào)撥單主子表TransVouch.IdTransVouchs.Autoid
EXPENSE代墊費(fèi)用單主子表ExpenseVouch.IDExpenseVouchs.Autoid
Ch盤點(diǎn)單主子表CheckVouch.ID CheckVouchs.Autoid
Ma限額領(lǐng)料單主子表MatchVouch.IDMatchVouchs.Autoid
SALEPAY銷售支出單主子表SalePayVouch.IDSalePayVouchs.Autoid
QUOMAIN銷售報(bào)價(jià)單主子表SA_QuoMain.IDSA_QuoDetails.Autoid
XJ收付款單主子表(銷售現(xiàn)結(jié)使用)Ap_CloseBill.ccancelnoAp_CloseBills.ID
SK收付款單主子表(收款cCancelNo is null)Ap_CloseBill.iIDAp_CloseBills.ID
OM_MO委外訂單主子表OM_MOMain.MoidOM_MODetails.MODetailsID
OM_MS
委外結(jié)算主子表OM_MatSettleVouch.MSIDOM_MatSettleVouchs.MSDetailsID
OM_Materials委外用料表OM_MOMaterials.MOIDOM_MOMaterials.MOMaterialsID
問(wèn)題2：新增或者修改自定義檔案，在保存的時(shí)候提示:鍵列信息不足或不正確，更新影響到多行
錯(cuò)誤原因：查userdef表
userdef表中多了個(gè)觸發(fā)器，T6的數(shù)據(jù)結(jié)構(gòu)中沒(méi)有這個(gè)觸發(fā)器，請(qǐng)?jiān)诓樵兎治銎髦姓业竭@個(gè)表，
（userdef，右鍵-所有任務(wù)-管理觸發(fā)器-名稱-下拉選擇，觸發(fā)器-刪除-確定）
問(wèn)題：按保存時(shí)提示說(shuō):操作過(guò)程中發(fā)生資源共享沖突(可能單據(jù)號(hào)重復(fù)),請(qǐng)稍后重試!
解決：最大單據(jù)號(hào)檢測(cè)修復(fù),更改發(fā)貨單的最大單據(jù)號(hào)的語(yǔ)句
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'
問(wèn)題：按保存時(shí)提示說(shuō)：?jiǎn)螕?jù)保存失敗，不能在具有唯一索引...的對(duì)象..中出入重復(fù)鍵的行。
解決：最大單據(jù)號(hào)檢測(cè)修復(fù),更改入庫(kù)單的最大單據(jù)號(hào)的語(yǔ)句
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'
應(yīng)付應(yīng)收單最大單據(jù)號(hào)
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為要修改的帳套數(shù)據(jù)庫(kù)
