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

Announcements

No record found.

News and Announcements icon
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,972 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,756 Super User 2026 Season 1 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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 39

#2
Michel ROY Profile Picture

Michel ROY 14

#3
imran ul haq Profile Picture

imran ul haq 8

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans