云县有关T+业务结账时提示：库存期初余额，【】仓库有未审核的记录！

问题现象：

有关T+业务结账时提示：库存期初余额，【】仓库有未审核的记录！

问题解决：

备份好账套数据，选择账套库执行以下脚本：

--查询异常数据

SELECT id INTO tempRDRecord FROM ST_RDRecord_b

WHERE id IN

(

SELECT b.id

FROM

ST_RDRecord_b b

LEFT

JOIN ST_RDRecord s ON s.id = b.idRDRecordDTO

WHERE

s.idVoucherType = '121'

AND

s.voucherState = '181'

AND

(s.auditor = ''

OR

s.auditor IS NULL)

AND

b.idwarehouse IS NULL

)

--删除异常数据

DELETE FROM ST_RDRecord_b WHERE id in (select id from

tempRDRecord)

delete FROM ST_RDRecord WHERE id in (select

idRDRecordDTO from st_rdrecord_b where id in (select id from tempRDRecord)) and

id not in (select idRDRecordDTO from ST_RDRecord_b)

--删除临时表

drop table tempRDRecord

--整理现存量

exec SCM_SP_RebuildCurrentStock