用友-知识库

所有的单据都不能审核 提示有重复值,

  • 问题描述:调拨单等单据审核提示 不能在具有唯一索引aa_rdrocords_pk的对象rdrecords中插入重复键的行
  • 问题原因:1. --事件探查器跟踪发现 -- Insert Into ufdata_001_2005..Rdrecords(id,cinvcode,cbarcode,cfree1,cfree2,cfree3,cfree4,cfree5,cfree6,cfree7,cfree8, cfree9,cfree10,inquantity,innum,cbatch,cassunit,dmadedate,inum,iquantity,iunitcost,iprice,ipunitcost,ipprice,dvdate, cposition,autoid,cvouchcode,isoutquantity,isoutnum,cdefine22,cdefine23,cdefine24,cdefine25,cdefine26,cdefine27, cdefine28,cdefine29,cdefine30,cdefine31,cdefine32,cdefine33,cdefine34,cdefine35,cdefine36,cdefine37,impoids, icheckids,itrids,citemcode,citem_class,cname,citemcname,imassdate,cbvencode,cinvouchcode) Values (234296,'WP3111',NULL,'C','黑色','34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,0,1,799,799, NULL,NULL,NULL,'',1601710,NULL,0,0,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, NULL,390975,NULL,NULL,NULL,NULL,NULL,NULL,NULL) 不能在具有唯一索引aa_rdrocords_pk的对象rdrecords中插入重复键的行 -- Insert Into ufdata_001_2005..Rdrecords(id,cinvcode,cbarcode,cfree1,cfree2,cfree3,cfree4,cfree5,cfree6,cfree7,cfree8, cfree9,cfree10,inquantity,innum,cbatch,cassunit,dmadedate,inum,iquantity,iunitcost,iprice,ipunitcost,ipprice,dvdate, cposition,autoid,cvouchcode,isoutquantity,isoutnum,cdefine22,cdefine23,cdefine24,cdefine25,cdefine26,cdefine27,cdefine28,cdefine29,cdefine30,cdefine31,cdefine32,cdefine33,cdefine34,cdefine35,cdefine36,cdefine37,impoids,icheckids, itrids,citemcode,citem_class,cname,citemcname,imassdate,cbvencode,cinvouchcode) Values(234296,'ATS833',NULL,'0','绿色','48',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,0,1,0,0,NULL,NULL, NULL,'',1601711,NULL,0,0,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,390976, NULL,NULL,NULL,NULL,NULL,NULL,NULL) 不能在具有唯一索引aa_rdrocords_pk的对象rdrecords中插入重复键的行;说明还是最大单据号表有问题。
  • 解决方案:游客无权查看
  • 相关补丁:
  • 模块:库存管理
  • 产品:852
  • 问题名称:所有的单据都不能审核 提示有重复值,
  • 更新时间:2005-06-28 00:00:00
  • 有用 没用92 浏览