Warehouse Management finished goods put away query doesnt work

(0) Share

Report

Posted on by simonschulte

178

Hi Guys,

I have a requirement, that the finished goods in production are put away on specific locations, depending on wich ressource/ressource group, the last job in the route is done.

Sadly, the query in the work template doesnt work at the moment. There are directive codes, wich then relate to the location direvtice These are the settings:

Joins in the query of the work template:

This is the query: of the work template:

Thats the work template itself:

depending on the resource group (PROD04. PROD05, PROD06, etc.) the system is supposed to choose diffrent put locations.
In the work creation history log I can see, that this work template is being skipped, when work is created.+

The ressource is selected in the regarding job in the production route and i thought, that the join would work but it doesnt.

Does anyone have an idea for a different query?

If you need more information, just let me know.

Kind regards,

Simon

Categories:

Dynamics 365 Supply Chain Management

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Sagar Suman 6,780 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Please try joining tables as shown here. I have not yet tested it but I think this can work. I will test tomorrow and confirm.

Start with Production order table and select Jobs field. Using this record go to Joins and Join 'Route Jobs' table.

Once the 'Route Jobs' table is added come back to the main query and try to filter the resource here.

Was this reply helpful? Yes No