After several hours trying to figure this one out, and support also stumped (although they are still trying to figure it out), I come to you with hat in hand.
We have 3 items have have bins. We just did inventory counts, so did an inventory worksheet and made all the adjustments so the count was good and bins had right count.
But when I go to look at the inventory item the count in one of the bins is wrong for 3 different items. Yet, if you look at the history, the changes after that worksheet date should not have impacted it to ADD items to those bins.
What has resulted is that the total inventory count for a location is less than the sum of the bins for that location. The total inventory count is CORRECT, it's the bins that are off. For instance, this one part has a total of 2905 for total parts for a specific location, but has 2892 in 1 bin and 125 in the other. Add them up and it comes out to 112 extra pieces showing in 1 bin, but not reflected in the total. Again, the total is correct, the numbers in the bins are wrong.
When I try to do an inventory adjustment to the correct bin amounts, the numbers are still off by 112. I looked at the put-away-bin sheet to see if that was causing the problem, but it's not.
This is all VERY frustrating because we just spent days and mucho $$ getting the correct inventory counts and doing the worksheets, and now the bins are wrong.
Anyone ever experience this and a way to fix it? I was about to do a fake inventory worksheet, but support was concerned that it might cause further damage and not to do this. Is it possible that some deleted transaction left the bins in a mess. That NS didn't properly back out the transaction? OR is this a user error (gasp)?