web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Supply chain | Supply Chain Management, Commerce Work creation for Mixe...

Supply chain | Supply Chain Management, Commerce

Answered

Work creation for Mixed Pallets

(3) Share

Report

Report

Posted on by AH-07052021-0

157

Hi All,

I have Scenario where my Item A0001& A002 are a Batch tracked items, and we have mixed pallets where for a given LP max qty = 40 QTY

Location: WH1A; LP01 = A001 20 qty + A002 20 qty

Location: WH1B; LP02 = A001 5 qty + A0002 35 qty

Location : WH1C; LP03 = A001 10 qty + A002 30 QTY

I have a sales order for 55 QTY for Item A002

The way my work is getting created =

Pick A0002 from WH1A = 20

Pick A0002 from WH1B = 35

The Way I want system to create work is by going by a LP - on hand qty descending for the sku.

Pick A0002 from WH1B = 35

Pick A0002 from WH1C = 20

is this possible on location directives to specify such a query with table joins, I tried but could not find solution

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

sagar_patil 918 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!

Hi,

Did you try following on Location directive query?

Note: Please help verify answer(s) if they guide you in right direction so other community members can also benefit from your question with verified answer.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1

Laurens vd Tang 258 Super User 2025 Season 2

#2

André Arnaud de Cal... 164 Super User 2025 Season 2

#3

Last 30 days Overall leaderboard

Featured topics

Quality order uses default receipt location instead of actual physical receipt location

Product updates

Dynamics 365 release plans