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

作者：杨青菁

用友小张





--查询无审核人单据
SELECT CODE AS 单据号 ,maker as 制单人 ,makerid  as 制单人id,auditor as 审核人 ,auditorid 审核人id
, voucherdate as 单据日期 , auditeddate 审核日期

FROM ST_RDRecord 
where auditor is null



--解决无审核人
update ST_RDRecord 
set auditor = maker,auditorid =auditorid,auditeddate=voucherdate
where where auditor is null AND voucherdate  between '2023-01-01'  and '2023-12-31'

解决T+出库库单据没有审核，无法年结月结处理--