We used the physical inventory worksheet under transactions to get our count sheets. Worked well. I then used the export physical inventory worksheet to get an Excel copy. Again, worked well. But when I was transferring the count numbers from the count sheets to Excel, I ran into a problem in that the two sheets didn't match. It seems that the worksheet you get under transaction doesn't print "On demand" items while the exported worksheet does. We don't have many on demand items but there are a few, and it slowed me considerably only because I had to check to make sure that the numbering I was transferring matched the correct item in excel.

This the criteria for the transaction worksheet.
Sort order: Item number, picking sequence
Selection: Items from location with any control set
All item numbers
All picking sequences

Bruce has modified it once for us, so I was wondering if it could be modified to show on demand items? Actually, I would prefer that the export worksheet didn't export on demand items.

Any ideas?
_________________________
Mike Smith
Viktorian Sheet Metal Mfg Inc