谁知道用友G6-E系统管理升级报错-214721790

bnn

问题现象：谁知道用友G6-E系统管理升级报错-2147217900
列名 'cbomsocode' 无效。
执行如下语句时出错:
CREATE view dbo.PP_MD_V
as
---- 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&lT;=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&lT;=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
问题模块：用友T6总账
详细问题描述：在用友T6企业管理件的总账模块中碰到如下问题，谁知道用友G6-E系统管理升级报错-2147217900
列名 'cbomsocode' 无效。
执行如下语句时出错:
CREATE view dbo.PP_MD_V
as
---- 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&lT;=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&lT;=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

bnn

谢谢

用友软件孙彦杰

您好，需要联系您的软件服务商，只有他们可以提交

bnn

[/抱拳]怎么提交呢，新手

用友软件孙彦杰

数据问题，请备份账套后提交到支持网解决