(FAQ)采购入库单提交报错
问题原因：物料多计量单位存在脏数据，同一个物料有多个基本计量单位。 解决方法：数据修复，在eas查询分析器中执行下面ksql: --备份多计量单位 select * into bak0529_multimeasureunit from t_bd_multimeasureunit; --根据物料基础页签基本计量单位更新多计量单位表错误标记的基本计量单位 update t_bd_multimeasureunit set fisbasicunit=0 where fisbasicunit=1 and not exists (select * from t_bd_material where fid = t_bd_multimeasureunit.fmaterialid and fbaseunit = t_bd_multimeasureunit.fmeasureunitid); --删除重复的多计量单位 delete t_bd_multimeasureunit where fid not in (select max(fid) from t_bd_multimeasureunit group by fmaterialid,fmeasureunitid);