Hi team, I noticed a discrepancy on an Item record where the Inventory Detail sublist shows a lot number with 64 quantity for a specific location. However, the same lot number does not appear on the Inventory Numbers subtab. Upon investigation, it seems there is no actual quantity for this lot due to negative inventory adjustments in the backend. What could be causing this inconsistency between the Inventory Detail sublist and the Inventory Numbers subtab?

Deleted or edited inventory transactions

Thanks @Luis. What do you mean by edited transactions? Do you mean updating the inventory adjustments or other transactions quantity after it's get created?

I'm assuming a change to the inventory detail.

Thanks @Tim Chapman. So even we update the inventory detail on the transactions then it should reflect the count in the inventory details sublist on the item record right?

I'm guessing that there was a change to a item receipt, or something to cause this mismatch. I see this when accounting re-receives in a item to change price but they receive it into a different bin and there was bin transfers associated already. I'm not sure exactly what is happening in your situation but I would follow the trail from the beginning and find what happened to cause the mismatch.