用友T3记账时报错,运行时错误‘-2147217873,怎么办?
用友T3财务软件在记账的时候提示错误:运行时错误‘-2147217873(80040e2f)':违反了PRIMMARY KEY 约束‘GL-mpostcond1_pk"不能在对象‘GL-Mpostcond1中键入重复键。如下图所示:
也有不少的财务会计朋友是在使用用友通T3软件的返记账过程中提示的。那么怎么解决这个问题呢?
经过用友财务软件小编跟踪数据库发现主要是软件考虑的不够周全,后来用友畅捷通在用友t+310.8plus1标准版及后续版本使用补丁做了改进了,所以解决这个问题要看版本。
如果是用友T310.8plus1之前的版本,请先在查询分析器中执行如下脚本:
use ufdata_xxx_2014
delete from gl_mpostcond1
然后再执行如下脚本,避免后续出现类似的问题。
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
ALTER Proc [dbo].[GL_P_JZA](@iPer tinyint = 11, @ccash tinyint =1, @tcond varchar(5000)= '') AS SET NOCOUNT On declare @ss varchar(8000)
declare @Checkflag varchar(20) declare @trnd bigint set @trnd=(select convert(bigint,rand()*100000000000)) declare @temptable varchar(50) declare @temptable2 varchar(50) set @temptable='GL_jztmp'+ convert(varchar(30),@trnd) set @temptable2='gl_bookB'+ convert(varchar(30),@trnd) set @Checkflag = (SELECT cvalue FROM AccInformation WHERE cSysID='GL' AND cName='bNotCheckJz')
Delete From GL_mpostcond1 if @ccash=0 begin
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..'+@temptable) is null exec('drop table tempdb..'+ @temptable)
if @Checkflag = 'False' set @ss='SELECT isignseq,ino_id,1 as zt into tempdb..'+@temptable+' 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..'+@temptable+' 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) exec('SELECT isignseq,ino_id,sum(zt) as zt1 into tempdb..' + @temptable2 + ' from tempdb..'+@temptable+' group by isignseq,ino_id') set @ss='select '+convert(char,@iPer,0)+' as iperiod,isignseq,ino_id from tempdb..' + @temptable2 + ' Where zt1 = 0 '+(case when @tcond='' then '' else ' and (' + @tcond + ')' end) insert GL_mpostcond1 exec (@ss) if not object_id('tempdb..'+@temptable2) is null exec('drop table tempdb..'+ @temptable2) End
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
如果是用友T310.8plus1之后的版本,包括用友T310.8plus1普及版和标准版请直接安装最新的补丁就行了,补丁下载地址在论坛中有哦:http://edu.ufidawhy.com。
- 1“存货分布表”上为什么只显示数量?
- 2用友通t3财务软件如何查询帐?
- 3用友T3企管通单据不需要审核如何设置
- 4用友T3企管通“期初同步”怎么操作
- 5为什么无法更换目标账套名称
- 6输出多栏账时提示“数据列数太多(错误号:65)
- 7用友软件出入库类别的用途
- 8用友畅捷通T+11.51免费下载
- 9T3用友通日常知识总结
- 10t3用友通标准版加快经济社会各领域信息化
- 11用友T3企管通如何去掉单据编码中的横线
- 12用友财务软件销售成本结转如何使用
- 13没有执行单据记账的权利
- 14用友软件提示-7内存溢出的解决办法
- 15T3用友通如何将已年结的账套独立出来
- 16t3用友通标准版能够给您带来的效益如下
- 17怎么将出纳通新增的票据编号显示在票据打印界面?
- 18新增资产时跑出的填制凭证界面如何取消
- 19用友T3打印单据时如何默认为新模板?
- 20求用友通t3免费单机版哪里有?
- 21用友T3销售退货-销售款项结算后部分退货处理
- 22用友T3财务报表提示演示版,怎么解决?
- 23用友软件T3用友通单据上的单价如何设置小数位
- 24运行时错误91,未设置对象变量或with block变量
- 25输出财务报表提示:不能设置类range的columnwidth属性?
- 26用友财务通普及版10.2免费下载地址
- 27用友T3报错:-2147110991从字符串向 datetime转换时失败
- 28如何在T3中保存修改后的报表模板
- 29用友通t3与用友通标准版10.2有什么区别?
- 30用友通标准版10.2免费下载地址
成都公司:成都市成华区建设南路160号1层9号
重庆公司:重庆市江北区红旗河沟华创商务大厦18楼