用友T3升级报错列名cMemo无效和对象名dbo.ST_CalBegInvAge无效解读.doc

用友T3恢复升级步骤 账套恢复 恢复账套之前，请确认账套号和账套路径是否按要求更改 比如：账套号为005，恢复路径为：E:\UFSMART\Admin\ 升级账套 选择需要升级的账套及年度，并确认 A如果出现以下情况: 对象名dbo.ST_CalBegInvAge无效 请在数据库2008中执行文件：对象名dbo.ST_CalBegInvAge无效.sql步骤如下 1在开始程序的打开SQL2008,如图 点连接进入 选文件/打开/文件,路径: 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 = Nselect @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 = NInsert Into +@cDBName+..STStockAgeTempTable(autoid, iqtty, inum) values(@autoid, @iTempQtty, @iTempNum) set @strLeftQty = SELECT cWhCode, cInvCode, IsNull(cBatch,