I think you nee to be using MAX & When ordered by which will show your location with the maximum stock and quantity.