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

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],

,