Unable to manually adjust inventory qty

HI ​@jzhu 

Do you have Allow Negative Qty turned on for the Item Class of that item?

Hi ​@Kandy Beatty no the item class is not checked for allow negative quantity. It is weird because none of the item class have it checked and only a few items are experiencing this issue. 

HI ​@jzhu 

What does the Historical Inventory look like for that item?

Are there outstanding purchases or sales against that item?

Also, check the Inventory Allocation Details

HI ​@Kandy Beatty 

I’ve checked both, there are no outstanding purchases or sales against them shown in Inventory Allocation Details. Inventory Summary shows that this item has an available qty of 2, which is the qty we are trying to adjust to zero. 

I also have a GI that shows all open sales order with line item and could not find the item. Searched in the SOLine and POLine DAC source data and could not find this item on any open order either.

​@jzhu Try to Recalculate Inventory see if this resolves the issue 

Good call out ​@dsimmerly 

HI ​@Kandy Beatty and ​@dsimmerly 

I tried recalculating inventory, and the item shows qty of zero. However, inventory allocation detail shows qty of 2 for the same item. 

Hi ​@jzhu were you able to find a solution? Thank you!

Hi ​@Chris Hackett, no I was not able to find a solution for this. The Allow Qty to be Negative setting does not apply on the Adjustments screen. So in order to adjust this, the qty cannot be less than zero.