问题描述:
没有实时凭证可以生成了 但是现在还提示有实时凭证没有生成 不能结账?
解决方案一:
“delete” from dap_rtvouch_b where pk_voucher in (“select” pk_voucher from dap_rtvouch where year=);
”delete“ from dap_rtvouch where year= ;
(执行前备份表)
方案二:
”delete“ from dap_rtvouch_b where pk_voucher in(
“select” pk_voucher from dap_rtvouch b where pk_voucher not in (“select” pk_rtvouch from dap_finindex a where a.pk_corp=b.pk_corp and a.pk_rtvouch =b.pk_voucher) );
“delete” from dap_rtvouch where pk_voucher in(
“select” pk_voucher from dap_rtvouch b where pk_voucher not in (“select” pk_rtvouch from dap_finindex a where a.pk_corp=b.pk_corp and a.pk_rtvouch =b.pk_voucher) );