Hi Edward,

Stock counts are not stored in the system. You can export the Quantity on Hand data value for a specific location, sorted by Pick Sequence, but it is not possible to print/export the values previously counted.

If you export the Stock Count field to the Excel workbook, it is by design to pre-fill this column value with -1, so that you don't accidentally re-import a different value (such as zero). The purpose of this field is for someone to do the count and replace the -1 with the physical value. Then when importing this Excel file back into Inventory, the appropriate count adjustments can be made.

There are 2 'ShowMeHow' videos on how to do physical inventory in IC, one the import way and another the manual way.