已经删除过的凭证，凭证整理还是不连号，新增凭证也无法选择此凭证号

已经删除过的凭证，凭证整理还是不连号，新增凭证也无法选择此凭证号原创

Oo霞oO

4人赞赏了该文章 272次浏览编辑于2020年08月07日 09:17:16

凭证序时薄科目余额表明细账等都查不到断号的凭证，数据库后台能查询到断号的凭证，但没有分录

数据库直接删凭证

select * from t_voucher where fperiod=9 and FNumber=26 and fyear=2018

select * from t_voucherentry where fvoucherid in (select fvoucherid from t_voucher where fperiod=9 and FNumber=26 and fyear=2018)

delete from t_voucherentry where fvoucherid in (select fvoucherid from t_voucher where fperiod=9 and FNumber=26 and fyear=2018)

delete from t_voucher where fperiod=9 and FNumber=26 and fyear=2018

赞 4