Skip to main content
Question

Unable to manually adjust inventory qty


Forum|alt.badge.img
  • Semi-Pro II
  • 122 replies

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!

7 replies

Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2209 replies
  • January 9, 2025

HI ​@jzhu 

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

 

 


Forum|alt.badge.img
  • Author
  • Semi-Pro II
  • 122 replies
  • January 9, 2025

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. 


Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2209 replies
  • January 10, 2025

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

 


Forum|alt.badge.img
  • Author
  • Semi-Pro II
  • 122 replies
  • January 10, 2025

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.


dsimmerly
Pro I
Forum|alt.badge.img+1
  • Pro I
  • 117 replies
  • January 10, 2025

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


Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2209 replies
  • January 10, 2025
dsimmerly wrote:

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

Good call out ​@dsimmerly 


Forum|alt.badge.img
  • Author
  • Semi-Pro II
  • 122 replies
  • January 13, 2025

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. 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings