• ChrisM@Work (8/12/2013)


    It is referenced:

    CASE -- All std time captured on Move*, as this is where quantity is recorded

    -- where Move trans types don't exist, qty is recorded on other trans types (e.g C)

    WHEN ISNULL(jt.qty_moved,0) <> 0

    AND jt2.trans_num IS NULL

    Doh! Sorry!