I have a product with two lots/serial number . lets consider I have a location RM/C1. In product_move_line, when I filter of this product with lot_id and location_id , I got the difference of quantity done in one lot_id is 52 and display this product with this lot_id in inventory report is 52.That is correct. But for another lot_id , I calculate the same and difference is 32, but that product with that lot_id is not shown in inventory report view and product's on hand quantity also. What's wrong with that?
Can someone explain how inventory report and product_move calculation is not equal?
Welcome for any suggestion and explanation.