To make ageing stock current is to do a Bin to Bin stock movement. The stock date is updated to the date of the transfer not the date the stock was originally booked in at. What about making the MovementBalance table have a field which is the StockIn Date?