T+ 標準版 13.0 填寫采購入庫報錯 存貨明細賬報錯 科目設(shè)置 其他應(yīng)付科目 勾選了進行分攤的費用選擇不到 打補丁報錯 期間結(jié)轉(zhuǎn)報錯

272號補丁，可以正常升級更新補丁，不會報數(shù)據(jù)庫錯誤 。原因： 刪除自定義項時，單據(jù)相關(guān)表數(shù)據(jù)未刪除。 

解決方法： 

1、安裝最新補丁； 

2、備份好賬套，執(zhí)行修復(fù)錯誤數(shù)據(jù)腳本 

DELETE FROM eap_VoucherTableColumn WHERE id IN ( SELECT ID FROM eap_VoucherTableColumn WHERE VoucherID IN ( 240, 241, 64, 8, 51, 50, 4, 71, 47, 149, 39 ) AND TableID IN ( SELECT ID FROM eap_VoucherTable WHERE VoucherID IN ( 240, 241, 64, 8, 51, 50, 4, 71, 47, 149, 39 ) AND DtoName IN ( N'RDRecordDetailDTO', N'RDRecordDetailDTO', N'RDRecordDetailDTO', N'RDRecordDetailDTO', N'RDRecordDetailDTO', N'RDRecordDetailDTO', N'RDRecordDetailDTO', N'RDRecordDetailDTO', N'RDRecordDetailDTO', N'RDRecordDetailDTO', N'RDRecordDetailDTO' ) ) AND FieldName NOT IN ( N'AllowUserDef', N'IsUserDef' ) AND FieldName LIKE N'%pubuserdef%' AND ShowSysField = 1 AND CHARINDEX(N'_', name) = 0 AND NAME IN ('pubuserdefdecm8','pubuserdefnvc6') )