Hi Edw

This is a lot easier than you think, assuming you have done Year-end processing in IC at the right time and that you don't care about individual locations.

Use the SmartFinder (F6) function within Inventory itself. You can select all of the fields above to appear on the grid, and then export to Excel using the ExcelDirect button.

Steve