Hi! I am trying to manually adjust an inventory item to qty zero but keep receiving the following error:
I checked that there are no open transactions in the system that has this item. Any idea on why this error shows up?
Thanks!
Answer
Unable to manually adjust inventory qty
Best answer by alexx
Do you have multiple warehouses/branches? Do you have the right branch selected for the adjustment?
Try going to Inventory Summary. If it shows “<UNASSIGNED>” under Location, that usually means there is a qty sitting on an unfinished transaction somewhere.
Double clicking on that line will direct you to a screen to show you what transactions are not completed.
+17HI
Do you have Allow Negative Qty turned on for the Item Class of that item?
Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
Hi
+17HI
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
Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
HI
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.
+1
+17
Good call out
Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
HI
I tried recalculating inventory, and the item shows qty of zero. However, inventory allocation detail shows qty of 2 for the same item.
Hi
Hi
Do you have multiple warehouses/branches? Do you have the right branch selected for the adjustment?
Try going to Inventory Summary. If it shows “<UNASSIGNED>” under Location, that usually means there is a qty sitting on an unfinished transaction somewhere.
Double clicking on that line will direct you to a screen to show you what transactions are not completed.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.