Include Inventory setup question on Requisition Worksheet

Hello,

I have a “Include Inventory” setup question:

I have 3 locations:
1- RAW-MATERIAL
2- WIP
3- FINNISHED

I need setup my system to the following:

When raw material is transfered to WIP it should not be considered as item on

inventory on Requistion Worksheet but…

I still need item on RAW-MATERIAL location to be considered on Requisition Worksheet.

Items are being consumed from WIP by Prod. Orders and Purchased to RAW-MATERIAL.

I have tryied to use two stockkeping units with Lot-for-Lot “Include Inventory” on

RAW-MATERIAL but not Including Inventory on WIP.

When I do it, it does not consider WIP, which is desirable, but does not consider

RAW-MATERIAL quantities, when it should.

There is no transfer route between RAW-MATERIAL and WIP.

Thanks in advance!

Fabio Armando
IT Coordinator
Dynamics NAV Administrator

Hi, Thanks for reading. Solution found was to setup transfer route between RAW-MATERIAL → WIP and remove Include Inventory from WIP SKU. After that, run Planning Worksheet but filtering <>WIP. Now it takes in consideration quantities on RAW-MATERIAL but not WIP as expected.