用友T310.8P1升级账套报错iTaxUnitPrice解决方法

kljhg1 · 发表于 2014-1-20 22:44:10

马上注册，结交更多好友，享用更多功能，让你轻松玩转社区。

您需要登录才可以下载或查看，没有账号？注册账号

×

本帖最后由 kljhg1 于 2014-1-20 22:48 编辑

在升级账套某一年度时报错，ZPURRKDLIST这个表在视图里面，列名也在这个表里，
反正就是它没错，但是就是升级报失败，
用友数据库对比了一下数据库：
"","对象名","状态","名称"
"1","视图","缺","ST_WareHouseWarnInfoView"
"2","视图","缺","PurBillNoVerify"
"3","视图","缺","SA_KHQJDZD_Detail"
"4","视图","缺","PUR_ORDER_EX"
"5","视图","缺","MC_SendMsgView"
"6","视图","缺","AP_Cancel1ZJYCB"
"7","视图","缺","AR_Cancel1ZJYCB"
"8","视图","缺","MC_SendMsg_HistoryView"
"9","视图","缺","MC_SendMsg_DHistoryView"
"10","视图","缺","MC_SendMsg_HHistoryView"
"11","视图","缺","MatchVouchPLRK"
"12","视图","缺","MP_SOToMatchVoucher"
"13","视图","缺","CostDistributeInSQ"
"14","视图","缺","CostDistributeInList"
"15","视图","缺","CostDistributeInQ"
"16","视图","缺","Ap_DetailCust_V"
"17","视图","缺","Ap_SalBillCust_V"
"18","视图","缺","AR_ApVouch_V"
"19","视图","缺","Ap_CloseCust_V"
"20","视图","缺","V_OutNotBalance"
"21","视图","缺","AP_DetailZQ"
"22","视图","缺","Sa_BillAgeViewZQ"
"23","视图","缺","CJZF_Ap_Receive"
"24","视图","缺","Ap_DetailCust_ZQ"
"25","视图","缺","CJZF_Ap_Payment"
"26","视图","缺","Ap_DetailVend_ZQ"
"27","视图","缺","Ap_ViewNoVerifySBV_ZQ"
"28","视图","缺","RetBatch"
"29","视图","缺","PurRdrecordV"

以上只是单独 “视图”里面少的，反正很多啊，整个数据库少的更多，参考一下吧

解决方法：
1：USE UFDATA_001_2012
update accinformation set cvalue='8.216' where csysid='AA' and cid='99'
升级SQL数据吧，个人运气比较好，没报错直接就跳成功了！
QQ图片20140120224031.jpg

2：打开账套后发现报错：
复制MC梦先生！
此方法留为自己备用，

zh3305 · 发表于 2014-1-20 22:56:11

没太明白怎么成功的..是因为以前补丁没打全的原因吗?

kljhg1 · 发表于 2014-1-20 22:59:24

zh3305 发表于 2014-1-20 22:56
没太明白怎么成功的..是因为以前补丁没打全的原因吗?

降低版本号，达到升级SQL成功，

zh3305 · 发表于 2014-1-20 23:00:28

kljhg1 发表于 2014-1-20 22:59
降低版本号，达到升级SQL成功，

这样也可以哦, 又学到一招了

37724861 · 发表于 2014-1-21 09:21:57

降低版本号，从低版本开始执行脚本而已

胖砸哦 · 发表于 2023-7-22 15:30:47

非常感谢您的分享，很有用哦

janyqi · 发表于 2023-8-4 11:54:06

非常感谢您的分享，很有用哦

janyzjq · 发表于 2023-8-4 14:34:56

非常感谢您的分享，很有用哦

janyzjq · 发表于 2023-8-7 08:34:10

感谢分享

janyzjq · 发表于 2023-8-8 08:15:56

感谢分享

janyqi · 发表于 2023-8-8 08:16:03

感谢分享

账号		自动登录	找回密码
密码			注册账号

初学者课程：T3自学\|T6自学\|U8自学	软件下载｜课件下载｜工具下载	资料：通资料\|U8资料\|NC\|培训\|年结	积分规则 \| 使用常见问题Q&A
知识库:U8 \| 通 \| NC \| U9 \| OA \| 政务	U8\|U9\|NCC\|NC65\|NC65客开\|NCC客开	新手必读 \| 任务 \| 快速增金币	用友QQ群[微信群]

[经验] 用友T310.8P1升级账套报错iTaxUnitPrice解决方法

马上注册，结交更多好友，享用更多功能，让你轻松玩转社区。

相关帖子

点评

点评