Which table we can use for every day's inventory quantity onhand

Hi team,

We are using cst_del_onhand_valuations table to get quantity_onhand and inventory valuation for our customized inventory balance BI report. But this table is a time spot table which only can show the most accurate current time inventory balance but if we select the as of date as past date, the on-hand quantity and valuation would be not so accuracy compare with that time's output.

Does we have any other tables can replace with this table and have the same information? We need have a table that store every day's inventory valuation balance as user requirement. Please kindly advice how to achieve this.