Skip to main content

physical inventory count

  • November 11, 2024
  • 1 reply
  • 72 views

Forum|alt.badge.img+1

we are trying to do our physical inventory count for year end.  we have about 9 count that when we try to complete we get the error “Unable to create adjustment for line ‘121’ Insufficient Qty. on hand for item ‘1234’’ in warehouse’  this warehouse hosts all our truck, so each truck is a location and all have the same part numbers.  i understand that as a whole based on the book qty the adjustment will cause the that item to go in the negative.  The solution would be to update one of the other trucks with this sku that would make this sku go positive first.  The problem is that we don’t know what truck that would be, and if we did, we get the same error with a different sku. it there for becomes one big circle with the same error.

 

My only thought now is to make an one big adjustment dated before year end to every truck by adding 1 item of every sku to each truck, then update the physical inventory count to hopefully bring the inventory back in line.

 

Any suggestions would be appreciated, as I don't to have to do another inventory count because this causes the inventory to be way out?

 

Andrew

Did this topic help you find an answer to your question?

1 reply

Forum|alt.badge.img+1
  • Author
  • Varsity I
  • 66 replies
  • November 27, 2024

We tried doing and inventory adjustment to fix the problem.  This failed, as it led to another error saying the book quantity has changed.   We are told for the PI saying that the book quantity has changed, we need to cancel the count and redo it.  luckily we tested this first, so it only affects 1 count.  we have 6 other inventory counts that we need to update with insufficient QTY issue.   We are now stuck, and are unable to complete the 6 other physical inventory counts with the error of insufficent qty.

Are there any other suggestions on how can complete the inventory counts without having to redo everything?


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