用友T3升级报错列名cMemo无效和对象名dbo.ST - CalBegInvAge无效

选文件/打开/文件,路径: D:\\用友相关

点执行就行了 附:数据库语句

--账套005年度为2014升级时，软件报错对象名dbo.ST_CalBegInvAge无效 --请执行以下语句 use ufdata_005_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