K3 CLOUD提示库存键重复，提示如下

 

 

 

 

 这是单位不统一造成的，按照项目数据依次执行，

先查询：

select FBASEUNITID,* from T_STK_INVENTORY where FMATERIALID=375461
select FBASEUNITID,* from T_BD_MATERIALBASE where FMATERIALID=375461

select * from T_BD_MATERIAL as al
left join
T_BD_MATERIAL_L as al_l
on al.FMATERIALID=al_l.FMATERIALID
where FNAME='香樟' AND FNUMBER='SWZC0132'

 

2014-12-29 只看该作者

--即时库存基本单位检查
select * from T_STK_INVENTORY t1 
inner join T_BD_MATERIALBASE t3 on t1.FMATERIALID = t3.FMATERIALID 
where t1.FBASEUNITID <> t3.FBASEUNITID

然后更新单位：

update T_STK_INVENTORY set FBASEUNITID=357226 where fid='0a94ef61-44d1-80c7-11ea-6338b75ce964'