How to age item ledger entry for remaining quantity?

I would like to have an option for an "as of" date to age the ILE so I can display the Remaining Quantity value to see what we have (or had) on a particular date. I tried using posting date but it didn't provide accurate results. Anyone know how to do this?