8.11升级8.52的问题!
2016-5-28 0:0:0 wondial8.11升级8.52的问题!
8.11升级8.52的问题!问题号: | 4110 |
---|---|
解决状态: | 最终解决方案 |
软件版本: | 8.52 |
软件模块: | 系统管理 |
行业: | 通用 |
关键字: | 建立帐套 |
适用产品: | U852—-总帐 |
问题名称: | 8.11升级8.52的问题! |
问题现象: | 8.11-8.12SQL很正常,8.12SQL在8.52中升级SQL数据的时候提示”帐套升级失败,错误号13类型不匹配”. |
问题原因: | JustInQ等视图不正确。 |
解决方案: | 请导入812sql版本下正确的视图。或者执行如下: DROP View JustInQ go –创建 View JustInQ Create View JustInQ AS SELECT JustInVouch.cJVCode, JustInVouch.cVouchType, JustInVouch.cWhCode, JustInVouch.dJVDate, JustInVouch.cUnitCode, JustInVouch.cDepCode, JustInVouch.cPersonCode, JustInVouch.cRdCode, JustInVouch.cJVMemo, JustInVouch.cJVDefine1, JustInVouch.cJVDefine2, JustInVouch.cJVDefine3, JustInVouch.cAccounter, JustInVouch.cMaker, Warehouse.cWhName, Vendor.cVenAbbName, Department.cDepName, Person.cPersonName, Rd_Style.cRdName, JustInVouch.bRdFlag, JustInVouch.cHandler, Person1.cPersonName AS cPersonName_1, JustInVouch.cDefine1, JustInVouch.cDefine2, JustInVouch.cDefine3, JustInVouch.cDefine4, JustInVouch.cDefine5, JustInVouch.cDefine6, JustInVouch.cDefine7, JustInVouch.cDefine8, JustInVouch.cDefine9, JustInVouch.cDefine10 FROM JustInVouch LEFT OUTER JOIN Department ON JustInVouch.cDepCode = Department.cDepCode LEFT OUTER JOIN GL_bdigest ON JustInVouch.cJVMemo = GL_bdigest.cid LEFT OUTER JOIN Person ON JustInVouch.cPersonCode = Person.cPersonCode LEFT OUTER JOIN Person Person1 ON JustInVouch.cHandler = Person1.cPersonCode LEFT OUTER JOIN Rd_Style ON JustInVouch.cRdCode = Rd_Style.cRdCode LEFT OUTER JOIN Vendor ON JustInVouch.cUnitCode = Vendor.cVenCode LEFT OUTER JOIN Warehouse ON JustInVouch.cWhCode = Warehouse.cWhCode WHERE (JustInVouch.cVouchType = ’20’) go –创建 view justinlist create view justinlist as SELECT JustInQ.cJVCode, JustInQ.cVouchType, JustInQ.cWhCode, JustInQ.dJVDate,JustInQ.cUnitCode, JustInQ.cDepCode, JustInQ.cPersonCode, JustInQ.cRdCode,JustInQ.cJVMemo, JustInQ.cJVDefine1, JustInQ.cJVDefine2, JustInQ.cJVDefine3, JustInQ.cAccounter, JustInQ.cMaker, JustInQ.cWhName, JustInQ.cVenAbbName,JustInQ.cDepName, JustInQ.cPersonName, JustInQ.cRdName, JustInQ.bRdFlag,JustInQ.cHandler, JustInQ.cPersonName_1, justinsq.cJVCode AS cJVCode_1,justinsq.cInvCode, justinsq.AutoID, justinsq.cInvName, justinsq.cInvStd, justinsq.cCorCode, justinsq.iJVPrice, justinsq.cFree1, justinsq.cFree2, justinsq.CorID,JustInQ.cDefine1, JustInQ.cDefine2, JustInQ.cDefine3, JustInQ.cDefine4,JustInQ.cDefine5, JustInQ.cDefine6, JustInQ.cDefine7, JustInQ.cDefine8,JustInQ.cDefine9, JustInQ.cDefine10 FROM JustInQ LEFT OUTER JOIN justinsq ON JustInQ.cJVCode = justinsq.cJVCode go drop view JustOutQ go –创建 view JustOutQ Create View JustOutQ AS SELECT JustInVouch.cJVCode, JustInVouch.cVouchType, JustInVouch.cWhCode, JustInVouch.dJVDate, JustInVouch.cUnitCode, JustInVouch.cDepCode, JustInVouch.cPersonCode, JustInVouch.cRdCode, JustInVouch.cJVMemo, JustInVouch.cJVDefine1, JustInVouch.cJVDefine2, JustInVouch.cJVDefine3, JustInVouch.cAccounter, JustInVouch.cMaker, Warehouse.cWhName, Department.cDepName, Person.cPersonName, Rd_Style.cRdName, JustInVouch.bRdFlag, JustInVouch.cHandler, Person1.cPersonName AS cPersonName_1, Customer.cCusAbbName, JustInVouch.cDefine1, JustInVouch.cDefine2, JustInVouch.cDefine3, JustInVouch.cDefine4, JustInVouch.cDefine5, JustInVouch.cDefine6, JustInVouch.cDefine7, JustInVouch.cDefine8, JustInVouch.cDefine9, JustInVouch.cDefine10 FROM JustInVouch LEFT OUTER JOIN Customer ON JustInVouch.cUnitCode = Customer.cCusCode LEFT OUTER JOIN Department ON JustInVouch.cDepCode = Department.cDepCode LEFT OUTER JOIN GL_bdigest ON JustInVouch.cJVMemo = GL_bdigest.cid LEFT OUTER JOIN Person ON JustInVouch.cPersonCode = Person.cPersonCode LEFT OUTER JOIN Person Person1 ON JustInVouch.cHandler = Person1.cPersonCode LEFT OUTER JOIN Rd_Style ON JustInVouch.cRdCode = Rd_Style.cRdCode LEFT OUTER JOIN Warehouse ON JustInVouch.cWhCode = Warehouse.cWhCode WHERE (JustInVouch.cVouchType = ’21’) go –创建view justoutlist create view justoutlist as SELECT JustOutQ.cJVCode, JustOutQ.cVouchType, JustOutQ.cWhCode, JustOutQ.dJVDate,JustOutQ.cUnitCode, JustOutQ.cDepCode, JustOutQ.cPersonCode, JustOutQ.cRdCode,JustOutQ.cJVMemo, JustOutQ.cJVDefine1, JustOutQ.cJVDefine2, JustOutQ.cJVDefine3,JustOutQ.cAccounter, JustOutQ.cMaker, JustOutQ.cWhName, JustOutQ.cDepName,JustOutQ.cPersonName, JustOutQ.cRdName, JustOutQ.bRdFlag, JustOutQ.cHandler,JustOutQ.cPersonName_1, JustOutQ.cCusAbbName,justoutsq.cJVCode AS cJVCode_1, justoutsq.cInvCode, justoutsq.AutoID,justoutsq.cInvName, justoutsq.cInvStd, justoutsq.iJVPrice, justoutsq.cFree1,justoutsq.cFree2, justoutsq.cObjCode, justoutsq.cName, JustOutQ.cDefine1,JustOutQ.cDefine2, JustOutQ.cDefine3, JustOutQ.cDefine4, JustOutQ.cDefine5,JustOutQ.cDefine6, JustOutQ.cDefine7, JustOutQ.cDefine8, JustOutQ.cDefine9,JustOutQ.cDefine10 FROM JustOutQ LEFT OUTER JOIN justoutsq ON JustOutQ.cJVCode = justoutsq.cJVCode go |
补丁编号: | |
录入日期: | 2016-03-16 15:23:45 |
最后更新时间: |
如果您的问题还没有解决,可以到 T+搜索>>上找一下
相关阅读
- “营改增”后支付境外商标使用费应代扣增值税2021-4-29 16:40:42
- 用友t6怎么反结账2020-4-26 23:26:22
- 暂存凭证做什么用?为什么不让保存?2019-4-23 8:0:0
- 在打印明细帐时(非套打)科目名称打不下时,2019-4-23 8:0:0
- 在打印明细帐时(非套打)科目名称打不下时,_02019-4-23 8:0:0
- 在采购入库单参照订单生成时候出错2019-4-23 8:0:0
- 域用户需要的权限2019-4-23 8:0:0
- 域网络环境下增加仓库、存货等档案提示错误2019-4-23 8:0:0
- 月末结账应付账款对账不平2019-4-23 8:0:0
- 月末结账时提示总账与明细账对账不平2019-4-23 8:0:0
最新信息
- 用友t3怎样取消审核
- 用友t6如何取消审核凭证
- 请问下,我建账选择的是小企业会计准则(2013年)行业性质,但是为什么在会计科目那里显示的都是小企业会计制度的会计科目?
- 前台收银程序T+pos启动后,提示数据库错误,编号11,绑定数据库错误。如何处理啊?
- 老师请问:怎么样才能把不能够按照默认供货商为单位来查询诸如销量、库存等等各类参数的问题反馈给开发团队??我们超市这单是和各个供货商对接库存和销售量都快疯了。这样一个带前端销售的软件怎么会这个基本的功能都没有……还需要做什么自定义项那么麻烦
- 请问t3标准版为什么从系统卸载不掉,请问怎么才能卸载掉?
- 为什么卸载的时候提示这个??
- T3卸载不了提示这个是什么意思?
- 请问这是怎么一回事,老是说登录不上服务器,防火墙都已经关闭了,提示下面这种
- 我用的是用友T3普及版 ,现在我点击注册登录时输入密码之后没有账套出来,我确定密码和用户名都是对的!还有点击系统管理的时候电脑没有反应,打不开系统管理!这个是什么原因呢?