刪除憑證失敗 并且刪除憑證報(bào)錯(cuò) T+13.0專業(yè)版 已打最新補(bǔ)丁

1.執(zhí)行腳本 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月的入庫(kù)調(diào)整單、紅字藍(lán)字回沖單的憑證 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

請(qǐng)備份賬套，然后執(zhí)行上面研發(fā)給出的腳本，再刪除第二點(diǎn)里的憑證