物料使用过程中启用批次管理、保质期管理导致有库存但是不能出库原创
9人赞赏了该文章
1,032次浏览
编辑于2022年06月01日 19:13:21
启用保质期前入库的即时库存:
使用过程中启用了保质期管理:
处理方法一:首先后台修改物料属性,关闭启用保质期、修改保质期(天)为0;然后正常出库、单据审核,再从后台把物料属性修改回来;
SELECT FNumber,FISKFPeriod, FKFPeriod,* FROM dbo.t_ICItem WHERE FNumber IN ('05.02.01.02.XXX')
![图片.png 图片.png](/download/01095f575d5ac7de4643b8604c2daab72e1a.png)
UPDATE dbo.t_ICItem
SET FISKFPeriod=0,FKFPeriod=0 --FISKFPeriod=1,FKFPeriod=720
WHERE FNumber IN ('05.02.01.02.XXX')
--更新结果
SELECT FNumber,FISKFPeriod, FKFPeriod,* FROM dbo.t_ICItem WHERE FNumber IN ('05.02.01.02.XXX')
![图片.png 图片.png](/download/010971da9a3484894dccb769cfaa4391f3f5.png)
![图片.png 图片.png](/download/0109f9f142f9c49a4a26a3ecfd194e58b356.png)
新增相应的出库单库(下面新增一张退料通知单):
![图片.png 图片.png](/download/0109b0256b30586a4ffe876195446ddaadfd.png)
再次查看即时库存(库存已不存在):
![图片.png 图片.png](/download/0109ee8f9d4f90094421afd8d15f69300f39.png)
更改回物料启用保质期参数(更改回之前新增的退料通知单一定要审核完毕,否则会报相关的错误):
UPDATE dbo.t_ICItem
SET FISKFPeriod=1,FKFPeriod=720 --FISKFPeriod=1,FKFPeriod=720
WHERE FNumber IN ('05.02.01.02.XXX')
查询更改:
SELECT FNumber,FISKFPeriod, FKFPeriod,* FROM dbo.t_ICItem WHERE FNumber IN ('05.02.01.02.XXX')
![图片.png 图片.png](/download/0109ca0f1f3312b3466caf7563dd780f3a7d.png)
处理方法二:给相关的即时库存增加上批号、保质期、到期日等信息;给相关的单据增加批号、保质期、到期日等信息;
即时库存信息:
![图片.png 图片.png](/download/010905f15a1f9d4b4f3d957fddcb7475f86d.png)
单据增加批号:
----修改收料通知单批号
UPDATE dbo.POInStockEntry
SET FBatchNo='20XXX'
WHERE FInterID=5481
![图片.png 图片.png](/download/01098616665d62344978b3f12bf85d48cf50.png)
![图片.png 图片.png](/download/010901581a80db5e47c8a0df512064b9f66f.png)
-----待检仓存量表
SELECT FKFDate,FKFPeriod,* FROM dbo.POInvBal WHERE FItemID IN (SELECT FItemID FROM dbo.t_ICItem WHERE FNumber='05.02.15.XXX') AND FBatchNo=''
AND FKFDate='XXXX'
![图片.png 图片.png](/download/01099e0c1e36f33849cb9200386f511dad79.png)
/*
处理待检仓即时库存
直接更新收料通知单不起作用,在校对库存时存储过程[CheckInventory]会重新“--校对虚仓”
*/
-----更新待检仓存量表
UPDATE dbo.POInvBal
SET FBatchNo='XXXXX'
WHERE FItemID IN (SELECT FItemID FROM dbo.t_ICItem WHERE FNumber='05.02.15.XXXX') AND FBatchNo=''AND FKFDate='XXXX'
-----检查更新结果
SELECT FKFDate,FKFPeriod,* FROM dbo.POInvBal WHERE FItemID IN (SELECT FItemID FROM dbo.t_ICItem WHERE FNumber='05.02.15.XXXX') AND FBatchNo<>''
AND FKFDate='XXXXXX'
![图片.png 图片.png](/download/01098dcf8a1c762340e09399bdcb2d2f7b7a.png)
检查更新后的即时库存(一定要“校对”一下,否则即时库存不会更新):
![图片.png 图片.png](/download/0109868f6940794341a19456b6fe82d4578a.png)
校对后,正常做出入库单据即可;
推荐阅读