You can export inventory of an item through:
1. Go to inventory > Item
2. Choose 'Create Item > Export Inventory'
3. Input the criteria, say, the location and / or item code
4. Once export is done, you can down load the file by clicking the icon on the right hand side
This is an example on how the export file looks like.