从请购单生成订单时,过滤请购单选择列表,选择00000000221号请购单时提示:单据转换时发生错误,详细信息为:所选用于生单的数据已经被别人修改。
可通过下列语句处理解决:
use ufdata_001_2011
select invcode from bas_part group by invcode having count(invcode)>1
delete from bas_part where invcode in (select invcode from bas_part group by invcode having count(invcode)>1) and partid not in (select min(partid) from bas_part group by invcode having count(invcode)>1)
请检查inventory_sub表、bas_part表中0308的存货是否有重复记录,如果没有启用结构性自由项,则inventory_sub表、bas_part表中存货编码为0308的存货应该只有一条记录。如有重复的,请删除重复记录即可。