用友软件升级不了怎么办（用友升级160的必要性）

www.yyxxoo.com 站长在本文给朋友们带来的是用友软件升级不了怎么办，和用友升级160的必要性的相关内容，相信能够对各位使用财务软件的朋友带来帮助，具体内容可参考文章目录。

文章目录：

• 1、各位大师，请问下为什么用友T3软件2011年、12年、13年可以升级成功，14年却升级不成功
• 2、谁知道用友U8系列的版本是怎么升级的，要详细点的，谢谢！
• 3、各位大师，请问下为什么用友T3软件2011年和12年可以升级成功，13年和14年却升级不成功
• 4、用友软件升级问题

各位大师，请问下为什么用友T3软件2011年、12年、13年可以升级成功，14年却升级不成功

在升级过程中，系统没有找到对应的cZQCode字段所以报错；建议你下载对应版本的补丁打一下，执行一下脚本再升级。如果还是不行，建议将软件版本降级之后再升级降级工具下载地址:（此工具在软件服务器上使用，请谨慎使用）；如果，这些方法都不行，那你就要找总部问题一下了。重要注明:所有操作之前一定备份好数据；降级工具图片

微信号：yyrjlls
扫码 有偿解决 用友软件技术问题!
复制微信号

谁知道用友U8系列的版本是怎么升级的，要详细点的，谢谢！

在安装盘中有个升级服务程序，服务端和客户端都安装；

服务端链接网络，会自动下载更新包；

客户端安装升级程序后，也会自动更新；

建议没有问题就不要乱升级；

U8的软件不敢恭维！！一升级就出现其他的问题；恶心的要死了

各位大师，请问下为什么用友T3软件2011年和12年可以升级成功，13年和14年却升级不成功

用msde管理工具执行以下脚本，具体方法:

运行msde管理工具，确定登录（如果有sql密码，要输入密码登录）

然后点脚本-执行，数据库选择出错的数据库，比如的你的2013出错，就选择UFDATA_（帐套号）_2013，然后在语句区中把下面的脚本文字复制进去，点执行，然后再升级，同样2014年也这么执行一下，管理工具在最下面附加里，自己下载下

alter table MatchVouch add bReqAnalyse bit,dIssueDate varchar(16)

GO

