Compare Physical Inventory Counts by Batch Report

Purpose: Use this report to identify the item locations that require a final count. You can run the report for a single physical inventory batch or for all batches.

How to print: Select Compare Physical Inventory Counts Listing at the Physical Inventory Evaluation Report Screen if you use sheets for count entry.

Selecting a batch: You can select a batch for this report by entering a valid control number and batch in the appropriate fields. If you leave these fields blank, the report runs for all current batches. The system submits the job CMPBTCCNT, which produces this 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/Batch #: The control number and batch number for the physical inventory.

• Batch status description: Valid status messages are:

• First count not entered

• Second count not entered

• Final count required

• Final count in progress

• Whs: A code for the warehouse in the batch.

• Item: A code for an item in the batch.

• SKU: A code for the SKU of the item.

• Location: A code for a location in the batch.

• LPN: The LPN for the item location.

• Count 1: Count one quantity entered.

• Count 2: Count two quantity entered.

• Variance: The variance between first and second counts.

• Created: A flag to indicate whether you created the item location or LPN during count entry (if selected).