用友T+ 专属云15.0 没有使用过的存货删除不了

删除存货删除不了

问题回复：

--库存期初后端可以查到 没有仓库的不符合业务规则的数据 --删除这些数据即可（与伙伴已沟通，T1升级的数据） 

select ST_RDRecord_b.* into ST_RDRecord_temp from ST_RDRecord inner join ST_RDRecord_b on ST_RDRecord.id =ST_RDRecord_b.idRDRecordDTO where idvouchertype in (select id from sm_vouchertype where name ='库存期初') and ST_RDRecord_b.idwarehouse is null and ST_RDRecord.idwarehouse is null delete from ST_RDRecord_b where id in (select id from ST_RDRecord_temp) delete from ST_RDRecord where id in (select idRDRecordDTO from ST_RDRecord_temp)