Inventory number reporting for lot numbered items/multi-location

We have multi-location inventory turned on and use lot numbers to track different versions of particular items.  I need to get a physical inventory count out of NetSuite that shows quantity on-hand per lot number and location.  The report will show total number per location (does not breakout per lot number) while in the lot number column it breaks out the quantity by lot number but that is for all the locations.  The saved search did not produce the desired numbers either.  Has anyone been able to get to these numbers?  I've contacted NS support and they told me this