Product Entry Physical Reconciliation Report Overview

Product > Entry > ICE Reports > ICEPR

Function acronym: ICEPR

Use this report to view a printed copy of information entered and adjustments made through Product Count Entry.

You can process this report for exceptions only, specified exception amounts or percents, all products, and full detail on serials and lots. If any run numbers are unresolved, they are printed at the end of the report. The report includes a total quantity difference and total amount difference which includes all products in the physical count run, not only the total of product printed if you are only printing exceptions.

If you select to include counted quantity by sequence number/bin, counts are listed by bin location. In addition to changes in the location of the data in line 1 (Product, Product Description, “per” Unit, Unit) and line 2 (Bin Location 1, Qty Expected, Cost, Quantity Counted, #Differences, Percent), the following data are included on a detail line on the report:

  • Ticket Number
  • Bin Location
  • Quantity Counted

This format and information prints when the Include Counted Quantity By Sequence Number/Bin? option is set to Yes.

The first part of the report shows the products selected: all of them or the exceptions. The following codes are used to describe different conditions:

ME Indicates multiple entries.
WM Indicates Warehouse Manager controlled.
A Indicates the product was added during reconciliation.
C Indicates an adjustment above the cost of XX.XX.

Use the Products Physical Counts Adjustment Exception Amount option in SA Administrator Options to set an amount for adjustments. The following section of the report shows serial number and lot number items that require adjustments when an amount exists in the Off By field on Product Count Entry - Serial/Lot Entry. The final sections provide information on each ticket number, including any missing tickets, and manually created records.

Physical Counts and Unavailable Inventory

Unavailable inventory is included when you perform a physical count. Product Entry Physical Reconciliation Report keeps on hand inventory entries separate from unavailable inventory entries. Serial number and lot quantity changes associated with unavailable inventory are printed under the ticket number for unavailable inventory.

Storeroom

If you run this report for a Storeroom-managed warehouse, the output has changed to show customer product information including customer inventory levels, the customer’s product name (if a record exists in Product Extended Product Cross Reference Setup, whether an adjustment impacts customer- or distributor-owned inventory, and expected customer quantities. The Ticket/Seq column is removed from the Storeroom version of this report.