Hi,
We are having a weird issue with the reservation entry table and I was hoping to get some clarification on the connection between this and the total inventory on hand. We have a lot tracked item (let's call it FRU-01) with a total inventory qty of 50k eaches across 3 locations. None of this inventory is reserved for open sales orders, but it should all be under the same lot number (LOT12345A). When I pull the reservation entry table, I'm only seeing positive surplus entries at these locations, with a total for 35k units.
Typically, if we are not manufacturing or purchasing the item at this location (and there are no transfers in place), is the total surplus for an item in reservation entry table supposed to supposed to match the total inventory at that location? If we do manufacture at that location, does the produced product end up being tracked as a surplus in the reservation entry table?