Inventory Transaction Dates do not respond

Hi I have a very complicated inventory table in the database that I want to calculate the on-hand grouped by many dimensions. I am struggling to get it correctly. So I decided to breakdown the probl...