So, I’m messing around with picking and shipping, and I’m noticing that I have a fair amount of part alloc records with values in “picking” but no material queue records. I haven’t fully tested it yet, but I believe you can simply delete a material queue record, and then what happens to the allocation? How do you pick something with no material queue record to process?
I also have cases of Picked Orders that have no open releases.
Granted, this is in a dev copy that gets beaten on, so the data isn’t great, but it still was “possible” for these tables to get out of sync.
What do you guys do in order to deal with this junk in the system?
You can. We have been using the FWB/MRQ workflow for years and I can say that people incorrectly deleting MRQ records is a non-issue here. I had to play around in the system just now to see how to deal with it because it honestly never comes up.
Depends on your workflow, but here, the item just wouldn’t get picked. If your customer/order isn’t marked as ‘Ship Complete’ I’m not sure there is anything built in to give you an indication that you missed a line. I think it would require a person being diligent enough to compare the FWB allocation or SO releases to what is physically picked.
Also, as a side note, apologies if I am telling you things you already know but if you are new to the MRQ this might be helpful.
If you are not seeing MRQ records you are expecting to, it is important to understand there are 2 tabs on the MRQ. ‘Unselected’ and ‘My Selections’
The Unselected tab contains records that have not been selected/assigned (VIA the MRQ manager dashboard) to an individual/group. These records are visible to everyone.
The My Selections tab contains records that have been selected/assigned to an individual or group. These records are visible ONLY to that individual/group.
Although deleting records is a non-issue here, it is VERY EASY to accidentally select an MRQ record, you can just double click on one. Whenever we have a ‘missing’ MRQ record here, this is always the cause.
Just a heads-up as it caused us a little headache while figuring it out:
We have a Warehouse Team called ‘Expedition’. All allocated sales orders are picked by this team. During allocation the user gets a pop-up presented ‘Do you want to print?’. If you click ‘Yes’ there will be no Material Queue record for team Expedition.
My sort of logic explanation to the order managers is that you tell the system it will be picked from a paper in stead of a digital pick list (Material Queue) and if Epicor would also create a Material Queue record there is a chance you pick items twice.
Yes that’s true. Just for the proces, people expects it to appear in ‘My Selections’ and having it assigned to employee ‘Printed’ it’s nowhere to be found by a shopfloor employee. For us off course it’s eventually an easy find.
