KIS迁移工具,升级专业版账套有虚仓时,升级不成功
金蝶云社区-dongzee
dongzee
0人赞赏了该文章 1228次浏览 未经作者许可,禁止转载编辑于2015年04月21日 00:48:00

专业版产品,用KIS迁移工具升级到RISE产品时,应用的仓库管理模块中,仓库有属性为虚仓的,升级过程中,

语句已终止。
违反了 PRIMARY KEY 约束 'PRKEY_ICSTJGBill'。不能在对象 'ICSTJGBill' 中插入重复键。--根据系统参数更新投料单已领数量,基本单位已领数量-end-
--领料单上仓库为虚仓,领料单生成受托加工领料单

insert into ICSTJGBill(
FBrNo,
FInterID,
FTranType,
FROB,
FDate,
FBillNo,
FStatus,
FDeptID,
FUse,
FSManagerID,
FFManagerID,
FCheckerID,
FBillerID,
FMultiCheckLevel1,
FMultiCheckLevel2,
FMultiCheckLevel3,
FMultiCheckLevel4,
FMultiCheckLevel5,
FMultiCheckLevel6,
FMultiCheckDate1,
FMultiCheckDate2,
FMultiCheckDate3,
FMultiCheckDate4,
FMultiCheckDate5,
FMultiCheckDate6,
FCurCheckLevel,
FUpStockWhenSave,
FBackFlushed,
FWBInterID,
FCancellation,
FCheckDate,
FSelTranType,
FChildren,
FRelateBrID,
FBrID)
select t1.FBrNo,
t1.FInterID,
t1.FTranType,
t1.FROB,
t1.FDate,
t1.FBillNo,
t1.FStatus,
t1.FDeptID,
t1.FUse,
t1.FSManagerID,
t1.FFManagerID,
t1.FCheckerID,
t1.FBillerID,
t1.FMultiCheckLevel1,
t1.FMultiCheckLevel2,
t1.FMultiCheckLevel3,
t1.FMultiCheckLevel4,
t1.FMultiCheckLevel5,
t1.FMultiCheckLevel6,
t1.FMultiCheckDate1,
t1.FMultiCheckDate2,
t1.FMultiCheckDate3,
t1.FMultiCheckDate4,
t1.FMultiCheckDate5,
t1.FMultiCheckDate6,
t1.FCurCheckLevel,
t1.FUpStockWhenSave,
t1.FBackFlushed,
t1.FWBInterID,
t1.FCancellation,
t1.FCheckDate,
t1.FSelTranType,
t1.FChildren,
ISNULL(t1.FRelateBrID,''),
ISNULL(t1.FBrID,'')
from KIS_ICStockBill t1 inner join KIS_ICStockBillEntry t2 on t1.FInterID=t2.FInterID
inner join KIS_t_Stock t3 on t2.FSCStockID=t3.FItemID and t3.FTypeID=502 and t1.FTranType=24