Hello,
I have Purchased an Item of 50 Quantity and a LOT is assigned. Then the item is consumed from the same LOT of 10 and 20 quantities for Production order. I have checked and verified these purchase and consumption entries in Item Ledger Entries. See the below screen shot.
The issue is that, When I am checking the Item availability by Lot report, still the Available Inventory for the item in the same LOT is 50. But it should be 20, since there are consumption entries are posted for 10 and 20 quantities as mentioned above.
Share your thoughts on this Available Inventory Mismatch.