1:首先根据申领单号,查看申领单内物资的可用库存
select
F_GET_STOCK_USEABLE_QTY(dtl.material_id,'100560',null,null,dtl.unpack_yn),
dtl.* from tb_usc_apply_detail dtl where dtl.apply_master_id='SL2017060812994'
2:如果显示的可用量确实有问题,则将排查可用量计算的sql,查看数据可能出现在那部分:1:实际库存,2:占用库存量
SELECT M2.USEABLE_QTY - NVL(M1.USEABLE_QTY, 0) USEABLE_QTY
FROM (
SELECT SUM(P.PICKING_QUANTITY) USEABLE_QTY
FROM TB_USC_PICKING P
WHERE P.STOCK_TRANSFER_ID IN(
SELECT DISTINCT STM.STOCK_TRANSFER_ID
FROM TB_USC_STOCK_TRANSFER_MASTER STM
WHERE STM.UNPACK_YN = 'N'
)
AND P.MATERIAL_ID = '685600000001749'
AND P.STATUS = 'N') M1,
(
SELECT SUM(JS.JIT_STOCK_AVAILABLE_QTY) USEABLE_QTY
FROM TB_USC_JIT_STOCK JS
WHERE JS.WH_ID = '100109'
AND JS.UNPACK_YN = 'N'
AND JS.MATERIAL_ID = '685600000001749') M2;
可能需要查询对应的仓库ID使用:select * from tb_usc_warehouse where wh_name like '%卫生材料库(低值)%'
3:如果确认是占用量存在问题,查看实际占用物资的单据:
SELECT *
FROM TB_USC_PICKING P
WHERE P.STOCK_TRANSFER_ID IN(
SELECT DISTINCT STM.STOCK_TRANSFER_ID
FROM TB_USC_STOCK_TRANSFER_MASTER STM
WHERE STM.UNPACK_YN = 'N'
)
AND P.MATERIAL_ID = '685600000001749'
AND P.STATUS = 'N'
附:
今天遇到的问题均是因为中途变更定数包单位,造成修改定数包之前的单据不能正常处理业务。
欢迎光临 临海小憇 (http://czidea.cn/) | Powered by Discuz! X3.3 |