Suggestion:
System has the provision for the both reports, lot wise stock status and valuation reports in the following path:
SCM ->Inventory -> Inventory status -> 1) lot wise stock status
SCM ->Inventory -> Inventory status -> 1) lot wise stock valuation
Both these reports are available lot wise i.e after Site, Date, and Item series, users have to select the lot number range. To get the valuation of the selected lot no range. These reports can be also parameterized on the bases of location code.
Lot wise stock Valuation report shows Lot No, Location, Exp.Date, Mfg. Date, Unit, Opening Balance, Receipts, Issues, Closing Balance and Value.
Lot wise stock Status report shows Lot No Unit Location, Mfg. Date, Exp. Date, Quantity, Rate and Value.