Hi everyone, I have a lot-numbered assembly item that shows a higher total on-hand quantity for lot numbers assigned to a specific location than what is reflected in the Physical Inventory Worksheet report for the same location. When I check the Inventory Detail subtab, the inventory status shows the correct quantities, matching the inventory report. However, when I review the quantities by lot number, they do not match.

Sounds like negative inventory issue. If you create an Inventory Balance saved search for that specific item it should be clear where the negative inventory is coming from.