I am attempting to write a report that needs to list the on hand qty of an inventory item for a given closed period. The same information you see in the History tab of Item Maintenance/Inquiry. I need to be able to look back at period 1 of this year for instance and know that the ending qty on hand in a warehouse was X.

The only file I have found that was close was IM_PeriodPostingHistory, for some reason my beginning qty for historical periods is all 0's except for the most recent closed period.

I am hoping to avoid having to calculate these historical quantities on hand but if that is my only option then what would be the best way of going about that?