用友T3用友通‘未审核的凭证允许记账’不起做用
2019-4-23 8:0:0 wondial用友T3用友通‘未审核的凭证允许记账’不起做用
用友T3用友通‘未审核的凭证允许记账’不起做用初始化时将”未审核的凭证允许记账”已打钩,数据库里的记录也是对的,但在记账时,出现”有未审核凭证,不能汇总记账凭证”,点”确定”后出现”无可记账凭证。是升级过程中没有执行关于“未审核也可以记帐”的相关语句。 重新执行如下语句: ALTER Proc GL_P_JZA(@iPer tinyint = 11, @ccash tinyint =1, @tcond varchar(5000)= ”) AS SET NOCOUNT On declare @ss varchar(8000) –ll Tong2005B declare @Checkflag varchar(20) set @Checkflag = (SELECT cvalue FROM AccInformation WHERE cSysID=’GL’ AND cName=’bNotCheckJz’) —————————— Delete From GL_mpostcond1 if @ccash=0 begin –ll Tong2005B if @Checkflag = ‘False’ set @ss=’SELECT iperiod,isignseq,ino_id From gl_accvouch where ibook=0 and iperiod= ‘+convert(char,@iPer,0) +(case when @tcond=” then ” else ‘ and (‘ + @tcond + ‘)’ end)+’ and (not (ccheck is null) and iflag is null or ccheck is null and iflag=1) GROUP BY iperiod,isignseq,ino_id’ else set @ss=’SELECT iperiod,isignseq,ino_id From gl_accvouch where ibook=0 and iperiod= ‘+convert(char,@iPer,0) +(case when @tcond=” then ” else ‘ and (‘ + @tcond + ‘)’ end)+’ and (iflag is null or ccheck is null and iflag=1) GROUP BY iperiod,isignseq,ino_id’ —————————– Insert GL_mpostcond1 exec (@ss) End Else begin if not object_id(‘tempdb..GL_jztmp’) is null drop table tempdb..GL_jztmp –ll Tong2005B if @Checkflag = ‘False’ set @ss=’SELECT isignseq,ino_id,1 as zt into tempdb..GL_jztmp FROM gl_accvouch inner join code ON gl_accvouch.ccode = code.ccode where ibook=0 and iperiod= ‘+convert(char,@iPer,0)+(case when @tcond=” then ” else ‘ and (‘ + @tcond + ‘)’ end) +’ and ((code.bbank ^ code.bcash) =1) and ((not (ccheck is null)) and (ccashier is null)) GROUP BY isignseq,ino_id Union SELECT isignseq,ino_id,0 as zt From gl_accvouch where ibook=0 and iperiod= ‘+convert(char,@iPer,0) +(case when @tcond=” then ” else ‘ and (‘ + @tcond + ‘)’ end)+’ and (not (ccheck is null) and iflag is null or ccheck is null and iflag=1) GROUP BY isignseq,ino_id’ else set @ss=’SELECT isignseq,ino_id,1 as zt into tempdb..GL_jztmp FROM gl_accvouch inner join code ON gl_accvouch.ccode = code.ccode where ibook=0 and iperiod= ‘+convert(char,@iPer,0)+(case when @tcond=” then ” else ‘ and (‘ + @tcond + ‘)’ end) +’ and ((code.bbank ^ code.bcash) =1) and (ccashier is null) GROUP BY isignseq,ino_id Union SELECT isignseq,ino_id,0 as zt From gl_accvouch where ibook=0 and iperiod= ‘+convert(char,@iPer,0) +(case when @tcond=” then ” else ‘ and (‘ + @tcond + ‘)’ end)+’ and (iflag is null or ccheck is null and iflag=1) GROUP BY isignseq,ino_id’ —————————— exec (@ss) SELECT isignseq,ino_id,sum(zt) as zt1 into #gl_bookB from tempdb..GL_jztmp group by isignseq,ino_id set @ss=’select ‘+convert(char,@iPer,0)+’ as iperiod,isignseq,ino_id from #gl_bookB Where zt1 = 0 ‘+(case when @tcond=” then ” else ‘ and (‘ + @tcond + ‘)’ end) insert GL_mpostcond1 exec (@ss) End。如有其它问题,请在下面回复疑问,我们将第一时间与您联系,帮助您解决问题。同时您也可以联系用友畅捷服务联盟用友4S店-用友天龙瑞德软件有限公司。用友天龙瑞德软件专业销售用友软件,用友财务软件,维护用友T3、用友t6、用友U8、致远oa软件。我们将竭诚为您服务。
联系电话:010-59798025。网址:http://yun.kuaiji66.com
如果您的问题还没有解决,可以到 T+搜索>>上找一下答案
相关阅读
- 用友T3用友通系统重装后,没有账套备份,如何恢复账套2019-4-29 8:0:0
- 企业是接单生产模式,需求不稳定,经常出现紧急订单,如何判断这样的紧急订单会不会造成计划和生产的..2019-4-27 8:0:0
- 企业在车间管理中,可以依据工段、车间、设备、员工等多种资源进行明细式派工?2019-4-27 8:0:0
- 以物易物在用友T3用友通通2005中如何实现2019-4-27 8:0:0
- 什么是安全库存、最低库存、最高库存?用友软件U8+中是如何管理的?2019-4-27 8:0:0
- 一般企业普通采购流程分为哪几种?2019-4-23 8:0:0
- 会计在填制凭证时会出现漏录某张凭证的情况,系统支持补录会计凭证吗?_12019-4-23 8:0:0
- 企业的生产班组能生产哪些品种,产能有多大很明确,这种情况下ERP系统能不能代替人工按照生产计划..2019-4-23 8:0:0
- 什么是动态安全库存?U8+的动态安全库存是如何实现的?2019-4-23 8:0:0
- 为什么说用友U8+的成本管理是一个完整的成本管理体系?2019-4-23 8:0:0