Picklist Controller - Stock order by option should be using a function or SP
The stock order by options in the "regular picking" workflow are to limited. It would be better if this was a function or a stored procedure.
For example if a picklist has type standard, i want the picker to first look at stock in Zone 1 but if the picklist type is assembly, i want the picker to go and pick in zone 2 first.
Currently not possible with the "regular picking" workflow that I know of.
-
Official comment
Thank you for your comments. We think this is a good idea, and have plans to implement it in the future. If our partners agree and up-vote this idea we will see it in a future Quality of Life release.
-
Hello Jan, thank you for your request, have you tried using this option on the picklist controller? http://wiki.produmex.name/doku.php?id=implementation:wms:picklistcontroller#:~:text=Pick%20items%20order%20by%20%2D%20Stored%20procedure%20name
-
Hi Jorge, thanks for your feedback but the "pick items by order" is to sort the items in the picklist after the location have been assigned to the line item. The "stock order by" is used to assign the location to pick from. I would need more control over the location that is being assign to pick from.
Unless i am mistaken.
Jan
-
Hello Jan
Don't know if this helps, but I used the "Only pick items on location on same or lower level as dock? (Y/N)" setting from within the Picklist controller to do a very similar process.
This only really works for sales picking though, as I could control the selected dock by forcing the users process to always be to create the picklist through the "Open Sales Report".
-
Hi Greg,
Great suggestion and I have done the same once, but I do agree with Jan that a SP would be most ideal as this allows for any complex scenario to be built by consultants.
FYI, it's perfectly possible to set the dock through the TransactionNotification, based on SQL criteria. It's a PMX table, not a SAP one so the DB UPDATE is not a huge concern. Just make sure you always set it to a valid dock location.Tom
-
Yes, i agree ... this is needed
-
Re-commenting on this feature request, I'm getting this request from different clients time after time. Some clients do not want to use SSCCs, they want to directed to an overstock location if the pick quantity is greater than or equal to a pallet quantity. This is where a custom stored procedure can help where we can include "CASE WHEN" logic . This feature should be on the top of the development list imo.
-
Re-commenting to keep it alive :)
Please sign in to leave a comment.
Comments
8 comments