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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)
Answered

Consolidate sales picking using WMS

(0) ShareShare
ReportReport
Posted on by 2

Hi everyone

I have this business scenario and I seem not to be able to configure Dynamics AX 2012 R3 to handle the need to pick quantities in TOTAL BY ITEM CODE.  The case is as follows: I have 2 sales orders with the following details:

-SO 100 : Customer X (with every 6 pieces of item AAA we give 1 free item AAA)

SO Line 1 :: item AAA - quantity 6

SO Line 2 :: Item AAA - quantity 1

- SO 101 : Customer Z

SO Line 1:: Item AAA - quantity 2

I am using the Load planning workbench to put these two sales orders on 1 Load.  When the system generates the Load, I am able to see 3 load lines being a load line for every sales order line.  This seems correct to us.  When we release the Load to warehouse using the Load planning workbench, the system creates 3 pick (work) lines, being one for every load line / sales order line and 1 put (work) line (which is always the total of the pick quantities).  We also reserve the quantity as soon as we release the load so we know that the quantities are available in stock prior to start picking

We need the system to sum the picks by item code.  Therefore in the example above, we expect to have 1 pick (work) line for a total quantity of 9 and 1 put line for the total quantity (which is already happening)

Any ideas how this can be achieved? 

All ideas welcomed.

Thanks

*This post is locked for comments

I have the same question (0)
  • Omar Dimech Profile Picture
    2 on at

    Hello

    any thoughts?

    pls, thanks!

    Omar

  • Guy Terry Profile Picture
    28,924 Moderator on at

    Hi Omar,

    I have no idea how you do this (or even if you can). I have seen a 3rd party add-on which allows the mobile device to group similar work lines into one pick instruction for the user.... in fact, I didn't realise it wasn't in standard AX and nearly suggested you use it!

  • Omar Dimech Profile Picture
    2 on at

    Hi Guy

    thanks for your thoughts.  May I ask you what is the possible, valid, good reason for having different picking lines for the same item?  I seem to be missing something here, but I can't reason it out.  Customers do not see much benefit to visit the same location multiple times when picking into the same load..

    Thanks

    Omar

  • Omar Dimech Profile Picture
    2 on at

    Hi Sukrut

    Thanks for your feedback.  Seems like a customisation is the only way forward....

  • Sagar Suman Profile Picture
    6,550 Super User 2025 Season 2 on at

    Hi Omar,

    In your above scenario kindly note that you although have one load for these two sales order but when you release the load to warehouse you will have two shipments for it as the two sales order are for different customers.

    Coming to consolidated work you will not get consolidated pick lines for multiple sales line for the same item in work although the work has been consolidated as far as I know.

  • Verified answer
    Omar Dimech Profile Picture
    2 on at

    Thanks everyone for all your thoughts

    I finally managed to handle this scenario using cluster picking

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans