Epicor picking process

Kinetic ERP
1

hi Folks

hoping someone can advise

We are in the process of testing WMS processes prior to bringing into Live, however we have noticed an issue when updating Pick from location via Material Request Queue / EMWW app.

basically when we override the Bin locations assigned at allocation, and pick from an alternative location, we eventually get to the stage where picked quantities go back into picking…

  • Create a sales order for a part
  • Part should be in stock in multiple locations
  • Open fulfillment workbench and allocate & release for picking, search by Qty Ascending
  • Material queue work is then created to pick quantity from specified locations

image
image736×135 73.4 KB

  • However, our operator may decide to / be instructed to override the allocations, and instead will take stock from Bin01 as there is sufficient stock there to fulfil the order
  • Operator overrides the location to Bin 01 for the line requiring 17pcs; Picked qty is updated, and database shows 17pcs in Bin02 (our Picked location)

image
image814×58 30.3 KB

image
image900×158 81.9 KB

  • They then repeat this action for the line requiring 23pcs, so Picked qty now correctly equals 40pcs

image
image892×62 35.6 KB

image
image883×147 131 KB

  • Next, they process the 60pcs and update to pick from Bin01, and again we see the Picked qty correctly updating

image
image887×64 35.2 KB

image
image887×124 111 KB

  • Finally, we go to the last outstanding record to pick the 75pcs. This time, the Picked qty does not update correctly:

image
image887×58 34.9 KB

image
image874×101 86.3 KB

  • As you can see, 40pcs have reverted to “Picking” status and the total Picked qty is 135pcs rather than 175pcs
  • Note that, as each transaction is completed, the Material Queue entry is removed (as you’d expect)

bit of a long shot i know, but has anyone ever encountered this issue?

we are on 22.7, but i have also tested on 22.37 and the same thing happens!

thanks

Mal

2

This is a single order release, for 175 pieces?

You used the fulfillment workbench to allocate quantity in 4 separate BINs for this release, and created 4 different STK-SHP transactions in the Material Request Queue?

Where is the data in your screenshots coming from, a BAQ?

3

hi Garret

correct 175 pieces allocated over 4 location

this is just a sql query looking at the Partbin table for that specific sales order

mal

4

i should add
we can replicate this each and every time we follow this scenario

5

Thanks, I wanted to try and replicate it myself, although we do not use allocation here.

This is not a solution but is there a specific reason you allocate instead of simply reserve? We reserve here and allow the pickers to mostly decide where they pick from (with rules) and I have never come across this issue before.

6

hi Garret
we have 10 + distribution depots 2 of which are large mfg sites so the key for us is to use emww and drive the picking process and remove the required knowledge - this product is in a specific location etc , as staff retention can be low in these areas.
Also a lot of our product looks the same, so leaving it up to the picker can result in wrong picks

7

Did you ever make it any further on this issue? We see it happen regularly as well when the bin or lot is changed during picking for an operational reason. Not normally an issue, but if there is a delay in shipping the originally allocated inventory that was not picked is unavailable for any future orders.

8

Hey ya

The only way we could avoid this issue was by introducing a shipping warehouse, so once an item was picked it moved automatically to the shipping warehouse where we could then ship the packs.

Been live for quite a while now ane zero issues

Mal

1 Like
9

Thanks for the reply, I will add that to the list of processes to try.