|
U8问题库
问题名称: |
T6升级U8问题 |
问题号: |
201106300034 |
软件版本: |
8.90 |
适用产品: |
财务会计 |
软件模块: |
总账 |
最后更新时间: |
2011-7-14 23:20:13 |
问题现象: |
T6升级到U8总是提示错误。已经通过T6转U8工具转换过帐套,还是报错。 |
解决方案: |
您好,
此问题【经测试】现做如下分析与答复:
【问题原因】
一、帐套1(在引入到U872升级过程中的报错):问题1、view dbo.recordinq 出现了手工加的列caccountpid,caccountpdate;
方案1、alter view dbo.recordinq
as
select dbo.rdrecord.id, dbo.rdrecord.brdflag, dbo.rdrecord.cvouchtype,
dbo.rdrecord.cwhcode, dbo.rdrecord.ddate, dbo.rdrecord.ccode,
dbo.rdrecord.crdcode, dbo.rdrecord.cdepcode, dbo.rdrecord.cpersoncode,
dbo.rdrecord.cprobatch, dbo.rdrecord.chandler, dbo.rdrecord.cmemo,
dbo.rdrecord.caccounter, dbo.rdrecord.cmaker, dbo.rdrecord.cdefine1,
dbo.rdrecord.cdefine2, dbo.rdrecord.cdefine3, dbo.rdrecord.cdefine4,
dbo.rdrecord.cdefine5, dbo.rdrecord.cdefine6, dbo.rdrecord.cdefine7,
dbo.rdrecord.cdefine8, dbo.rdrecord.cdefine9, dbo.rdrecord.cdefine10,
dbo.warehouse.cwhname, dbo.department.cdepname, dbo.person.cpersonname,
dbo.rd_style.crdname, dbo.rdrecord.csource, dbo.rdrecord.cbustype,
dbo.rdrecord.dveridate, dbo.rdrecord.cbuscode, dbo.rdrecord.cptcode,
dbo.rdrecord.cstcode, dbo.rdrecord.ccuscode, dbo.rdrecord.cvencode,
dbo.rdrecord.cordercode, dbo.rdrecord.carvcode, dbo.rdrecord.cbillcode,
dbo.rdrecord.cdlcode, dbo.rdrecord.darvdate, dbo.rdrecord.cchkcode,
dbo.rdrecord.dchkdate, dbo.rdrecord.cchkperson, dbo.rdrecord.vt_id,
dbo.rdrecord.bisstqc, dbo.rdrecord.cdefine11, dbo.rdrecord.cdefine12,
dbo.rdrecord.cdefine13, dbo.rdrecord.cdefine14, dbo.rdrecord.cdefine15,
dbo.rdrecord.cdefine16, dbo.rdrecord.imquantity,
dbo.rdrecord.cpspcode, dbo.rdrecord.cmpocode, dbo.rdrecord.bpufirst,dbo.rdrecord.biafirst,
dbo.rdrecord.ipurorderid, dbo.rdrecord.ipurarriveid, dbo.rdrecord.iproorderid,
dbo.rdrecord.iarriveid, dbo.rdrecord.isalebillid,
convert(char,convert(money,dbo.rdrecord.ufts),2) as ufts
--,dbo.rdrecord.caccountpid,
--dbo.rdrecord.caccountpdate
from dbo.rdrecord left outer join
dbo.department on
dbo.rdrecord.cdepcode = dbo.department.cdepcode left outer join
dbo.gl_bdigest on dbo.rdrecord.cmemo = dbo.gl_bdigest.cid left outer join
dbo.person on
dbo.rdrecord.chandler = dbo.person.cpersoncode left outer join
dbo.person person1 on
dbo.rdrecord.cpersoncode = person1.cpersoncode left outer join
dbo.rd_style on
dbo.rdrecord.crdcode = dbo.rd_style.crdcode left outer join
dbo.warehouse on dbo.rdrecord.cwhcode = dbo.warehouse.cwhcode
where (dbo.rdrecord.cvouchtype = '10')
问题2、查询执行的帐套数据库可以发现RDRECORDS 多了csocode,表结构不应该有这个列;
方案2、ALTER TABLE RDRECORDS DROP COLUMN csocode
问题3、注释掉下面C:\U8SOFT\Admin\SQLFILE8710\Main\Ufdata\Structure\Data_STR_QM_mix_NL.sql
--去掉建在rdrecord的上的外键
--ALTER TABLE dbo.GSP_VOUCHUNSALABLE
--DROP CONSTRAINT FK_GSP_VOUCHUNSALABLE_RdRecord
二、帐套2升级
先通过T6升级工具导入再输出U8普及版,再引入到U852再升级到U852,最后引入到U872再升级到U872
解决方案:
通过ftp:/(外网) 下载U852的帐套数据 引入到U872 继续升级
已放到FTP下载数据目录,下载账号u8xiazai 密码 u8xiazai*2009
注意要点击IE浏览器工具栏的页面选择在windows 资源管理器中打开FTP |
马上注册,结交更多好友,享用更多功能,让你轻松玩转社区。
您需要 登录 才可以下载或查看,没有账号?注册账号
×
T6升级到U8总是提示错误。已经通过T6转U8工具转换过帐套,还是报错。 |
|