Is there a way to get a report which shows the total inventory value at a specific date?
Try Inventory Value Movement report which shows movements in inventory on hand for specific period. The closing balance represents value of each inventory item for the period.