/****** 对象:  StoredProcedure [dbo].[ST_CalBegInvAge]    脚本日期: 08/15/2014 13:12:13 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

--计算上年结存库龄

CREATE PROCEDURE [dbo].[ST_CalBegInvAge]

@cDBName Varchar(20),    --上一个账套名称

@CurrentDate Datetime,    --计算日期

@cCurDBName  varchar(20)    --当前账套名称

As

Declare @strLeftQty nVarchar(4000)

Declare @StockStartDate datetime

declare @cWhCode nvarchar(50)

declare @cInvCode nvarchar(50)

declare @cBatch nvarchar(50)

declare @cFree1 nvarchar(120)

declare @cFree2 nvarchar(120)

declare @iQtty float

declare @iNum float

declare @autoId int

declare @iVouchQtty float

declare @iVouchNum float

declare @iTempQtty float

declare @iTempNum float

declare @strSQLInvAge nVarchar(4000)

declare @strInvAge nVarchar(4000)

declare @strSQLIn  nVarchar(4000)

declare @strSQLOut nVarchar(4000)

declare @strNewRecord nVarchar(4000)

declare @strSql nVarchar(200)

declare @sSQL  nVarchar(200)

declare @sBegdate As nVarchar(200)

declare @iCou int

--取库存启用日期

Set @sBegdate = N'select @StockStartDate = cast(cValue as Datetime)  from ' + @cDBName + '..accinformation ' + ' Where cSysid=''ST'' and cName= ''dSTStartDate'' '

exec sp_executesql @sBegdate,N'@StockStartDate datetime output', @StockStartDate output

If @StockStartDate is Null

Begin

Return

End

--计算本期当前结存

Set @strNewRecord = N'Insert Into ' +@cDBName+'..STStockAgeTempTable(autoid, iqtty, inum)

values(@autoid, @iTempQtty, @iTempNum) '

set @strLeftQty =

' SELECT cWhCode,

cInvCode,

IsNull(cBatch,'''') As cBatch,

IsNull(cFree1,'''') As cFree1,

IsNull(cFree2,'''') As cFree2,

SUM(case when bRdFlag = 1 then iQuantity else -iQuantity end) as iQtty,

SUM(case when bRdFlag = 1 then iNum else - iNum end) AS iNum

 From(  Select bRdFlag, cWhCode, cInvCode, iQuantity, INum, cBatch, cFree1, cFree2

From '+ @cDBName+'..ST_BegInvAge

Union ALL

Select R.bRdFlag, R.cWhCode, Rs.cInvCode, Rs.iQuantity, Rs.INum, Rs.cBatch, Rs.cFree1, Rs.cFree2

From ' + @cDBName+ '..RdRecord R inner join '+@cDBName+'..RdRecords Rs on R.id = Rs.id

Where R.dDate = @StartDate And R.dDate = @CurrentDate And cVouchType ''33'' And cVouchType ''34''

) X

group by cWhCode, cInvCode, IsNull(cBatch,''''),IsNull(cFree1,''''), IsNull(cFree2,'''') '

--取入库语句

Set @strSQLIn = ' Select AutoId, iQtty, iNum

 From (Select dDate, AutoId, abs(iQuantity) As iQtty, abs(iNum) As iNum

From '+@cDBName+'..ST_BegInvAge

Where cWhCode = @cWhCode and cInvCode = @cInvCode and isnull(cBatch,'''') = @cBatch

and isnull(cFree1,'''') = @cFree1 and isnull(cFree2,'''') = @cFree2

Union ALL

Select d.dDate,ds.autoid, Abs(ds.iQuantity) as iQtty, Abs(ds.iNum) as iNum

from '+@cDBName+'..RdRecord d join ' + @cDBName + '..RdRecords ds on (d.id = ds.id)

where ( (d.bRdFlag = 1 and ds.iQuantity 0) or (d.bRdFlag 1 and ds.iQuantity 0))

And d.dDate = @StartDate and d.dDate = @CurrentDate and d.cWhCode = @cWhCode

and ds.cInvCode = @cInvCode and IsNull(ds.cBatch,'''') = @cBatch and IsNull(ds.cFree1,'''') = @cFree1

and IsNull(ds.cFree2,'''') = @cFree2) X

order by dDate Desc,AutoID Desc for read only '

Set @strSQLIn = N' declare curInvIn insensitive cursor for ' + @strSQLIn

set @strLeftQty = N'declare curRd cursor for ' + @strLeftQty

execute sp_executesql @strLeftQty,

N'@CurrentDate Datetime, @StartDate Datetime',

@CurrentDate, @StockStartDate

open curRd

fetch next from curRd into

@cWhCode,@cInvCode,@cBatch,

@cFree1,@cFree2,@iQtty, @iNum

--建立计算结果临时表

Set @sSQL = N'select @Num = count(1) from ' + @cDBName + '..sysobjects ' + ' Where name = ''STStockAgeTempTable'' '

exec sp_executesql @sSQL,N'@Num int output', @iCou output

If @iCou 0

Begin

Exec (' Drop Table ' + @cDBName+'..STStockAgeTempTable')

End

Exec (' Create Table '+@cDBName+'..STStockAgeTempTable (autoId int , iQtty float,  iNum float)')

--sp_help ST_BegInvAge

while @@fetch_status = 0

begin

if(@iQtty 0 ) set @iQtty = 0

if(@iNum 0 or @iNum is null) set @iNum = 0

Set @iTempQtty = 0.0

Set @iTempNum = 0.0

--按降序取入库

execute sp_executesql @strSQLIn,

N'@CurrentDate Datetime, @StartDate Datetime, @cWhCode varchar(50),

@cInvCode varchar(20), @cBatch varchar(50),

@cFree1 varchar(120), @cFree2 varchar(120)',

@CurrentDate, @StockStartDate, @cWhCode, @cInvCode, @cBatch, @cFree1, @cFree2

open curInvIn

fetch next from curInvIn into @autoId, @iVouchQtty, @iVouchNum

while (round(@iQtty,6) 0 or round(@iNum,6) 0) and @@fetch_status =0

begin

if Round(@iQtty, 6) Round(@iVouchQtty, 6)

begin

set @iTempQtty = @iVouchQtty

set @iQtty = Round(@iQtty, 6) - Round(@iVouchQtty, 6)

end

else begin

set @iTempQtty = @iQtty

set @iQtty = 0.0

end

if Round(@iNum, 6) Round(@iVouchNum,6)

begin

set @iTempNum = @iVouchNum

set @iNum = Round(@iNum, 6) - Round(@iVouchNum, 6)

end

else begin

set @iTempNum = @iNum

set @iNum = 0.0

end

--增加计算结果

execute sp_executesql @strNewRecord,

N'@autoid int, @iTempQtty float, @iTempNum float',

@autoid, @iTempQtty, @iTempNum

Set @iTempQtty = 0.0

Set @iTempNum = 0.0

fetch next from curInvIn into @autoid, @iVouchQtty, @iVouchNum

end

close curInvIn

deallocate curInvIn

fetch next from curRd into

@cWhCode,@cInvCode,@cBatch,@cFree1,@cFree2,@iQtty, @iNum

end

close curRd

deallocate curRd

--将结果数据输出

set @strSQLInvAge =N'

Select  [ID], [bRdFlag],[cVouchType],[cWhCode] ,[dDate] ,

[cCode],[cRdCode],[cDepCode] ,[cPersonCode] ,[cVenCode] ,

[cHandler] ,[cMemo] ,[cMaker] ,[cDefine1] ,[cDefine2] ,

[cDefine3]  ,[cDefine4] ,[cDefine5] ,[cDefine6] ,[cDefine7]  ,

[cDefine8] ,[cDefine9] ,[cDefine10] , RT.[AutoID] ,[cInvCode],

(case when x.bRdFlag = 0 then -1 * RT.[iNum] else RT.[iNum] end)  As iNum,

(case when x.bRdFlag = 0 then -1 * RT.[iQtty] else RT.[iQtty] end) As iQuantity ,

[iUnitCost] ,[iPrice]  ,[cBatch],[cFree1] ,

[cFree2] ,[dVDate] ,[cDefine22] ,[cDefine23] ,[cDefine24] ,

[cDefine25] ,[cDefine26] ,[cDefine27] ,[cItem_class]  , [cItemCode]  ,

[cName] ,[cItemCName]

Into '+ @cCurDBName+'..ST_BegInvAge

From '+@cDBName+'..STStockAgeTempTable RT Inner Join (

Select  [ID], [bRdFlag],[cVouchType],[cWhCode] ,[dDate] ,

[cCode],[cRdCode],[cDepCode] ,[cPersonCode] ,[cVenCode] ,

[cHandler] ,[cMemo] ,[cMaker] ,[cDefine1] ,[cDefine2] ,

[cDefine3]  ,[cDefine4] ,[cDefine5] ,[cDefine6] ,[cDefine7]  ,

[cDefine8] ,[cDefine9] ,[cDefine10] ,[AutoID] ,[cInvCode],

[iNum] ,[iQuantity] ,[iUnitCost] ,[iPrice]  ,[cBatch],[cFree1] ,

[cFree2] ,[dVDate] ,[cDefine22] ,[cDefine23] ,[cDefine24] ,

[cDefine25] ,[cDefine26] ,[cDefine27] ,[cItem_class]  , [cItemCode]  ,

[cName] ,[cItemCName]

From '+@cDBName+'..ST_BegInvAge

Union All

Select  R.[ID], [bRdFlag],[cVouchType],[cWhCode] ,[dDate] ,

[cCode],[cRdCode],[cDepCode] ,[cPersonCode] ,[cVenCode] ,

[cHandler] ,[cMemo] ,[cMaker] ,[cDefine1] ,[cDefine2] ,

[cDefine3]  ,[cDefine4] ,[cDefine5] ,[cDefine6] ,[cDefine7]  ,

[cDefine8] ,[cDefine9] ,[cDefine10] ,[AutoID] ,[cInvCode],

[iNum] ,[iQuantity] ,[iUnitCost] ,[iPrice]  ,[cBatch],[cFree1] ,

[cFree2] ,[dVDate] ,[cDefine22] ,[cDefine23] ,[cDefine24] ,

[cDefine25] ,[cDefine26] ,[cDefine27] ,[cItem_class]  , [cItemCode]  ,

[cName] ,[cItemCName]

From '+@cDBName+'..RdRecords Rs inner join '+@cDBName+'..RdRecord R On (R.ID = Rs.ID)

Where dDate = @StartDate And dDate = @CurrentDate And cVouchType ''33'' And cVouchType ''34''

) X On RT.autoId = X.autoId  

'

execute sp_executesql @strSQLInvAge,

N'@CurrentDate Datetime, @StartDate Datetime',

@CurrentDate,

@StockStartDate

用友软件升级问题

先升级到U861在升级U871阶段性升级必须要过渡，就合8.1需要8.21过度一样

普及版可以升到861

861也可以升到U871

用友软件升级不了怎么办的介绍就聊到这里吧，感谢你花时间阅读本篇文章，更多关于用友升级160的必要性、用友软件升级不了怎么办的内容可本站进行搜索或者添加客服微信。

Tags：用友软件升级不了怎么办，