Suggestions:
Stock movement reports give us all the details of the stock related to all transactions done in the selected date range of the selected item in the particular site.
Report shows item number, item details, unit, transaction type, transaction date, loc code, lot number, issue qty and receipt qty along with the opening /closing stock of the item. Transactions which are effecting Stock movement are covered.
Stock movement reports exist in SCM-> Inventory-> Inventory status.
In parameters users need to select Site code, Item code from and to, Item code from and to, Lot No from and to and Date from and to.
Please see the snapshot: Stock movement.png