Assist on checking below concern of Ms. Lea

I would just like to make an inquiry regarding our current inventory files in Pentaho. Whenever we generate our Per Location Inventory Valuation file why is it that stores that are already closed contain units and those stores that are newly opened does not contain the units we allocated? At the same time those stores that are fully closed and contains no units are still listed? At the same time why are there duplicate store names and why are there stores that are not for our brand included in the list (kindly see image below)
