Could you create a report showing the inventory by Item, but in all of our companies?
Sometimes I see the strangest and most exotic constructions or C/AL coding to answer these kinds of questions, when a more simple solution could do the same and better.