T+ 填写采购入库报错 存货明细账报错 科目设置 其他应付科目 有错误

T+ 标准版 13.0 填写采购入库报错 存货明细账报错 科目设置 其他应付科目 勾选了进行分摊的费用选择不到 打补丁报错 期间结转报错

272号补丁，可以正常升级更新补丁，不会报数据库错误 。原因： 删除自定义项时，单据相关表数据未删除。 

解决方法： 

1、安装最新补丁； 

2、备份好账套，执行修复错误数据脚本 

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') )