Physical Inventory Worksheet quantity Not Equal to Zero still pulls up items with Zero Quantity
When customizing the Physical Inventory Worksheet and adding a filter Quantity = Not Equal to Zero and Show Zeros = F, there are still items that will appear on the report. On Hand column of the report generates the amount from the Inventory Activity Detail.
To further illustrate:
1. Customize a Physical Inventory Worksheet. Add filter Quantity = Not Equal to Zero and uncheck the Show Zero box under More Options link and hit Save.
2. Notice that some items will still appear on the report even if the On Hand = 0.
3. Click on the zero On Hand quantity on any item and user will be transported to Inventory Activity Detail of the Item.
4. On the Inventory Activity Detail Page, observe that the Total of the quantity on the Item is equal to Zero. This is the Zero amount that shows on the Physical Inventory Worksheet.
Note: Even if the quantity on hand of the item is zero, it will still appear on the report since amount that will be shown on the On Hand column is the total of the transactions on the Inventory Activity Detail.