T+13.0删除凭证失败 并且删除凭证报错

删除凭证失败 并且删除凭证报错 T+13.0专业版 已打最新补丁

1.执行脚本 update GL_SrcVoucherInfo set srcvoucherid=ST_AdjustCostVoucher.id from GL_SrcVoucherInfo left join GL_Doc on GL_Doc.id=GL_SrcVoucherInfo.idDocDTO left join ST_AdjustCostVoucher on ST_AdjustCostVoucher.code=GL_SrcVoucherInfo.srcVoucherNo where GL_Doc.accountingyear=2020 and idSrcVoucherType=18 and srcvoucherid is null update GL_SrcVoucherInfo set srcvoucherid=ST_SubsidiaryBook.id from GL_SrcVoucherInfo left join GL_Doc on GL_Doc.id=GL_SrcVoucherInfo.idDocDTO left join ST_SubsidiaryBook on ST_SubsidiaryBook.voucherCode=GL_SrcVoucherInfo.srcVoucherNo where GL_Doc.accountingyear=2020 and idSrcVoucherType=82 and srcvoucherid is null and backVoucher=1 update GL_SrcVoucherInfo set srcvoucherid=ST_SubsidiaryBook.id from GL_SrcVoucherInfo left join GL_Doc on GL_Doc.id=GL_SrcVoucherInfo.idDocDTO left join ST_SubsidiaryBook on ST_SubsidiaryBook.voucherCode=GL_SrcVoucherInfo.srcVoucherNo where GL_Doc.accountingyear=2020 and idSrcVoucherType=106 and srcvoucherid is null and backVoucher=2 delete GL_SrcVoucherInfo from GL_SrcVoucherInfo a left join GL_Doc b on a.idDocDTO=b.id where srcvoucherid is null and b.accountingyear=2020 and idSrcVoucherType=18 and srcVoucherNo not in (select code from ST_AdjustCostVoucher ) 

2.删除以下凭证，然后重新生成5月和6月的入库调整单、红字蓝字回冲单的凭证 2020 5 0008 2020 5 0009 2020 5 0047 2020 5 0059 2020 5 0060 2020 5 0061 2020 5 0062 2020 5 0063 2020 6 0020 2020 6 0073 2020 6 0092 2020 6 0095 2020 6 0096 2020 6 0097 2020 6 0099 2020 6 0100 2020 6 0101 2020 6 0102 2020 6 0103 2020 6 0104 2020 6 0110 2020 6 0111 2020 6 0112 2020 6 0113 2020 6 0115 2020 6 0116 2020 6 0117 2020 6 0118 2020 6 0145 2020 6 0146

请备份账套，然后执行上面研发给出的脚本，再删除第二点里的凭证