Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / AX2012R3 WHS Sales Ord...
Microsoft Dynamics AX (Archived)

AX2012R3 WHS Sales Order Picking sequences

(0) ShareShare
ReportReport
Posted on by DPerko 415

I am in the process of setting up sales order picking using the new WHS functionality and have two questions regarding how to get work created correctly and sequenced correctly.

The first one is related to splitting sales orders up by area of warehouse. My warehouse is divided into 4 areas, with one picker assigned to each area. I also have one picker that picks from the entire warehouse when a skid quantity is needed. If I have 2 sales orders with lines in areas 1 and 3 as well as a skid how do generate 3 pieces of work (one for each area and one for skids)? Should this be addressed with different location directives or different work templates or both? (Note my Reservation Hierarchy is set to reserve at the Site/Warehouse level).

The second question is related to Picking Routes. I would assume the normal sequencing would be based on the Sort Code on the location - is this a correct assumption? The customer I am working with is looking to sequence by weight - so heaviest material is picked first and put on the bottom of the pallet with progressively lighter material put on top. (They do understand that this may cause them to go up and down a Aisle multiple times). Is sequencing by weight possible?

Thanks for any insight you may be able to provide.

Dan

*This post is locked for comments

  • DPerko Profile Picture
    DPerko 415 on at
    RE: AX2012R3 WHS Sales Order Picking sequences

    Frans -

    Thanks I think that will get me where I need to be.

    Dan

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: AX2012R3 WHS Sales Order Picking sequences

    Hi Dan,

    I suggest to create a work pool ID per area (zone or zone group).

    Create a work template per area,

    work pool = area

    Filter this template with edit query Temp work transactions zone = area (or simular).

    After processing the wave, the work can be filtered on work pool = area.

  • DPerko Profile Picture
    DPerko 415 on at
    RE: AX2012R3 WHS Sales Order Picking sequences

    That is what I thought. I am just trying to define the simplest process to see work by zone (or range of locations). I couldn't find how to filter the work this way so thought a wave may be the way to do it.

  • Verified answer
    Ivan (Vanya) Kashperuk Profile Picture
    Ivan (Vanya) Kashperuk on at
    RE: AX2012R3 WHS Sales Order Picking sequences

    I mean, before you try to process a wave, you don't yet know, where these goods are supposed to be picked from (which zone), so I don't see how you can already pre-create many waves based on that criteria. Unless you build in some pre-processing step into the wave processing, that will split it into multiple waves based on the zones somehow. I wouldn't.

    Besides, what exactly do you want to manage? You can just not release the created work, so all of it will be blocked, and already split per zone. So you can release them manually in the order and at the time you want.

  • DPerko Profile Picture
    DPerko 415 on at
    RE: AX2012R3 WHS Sales Order Picking sequences

    Ivan -

    Had one follow up on this. The blog works perfectly for splitting work by location. Is it possible to move this up to the Wave level? (If I release multiple sales orders that have materials to pick from multiple areas I would like each area to be its own wave to make it easier to manage.).

    I set up wave templates with a query over temporary work transactions table but I am thinking that it isn't working because work is created after the wave.

    Any thoughts on this?

    Thanks again - Dan

  • DPerko Profile Picture
    DPerko 415 on at
    RE: AX2012R3 WHS Sales Order Picking sequences

    Ivan -

    The blog link was perfect to split the sales work by area but I'm now running into the next problem. My process is to pick, location in one of several staging areas to be consolidated with with other lines for the order and then loaded to a truck when it arrives. (Ideally I would like to be able to "load" an entire sales order in one step instead of each picked item).

    A user will pick multiple sales orders in their Wave and each SO generates its own Pick. The Put to the staging area is for the sum of all lines for the item and the pick and put during load is for the entire quantity of the item (multiple orders).

    How can keep the pick and put for each sales order line separate yet include them in the same wave?

    In addition I found no way to perform the load step for an entire load - it seems like I need to treat each item separate. I am assuming I am missing something simple but I'm not sure what.

  • DPerko Profile Picture
    DPerko 415 on at
    RE: AX2012R3 WHS Sales Order Picking sequences

    Thanks - I will test this out next week.

  • Guy Terry Profile Picture
    Guy Terry 28,621 Super User 2024 Season 2 on at
    RE: AX2012R3 WHS Sales Order Picking sequences

    Hi Dan,

    Yes, Ivan refers to the sort on the Edit Query of the Work Template header.

    You want to Sort on the total weight of the sales order line (or Load line, in the event that you do partial release). It would not be possible to do this in standard, because the Total weight is not a field that exists on any of those tables.

    A modification to add a Weight field to the Temporary Work Transaction Line, and get it to populate based on the net weight of the item (and the relevant quantity field on the Temporary Work Transaction Line) might be possible.

  • DPerko Profile Picture
    DPerko 415 on at
    RE: AX2012R3 WHS Sales Order Picking sequences

    Ivan -

    Thanks for the reply. That blog looks like the concept will work. I will need to do it by range of locations (since I am using Zones for pick velocity) but that field is also in the Temp Work table. I wasn't sure how this would work with the reservation hierarchy not getting to a location until work is created.

    For the weight it would be InventTable weight * quantity. Is the sort you re referring to on the Edit Query?

    Dan

  • Verified answer
    Ivan (Vanya) Kashperuk Profile Picture
    Ivan (Vanya) Kashperuk on at
    RE: AX2012R3 WHS Sales Order Picking sequences

    For your first question - take a look at this blog post:

    blogs.msdn.com/.../how-to-direct-work-for-a-specific-zone.aspx

    As for the second item - Would it be the weight from the InventTable (Item details)? If yes, it should in theory be possible to Sort (In the Work template) based on Item net weight (from InventTable). I haven't tried it myself though

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans