Information Systems:Two Pickers Get Same Pick List
This will work fine until it is time to generate the invoice; then both RF guns will freeze. If this happens when no-one in I.T. is available to fix this, the warehouse can ship one set of items to the customer, with a note saying the invoice will follow, put the second set back on the shelf, and send available information to I.T. Best would be the pick list or order number; at the very least customer number, and at least one item number. The program running on each RF gun needs to be cancelled by I.T. If not available, the guns can be put aside, and the end of day will do it. In that case. The pickers will have to sign on with an alternate user ID.
The items picked but not invoiced will be in location 88 PACKING. To find these, use query on file WHOLOP in library UP1480BFVA, selecting records where field LPLCID equals 'PACKING'.
Display Report
Report width . . . . . : 314
Position to line . . . . . Shift to column . . . . . .
Line ....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8....+....9....+..
Whse Location Location ID Item Batch First Oldest Quantity in
zone put away reception location
date date
000001 MAI 88 PACKING 02430197 20141015 20141015 2.000
000002 MAI 88 PACKING 00527978 20120410 20141007 2.000
000003 MAI 88 PACKING 02202927 20120629 20141020 2.000
000004 MAI 88 PACKING 02281996 20140603 20140917 2.000
000005 MAI 88 PACKING 02202539 20131011 20140911 2.000
000006 MAI 88 PACKING 02377695 20130218 20140813 1.000
F3=Exit F12=Cancel F19=Left F20=Right F21=Split F22=Width 80
It is best to do this in the morning before the pickers start working, so that only items on the pick list that has a problem will show here. Items go into this location when the picker picks the last item on the pick list, and go out when the invoice is generated.
Next find the pick list, and see the actual item quantities. Go to the warehouse Picking and Shipping Menu, and selection option 2.
11/14/14 09:26:30 uniPHARM -- PRODUCTION PLRIQ040/LISTCTL
PLZ - Pick List Status PRODUCTION 1.00
Display Order Field Test Value
MAIN By Priority, Sched Dte, S __________ ____ _________________
Limit to: AND __________ ____ _________________
Date Range AND __________ ____ _________________
CU NOV 12 14 12:01 AM NOV 14 14 9:26 AM
Carr Stat Zone Group Del Locn Order Handler Customer Whs Item #
3220950 02377695
DT=Details
SD=Shipping Documents S #
Carr Zone Group Del Locn Schedule Pr h Lin STAT DESC CUST DESC
DT ATL OTC/HABA INTOWN NOV 14 14 8:05 AM 50 Y 6 fully comp SURLANG ME
F21=Srcn Reset
F3=Exit F5=Refresh F8=More Info F12=Previous F24=Srcn Save
In this case, we know the order number. As there can be multiple pick lists for one sales order, also key in one of the item numbers. Also change the date range to be sure the pick list will be included. Use option DT to see the details.
11/14/14 09:33:11 uniPHARM -- PRODUCTION PLRIU045/LISTCTL
PLZ - Pick List Details PRODUCTION 1.00
Pick List Batch Consol PL# Customer
3520488 5792627 11306 SURLANG MEDICINE CENTRE PHARM.
Warehouse Zone Group Order No
MAI OTC/HABA 3220950 105-19475 FRASER HWY
Del Locn Share? # Lines Invoice SURREY
INTOWN Y 6 BC V3S 6K7
Order Date Cutoff
Priority Scheduled Carrier THU NOV 13 2014 THU 9:05 PM
50 ATL Atlas Courier Pickup Date Added
Scheduled Pickup Status 8:05 AM NOV 13 14 12:11 PM
NOV 14 14 8:05 AM COMPLETED Atlas Courier
O/H P
Line Zone/Locn Qty UOM Item Desription Item # Qty k
10 O1 C133 1 EA IBUPROFEN 400MG CAPLETS 02377695 80 Y
20 O1 K042 1 EA SPECTRO JEL CLEANSER FRAG FREE 02430197 18 Y
100 O1 K121 1 EA NIZORAL SHAMPOO ANTI DANDRUFF 00527978 578 Y
220 O1 N420 1 EA VITAMIN D3 1000IU TAB BIOMEDIC 02202927 182 Y
250 O1 P210 1 EA FERROUS GLUCONATE 300MG TABLET 02281996 387 Y
260 O1 R161 1 EA ACETAMINOPHEN 500MG EX STR TAB 02202539 138 Y
F3=Exit
F5=Refresh F9=Show UPC F10=Show Size F12=Previous
Notice that these are the same items as are in the PACKING location, but all except for the first one are in PACKING twice. This could mean that it was only picked once. Check this by using the 'location transaction' inquiry program.
*VA/480B* Location transaction enquiry 14:45:40 WMR16001
-------------------------------------------------------------------------------
Date Whs Zn Location Item Trans. Qty.
-------------------------------------------------------------------------------
Date Whs Zn Location Item
MAI 02377695_______________________
F1=Shift info
Key in the warehouse and the item, then press enter. Press page up to get to the most recent transactions.
*VA/480B* Location transaction enquiry 14:45:40 WMR16001
-------------------------------------------------------------------------------
Date Whs Zn Location Item Trans. Qty.
_ 11/12/14 MAI 88 PACKING 02377695 IBUPROFEN 400MG CAPLETS 1.00
1 11/13/14 MAI O1 C133 02377695 IBUPROFEN 400MG CAPLETS 1.00-
_ 11/13/14 MAI 99 SHAROND 02377695 IBUPROFEN 400MG CAPLETS 1.00
_ 11/13/14 MAI 88 PACKING 02377695 IBUPROFEN 400MG CAPLETS 1.00-
_ 11/13/14 MAI 99 SHAROND 02377695 IBUPROFEN 400MG CAPLETS 1.00-
_ 11/13/14 MAI 88 PACKING 02377695 IBUPROFEN 400MG CAPLETS 1.00
1 11/13/14 MAI O1 C133 02377695 IBUPROFEN 400MG CAPLETS 1.00-
_ 11/13/14 MAI 99 HAMZAS 02377695 IBUPROFEN 400MG CAPLETS 1.00
_ 11/13/14 MAI 99 HAMZAS 02377695 IBUPROFEN 400MG CAPLETS 1.00-
_ 11/13/14 MAI 88 PACKING 02377695 IBUPROFEN 400MG CAPLETS 1.00
1 11/13/14 MAI O1 C133 02377695 IBUPROFEN 400MG CAPLETS 1.00-
_ 11/13/14 MAI 99 THIDAN 02377695 IBUPROFEN 400MG CAPLETS 1.00
_ 11/13/14 MAI 99 THIDAN 02377695 IBUPROFEN 400MG CAPLETS 1.00-
_ 11/13/14 MAI 88 PACKING 02377695 IBUPROFEN 400MG CAPLETS 1.00
_ 11/13/14 MAI 88 PACKING 02377695 IBUPROFEN 400MG CAPLETS 1.00-
1 11/13/14 MAI O1 C133 02377695 IBUPROFEN 400MG CAPLETS 1.00-
_ 11/13/14 MAI 99 THIDAN 02377695 IBUPROFEN 400MG CAPLETS 1.00
_ 11/13/14 MAI 99 THIDAN 02377695 IBUPROFEN 400MG CAPLETS 1.00-
_ 11/13/14 MAI 88 PACKING 02377695 IBUPROFEN 400MG CAPLETS 1.00
_ 11/13/14 MAI 88 PACKING 02377695 IBUPROFEN 400MG CAPLETS 1.00-
_ 11/14/14 MAI 88 PACKING 02377695 IBUPROFEN 400MG CAPLETS 1.00-
_ 11/14/14 MAI O1 C133 02377695 IBUPROFEN 400MG CAPLETS 1.00-
_ 11/14/14 MAI 99 SHAROND 02377695 IBUPROFEN 400MG CAPLETS 1.00
_ 11/14/14 MAI 99 SHAROND 02377695 IBUPROFEN 400MG CAPLETS 1.00-
_ 11/14/14 MAI 88 PACKING 02377695 IBUPROFEN 400MG CAPLETS 1.00
_ 11/14/14 MAI 88 PACKING 02377695 IBUPROFEN 400MG CAPLETS 1.00-
--------------------------------------------------------------------------------
Date Whs Zn Location Item
MAI 02377695
F1=Shift info
Look at every transaction where the picker has taken something from the shelf.
*VA/480B* Location transaction enquiry 14:55:31 WMR16003
-------------------------------------------------------------------------------
Warehouse........... MAI Main Warehouse
Zone................ O1 OTC
Location ID......... C133
Item................ 02377695
IBUPROFEN 400MG CAPLETS
Batch............... Order reference.....
NCC number..........
Transit balance..... N
Awaiting QC......... N Awaiting costs...... N
Loc qty before...... 141.00
Transaction qty..... 1.00-
Loc qty after....... 140.00
Inventory event..... RPK1
Description......... R/F Pick from
Order number........ 3520488
Order line number... 1
Date................ 11/13/14
Time................ 17:20:30
User................ HAMZAS
Look at the ‘order number’; which for this type of transaction is actually the pick list number. It is only in one of the pick transactions for the day the problem occurred, therefore one picker picked all six lines, and the other picker only picked five. The question is, how many items were shipped to the customer, and how many were put back on the shelf. To find out, compare the quantity that is actually on the shelf, to what the computer says is in that location (the location balance; not the warehouse balance). If they agree, the item in PACKING was shipped to the customer and should be invoiced. If the shelf is under by the quantity in packing, it should be transferred back to the shelf.
Go to the ASW warehouse dispatch task menu (GO DISPAT), and select option 4 Confirm sales order pick list.
*VA/480B* Pick list confirmation 11/14/14 10:45:33 DMR33001
-------------------------------------------------------------------------------
Pick list number.... 3520488
Pick consolidation.. _______
Dispatch date....... 111414
Key in the pick list number, and press enter
*VA/480B* Location confirmation 11/14/14 10:46:30 WMR91001
Pick
-------------------------------------------------------------------------------
List number 3520488 Warehouse MAI
-------------------------------------------------------------------------------
Line Item Sugg. qty
Batch Actual qty Zn Location PA SN +
1 02377695 1.00
1.00 88 PACKING
2 02430197 1.00
2.00 88 PACKING
3 00527978 1.00
2.00 88 PACKING
4 02202927 1.00
2.00 88 PACKING
5 02281996 1.00
2.00 88 PACKING
6 02202539 1.00
2.00 88 PACKING
-------------------------------------------------------------------------------
Line
F1=Change batch,loc. F8=Blank; sugg. qty F9=Blank; zero F10=Order
The ‘actual quantities’ do not agree with the ordered quantities, so have to be corrected. This is where you can change the quantities to match what was actually shipped.
*VA/480B* Location confirmation 11/14/14 11:09:02 WMR91001
Pick
-------------------------------------------------------------------------------
List number 3520488 Warehouse MAI
-------------------------------------------------------------------------------
Line Item Sugg. qty
Batch Actual qty Zn Location PA SN +
1 02377695 1.00
1.00 88 PACKING
2 02430197 1.00
1.00 88 PACKING
3 00527978 1.00
1.00 88 PACKING
4 02202927 1.00
1.00 88 PACKING
5 02281996 1.00
1.00 88 PACKING
6 02202539 1.00
1.00 88 PACKING
-------------------------------------------------------------------------------
Line
F1=Change batch,loc. F8=Blank; sugg. qty F9=Blank; zero F10=Order
You can key in the correct quantities (to agree with the pick list) and press either F8 or F9, or I think F10 will fix them.
*VA/480B* Pick list confirmation 11/14/14 11:10:41 DMR33004
-------------------------------------------------------------------------------
Pick list number.... 3520488
Customer............ 11306 SURLANG MEDICINE CENTRE PHARM.
-------------------------------------------------------------------------------
Line Unit Qty ord Qty dsp Bch/SN Bl P
Order Item Goods type Commodity code
1 EA 1.00 1.00 N
3220950 00527978
2 EA 1.00 1.00 N
3220950 02430197
3 EA 1.00 1.00 N
3220950 02202927
4 EA 1.00 1.00 N
3220950 02202539
5 EA 1.00 1.00 N
3220950 02281996
6 EA 1.00 1.00 N
3220950 02377695
-------------------------------------------------------------------------------
F1=Shift info
Double check that the quantity dispatched matches the quantity ordered, and that back log is ‘N’, then press enter.
*VA/480B* Pick list confirmation 11/14/14 11:11:18 DMR33008
-------------------------------------------------------------------------------
Pick list number.... 3520488
Customer............ 11306 SURLANG MEDICINE CENTRE PHARM.
TOD................. FOB Free on Board
MOT................. NRA No Route Assigned
-------------------------------------------------------------------------------
Order Type Freight Postage Insurance Ins % Admin fee Inv fee
3220950 WO __________ __________ _________ ______ __________ _________
F1=Goods marking and curr
Press enter again.
The sales order will now be in status 45 ‘ready to invoice’. The green screen pick list confirmation does not cause the ASW direct jobs to process this order, so we will have to do it. Go to the ASW sales tasks menu (GO SALES), and select option 1 Work with sales orders. Then key in the sales order number, and press enter.
*VA/480B* Work with sales orders 11/14/14 11:12:28 DMR30001
Header view
-------------------------------------------------------------------------------
1=Add 2=Change 3=Copy 4=Delete 5=Display 6=Lines 7=Text 8=Addresses
11=Order confirmation 12=Pick list 13=Invoicing
Order Customer Handler St OT Ord.date Order value
6 3220950 11306 SURLANG MEDI EDISO 45 WO 11/13/14 34.59
__ 3220934 12287 OUTREACH PHA EDISO 20 WF 11/13/14 102.37
__ 3220932 10481 MACDONALD'S EDISO 20 WF 11/13/14 83.57
__ 3220911 10814 PRATT'S COMP ROYF 20 SP 11/13/14 55.62
__ 3220904 12271 SUMMERLAND M EDISO 20 WF 11/13/14 59.40
__ 3220893 12175 PHARMASAVE # CHERYLC 20 SP 11/13/14 182.58
__ 3220870 11787 ROBIN'S PHAR EDISO 20 WF 11/13/14 1.24
__ 3220857 10418 KERRISDALE P EDISO 20 WF 11/13/14 23.96
__ 3220854 10418 KERRISDALE P NORMAM 20 SP 11/13/14 6.14
__ 3220810 11934 20/20 PHARMA EDISO 20 WF 11/13/14 43.23
__ 3220801 11087 UNIPHARM WHO FELIXP 30 IN 11/13/14 2261.64
More...
Order Customer Handler St OT Ord date
3220950 ____________ __________ __ __ ______
F1=Shift info F2=Item view F7=Repeat F8=Move cursor F10=More options
F11=View controls
Key in option 6 to see the lines. Key in option 2 Change for one of the items on the pick list, then press enter until you are back to the sales order header view. Press F5 to refresh; the sales order should no longer show, as the direct jobs will have invoiced it, and changed it to status 60.
Go back to the query display of items in location PACKING.
Display Report
Report width . . . . . : 314
Position to line . . . . . Shift to column . . . . . .
Line ....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8....+..
Whse Location Location ID Item Batch First Oldest Quantity in
zone put away reception location
date date
000001 MAI 88 PACKING 02430197 20141015 20141015 1.000
000002 MAI 88 PACKING 00527978 20120410 20141007 1.000
000003 MAI 88 PACKING 02202927 20120629 20141020 1.000
000004 MAI 88 PACKING 02281996 20140603 20140917 1.000
000005 MAI 88 PACKING 02202539 20131011 20140911 1.000
F3=Exit F12=Cancel F19=Left F20=Right F21=Split F22=Width 80
We are left with the duplicate picking – which may or may not including item 02377695; depending on whether or not you confirmed shipment of it.
Go into either location balance inquiry –
*VA/480B* Location balance enquiry 11/14/14 11:50:12 WMR15001
-------------------------------------------------------------------------------
Whs Zone Location Batch Tr QC AC Hld Unit On hand
Item
MAI * O1 K042 EA 18
02430197 SPECTRO JEL CLEANSER FRAG
MAI 88 PACKING EA 1
02430197 SPECTRO JEL CLEANSER FRAG
-------------------------------------------------------------------------------
Whs Zone Location Batch Item NCC
MAI 02430197
Order ref Hld
F1=Shift info
Or item display in InfoNet –
Items have to be transferred from PACKING back to the shelf locations. Go to ASW inventory handling tasks (GO INVHAN), and select option 3 Enter location movements.
*VA/480B* Location movements entry 11/14/14 11:57:42 WMR71001 ------------------------------------------------------------------------------- Whs Item Batch Quantity MAI 02430197 1.00 From zone/location 88 PACKING To zone/location O1 K042 MAI 00527978 1.00 From zone/location 88 PACKING To zone/location O1 K121 MAI 02202927 1.00 From zone/location 88 PACKING To zone/location O1 N420 MAI 02281996 1.00 From zone/location 88 PACKING To zone/location O1 P210 ------------------------------------------------------------------------------- Wh Item Batch Quantity MAI 02202539 1 F.Zone F.Location T.Zone T.Location NCC no Tr Hld Order ref Line 88 PACKING O1 R161 N N _______ _____
Transfer all items from packing to the shelf location (picking not overflow) you see in either location balance inquiry or InfoNet. Refresh the screen after each transfer to check accuracy. When you are done, go back to the query display of items in location PACKING – there should be none; or perhaps just current activity.