摘要:
异动盘点:一般在每天下班前,由系统导出当天有货物进出的库位,交由仓管去指定库位盘点货物,盘点数据与系统数据对比确认是否有差异。select * from v_Invtake where loc in --v_Invtake视图 查询库存信息(/*********************当天收货*********************/SELECT distinct LOC FROM RECEIPTDETAIL WHERE RECEIPTDETAIL.STATUS>='06' AND LOC<>'' AND CONVERT(DATETIME,R 阅读全文