Before printing valuation report by date I normally do the followings

=> Enquires => Inventory => Valuation by Date => View and then Save Valuation as per parameters below

I then run my valuation report on the same date as shows on Valuation by Date Window.

Then I print transactions report 

Then I took Amount - Profit to get stock on hand