How to display inventory in each location on product view?
We have one company and at the moment two locations.
We have set up a warehouse management system where items are held on specific racks and rows (eg. Row D, Rack 5) in the main warehouse (first location), and nothing for the second location.
When we bring up product information, the inventory level for the item is displayed which shows the total number of products available across both locations, but how do we display how much stock we have in each location on the product display?
I know that we can do a warehouse/location query and find out what do we have where, but it would be highly advantageous if we could see what is where on the product information view. Not being able to see what's at which location also renders the "Storage Location" entries rather meaningless as they only show the rack/row location for the one location while in fact there may not be any products in stock at that location at all even though the inventory shows that items are in stock.