Hi Vineet, Please apply data fix script to FICAC database then retest. ---------------- DELETE FROM LBS_LOT_BIN_SER WHERE company_id = '1001' and location = 'EMP' and part_no = 'P0000001190' and bin_no = '112' and lot_ser = 'G1000GHJ11903' and ref = 'N/A' DELETE FROM LBS_LOT_BIN_SER WHERE company_id = '1001' and location = 'JHB' and part_no = 'P0000000473' and bin_no = 'ST' and lot_ser = '9UL854384731' and ref = 'N/A' DELETE FROM LBS_LOT_BIN_SER WHERE company_id = '1001' and location = 'JHB' and part_no = 'P0000000504' and bin_no = 'ST' and lot_ser = 'P00000005043' and ref = 'N/A' update LBS_LOT_BIN_SER SET ref = ''
UPDATE LBS_INV_LIST SET in_stock = ISNULL((SELECT SUM(s.qty) FROM LBS_LOT_BIN_SER s WHERE s.company_id = l.company_id AND s.part_no = l.part_no AND s.location = l.location ),0) FROM LBS_INV_LIST l JOIN LBS_INVENTORY i ON l.company_id = i.COMPANY_ID and l.part_no = i.part_no where i.lot_bin_track = 'Y' |