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