用友t3升级报错列名cmemo无效和对象名dbost calbeginvage无效

1、用友t3升级报错列名cmemo无效和对象名dbost_calbeginvage 无效用友T3恢复升级步骤1、账套恢复 恢复账套之前，请确认账套号和账套路径是否按要求更改比如：账套号为005,恢复路径为：E:UFSMARTAdmin2、升级账套选择需要升级的账套及年度，并确认密 口住隹皿1 yi .M味駅邛- 沖凸 kv 烹甘站却ir-ftHnfh科制nJFS陨虧:Ilf -II： ?6 13：?i：r1柠制令JPSE/iVER“if d1諌叭/冉20LS-W 鏡 - 1.-.?5CA ierwrt啊韵说,., 世価面1诵曹RH鮭曲解巨!“时巳鮎刊：難斟I* “ ) declare strlnv

2、Age nVarchar(4000) declare strSQLln nVarchar(4000) declare strSQLOut nVarchar(4000) declare strNewRecord nVarchaT(4000)declare strSql nVarchar(200)declare sSQL nVarchar(200) declare sBegdate As nVarchar(2CX)declare iCou int请在数据库2008中执行文件：对象名dbo.ST_CalBeglnvAge无效.sql步骤如下1在开始程序的打开SQL2008如图点连接进入选文件/打开/

3、文件,路径用友相关点执行就行了附: 数据库语句- 账套 005年度为 2014 升级时，软件报错对象名 dbo.ST_CalBegInvAge 无效 - 请执行以下语句use ufdata_005_2014alter table MatchVouch add bReqAnalyse bit,dIssueDate varchar(16)GO/* 对象 : StoredProcedure dbo.ST_CalBegInvAge脚本日期 :08/15/2014 13:12:13 */SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO- 计算上年结存库龄CREA

4、TE PROCEDURE dbo.ST_CalBegInvAgecDBName Varchar(20), - 上一个账套名称CurrentDate Datetime, - 计算日期cCurDBName varchar(20) - 当前账套名称AsDeclare strLeftQty nVarchar(4000)Declare StockStartDate datetimedeclare cWhCode nvarchar(50)declare cInvCode nvarchar(50)declare cBatch nvarchar(50)declare cFree1 nvarchar(120)d

5、eclare cFree2 nvarchar(120)declare iQtty floatdeclare iNum floatdeclare autoId intdeclare iVouchQtty floatdeclare iVouchNum floatdeclare iTempQtty floatdeclare iTempNum floatdeclare strSQLInvAge nVarchar(4000)declare strInvAge nVarchar(4000)declare strSQLIn nVarchar(4000)declare strSQLOut nVarchar(4

6、000)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= dSTStartDateexec sp_exe

7、cutesql sBegdate,NStockStartDate datetime output, StockStartDateoutputIf StockStartDate is NullBeginReturnEnd- 计算本期当前结存Set strNewRecord = NInsert Into +cDBName+.STStockAgeTempTable(autoid, iqtty,inum)values(autoid, iTempQtty, iTempNum) set strLeftQty = SELECT cWhCode,cInvCode,IsNull(cBatch,) As cBat

