速达T+13.0销货单同时生成两个出库单

7月份33号销货单，在销货单自动生成出库单设置下，修改了33号销货单后再次生单生成了两张出库单，且删除不掉出库和销货

备份数据执行脚本，错误数据导致原因 销货单的单据状态不正确，应该是生效状态，但实际不是，切换流程后，友重新审核导致产生2张销售出库单 请按照如下步骤处理错误数据 查询销货单已经删除销售出库单存在的单据

SELECT voucherState,* FROM ST_RDRecord WHERE idvouchertype = '19' AND idsourcevouchertype = '104' AND sourceVoucherId NOT IN ( SELECT id FROM SA_SaleDelivery ); 查询出的结果包括，其中181为未生效，189为已生效 181 IO-2020-07-0003 181 IO-2020-07-0004 189 IO-2020-07-0006 189 IO-2020-07-0007 181 IO-2020-07-0008 181 IO-2020-07-0009 181 IO-2020-07-0016 181 IO-2020-07-0019

要删除以上出库单，需要先做如下处理 备份账套 弃审 IO-2020-07-0006 执行如下脚本断掉销售出库单与销货单的关系（只针对以上出库单）

UPDATE ST_RDRecord_b SET idsourcevouchertype=NULL, sourceVoucherId=NULL, sourceVoucherDetailId=NULL WHERE idRDRecordDTO IN ( SELECT id FROM ST_RDRecord WHERE code IN ('IO-2020-07-0003', 'IO-2020-07-0004', 'IO-2020-07-0006', 'IO-2020-07-0007', 'IO-2020-07-0008', 'IO-2020-07-0009', 'IO-2020-07-0016', 'IO-2020-07-0019') ); UPDATE ST_RDRecord SET idsourcevouchertype=NULL, sourceVoucherId=NULL, isAutoGenerate = 0 WHERE id IN ( SELECT id FROM ST_RDRecord WHERE code IN ('IO-2020-07-0003', 'IO-2020-07-0004', 'IO-2020-07-0006', 'IO-2020-07-0007', 'IO-2020-07-0008', 'IO-2020-07-0009', 'IO-2020-07-0016', 'IO-2020-07-0019') );

进入系统，手动删除以上出库单 处理销货单 SA-2020-07-0033 执行如下脚本

UPDATE ST_RDRecord_b SET idsourcevouchertype=NULL, sourceVoucherId=NULL, sourceVoucherDetailId=NULL WHERE idRDRecordDTO IN ( SELECT id FROM ST_RDRecord WHERE code IN ('IO-2020-07-0040','IO-2020-07-0041') ); UPDATE ST_RDRecord SET idsourcevouchertype=NULL, sourceVoucherId=NULL, isAutoGenerate=0 WHERE id IN ( SELECT id FROM ST_RDRecord WHERE code IN ('IO-2020-07-0040', 'IO-2020-07-0041' ) );

进入系统 手动删除销售出库单 IO-2020-07-0040 IO-2020-07-0041 进行可用量整理 重启T+服务 请打最新补丁