金蝶K/3 WISE15.1迁移 金蝶KIS旗舰版7.01 迁移失败提示列名 ‘FPlanArea’ 无效。–升级仓库数据(包含自定义)

金蝶K/3 WISE15.1迁移 金蝶KIS旗舰版7.01 列名 ‘FPlanArea’ 无效。–升级仓库数据(包含自定义)

解决方案：

1、先备份好账套文件

2、下载修复语句，到数据库中对K3账套执行，再迁移

修复语句知识付费：

经过上面执行修复好，该报错就不提示了

具体报错日志：

列名 ‘FPlanArea’ 无效。–升级仓库数据(包含自定义)
declare @colName varchar(80)
declare @dataType varchar(80)
declare @dataLength int
declare @ExecSQL varchar(8000)
declare @colsVale varchar(2000)
set @ExecSQL = ”
set @colName = ”
set @colsVale = ”
declare @Item_col_cursor cursor
Set @Item_col_cursor = cursor for
select column_name,data_type,isnull(CHARACTER_MAXIMUM_LENGTH,0) from information_schema.columns
where table_name = ‘K3_t_Stock’ and COLUMN_NAME like ‘F\_%’ escape ‘\’
open @Item_col_cursor
fetch @Item_col_cursor into @colName,@dataType,@dataLength
while @@fetch_status=0
Begin
if @dataType = ‘varchar’ or @dataType = ‘nvarchar’
begin
set @ExecSQL =@ExecSQL + ‘ Alter Table t_Stock Add ‘ + @colName + ‘ ‘ + @dataType + ‘(‘ + convert(varchar(10),@dataLength) + ‘) null’
set @colsVale = @colsVale + ‘,’ + @colName
end
else if @dataType = ‘decimal’
begin
set @ExecSQL =@ExecSQL + ‘ Alter Table t_Stock Add ‘ + @colName + ‘ decimal(23,10) null’
set @colsVale = @colsVale + ‘,’ + @colName
end
else
begin
set @ExecSQL =@ExecSQL + ‘ Alter Table t_Stock Add ‘ + @colName + ‘ ‘ + @dataType + ‘ null’
set @colsVale = @colsVale + ‘,’ + @colName
end
fetch next from @Item_col_cursor into @colName,@dataType,@dataLength
End
IF @ExecSQL<>” exec (@ExecSQL)
close @Item_col_cursor
deallocate @Item_col_cursor
set @ExecSQL = ”
set @ExecSQL = ‘
Insert into t_Stock(
FItemID,
FBrNO,
FHelperCode,
FEmpID,
FAddress,
FPhone,
FProperty,
FBWorkShop,
FName,
FNumber,
FParentID,
FDeleted,
FShortNumber,
FTypeID,
FIsStockMgr,
FSPGroupID,
FMRPAvail,
FGroupID,
FStockGroupID,
–FModifyTime,
FCalcCostOrder,
FPlanArea,
FUnderStock’ + @colName + ‘
)
Select
FItemID,
FBrNO,
FHelperCode,
FEmpID,
FAddress,
FPhone,
FProperty,
FBWorkShop,
FName,
FNumber,
FParentID,
FDeleted,
FShortNumber,
FTypeID,
FIsStockMgr,
FSPGroupID,
FMRPAvail,
FGroupID,
FStockGroupID,
–FModifyTime,
FCalcCostOrder,
FPlanArea,
FUnderStock’ + @colsVale + ‘
From K3_t_Stock’
exec (@ExecSQL)