Hi Mike,
I believe I was able to replicate the problem. I created a brand new item from scratch, and did not make it active at any location. Naturally the qty on hand is zero. When I choose 'All items' for the worksheet and also include the option 'Suppress 0 qty items', this new item does not print on the worksheet report, but it is included in the export file, incorrectly. This should be fixed.
If I make the item active at the location, then it properly gets suppressed from the export.
When an item is On Demand at a location, it means there is no record in the item location file for that item/location combination. So GridView can't be used to search for a data value there. Looks like you got something that works for GV?
_________________________
Regards,
Softrak Tech Support