Picklist Controller - Stock order by option should be using a function or SP Respondida

Jan Van Gemert

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.

Comentarios

9 comentarios

  • Comment author
    Jorge Herrera
    • Comentario oficial

    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.

  • Comment author
    Jorge Herrera
    • Editado

    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

    0
  • Comment author
    Jan Van Gemert

    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

    0
  • Comment author
    Greg Crawford

    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". 

    0
  • Comment author
    Tom Bernaerd

    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 

    0
  • Comment author
    Ryan Paton

    Yes, i agree ... this is needed

    0
  • Comment author
    Ryan Paton

    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. 

    0
  • Comment author
    Jan Van Gemert

    Re-commenting to keep it alive :)

    0
  • Comment author
    Miguel Oscar Lozano

    Hi all,
    Excited to see the cross collaboration between colleagues. I was wondering about your feedback about the the feature delivered on WMS 2024.10 (3) Create a Function to Allocate Stock on Pick List Proposals did you have the chance to use it?

    0

Iniciar sesión para dejar un comentario.