As an idea, I think what you are missing is the 'Location'. I think the newest Inventory 101104 uses a default location for inventory items.
****On some test data******* Modify a Physical Inventory worksheet to modify the Picking Sequence and attempt to import (not using any quantity fields in the import). This imports by Location. ****On some test data*******_