opening stock logic

Hi all,

I need the best logic to get the opening stock of a day of any month or date in range.... I tried with movement types but for some material its coming with negative values.

I need it urgently

Thanks & Regards

vivek varun