Question

用友ERP年结出现 错误信息： INSERT 语句与 COLUMN FOREIGN KEY 约束 'FK_PP_POMain_Inventory' 冲突。

年度：2015
程序名： UFPPJZ: Begin
模块：生产管理：生产订单
最后语句：Insert Into PP_POMain ( MainId, ID, cInvCode, dStartDate, dEndDate, cMemo, fQuantity,iDataFrom, cFree1, fInQuantity, cFree2, cFree3, cFree4, cFree5, cFree6, cFree7, cFree8, cFree9, cFree10, bUsed,cClose,bCheck,fTotalCheck,cBOMSoCode, bPutFromSo,cSOsIDs,cDefine22,cDefine23,cDefine24,cDefine25,cDefine26,cDefine27,cDefine28,cDefine29,cDefine30,cDefine31,cDefine32,cDefine33,cDefine34,cDefine35,cDefine36,cDefine37,iBLevel,bExpandEndB,iFromType,fincheckquantity,fhgquantity,fbhgquantity,fhgnum,fbhgnum,fybjsquantity,fybjsnum,fybjsinquan,fybjsinnum,fhginquan,fhginnum,irejid,fthquantity,fthnum,fthinquan,fthinnum,fbfquantity,fbfnum,irdautoid,iBlevelBak,bExpandendBak,fQuantityed ,bPutFromYC, iYCsIDs, fNumed, cItem_class, cItemCode, cItemName, cunitid, fNum, fInNum, finchecknum, cBatch, bNeedReCalComps, iRelationID,fMinFitPInv) select MainId, ID, cInvCode, dStartDate, dEndDate, cMemo, fQuantity,iDataFrom, cFree1, fInQuantity, cFree2, cFree3, cFree4, cFree5, cFree6, cFree7, cFree8, cFree9, cFree10, bUsed,cClose,bCheck,fTotalCheck,cBOMSoCode, bPutFromSo,cSOsIDs,cDefine22,cDefine23,cDefine24,cDefine25,cDefine26,cDefine27,cDefine28,cDefine29,cDefine30,cDefine31,cDefine32,cDefine33,cDefine34,cDefine35,cDefine36,cDefine37,iBLevel,bExpandEndB,iFromType,fincheckquantity,fhgquantity,fbhgquantity,fhgnum,fbhgnum,fybjsquantity,fybjsnum,fybjsinquan,fybjsinnum,fhginquan,fhginnum,irejid,fthquantity,fthnum,fthinquan,fthinnum,fbfquantity,fbfnum,irdautoid,iBlevelBak,bExpandendBak,fQuantityed ,bPutFromYC, iYCsIDs, fNumed, cItem_class, cItemCode, cItemName, cunitid, fNum, fInNum, finchecknum, cBatch, bNeedReCalComps, iRelationID ,fMinFitPInv from UFDATA_888_2014..PP_POMain where id=42367
错误信息： INSERT 语句与 COLUMN FOREIGN KEY 约束 'FK_PP_POMain_Inventory' 冲突。该冲突发生于数据库 'UFDATA_888_2015'，表 'Inventory', column 'cInvCode'

Answer 1

要插入的存货编码数据在存货档案中不存在

追问

那要怎么弄啊

追答

在存货档案中直接添加不存在的存货档案！

追问

问题是不知道那个存货档案不存在啊

追答

select * from UFDATA_888_2014..PP_POMain where id=42367

看看这个ID对应的存货数据