问题现象: | 您好,查询现存量003仓库存货010302100003分别对应的新品数和可用品数与联查到的在库序列号数据不一致,可以远程,烦请帮忙解决,谢谢! |
问题原因: | |
解决方案: | 您好, 此问题【经查看数据/测试】现做如下分析与答复: 【问题原因】 有形态转换单转换可用品至新品时指定序列号错误造成; 【解决方案】 执行如下脚本调整 update ST_SNDetail_Otherin set isnprestate='4' where cinvcode='010302100003' and cwhcode='003' and cinvsn='LA3181008299' and cfree2='可用品' update ST_SNState set isnstate='4' where cinvcode='010302100003' and cinvsn='LA3181008299' and cfree2='可用品' and cwhcode='003' insert into ST_SNState ( cInvCode, cWhCode, cPosition, cfree1, cfree2, cfree3, cfree4, cfree5, cfree6, cfree7, cfree8, cfree9, cfree10, cSNDefine1, cSNDefine2, cSNDefine3, cSNDefine4, cSNDefine5, cSNDefine6, cSNDefine7, cSNDefine8, cSNDefine9, cSNDefine10, iSNState, iSNPreState, iSNOperateCount, cInCode, itrackid, cBatch, cVenCode, cInvSN, dmdate, dvdate, imassunit, imassdate) select cInvCode, cWhCode, cPosition, cfree1, '新品', cfree3, cfree4, cfree5, cfree6, cfree7, cfree8, cfree9, cfree10, cSNDefine1, cSNDefine2, cSNDefine3, cSNDefine4, cSNDefine5, cSNDefine6, cSNDefine7, cSNDefine8, cSNDefine9, cSNDefine10, 2, iSNPreState, 1, cInCode, itrackid, cBatch, cVenCode, 'LA3181008299', dmdate, dvdate, imassunit, imassdate from ST_SNState where cinvcode='010302100003' and cwhcode='003' and cinvsn='LA3181105500' update ST_SNDetail_Otherin set isnprestate='2', cinvsn='LA3181008299' where cinvcode='010302100003' and cwhcode='003' and cinvsn='LA3181105500' and cfree2='新品' update ST_SNDetail_Otherin set iSNOperateCount =1 where cinvcode='010302100003' and cwhcode='003' and cinvsn='LA3181008299' and cfree2='新品' delete ST_SNState where cinvcode='010302100003' and cwhcode='003' and cinvsn='LA3181008299' and cfree2='可用品'; 【注意事项】修改前请务必做好数据备份;由于网站的关系,上述语句中的标点符号 ‘ % + 必需在输入法为英文的状态下重新录入后再执行 |
相关补丁: | |
版本: | 8.90 |
模块: | 库存管理 |
产品: | 供应链 |
问题名称: | 现存量与在库序列号不一致 |
最后更新: | 2011-09-14 23:24:46 |