仓库盘点:异动盘点

异动盘点：一般在每天下班前，由系统导出当天有货物进出的库位，交由仓管去指定库位盘点货物，盘点数据与系统数据对比确认是否有差异。

select * from v_Invtake  where loc in  --v_Invtake视图 查询库存信息
(
/*********************当天收货*********************/
 SELECT distinct LOC FROM RECEIPTDETAIL
    WHERE RECEIPTDETAIL.STATUS>='06'
    AND LOC<>''
    AND CONVERT(DATETIME,RECEIPTDETAIL.LOTTABLE04,120)='2012-9-20'
 UNION  All
/*********************当天物转*********************/
    SELECT distinct TOLOC  from InvTransferDetail
    left join   InvTransfer on  InvTransfer.whseid=InvTransferDetail.whseid and InvTransfer.transferkey=InvTransferDetail.transferkey
    WHERE  InvTransfer.status='1' and  InvTransfer.type='1'
    AND CONVERT(datetime, CONVERT(varchar(10), InvTransferDetail.adddate, 120),120)='2012-9-20'
UNION ALL
/*********************当天出货*********************/
    SELECT  distinct FROMLOC FROM PICKDETAIL
    WHERE  STATUS='05'
    AND  CONVERT(datetime, CONVERT(varchar(10), PICKDETAIL.EDITDATE, 120),120)='2012-9-20'
UNION ALL
/*********************当天移库*********************/
    SELECT distinct TOLOC FROM InvMoveDetail
    JOIN InvMove ON InvMove.WHSEID=InvMoveDetail.WHSEID AND InvMoveDetail.MOVEKEY=InvMove.MOVEKEY
    WHERE InvMove.STATUS='1'
    AND CONVERT(datetime, CONVERT(varchar(10), C_DATE, 120),120)='2012-9-20'
)

转载于:https://www.cnblogs.com/damoyoushui/archive/2012/09/20/colin_zheng.html