8、ch,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 iNumFrom( Select bRdFlag, cWhCode, cInvCode, iQuantity, INum, cBatch, cFree1, cFree2From + cDBName+.ST_BegInvAgeUnion

9、ALLSelect R.bRdFlag, R.cWhCode, Rs.cInvCode, Rs.iQuantity, Rs.INum, Rs.cBatch, Rs.cFree1,Rs.cFree2From + cDBName+ .RdRecord R inner join +cDBName+.RdRecords Rs on R.id = Rs.idWhere R.dDate = StartDate And R.dDate = CurrentDate And cVouchType 33 And cVouchType 34) Xgroup by cWhCode, cInvCode, IsNull(

10、cBatch,),IsNull(cFree1,), IsNull(cFree2,) - 取入库语句Set strSQLIn = Select AutoId, iQtty, iNumFrom (Select dDate, AutoId, abs(iQuantity) As iQtty, abs(iNum) As iNumFrom +cDBName+.ST_BegInvAgeWhere cWhCode = cWhCode and cInvCode = cInvCode and isnull(cBatch,) = cBatchand isnull(cFree1,) = cFree1 and isnu

11、ll(cFree2,) = cFree2Union ALLSelect d.dDate,ds.autoid, Abs(ds.iQuantity) as iQtty, Abs(ds.iNum) as iNumfrom +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 = StartDate and d.dDate = CurrentDate and d.cWh

12、Code = cWhCodeand ds.cInvCode = cInvCode and IsNull(ds.cBatch,) = cBatch and IsNull(ds.cFree1,) = cFree1and IsNull(ds.cFree2,) = cFree2) Xorder by dDate Desc,AutoID Desc for read only Set strSQLIn = N declare curInvIn insensitive cursor for + strSQLInset strLeftQty = Ndeclare curRd cursor for + strL

13、eftQty execute sp_executesql strLeftQty,NCurrentDate Datetime, StartDate Datetime, CurrentDate, StockStartDateopen curRdfetch next from curRd intocWhCode,cInvCode,cBatch, cFree1,cFree2,iQtty, iNum- 建立计算结果临时表Set sSQL = Nselect Num = count(1) from + cDBName +.sysobjects + Wherename = STStockAgeTempTab

14、le exec sp_executesql sSQL,NNum int output, iCou outputIf iCou 0BeginExec ( Drop Table + cDBName+.STStockAgeTempTable)EndExec ( Create Table +cDBName+.STStockAgeTempTable (autoId int ,iQtty float,iNum float)-sp_help ST_BegInvAgewhile fetch_status = 0beginif(iQtty 0 ) set iQtty = 0if(iNum 0 or round(

15、iNum,6) 0) and fetch_status =0beginif Round(iQtty, 6) Round(iVouchQtty, 6)beginset iTempQtty = iVouchQttyset iQtty = Round(iQtty, 6) - Round(iVouchQtty, 6) endelse beginset iTempQtty = iQttyset iQtty = 0.0 endif Round(iNum, 6) Round(iVouchNum,6)beginset iTempNum = iVouchNumset iNum = Round(iNum, 6)

16、- Round(iVouchNum, 6) endelse beginset iTempNum = iNumset iNum = 0.0 end- 增加计算结果execute sp_executesql strNewRecord,Nautoid int, iTempQtty float, iTempNum float, autoid, iTempQtty, iTempNumSet iTempQtty = 0.0Set iTempNum = 0.0fetch next from curInvIn into autoid, iVouchQtty, iVouchNum endclose curInv

17、Indeallocate curInvInfetch next from curRd into cWhCode,cInvCode,cBatch,cFree1,cFree2,iQtty, iNum endclose curRddeallocate curRd- 将结果数据输出set strSQLInvAge =NSelect ID, bRdFlag,cVouchType,cWhCode ,dDate , cCode,cRdCode,cDepCode ,cPersonCode ,cVenCode ,cHandler ,cMemo ,cMaker ,cDefine1 ,cDefine2 ,cDefi

18、ne3 ,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 ,cDefine2

19、2 ,cDefine23 ,cDefine24 ,cDefine25 ,cDefine26 ,cDefine27 ,cItem_class , cItemCode ,cName ,cItemCNameInto + cCurDBName+.ST_BegInvAgeFrom +cDBName+.STStockAgeTempTable RT Inner Join ( Select ID, bRdFlag,cVouchType,cWhCode ,dDate , cCode,cRdCode,cDepCode ,cPersonCode ,cVenCode , cHandler ,cMemo ,cMaker

20、 ,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 ,cItemCNam

21、eFrom +cDBName+.ST_BegInvAgeUnion AllSelect 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 ,