Hello,

I've checked the option to suppress the zero quantity items on my physical inventory worksheet, but it keeps printing (selecting) items with no quantity on hand.

Is there something I'm missing?

I'm running IC V8.1C (110713).

Hello,

What other options/settings do you have on your Print Physical Inventory Worksheet window? I've tried this successfully three times.

Each time I used 'All items from inv. list' with 'Any account set', all locations, items and picking seqs.

The first time, I had 'Suppress 0 qty items' and 'Include quantity on hand' enabled only.

The second time, I enabled 'Create physical inv. adjustment workfile' also.

The third time, I also enabled the 'Create export file'.

Perhaps you're using a different combination of settings. Note that items having negative quantities will still be selected for the report.

Hello!

With these options:


I get this report:



While the second item (and lots following) on the report have no quantity on hand, even when I do an item inquiry:



Any ideas?

Hi, Andrew,

Hmmmm .... Is integrity clean? How many locations are in this data? I just created a new item with 0 quantity and it still doesn't print on the report. Are items allowed at all locations? Certainly, there is something different with the setup and/or settings in your data than mine.

If items are not allowed at all locations, when you Edit Locations, are all items selected at this particular location? Or, is only one item allowed at the location? Or?

What happens for you with sample data?

Do you want to send the data to me?

Hi,

Yes, DIC is clean. There is only a single location.

Not a problem in the sample data, even when only a single location is selected. All works fine there.

I uploaded the data this evening.

Hi, Andrew,

Okay, I've tracked this down to the dataset (1) having single segment items and (2) those that have zero quantities and still display on the report have not been selected for a location. It is not limited to datasets having one location only and multi-segment items don't exhibit the problem.

Am reporting this to R&D. Thanks for bringing it to our attention and providing the data so we could track the issue down.

In the meantime, if you want to effectively suppress those 0 quantity items from the Physical Inventory report, select Edit | Locations and Add 'All Items' to the location.

Thanks.

Hate those single segment item numbers.