已经删除过的凭证,凭证整理还是不连号,新增凭证也无法选择此凭证号原创
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
推荐阅读