Item On Hand Quantity for a previous period

Hi,

Does anyone know how to get the on hand quantity for a particular period?

We are trying to use below two tables. From the first one, I
can get the current run time on hand quantity (OHQ) which seems correct. But to
get previous period like last month OHQ, I will need to check material transactions table based on
the transaction date. But since the material transactions table includes all kinds of
transactions. To match with on hand quantity detail one,

just wondering if there is anything needs to be considered....

Since I checked some items, some of them the number