Open Forum

Like what you see? Discover the benefits of the D365UG/AXUG Community. Learn More

1.  Sorting work lines by sort code

Posted 4 days ago

Hi,
We are sorting by sort code in the Edit query of our work template, however when an item is split into different locations it will visit all locations for ItemA (using sort code), then may revisit the same locations for ItemB (again using sort code) and so on. This means that any given location can be visited multiple times (work lines are first sorted by item and then by location even though the work template only contains the sort code).

For example, suppose a sales order contains 4 pcs of ItemA & 3 pcs of ItemB.
LocationA (sort code 2) contains 2 pcs of ItemA and 2 pcs of ItemB.
LocationB (sort code 1) contains 2 pcs of ItemA and 1 pc of ItemB.

Work lines will look like this:
ItemA pick 2 pcs from LocationB
ItemA pick 2 pcs from LocationA
ItemB pick 1 pc from LocationB
ItemB pick 2 pcs from LocationA

We would expect to see this:
ItemA pick 2 pcs from LocationB
ItemB pick 1 pc from LocationB
ItemA pick 2 pcs from LocationA
ItemB pick 2 pcs from LocationA

Have you come across this kind of behavior and do you know how to have the work sorted by location only, and not by item?

Thank you
Tania



------------------------------
Tania Commisso
Business Analyst
Carpet Art Deco Intl
Montreal
------------------------------


2.  RE: Sorting work lines by sort code

Posted 4 days ago
Have you tried setting up Cluster Picking?  This is what this was meant for.

------------------------------
Robert Stogner

------------------------------



3.  RE: Sorting work lines by sort code

Posted 4 days ago
Yes, we tried cluster picking but it's still following the order of the work lines (sorted by item first and then sort code).
Can you see anything wrong with our cluster setup? BTW, we also tried adding the sort code in the Set up Cluster/Cluster sorting



------------------------------
Tania Commisso
Business Analyst
Carpet Art Deco Intl
Montreal
------------------------------



4.  RE: Sorting work lines by sort code

TOP CONTRIBUTOR
Posted 4 days ago
What does your location directive show? You should be able to add sorting in the location directive to go by location then item number. I'm not sure how the Sort code affects this though, i have rarely had to use that for most of my clients.

------------------------------
Andrew Lencsak
Senior Application Consultant
eBECS
Atlanta GA
------------------------------