RF Picking : Order lists are not correct

Creation date: 02/03/2022 09:18    Updated: 02/03/2022 09:18   #ordernotfilterbyzone rforderpicking
Question:

Date : 18/02/2022


Details :


Environment : Prod and Dev

All DC


We found that order lists in RF Picking modules have been shown all the order lists even that order was not belong to the working area selected.

So that make the user confused.


Please see more details as attached.


Answer:

Investigation:

To pass in the parameter for the Zone selected

SELECT DOC_ORDER_HEADER.ORDERNO AS @LIST_VIEW@,
BSM_CODE_ML.CODEDESCR AS @LIST_VIEW@,
DATE_FORMAT(DOC_ORDER_HEADER.ADDTIME,'%Y-%m-%d %T')  AS @LIST_VIEW@
FROM DOC_ORDER_HEADER
LEFT JOIN BSM_CODE_ML ON DOC_ORDER_HEADER.ORDERTYPE=BSM_CODE_ML.CODEID AND BSM_CODE_ML.LANGUAGEID='#LANGUAGE#'
LEFT JOIN TSK_TASKLISTS ON DOC_ORDER_HEADER.ORDERNO=TSK_TASKLISTS.DOCNO
LEFT JOIN BAS_LOCATION ON TSK_TASKLISTS.FMLOCATION=BAS_LOCATION.LOCATIONID
WHERE DOC_ORDER_HEADER.SOSTATUS<'80'
AND BSM_CODE_ML.CODETYPE='SO_TYP'
AND TSK_TASKLISTS.TASKTYPE='PK' AND TSK_TASKLISTS.TASKPROCESS<='10' AND
(TSK_TASKLISTS.DOCNO='@TXT_ORDERNO_1#ALLOW_EMPTY#@') AND 
(TSK_TASKLISTS.GROUPTASKID='@TXT_GROUPTASKID_1#ALLOW_EMPTY#@') AND (BAS_LOCATION.ZONEGROUP='@TXT_AREA_1#ALLOW_EMPTY#@') AND
(BAS_LOCATION.ZONEID='@TXT_ZONE_1#ALLOW_EMPTY#@') AND (BAS_LOCATION.LOCGROUP1='@TXT_LOCGROUP1_1#ALLOW_EMPTY#@') AND (BAS_LOCATION.LOCGROUP2='@TXT_LOCGROUP2_1#ALLOW_EMPTY#@') AND (TSK_TASKLISTS.FMLOCATION>='@TXT_LOCATIONIDFM_1#ALLOW_EMPTY#@')  AND (TSK_TASKLISTS.FMLOCATION<='@TXT_LOCATIONIDTO_1#ALLOW_EMPTY#@') AND (TSK_TASKLISTS.HOLDWHO='#USERID#' OR TSK_TASKLISTS.HOLDWHO IS NULL) 

AND (DOC_ORDER_HEADER.CUSTOMERID = '#AUTHORIZE_CUSTOMER#')
AND (BAS_LOCATION.WORKINGAREA='@SEL_WORKING_AREA_1@')
AND (BAS_LOCATION.ZONEGROUP='#AREAID#')

GROUP BY DOC_ORDER_HEADER.ORDERNO,DOC_ORDER_HEADER.ADDTIME,BSM_CODE_ML.CODEDESCR  LIMIT 0,99



Investigation:

Fix in RF programme to send in "selected area"
Files