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'
--即时库存基本单位检查 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'
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步