Take a look at the built in report called "Current Inventory Report". I think that'll get you closer. You can customize from there.