升级后采购入库单单据保存失败-用友U8

对应版本:用友U8.51对应产品线：供应链对应模块：采购管理模块问题现象:升级完后，在做采购入库单保存时提示“单据保存失败，修改或稍后再试！不能在具有唯一索引‘aardrecord_pk’的对象‘rdrecord’中插入重复的行，不能在具有唯一索引‘aardrecord_pk’的对象‘rdrecords’中插入重复键的行，新增单据保存失败。问题原因：由于升级时，先不急于做的当年数据，再升级以前年度数据所造成UFSYSTEM表中UA_IDENTITY中RD号中主表、子表ID号改小所至解决方案：经跟踪后发现在如下语句终止InsertIntoRdrecords(autoid,id,cinvcode,cbarcode,cassunit,inum,iquantity,iunitcost,iprice,iaprice,ipunitcost,ipprice,cbatch,cvouchcode,cfree1,cfree2,cfree3,cfree4,cfree5,cfree6,cfree7,cfree8,cfree9,cfree10,inquantity,innum,dmadedate,iflag,dsdate,itax,isnum,isquantity,imoney,isoutquantity,isoutnum,ifnum,ifquantity,dvdate,cposition,cdefine22,cdefine23,cdefine24,cdefine25,cdefine26,cdefine27,cdefine28,cdefine29,cdefine30,cdefine31,cdefine32,cdefine33,cdefine34,cdefine35,cdefine36,cdefine37,impoids,itrids,icheckids,citem_class,citemcode,iarrsid,iposid,facost,cname,citemcname,imassdate,cbvencode,cinvouchcode,cgspstate,ccheckcode,icheckidbaks,crejectcode,irejectids,ccheckpersoncode,dcheckdate)Values(54625,20895,’A01011’,NULL,NULL,0,100,10,1000,1000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,0,NULL,0,0,0,0,0,0,0,0,NULL,’’,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)错误可能是在Rdrecords的ID号上。打开UFSYSTEM中UA_Identity表，修改帐套中RD的iFatherID和iChildId与实际rdrecord/s表的id号一致。再次保存ok

本文链接：https://www.bbsufida.com/u8/39019.html