我在使用用友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
请问用友软件售后服务,应该如何解决呢?注意以下内容来自网友提供的尝试性解决方案,操作前请务必参考用友软件备份账套数据教程备份数据,如果未能解决您的问题,可以点击并添加用友软件工程师微信号进行咨询。
您好,数据库结构与标准帐套有差异,请备份账套后提交支持网解决