Could you perhaps first run a mass update, searching for inv items "where location is empty", flip those all to some location, and then run the inv worksheet to reset quantities?