Sub Inventory Prioritization - Picking rule

Summary:

Business has a situation where a battery item will be present in 2 sub inventories. When demand comes, stock should get allocated from a lot which is maximum recharged.

Content (please ensure you mask any confidential information):

Part number: 551XXXX

SubInventory1: 467WL1; on hand stock 40 qty present

Subinventory2: 467WL1ShLF (Sub inv where LOTS eg: 4304 which is maximum recharged are placed); on hand stock 2 quantity present

Sub inventories do not have picking order. Expectation is the stock should get allocated from 467WL1ShLF sub inventory 1st.

We have created few Picking rules while testing this scenario.

Pickingrule1:

Priority1: Sub inventory Ascending