Skip to main content

Notifications

Announcements

No record found.

Supply chain | Supply Chain Management, Commerce
Suggested answer

How to create sales work, load and shipment per each sales order line?

Posted on by 28

Each sales order line should create its own sales work, load and shipment.

I don't use the Load planning workbench but a batch job for Automatic release of sales orders. Here, I filter for each order line number. There must be a better way? Maybe in Location directives?


I would be grateful for any ideas for solution!

  • Suggested answer
    Danny Bilodeau Profile Picture
    Danny Bilodeau 4,058 Super User 2024 Season 1 on at
    How to create sales work, load and shipment per each sales order line?
    Hi EduardsV,
    The magic happens at the Wave Template.   When you release to warehouse, the Wave is executed based on the wave template.  You can apply a limit to the Wave Template so that the is a Wave-Load-Work for each sales line:
      
  • EduardsV Profile Picture
    EduardsV 2 on at
    How to create sales work, load and shipment per each sales order line?
    Hi? 
     
    Any feedback on this request? We also need to fulfill the same requirement. Work header breaks in work templates would allow  to create unique work for every line, but they still would be consolidated in the same shipment and load.
     
    We also need to get 5 works = 5 shipments = 5 loads principle so that we can further post packing slip/invoice to every work separately.
  • andrewlencsak Profile Picture
    andrewlencsak 291 on at
    RE: How to create sales work, load and shipment per each sales order line?

    My guess is you would have to do something with the Work template. First, you would need to ensure there is no auto consolidation you have going on with your Wave templates, or Shipment consolidation policies so that it wont try to group multiple Work Ids for the same order into a shipment. For work templates, you will have to edit the query so that can find the right field to create a Work header break against.

    pastedimage1683655582959v1.png

    When you Edit query, you can add a Sort for use with Work header breaks. I could not sort on Sales order table then Sales line as it threw an error, but I could Sort on Temporary work transactions table then order line:

    pastedimage1683655643329v2.png

    Click OK after adding that Sort, and it will make the "Work header breaks" button available as shown in my earlier screenshot, then you can click "Group by this field":

    pastedimage1683655757481v3.png

    Not sure if this will definitely work, but worth a try.

  • RE: How to create sales work, load and shipment per each sales order line?

    My question is not how to create sales work, load and shipment in general, but a specific question when using form Automatic release of sales orders, how to limit creation of sales work, load and shipment to each sales order line. If you use Automatic release of sales orders, all sales line on one sales order creates work for one load and shipment and on one packing slip. I want to have each sales line own its own sales work, load and shipment.

  • Suggested answer
    Charlotte X Profile Picture
    Charlotte X on at
    RE: How to create sales work, load and shipment per each sales order line?

    Hi Johan,

    When simply creating Picking list for a Sales order, completing the Registration and posting the Packing slip, the Shipment details are recorded in WMSSHIPMENT table.

    Please refer to this old thread:

    (+) Create Warehouse shipment from sales Order - Dynamics 365 Supply Chain Management Forum Community Forum

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans