(FAQ)某些物料在出、入库单录入提交的时候提示错误
原因：一个物料含有多个基本计量单位 解决方法：有重复记录select fmaterialid,count(*) from t_bd_multimeasureunit where fisbasicunit=1 group by fmaterialid having count(*)>1，可用以下脚本修复。 --备份多计量单位 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);