Dynamics Community Forum Thread Details

Prevent mixed statuses at a WHS location during production consumption

We have a WHS-enabled raw material item that must allow physical negative inventory.

The location profile is configured with:

Allow mixed inventory statuses: No

Initially, the following inventory exists:

Item: 343584
Warehouse: 40
Location: SilosTest1
Quantity: 10,000 g
Inventory status: Block

When production consumption of 10 g is posted, D365 correctly does not consume the blocked stock. However, it creates:

-10 g with status Avail

As a result, the same location contains:

10,000 g Block
-10 g Avail

We want the item to remain allowed to go into negative inventory generally. However, we do not want Block and Avail inventory statuses to exist at the same location at the same time.

The expected behavior is:

if the location has no inventory, negative inventory may be created,
if the location contains inventory with status Block, production consumption should stop with an error,
the user should first change the inventory status from Block to Avail,
the location should never contain both Block and Avail statuses simultaneously.

The Allow mixed inventory statuses = No setting appears to work for WHS movements, but it does not prevent production posting from creating negative inventory with another status at the same location.

Is there any standard configuration that can enforce this rule during production consumption, or is a custom validation required?

Thank you.

Categories:

Dynamics 365 Supply Chain Management

Quick Links

Leaderboard > Supply chain | Supply Chain Management, Commerce