web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Supply Chain Management forum / WAX: System directed s...
Supply Chain Management forum

WAX: System directed sort orders

(0) ShareShare
ReportReport
Posted on by raff 1,236

hi

we have a system directed mobile device menu item that should sort by "InventLocationId"  ascending

we have no other sort criteria, but the work being presented is not in any order that i can determine

our locations all start with X, eg

X01A01 to X01A40

are the characters throwing the sort out?

m

Categories:
Supply Chain Management
I have the same question (0)
  • Guy Terry Profile Picture
    Guy Terry 29,013 Moderator on at

    Hi raff,

    InventLocationId is the Warehouse. If you want to sort by Location, you should sort by WMSLocationId.

  • raff Profile Picture
    raff 1,236 on at

    hi Guy

    ah yes so it is ! :)

    but in mobile device menus items there is no option to sort by wmsloctionid or even sortcode when system directed!?

    and i don't think you can join tables here to get access to more fields either?

    mal

  • Guy Terry Profile Picture
    Guy Terry 29,013 Moderator on at

    Correct, but normally the sorting on Location or Sort code is done by the Work template, not by 'System directed' picking. What is it you want to happen?

  • raff Profile Picture
    raff 1,236 on at

    yes we where starting to think maybe we should control this via the work templates rather than the menu item

    basically its replenishment work from storage to pick face, where i want to keep the driver in the same storage aisle for as long as possible when taking  pallets out to a P&D station - at the moment it will say pick from Aisle 42 then 28 then 42 then 29 then 42, this should be sorted by pick from 28 then 29 then 42,42,42

    ill have a look at the templates now

  • raff Profile Picture
    raff 1,236 on at

    ok so all we can sort by in templates are "Temporary work transactions"  field "Location" - which we are actually already sorting by

    is our problem the fact we have a template per aisle - hence 30 templates(had to do this to get 2 stage movements working and ensure the correct P&D station was utilised on the put movement)

    but when we run replen, stock can be anywhere in these 30 aisles hence movements will never be in order? which is why system directed sorting would be nice !?

  • Suggested answer
    fatihgork Profile Picture
    fatihgork 3,817 on at

    Hi,

    If you have separate work templates for your aisles then you should get a separate work for each aisle. Is this happening?

    If so, what is the workpoolID on those work templates?

    Can you add your aisle number in this field as well and select "WorkPoolId" as your sorting criteria for system directed menuitem?

  • raff Profile Picture
    raff 1,236 on at

    hi Fatih

    we dont have work poolids setup;

    but the problem with this is for example

    Replenishment for Pick face zone is started:

    pick face A location creates work for the oldest LP from storage Aisle 28 location 29

    pick face B location creates work for the oldest LP from storage Aisle 29 Location 10

    pick face C location creates work for the oldest LP from storage Aisle 30 Location 2

    pick face D location creates work for the oldest LP from storage Aisle 28  location 20

    how can the work now be sorted for Pick Face A and D movement within the same aisle? to ensure i get directed to location 20 before 29?

  • Suggested answer
    fatihgork Profile Picture
    fatihgork 3,817 on at

    Hi raff,

    The sorting in system directed functionality is sorting by fields on work headers. But location is on work line, so this will not happen with out of box functionality. 

    If you can create 1 work per aisle, then you can add the sorting criteria in your location directives so that work record will be created as sorted by LocationID. 

    I can only think of running the creation overnight, and creating 1 work per aisle (Or per qty threshold).

    Since you have separate work templates per aisle, you can populate workpoolIDs on these work templates like "Aisle1Replenishment" for aisle1,"Aisle2Replenishment" for aisle 2 and so on.

    So, your work records will be as below:

    Work

    		 WorkPoolID
    pick face A location creates work for the oldest LP from storage Aisle 28 location 29 Aisle28Replenishment

    pick face B location creates work for the oldest LP from storage Aisle 29 Location 10

    		 Aisle29Replenishment

    pick face C location creates work for the oldest LP from storage Aisle 30 Location 2

    		 Aisle30Replenishment

    Then you can select workpoolid as the sorting criteria in your mobile device menuitem setup. Therefore the user will be directed to pick from Aisle28 to aisle 30.

  • raff Profile Picture
    raff 1,236 on at

    hi Fatih

    but with replenishment the location requiring stock and the random location of the oldest storage pallet across 30 aisles each with 280 locations each determine the work template that will be used, so i dont think its possible to control this?

    also we run demand based replenishment or high freq min/max during the day so waiting until night is not a luxury we have

  • Suggested answer
    fatihgork Profile Picture
    fatihgork 3,817 on at

    Hi Raff,

    Why not use thresholds on waves? Process them when max qty is reached and generate works. In such scenario you can limit the creation of works and get the maximum efficiency per work possible. And add sorting criteria to your location directive setups, to sort work lines by LocationId or sort code if you haven't done it yet.

    That case, you can create works when a wave quantity reaches the threshold.

    To make it even better, you can group your items in a way that will let you have separate wave templates, and that will also allow you to have different thresholds for different items.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Supply Chain Management

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans