T+明细账有但是凭证查询不到

分享到:

2022-06-14 17:04:06

select *  from  GL_Doc where accountingyear=2020 and accountingperiod=10
select idDocDTO,*  from  GL_Entry where idDocDTO not   in(select id from GL_Doc)
 
select *  from  GL_Doc where id not in (select iddocdto from GL_Entry)
745142488 17:02:03
delete from GL_Journal where madedate='20201019' and id in(4235,4236,4237)

 
select * from GL_Journal where madedate='20210120' and auditorname='苏敏'
delete  from GL_Journal where madedate='20210120' and docno in(0010) and auditorname='苏敏'
 
声明:此篇为用友服务中心文章,转载请标明出处链接:
  • 相关文章
  • 热门下载
  • 数据修复
  • 热门标签
合作伙伴