
问题场景:
作废凭证提示两清,但是软件前台取消两清后仍无法执行作废操作
正常操作取消两清步骤:点击直达
—
本次解决步骤:
数据库清除该凭证号的两清标志
select iflagbank as 银行两清,iflagPerson as 往来两清,cdigest as 摘要,ccode as 科目编目 ,md as借方金额,mc as 贷方金额
from GL_accvouch
where dbill_date between '2023-12-01' and '2023-12-31'
and ino_id='52'

update GL_accvouch
set iflagbank=null,iflagPerson=null
where dbill_date between '2023-12-01' and '2023-12-31'
and ino_id='52'
