"Which options do you have selected for the Physical Inventory worksheet report?"
All items
All Accounts
Specific locations
Suppress Inactive Items
A specific range of item numbers
Include Qty on Hand
Create PI Adjustment workfile
That's the setup for the majority of our locations. Some of the item ranges may be somewhat smaller depending on the location but on average there should be upwards of 200 items.
As I said, the editing portion of the process only shows 8 - 10 items as opposed to the 200 or so items.

I was under the impression that creating the worfile would over write any predecessor file - is this correct? If so, why then would this problem persist.
Your help is greatly appreciated.
Peter