Purpose: Use this report to review item locations or LPNs which previously had an entered count (that is, there was inventory in the location) and which had a count of 0 entered on a subsequent count. This report does not include item locations or LPNs which never had a count greater than zero entered. Running this report will help you catch an error in which a zero count was entered for the wrong item location or LPN.
How to print: Select Print Physical Inventory Zero Count Report at the Physical Inventory Evaluation Report Screen. You will also need to specify a control and batch number. The system submits the job PI_ZERO, which produces the report.
RF physical inventory: This report does not include counts being entered in RF Physical Inventory (records in the Physical Inventory Upload New table). In order to include counts done in RF Physical Inventory, you must first accept the count to upload the records from the Physical Inventory Upload New table to the Physical Inventory table.
For more information: See the sample report in PDF format.
Contents:
• control number and batch number
• warehouse code and description
• item and SKU codes
• location code
• location class
• location type. Valid types are:
• P = primary
• S = secondary
• B = bulk
• T = temporary
• LPN. If the item location is not associated with an LPN, the LPN is 0
• first count quantity
• first count ticket number if you use tickets
• first count status, where:
• Selected = counted
• Unselected = not counted
• second count quantity, ticket number and status, as above
• final count quantity, ticket number and status, as above
• on-hand quantity for the item location before generating the physical inventory. If an item location contains a quantity assigned to one or more LPNs and a “loose” quantity, the item location quantity not assigned to LPNs will appear under LPN 0
