Skip to main content
Solved

What is the best way to customize Pick priority by item in multiple warehouse situation?

  • October 21, 2020
  • 1 reply
  • 359 views

Forum|alt.badge.img+5
  • Captain II
  • 398 replies

Hello,

     I have a requirement that to sorting lines on pick list by item priority. Note: not by location priority. That is , supposing item A with priority 1, which is highest, item A would become the first line on pick list no matter what locations item A are stocked.

     It is not too difficult on 1 warehouse situation. I just add a field on stock item screen to let user set 1 to 100. And sorting on pick list by this user field.

      However, if the instance has multiple warehouses, and these warehouses might have different priorities on items. That would make things complicated.

      A workable way I can think out of is such I add multiple fields on stock item, 1 field for 1 warehouse. And for different warehouses, using an independent pick list form which sorted by different priority field. 

    It can be a way to fulfill the need, but it is not quite smart. Can somebody give me a talent idea? Thank you in advance.

Best answer by Hughes Beausejour

The sort needs to happen on the database with BQL/SQL for performance reason. If items need different pick priority based on the warehouse they are stocked then you need to store different priorities in database.

How many depends on your business rules. If each warehouse has a different priority then a priority per warehouse is required. If they are not all different and can be regrouped by warehouse types you can cut down on the amount of data needed.

View original
Did this topic help you find an answer to your question?

1 reply

Hughes Beausejour
Acumatica Employee
Forum|alt.badge.img+2
  • Acumatica Developer Support Team
  • 91 replies
  • Answer
  • October 22, 2020

The sort needs to happen on the database with BQL/SQL for performance reason. If items need different pick priority based on the warehouse they are stocked then you need to store different priorities in database.

How many depends on your business rules. If each warehouse has a different priority then a priority per warehouse is required. If they are not all different and can be regrouped by warehouse types you can cut down on the amount of data needed.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings