|
马上注册,结交更多好友,享用更多功能,让你轻松玩转社区。
您需要 登录 才可以下载或查看,没有账号?注册账号
×
结转失败:失败所在函数:usgxljz.pujz.TurnToNextYear()
该函数功能:采购结转主函数
最后执行的SQL语句: INSERT INTO PU_AppVouchs ([id],[autoid],[cvencode],[cinvcode],[fquantity],[funitprice],[ipertaxrate],[ftaxprice],[fmoney],[drequirdate],[darrivedate],[ireceivedqty],[cfree1],[cfree2],[cfree3],[cfree4],[cfree5],[cfree6],[cfree7],[cfree8],[cfree9],[cfree10],[cdefine22],[cdefine23],[cdefine24],[cdefine25],[cdefine26],[cdefine27],[cdefine28],[cdefine29],[cdefine30],[cdefine31],[cdefine32],[cdefine33],[cdefine34],[cdefine35],[cdefine36],[cdefine37],[citem_class],[citemcode],[citemname],[btaxcost],[ippartid],[ipquantity],[iptoseq],[csource],[sodid],[sotype],[imrpsid],[iropsid],[cbcloser],[fnum],[cunitid],[ireceivednum],[cpersoncodeexec],[cdepcodeexec],[iinvmpcost]) SELECT UFDATA_999_2010..PU_AppVouchs.[id],[autoid],[cvencode],[cinvcode],[fquantity],[funitprice],[ipertaxrate],[ftaxprice],[fmoney],[drequirdate],[darrivedate],[ireceivedqty],[cfree1],[cfree2],[cfree3],[cfree4],[cfree5],[cfree6],[cfree7],[cfree8],[cfree9],[cfree10],[cdefine22],[cdefine23],[cdefine24],[cdefine25],[cdefine26],[cdefine27],[cdefine28],[cdefine29],[cdefine30],[cdefine31],[cdefine32],[cdefine33],[cdefine34],[cdefine35],[cdefine36],[cdefine37],[citem_class],[citemcode],[citemname],[btaxcost],[ippartid],[ipquantity],[iptoseq],[csource],[sodid],[sotype],[imrpsid],[iropsid],[cbcloser],[fnum],[cunitid],[ireceivednum],[cpersoncodeexec],[cdepcodeexec],[iinvmpcost] FROM UFDATA_999_2010..PU_AppVouchs inner JOIN UFDATA_999_2010..PU_AppVouch ON UFDATA_999_2010..PU_AppVouchs.ID=UFDATA_999_2010..PU_AppVouch.ID WHERE UFDATA_999_2010..PU_AppVouch.cCloser is null or ddate>=N'2011-01-01' order by UFDATA_999_2010..PU_AppVouch.ID
失败原因:INSERT 语句与 COLUMN FOREIGN KEY 约束 'PuAppVouchs_Inventory' 冲突。该冲突发生于数据库 'UFDATA_999_2011',表 'Inventory', column 'cInvCode'。
失败所在函数:usgxljz.pujz.TurnToNextYear()
该函数功能:采购结转主函数
最后执行的SQL语句: INSERT INTO PU_AppVouchs ([id],[autoid],[cvencode],[cinvcode],[fquantity],[funitprice],[ipertaxrate],[ftaxprice],[fmoney],[drequirdate],[darrivedate],[ireceivedqty],[cfree1],[cfree2],[cfree3],[cfree4],[cfree5],[cfree6],[cfree7],[cfree8],[cfree9],[cfree10],[cdefine22],[cdefine23],[cdefine24],[cdefine25],[cdefine26],[cdefine27],[cdefine28],[cdefine29],[cdefine30],[cdefine31],[cdefine32],[cdefine33],[cdefine34],[cdefine35],[cdefine36],[cdefine37],[citem_class],[citemcode],[citemname],[btaxcost],[ippartid],[ipquantity],[iptoseq],[csource],[sodid],[sotype],[imrpsid],[iropsid],[cbcloser],[fnum],[cunitid],[ireceivednum],[cpersoncodeexec],[cdepcodeexec],[iinvmpcost]) SELECT UFDATA_999_2010..PU_AppVouchs.[id],[autoid],[cvencode],[cinvcode],[fquantity],[funitprice],[ipertaxrate],[ftaxprice],[fmoney],[drequirdate],[darrivedate],[ireceivedqty],[cfree1],[cfree2],[cfree3],[cfree4],[cfree5],[cfree6],[cfree7],[cfree8],[cfree9],[cfree10],[cdefine22],[cdefine23],[cdefine24],[cdefine25],[cdefine26],[cdefine27],[cdefine28],[cdefine29],[cdefine30],[cdefine31],[cdefine32],[cdefine33],[cdefine34],[cdefine35],[cdefine36],[cdefine37],[citem_class],[citemcode],[citemname],[btaxcost],[ippartid],[ipquantity],[iptoseq],[csource],[sodid],[sotype],[imrpsid],[iropsid],[cbcloser],[fnum],[cunitid],[ireceivednum],[cpersoncodeexec],[cdepcodeexec],[iinvmpcost] FROM UFDATA_999_2010..PU_AppVouchs inner JOIN UFDATA_999_2010..PU_AppVouch ON UFDATA_999_2010..PU_AppVouchs.ID=UFDATA_999_2010..PU_AppVouch.ID WHERE UFDATA_999_2010..PU_AppVouch.cCloser is null or ddate>=N'2011-01-01' order by UFDATA_999_2010..PU_AppVouch.ID
失败原因:采购系统结转失败
用户取消结转!
谁能帮忙看看,871的 |
|