Need to know inventory count of an item in a given previous date

Hi! I need to know the inventory count of a given item  within an operating unit in a given previous date.  Can I simply sum up the primary_quantity of MTL_MATERIAL_TRANSACTIONS on or before that previous date but filtering out the record of the transaction_type_id for cost updates? Is there another type of cost update aside from Average which I may need to filter out also?  Are there any other tables/views or workaround that I can use to solve this issue?

Thanks in advance.