Running a Reconciliation Report
Once counts are entered for each item, Variance reports should be run. The Variance report will compare the quantities entered to the quantity expected for each item. Each item appears only once on the report.
Search Bar: ICEPR
Menu: Product > Entry > ICE Reports > IC Entry Physical Reconciliation Report
Bookmark: ICEPR – IC Reconciliation
1. Click on the arrow next to icepr.
2. Choose <New> <One Time>
3. Set the printing information to Print.
4. Set the printer branch printer.
5. Click <Next>
6. Enter Branch#.
7. Enter Run # (can be found on your count sheet).
8. Click <Next>
9. Click <Save>
The variance report will be sorted from the largest discrepancy to the smallest discrepancy in terms of dollar variance. The report shows only 1 location for each item (the primary location).
To double check all locations go back into ICEPE and sort by product by clicking on the column heading. This will show all locations where an item was counted.
If you find a discrepancy, go back to ICEPE and change the count. You can then run another variance report if necessary.
Things to consider when auditing counts:
Vendor Shipments: PO’s in the warehouse but not yet received in Sx.e
Vendor Returns: Return PO’s that have been received but not yet shipped to the vendor
Warehouse Transfers: Transfers that are staged but not yet shipped
Warehouse Transfers: Transfers that have arrived but not yet received in Sx.e
Sales Orders: Open Sales orders that are staged but not yet invoiced
Sales Orders: Return Orders that have not yet invoiced but are in the warehouse
Misidentified product/packaging variations
Warehousing bin allocation, identification or misidentification