用友G6-e升级时报错-2147217900用友G6-...?

发布:admin阅读:53时间:5年前

我在使用用友T6企业管理软件的T6总账模块中碰到了一个奇怪的问题:

g6-e升级时报错-2147217900

具体的情况如下:

g6-e升级时报错-2147217900列名 'cbomsocode' 无效。执行如下语句时出错:CREATE view dbo.PP_MD_Vas ---- itotalnet 就是为了计算方便一些。-- select b.nid as nid,b.cmpid,b.cinvcode,b.cFree1,b.cFree2,b.cFree3,b.cFree4,b.cFree5,b.cFree6,b.cFree7,b.cFree8,b.cFree9,b.cFree10,b.cbomsocode,b.dRequireDate,iTotalNet-(select sum(ineeds) from pp_rmrpdetails A where A.nid<=B.nid and-- A.cinvcode=B.cinvcode -- and isnull(a.cfree1,'')=isnull(b.cfree1,'') and isnull(a.cfree2,'')=isnull(b.cfree2,'') and isnull(a.cfree3,'')=isnull(b.cfree3,'') -- and isnull(a.cfree4,'')=isnull(b.cfree4,'') and isnull(a.cfree5,'')=isnull(b.cfree5,'') and isnull(a.cfree6,'')=isnull(b.cfree6,'') -- and isnull(a.cfree7,'')=isnull(b.cfree7,'') and isnull(a.cfree8,'')=isnull(b.cfree8,'') and isnull(a.cfree9,'')=isnull(b.cfree9,'') -- and isnull(a.cfree10,'')=isnull(b.cfree10,'') -- and A.cmpid=B.cmpid-- ) as iUse,-- (select count(nid) from pp_rmrpdetails A where A.nid<=B.nid and-- A.cinvcode=B.cinvcode -- and isnull(a.cfree1,'')=isnull(b.cfree1,'') and isnull(a.cfree2,'')=isnull(b.cfree2,'') and isnull(a.cfree3,'')=isnull(b.cfree3,'') -- and isnull(a.cfree4,'')=isnull(b.cfree4,'') and isnull(a.cfree5,'')=isnull(b.cfree5,'') and isnull(a.cfree6,'')=isnull(b.cfree6,'') -- and isnull(a.cfree7,'')=isnull(b.cfree7,'') and isnull(a.cfree8,'')=isnull(b.cfree8,'') and isnull(a.cfree9,'')=isnull(b.cfree9,'') -- and isnull(a.cfree10,'')=isnull(b.cfree10,'') -- and A.cmpid=B.cmpid-- ) as tmpid-- from pp_rmrpdetails B

请问用友软件售后服务,应该如何解决呢?注意以下内容来自网友提供的尝试性解决方案,操作前请务必参考用友软件备份账套数据教程备份数据,如果未能解决您的问题,可以点击并添加用友软件工程师微信号进行咨询。

您好,数据库结构与标准帐套有差异,请备份账套后提交支持网解决

用友软件论坛 https://aichanjet.com/yyt6/422330.html

上一篇:我要看1-3的成本汇总数,要在哪里去查看我要看1-3的...?

下一篇:15年没有做年度结转,直接建立的16年年15年没有做年...?

用友软件古老师,13年用友软件技术经验,有偿服务各类疑难杂症!

微信号复制成功

打开微信,点击右上角"+"号,添加朋友,粘贴微信号,搜索即可!