ERP系统库存月结增加当前库存-批次库存-MES储位批次库存的一致性校验
1、月结弹出窗口增加是否校验当前库存-批次库存-MES储位批次库存的一致性勾选选项
2、如果进行一致性校验,弹出提示窗口,列出异常数据,并提供“继续”和“退出”选项
a 继续 无视三者库存的不一致,继续月结
b 退出 当即终止月结作业
3、对弹出的异常数据,提供导出功能
4、异常数据格式
5、参考SQL语句
select obas_part.item_no as 物料编码,
obas_part.part_name as 物料名称,
obas_part.part_spec as 物料规格,
oscm_material.wh_no as 仓库编码,
isnull(oscm_material.total_qty,0) as 当前库存, --当前库存结存
isnull(qty1,0) as 批次库存, --批次库存结存
isnull(qty2,0) as 储位库存 --储位批次库存结存
from oscm_material join obas_part on oscm_material.part_no = obas_part.part_no
left outer join (select part_no,wh_no,sum(total_qty) as qty1 from ov_scmlotmaterial group by part_no,wh_no) as scmlotmaterial on oscm_material.part_no = scmlotmaterial.part_no and oscm_material.wh_no = scmlotmaterial.wh_no
left outer join
(select part_no,wh_no,sum(sheet_qty) as qty2
from omes_binmaterial
group by part_no,wh_no) as omes_material on oscm_material.part_no = omes_material.part_no and oscm_material.wh_no = omes_material.wh_no
where oscm_material.month_no = '202305'
and (isnull(total_qty,0) <> isnull(qty1,0) or isnull(qty1,0) <> isnull( qty2,0) or total_qty <> isnull( qty2,0))
order by oscm_material.wh_no