Search Knowledge Base Articles
user scan infor list show 'already scan'
Morning BIS team chong here , pls cek & advise the error "already scan" when scan info list for below :-
1. SO25/00973 11EC--032 bag no . 11 & 12
2. SO25/01006 11ET-020 bag no. 43
qrmaster for production barcode scan
whqrmaster for warehouse barcode scan
SELECT * FROM ierpadmin.whqrmaster where sonum = 'SO25/01006' AND STOCKCODE = '11ET--0200207AK0K0'
SELECT * FROM ierpadmin.whqrmaster where sonum = 'SO25/00973' AND STOCKCODE = '11EC--032---7AK0K0'
root cause
SELECT * FROM ierpadmin.whqrmaster ,
qrmaster column is "ITFG212905287-697-615" format is not 'null' mean something wrong,
should be null value.
the process is
warehouse scan receive
scan receive
do internal transfer
internal transfer acknowlegement
suvin provide the sql code:
UPDATE whqrmaster SET store = '1WHL',
shipmark = NULL, qrmaster = NULL, location = NULL,
type = NULL, delivertype = NULL, dt_scanout = NULL,
scanout_by = NULL, dt_finishscanout = NULL, pallet = NULL,
layer = NULL,
status = NULL, status3 = '0' WHERE qrmaster = 'ITFG21%';
ITFG21%=ITFG212905287-697-615