迷你版11.0升级15.0,往来单位报错升级失败
金蝶云社区-李亚欣
李亚欣
0人赞赏了该文章 1,150次浏览 未经作者许可,禁止转载编辑于2018年05月29日 09:41:27
迷你版11.0升级专业版15.0往来单位升级失败,提示:升级失败,原因: 用于插入T_Organization客户数据的SQL语句执行错误: INSERT INTO T_Organization(FShortNumber,FItemID,FNumber,FName,FAddress,FPostalCode,FFax,FPhone,FContact,FTaxNum,Fbank,Faccount,FStatus,FValueAddRate) SELECT T1.FShortNumber,T1.FItemID,T1.FNumber,T1.FName,T2.FAddress,T2.FZip,T2.FFax,T2.FPhone,T2.FContact,T2.FTax,T2.FBank,T2.FBank,1072,17 FROM T_Item T1,AIS_GLCust T2,AIS_GLObj T3 WHERE T1.FShortNumber = T3.FObjID AND T2.FObjID = T3.FObjID AND T1.FItemClassID = 1 AND T1.FDetail=1 AND T3.FClsID = 1 AND T1.FItemID NOT IN (SELECT FItemID FROM T_Organization)用于插入T_Supplier供应商数据的SQL语句执行错误: INSERT INTO T_Supplier(FShortNumber,FItemID,FNumber,FName,FAddress,FPostalCode,FFax,FPhone,FContact,FTaxNum,Fbank,Faccount,FStatus,FValueAddRate) SELECT T1.FShortNumber,T1.FItemID,T1.FNumber,T1.FName,T2.FAddress,T2.FZip,T2.FFax,T2.FPhone,T2.FContact,T2.FTax,T2.FBank,T2.FBank,1072,17 FROM T_Item T1,AIS_GLCust T2,AIS_GLObj T3 WHERE T1.FShortNumber = T3.FObjID AND T2.FObjID = T3.FObjID AND T1.FItemClassID = 8 AND T1.FDetail=1 AND T3.FClsID = 1 AND T1.FItemID NOT IN (SELECT FItemID FROM T_Supplier) 如图:

哪位能帮忙解决下这个问题,谢谢